AppNote Reference: EPU (Excel and Project)

Last reviewed: September 18, 1996
Article ID: Q73648

SUMMARY

The following is a list of the application notes currently available in the EPU group.

              EPU (EXCEL PROJECT UNIT) APPLICATION NOTES
              ==========================================

MICROSOFT EXCEL

Microsoft Excel for Windows 95

GF1201     FastTips Catalog
           No Disk Included
           Applies to Microsoft Excel version 7.0 for Windows 95
           Software/Data Library: Not Available
           Last Update: 8/95
           MSDL: Not Available
           FastTips: (800) 936-4100

WE1207     Upgrading Questions and Answers
           No Disk Included
           Applies to Microsoft Excel version 7.0 for Windows 95
           Software/Data Library: S15511
           Last Update: 8/95
           MSDL: WE1207.EXE
           FastTips: (800) 936-4100

WE1208     Basic Use Questions and Answers
           No Disk Included
           Applies to Microsoft Excel version 7.0 for Windows 95
           Software/Data Library: S15512
           Last Update: 8/95
           MSDL: WE1208.EXE
           FastTips: (800) 936-4100

WE1209     Printing Questions and Answers
           No Disk Included
           Applies to Microsoft Excel version 7.0 for Windows 95
           Software/Data Library: S15513
           Last Update: 8/95
           MSDL: WE1209.EXE
           FastTips: (800) 936-4100

WE1210     Working with Shared Documents Questions and Answers
           No Disk Included
           Applies to Microsoft Excel version 7.0 for Windows 95
           Software/Data Library: S15514
           Last Update: 8/95
           MSDL: WE1210.EXE
           FastTips: (800) 936-4100

WE1238     Jet Error Help File (Msjeterr.hlp)
           Disk Included
           Applies to Microsoft Excel for Windows 95, version 7.0
           Software/Data Library: S15535
           Last Update: 9/95
           MSDL: WE1238.EXE
           FastTips: Not Available

   The Application Note "Jet Error Help File (MSJETERR.HLP)" (WE1238) is
   now available from Microsoft Product Support Services (PSS). The WE1238
   disk included with this Application Note contains the Jet Error Help
   file, Msjeterr.hlp, for use with Microsoft Excel for Windows 95.

WE1254     15-Digit Number Patch for Version 5.0c
           Disk Included
           Applies to Microsoft Excel for version 5.0c Windows
           Software/Data Library: S15575
           Last Update: 12/95
           MSDL: WE1254.EXE
           FastTips: Not Available

   The Application Note "15-Digit Number Patch for Version 5.0c" (WE1254)
   is now available from Microsoft Product Support Services (PSS). The disk
   included with this Application Note contains a patch that corrects
   problems you may encounter when you enter the following numbers in a
   Microsoft Excel worksheet:

      140737488355328

      281474976710656

      562949953421312

   NOTE: You can obtain the Microsoft Excel for Windows 95, version 7.0,
   version of this patch (XL15link.exe) from online services or by calling
   Microsoft Product Support Services (request part 065-054-S61). For more
   information about this patch, please see the following article in the
   Microsoft Knowledge Base:

      ARTICLE-ID: Q128650
      TITLE     : XL7 Patch Available: 15-Digit Number, Linking, and
                  Transpose

WE1277     Visual Basic for Applications Equivalents for Lotus 1-2-3 Macro
           Commands
           Available ONLY through Online Services. Not available in OE.
           Applies to Microsoft Excel version 7.0 for Windows 95
           Software/Data Library: S15868
           Last Update: 03/96
           MSDL: WE1277.EXE
           FastTips: Not available.

   Application Note WE1277 contains equivalent macro code in Visual Basic
   for Applications for most Lotus 1-2-3 macro functions.

Microsoft Excel for Windows and Macintosh

NOTE: AppNotes that begin with the prefix XE apply to Excel for both Windows and Macintosh.

XE0124     Regression Analysis and Best Fit Lines
           [NOTE: This replaces WE0124 and WE0126]
           No Disk Included
           Applies to Microsoft Excel 3.0, 4.0, 4.0a
           Software/Data Library: Not Available
           Last Update: 8/93
           MSDL: XE0124.EXE (Windows); XE0124.SEA (Macintosh)
           FastTips: Not available

   This Application Note discusses how to use Microsoft Excel
   functions to perform simple, multiple, and polynomial regression
   analysis. It contains examples of how to use LINEST(), LOGEST(),
   TREND(), and GROWTH() to describe a best fit line or curve and to
   make predictions about your data. It also outlines some of the new
   statistical functions and tools available with Microsoft Excel
   version 4.0.

XE0125     Cell Referencing from a Macro
           [NOTE: AppNote WE0125 was deleted and replaced with XE0125]
           No Disk Included
           Applies to Microsoft Excel versions 3.0, 4.0
           Software/Data Library: Not Available
           Last Update: 8/93
           MSDL: XE0125.TXT (Windows); XE0125.SEA (Macintosh)
           FastTips: Not Available

   This Application Note outlines how to reference cells from a macro
   and discusses the A1 and R1C1 reference styles. It includes tables
   that define terms such as "absolute reference" and "relative
   reference" and contains descriptions of specific macro functions
   and the types of cell referencing they will accept.

XE0127     Using Dates and Times
              [NOTE: AppNote WE0127 was deleted and replaced by XE0127]
           No Disk Included
           Applies to Microsoft Excel versions 1.0, 1.03, 1.04, 1.06,
           1.5, 2.2, 3.0, and 4.0, for the Macintosh; and to Microsoft
           Excel versions 2.0, 2.1, 2.1c, 2.1d, 3.0, and 4.0, for
           Windows
           Software/Data Library: Not Available
           Last Update: 6/93
           MSDL: XE0127.TXT
           FastTips: (800) 936-4100

   This application note describes how to use new and existing date
   and time functions in Microsoft Excel 4.0 and earlier versions, for
   both Windows and Macintosh. It also describes how dates and times
   are stored.

XE0183     Tips for Manipulating the Data in a Chart
           (Replaces ME0183)
           No Disk Included
           Applies to Microsoft Excel versions 3.0, 4.0, and 4.0a for
           Windows and Microsoft Excel versions 3.0 and 4.0 for the
           Macintosh
           Software/Data Library: Not Available
           Last Update: 11/93
           MSDL: Pending
           FastTips: Not Available

   This Application Note provides and overview of how values are
   plotted in a chart and discusses how to add information to and
   delete information from a chart, how to make a chart independent
   from a worksheet, and how to add data point labels to a chart.

XE0186      Database Tips
               [NOTE: AppNote ME0186 was deleted and replaced by XE0186]
            No Disk Included
            Applies to Microsoft Excel versions 2.x, 3.0, and 4.0
            for Windows, and to Microsoft Excel versions 2.2, 3.0, and
            4.0 for the Macintosh.
            Software/Data Library: Not Available
            Last Update: 5/93
            MSDL: XE0186.TXT
            FastTips: (800) 936-4100

   This Application Note describes how you can more productively use
   the database features of Microsoft Excel.

XE0210      Creating and Using Tables
               [NOTE: AppNote number ME0210 was deleted and replaced by
               XE0210]
            No Disk Included
            Applies to Microsoft Excel versions 2.x, 3.0, 4.0, and 4.0a
            for Windows and Microsoft Excel versions 1.0, 1.03, 1.04,
            1.06, 1.5, 2.2, 3.0, and 4.0 for the Macintosh
            Software/Data Library: Not available
            Last Update: 5/93
            MSDL: XE0210.TXT
            FastTips: (800) 936-4100

   This Application Note describes how to create one-input and two-input
   data tables using the Table command on the Data menu. It also discusses
   how you can use one-input and two-input tables to evaluate database
   information obtained using database functions and comparison or computed
   criteria.

XE0449     Using Dynamic Dialog Boxes
           No Disk Included
           Applies to Microsoft Excel  versions 3.0 and 4.0 for Windows,
           and 3.0 and 4.0 for the Macintosh
           Software/Data Library: Not Available
           Last Update: 12/93
           MSDL:  XE0449_W.EXE(MS-DOS/Windows) or XE0449_M.SEA (Macintosh)
           FastTips: Not Available

   This Application Note discusses how to create a dynamic dialog box and
   provides a sample dialog box definition table and sample macro code
   you can use to activate the dialog box. It also provides an example of
   one way you can retrieve information from a dynamic dialog box and
   enter that information into a database.

NOTE: This Application Note is a cross-platform update to the earlier WE0449.

XE0696      Using Microsoft Excel Workbooks
               [NOTE: AppNote WE0696 was deleted and replaced by XE0696]
            No disk included
            Applies to Microsoft Excel version 4.0
            Software/Data Library: S14076
            MSDL: XE0696.TXT
            FastTips: (800) 936-4100

   This application note describes how to use Microsoft Excel version
   4.0 workbooks, which are documents in which you store other
   Microsoft Excel documents or references to them. Workbooks replace
   Microsoft Excel version 3.0 workspaces.

XE0800     Most Frequently Asked Questions
           No Disk Included
           Applies to Microsoft Excel version 4.0
           Software/Data Library: Pending
           Last Update: 7/93
           MSDL: XE0800.EXE (Windows); XE0800.SEA (Macintosh)
           FastTips: Not Available

   This Application Note provides detailed responses to some of the
   most frequently asked questions about Microsoft Excel version 4.0.
   The questions, which were derived from polling members of the
   Microsoft Excel technical support staff, are broken into eight
   functional categories. These categories include, tips and tricks,
   printing, working with text files, formulas and functions, macros,
   workbooks, and working with other applications.

XE0872     Creating a Crosstab Table with the Crosstab ReportWizard
           No Disk Included
           Applies to Microsoft Excel version 4.0
           Software/Data Library: S14946
           Last Update: 11/93
           MSDL: XE0872.EXE
           FastTips: Not Available

   This Application Note demonstrates how to use the Crosstab
   ReportWizard to create a crosstab table that resembles the one
   pictured on page 349 of "User's Guide 1," version 4.0.

XE0923     Basic Use Questions and Answers
           No Disk Included
           Applies to Microsoft Excel version 5.0 for Windows
           Software/Data Library: Not Available
           Last Update: 10/93
           MSDL: XE0923.TXT
           FastTips: (800) 936-4100

XE0924     Printing Questions and Answers
           No Disk Included
           Applies to Microsoft Excel version 5.0 for Windows
           Software/Data Library: Not Available
           Last Update: 10/93
           MSDL: XE0924.TXT
           FastTips: (800) 936-4100

XE0925     Working with Charts Questions and Answers
           No Disk Included
           Applies to Microsoft Excel version 5.0 for Windows
           Software/Data Library: Not Available
           Last Update: 10/93
           MSDL: XE0925.TXT
           FastTips: (800) 936-4100

XE0926     List Management and Data Analysis Questions and Answers
           No Disk Included
           Applies to Microsoft Excel version 5.0 for Windows
           Software/Data Library: Not Available
           Last Update: 10/93
           MSDL: XE0926.TXT
           FastTips: (800) 936-4100

XE0927     Using Macros Questions and Answers
           No Disk Included
           Applies to Microsoft Excel version 5.0 for Windows
           Software/Data Library: Not Available
           Last Update: 1/96
           MSDL: XE0927.TXT
           FastTips: (800) 936-4100

XE0938     Introduction to Custom Dialog Boxes
           No Disk Included
           Applies to Microsoft Excel version 4.0 for Windows and
           version 4.0 for the Macintosh
           Software/Data Library: Not Available
           Last Update: 2/94
           MSDL: XE0938_W.EXE (Windows) or XE0938_M.SEA (Macintosh)
           FastTips: Not Available

   The "Introduction to Custom Dialog Boxes" (XE0938) Application Note
   shows you how to use the Dialog Editor to create a custom dialog box and
   provides sample macro code to display it.

XE0962     Equations for Financial Functions
           No Disk Included
           Microsoft Excel versions 3.0, 4.0, and 4.0a for
           Windows, and Microsoft Excel versions 3.0 and 4.0 for Windows
           Software/Data Library: S14822
           Last Update: 11/94
           MSDL: XE0962.EXE
           FastTips: Not Available

   This Application Note describes the formulas used in the financial
   functions that are included with Microsoft Excel versions 3.0, 4.0, and
   4.0a. The theories that these formulas are derived from are based on
   information in the "Standard Securities Calculation Methods," published
   by the Securities Industry Association, 120 Broadway, New York, NY.

Microsoft Excel for the Macintosh

GF0895     FastTips Catalog
           No Disk Included
           Applies to Microsoft Excel version 4.0 for the Macintosh
           Software/Data Library: Not Available
           Last Update: 8/27/93
           MSDL: Not Available
           FastTips: (800) 936-4100

ME0185 Using Custom Help
        Applies to Excel for the Macintosh versions 2.2, 3.0, and 4.0
        Software/Data Library: ME0185, S12983

ME0185     Using Custom Help
           No Disk Included
           Applies to Microsoft Excel versions 2.2, 3.0, and 4.0 for
           the Macintosh
           Software/Data Library: S12983
           Last Update: 3/93
           MSDL: ME0185.SEA
           FastTips: Not Available

This AppNote describes how to use the custom help feature in Excel 2.2, 3.0, and 4.0.

ME0188 Entering Formulas

        Applies to Excel for the Macintosh versions 1.0, 1.03, 1.04,
           1.06, 1.5, 2.2, and 3.0
        Software/Data Library: Not available

   Describes how to enter formulas into Excel.

ME0197 Text Concatenation
        Applies to Excel for the Macintosh versions 1.0, 1.03, 1.04,
           1.06, 1.5, 2.2, and 3.0
        Software/Data Library: ME0197, S12995

   Describes how to concatenate (string together) several text values.

ME0333 Using Pascal Code Resources
        Disk included
        Applies to Excel for the Macintosh, version 2.2
        Software/Data Library: ME0333.SEA, S13009
        MSDL: Yes
        FastTip: Not Available

   Describes how Excel can use external Pascal code after that code
   has been compiled as a resource. The disk contains code examples.

ME0570 Charting Questions & Answers
        No Disk Included
        Applies to Excel for the Macintosh, version 3.0
        Software/Data Library: Not available
        MSDL: Yes
        FastTip: (800) 936-4100

(800) 936-4100

ME0571 Installing Questions & Answers

        No Disk Included
        Applies to Excel for the Macintosh, version 3.0
        Software/Data Library: Not available
        MSDL: Yes
        FastTip: (800) 936-4100

ME0572 Printing Questions & Answers
        No Disk Included
        Applies to Excel for the Macintosh, version 3.0
        Software/Data Library: Not available
        MSDL: Yes
        FastTip: (800) 936-4100

ME0573 Updating Questions & Answers
        No Disk Included
        Applies to Excel for the Macintosh, version 3.0
        Software/Data Library: Not available
        MSDL: Yes
        FastTip: (800) 936-4100

ME0574 Usage Questions & Answers
        No Disk Included
        Applies to Excel for the Macintosh, version 3.0
        Software/Data Library: Not available
        MSDL: Yes
        FastTip: (800) 936-4100

ME0802     Opening and Saving Text Files
           Disk Included
           Applies to Microsoft Excel version 4.0, for the Macintosh
           Software/Data Library: S14205
           Last Update: 7/93
           MSDL: N/A
           FastTips: (800) 936-4100

   This Application Note discusses how Microsoft Excel parses text and
   formats numbers and alphanumeric characters in text files. The
   ME0802 disk included with this Application Note contains the Text
   Reader add-in macro, which you can use to import text files. This
   macro parses your text according to a delimiter you select and
   prevents Microsoft Excel from applying automatic number formatting
   to the entries in your file.

ME0858     Generating Smooth Curves in Charts
           Disk Included
           Applies to Microsoft Excel version 4.0 for the Macintosh
           Software/Data Library: S14353
           Last Update: 9/93
           MSDL: ME0858.SEA
           FastTips: Not Available

   This Application Note includes two add-in macros that use the
   interpolation method to generate smooth curves in charts.

Microsoft Excel for Windows

GF0897     FastTips Technical Library Catalog
           No Disk Included
           Applies to Microsoft Excel 4.0 for Windows
           Software/Data Library: Not Available
           Last Update: 12/16/94
           MSDL: Not Available
           FastTips: (800) 936-4100

GF0953     FastTips Technical Library Catalog
           No Disk Included
           Applies to Microsoft Excel 5.0 for Windows
           Software/Data Library: Not Available
           Last Update: 5/95
           MSDL: Not Available
           FastTips: (800) 936-4100

WE0107 HPPCL Driver and HP Cartridge Support
        Disk included
        Applies to Excel for Windows version 2.1
        Software/Data Library: WE0107, S13565

   Contains a revised Windows PCL/HP LaserJet driver (version 3.2b),
   which includes support for the HP LaserJet IIP; the disk also
   contains new HP font cartridge support add-on files for the HPPCL
   driver.

WE0145 Importing Excel Graphics into Word
        Software/Data Library: Not available

   Discusses methods of importing graphics from Excel to Microsoft
   Word for MS-DOS version 5.0.

WE0404 Excel Custom Help File Conversion Utility
        Disk included
        Software/Data Library: WE0404, S12923
        MSDL: WE0404.EXE
        Last Update: 2/91

   Contains a utility for creating custom Help for Excel applications.

WE0500     A Practical Guide to Using Q+E, Part I (Also see WE0821)
Article truncated.

	
	


================================================================================


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 18, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.