Microsoft KB Archive/254365

{|
 * width="100%"|

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.

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

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 :