Excel 2001 for Macintosh

Maria Langer is the author of dozens of computer books, including best-selling Visual QuickStart Guides on the Mac OS, Word, and Excel. A columnist for Mac Today magazine and FileMaker Pro Advisor, she also writes for Mac Addict and other publications. Visit her on the Web at www.marialanger.com

Introduction.


Introduction. New & Improved Features in Excel 2001.



1. The Excel Workplace.


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



2. Worksheet Basics.


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



3. Editing Worksheets.


Editing Worksheets. Editing Cell Content. 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.



4. Working with Files.


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



5. Using Functions in Formulas.


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.



6. Formatting Cells.


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



7. Working with Graphic Objects.


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



8. Creating Charts.


Charts. The Chart Wizard. Worksheets & Chart Links. Data Series & Points. Chart Elements. Chart Types. Chart Options. Titles. Axes. Gridlines. Legend. Data Labels. Data Table. Formatting Chart Elements. Other Formatting Options.



9.Printing.


Printing. Printer Drives. The Page Setup Dialog Box. Print Preview. The Print Dialog Box. Printing to a File.



10. Working with Lists.


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



11. Working with Others.


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



12. Using Other Applications.


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



13. Advanced Techniques.


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



14. Web Pages & Hyperlinks.


Web pages. Hyperlinks.



15. Setting Excel Preferences.


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



Appendix A. Menus & Shortcut Keys.


Menus & Shortcut Keys.



Appendix B. Function Reference.


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



Index.