Excel 2001 for Macintosh

Using the same task-based, visual reference format of the Visual QuickStart Guide series, you'll learn how to enter data and formulas, structure and format a worksheet, use charts and reports, and incorporate Web documents into a spreadsheet.

Contents

• Introduction
• New & Improved Features in Excel 2001

• Meet Microsoft Excel
• The Mouse
• Menus
• Shortcut Keys
• Toolbars & Palettes
• Dialog Boxes
• Scrolling Window Contents
• The Office Assistant
• Excel Help

• How Worksheets Work
• Launching Excel
• Quitting Excel
• Excel Workbooks, Templates, & Wizards
• The Project Gallery
• Creating Workbooks
• Activating & Selecting Cells
• Entering Values & Formulas
• Values
• Formula Basics
• The Calculator
• Natural Language Formulas

• Editing Worksheets
• Editing Cell Contents
• Inserting & Deleting Cells
• Copying Cells
• Copying with Copy & Paste
• The Fill Handle
• The Fill Command
• Series & AutoFill
• Copying Formulas
• Relative vs. Absolute Cell References
• Mixed References
• Moving Cells
• The Office Clipboard
• Undoing, Redoing, & Repeating Actions

• Excel Files
• Workbook Sheets
• Workbook Windows
• Saving Files
• Opening Existing Files

• Functions
• Anatomy of a Function
• Arguments
• Entering Functions
• Math & Trig Functions
• Statistical Functions
• Financial Functions
• Logical Functions
• Lookup and Reference Functions
• Information Functions
• Date and Time Functions
• Text Functions

• Formatting Basics
• Number Formatting
• Alignment
• Font Formatting
• Borders
• Cell Shading
• Styles
• Conditional Formatting
• The Format Painter
• Column Width & Row Height
• AutoFit
• AutoFormat
• Removing Formatting from Cells

• Graphic Objects
• The Drawing Toolbar
• Drawing Objects
• Inserting Pictures
• Working with Graphic Objects
• Stacking Order

• Charts
• The Chart Wizard
• Worksheet & Chart Links
• Data Series & Points
• Chart Elements
• Chart Type
• Chart Options
• Titles
• Axes
• Gridlines
• Legend
• Data Labels
• Data Table
• Formatting Chart Elements
• Other Formatting Options

• Printing
• Printer Drivers
• The Page Setup Dialog Box
• Print Preview
• The Print Dialog Box
• Printing to a File

• List Basics
• Using the Data Form
• The List Manager
• AutoFilter
• Advanced Filters
• Sorting
• Subtotals
• Database Functions

• Collaboration Features
• Document Properties
• Comments
• Revision Tracking
• Document Protection
• Save Options & Password Protection
• Workbook Sharing

• Using Excel with Other Applications
• OLE Objects
• Using Word with Excel
• Using Entourage with Excel
• Using FileMaker Pro with Excel

• Advanced Techniques
• Names
• 3-D References
• Opening Worksheets with Links
• Consolidations
• Custom Views
• Macros

• Web Pages
• Hyperlinks

• The Preferences Dialog Box
• View Preferences
• Calculation Preferences
• Edit Preferences
• General Preferences
• Transition Preferences
• Custom Lists Preferences
• Chart Preferences
• Color Preferences

• Menus & Shortcut Keys

• Functions
• Financial Functions
• Date & Time Functions
• Math & Trig Functions
• Statistical Functions
• Lookup & Reference Functions
• Database Functions
• Text Functions
• Logical Functions
• Information Functions