XL97: Microsoft Excel Pages - Tips and Tricks 1997 |
The information in this article applies to:
- Microsoft Excel 97 for Windows
SUMMARY
This article describes the 1997 issues of Microsoft Excel Pages - Tips and Tricks that you can obtain from the Microsoft Download Center. See these issues to learn about interesting shortcuts for and new ways of using Microsoft Excel. These tips and tricks are produced by Microsoft Product Support Services Engineers.
NOTE: Microsoft Excel Pages issues for 1997 and 1998 contain Microsoft Word 97 formatting. To view these documents, use Word 97 or Word 7.0 with the Word 97 file converter.
MORE INFORMATION
1997 Issues
The following files are available for download from the Microsoft Download Center. Click the file names below to download the files:
December '97 Tips and Tricks for Microsoft Excel 97
Including: How to Use Automation to Control Microsoft Outlook - Part IV
Using the Microsoft Outlook Journal with Microsoft Excel 97
New Worksheet List
Data Analysis Tools - Part II (Histogram and Sampling)
October-November '97 Tips and Tricks for Microsoft Excel 97
Including: Assigning Help Files and Topic IDs
Combining Lists with Microsoft Query
Data Analysis Tools - Part I (Moving Average & Rank and Percentile)
Manipulating Data with the Text to Columns Wizard
September '97 Tips and Tricks for Microsoft Excel 97
Including: How to Use Automation to Control Microsoft Outlook - Part 3
Using Worksheet Events in Microsoft Visual Basic for Applications
Using Shared Workbooks
Track Data with the Template Wizard
August '97 Tips and Tricks for Microsoft Excel 97
Including: How to Use Automation to Control Microsoft Outlook - Part 2
ActiveX: the Calendar Control from Microsoft Word
Arrays in Visual Basic for Applications Revisited
June-July '97 Tips and Tricks for Microsoft Excel 97
Including: What is Automation?
Creating a Microsoft Excel PivotTable from Microsoft Word
Automation: A Real Spellbinder
How to Use Automation to Control Microsoft Outlook
May '97 Tips and Tricks for Microsoft Excel 97
Including: Using the Range Finder
How to Programmatically "Save as HTML"
How to Import WEB Tables into Microsoft Excel 97
April '97 Tips and Tricks for Microsoft Excel 97
Including: The Office Assistant Animation Explorer (built by Microsoft Product Support Services engineers)
The Me macro keyword
Using array formulas
Explanation of Class modules in macros
March '97 Tips and Tricks for Microsoft Excel 97
Macro Programming Topics:
Creating Command Bars
Using CreateObject and GetObject
New Functionality for the UsedRange Property
How to Provide Help to Your Users
February '97 Tips and Tricks for Microsoft Excel 97
Including: Calculating Compound Interest
New Worksheet Functions
Page Break Preview and Hyperlinks in Microsoft Excel 97
January '97 Tips and Tricks for Microsoft Excel 97
Including: Microsoft Excel 97 Conditional Formats
New Chart types in Microsoft Excel 97
Natural Language Formulas
Using a PivotTable
REFERENCES
For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address
and then click How to use the Microsoft Download Center.
Archived Issues
For additional information about other archived issues of Microsoft Excel Pages, click the article numbers below to view the articles in the Microsoft Knowledge Base:
Q254363 Microsoft Excel Pages - Tips and Tricks 1998
Q254364 Microsoft Excel Pages - Tips and Tricks 1996
Additional query words: XL97
Keywords : kbfile kbdta
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbhowto
Technology :
Last Reviewed: February 18, 2000 |