Excel 2002 for Windows

Maria Langer is the author of Excel 2000 for Windows: Visual QuickStart Guide (0-201-35427-6), and she has written more than a dozen other computer books, including the newly-released Mac OS X: Visual QuickStart Guide (0-201-70900-7). When not writing books, she can be found terrorizing the skies of Arizona in her helicopter.

Introduction to Excel 2002.


Introduction. New & Improved Features in Excel 2002.



1. The Excel Workplace.


Meet Microsoft Excel. The Excel Screen. The Mouse. Menus. Shortcut Keys. Toolbars. The Task Pane. Dialogs. Scrolling Window Contents. The Office Assistant. Excel Help.



2. Worksheet Basics.


How Worksheets Work. Running Excel. Exiting Excel. Creating a New Workbook. Activating & Selecting Cells. Entering Values & Formulas. Values. Formula Basics. Error Checking Smart Tag.



3. Editing Worksheets.


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 Strategies.



4. Working with Files. Excel Files.


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



5. Using Functions in Formulas.


Functions. Anatomy of a Formula. 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. Borders. 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. 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.



9. Printing.


Printing. The Page Setup Dialog. Print Preview. The Print Dialog.



10. Working with Lists.


List Basics. Using the Data Form. 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 Programs.


Using Excel with Other Programs. OLE Objects. Using Word with Excel. Using Outlook with Excel.



13. Advanced Techniques.


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



14. Web Publishing.


Web Publishing. Creating Web Pages. Hyperlinks.



15. Setting Excel Options.


The Options Dialog. View Options. Calculation Options. Edit Options. General Options. Transition Options. Custom Lists Options. Chart Options. Color Options. International Options. Save Options. Error Checking Options. Spelling Options. Security Options.



Appendix A: Menus & Shortcut Keys.


Menus & Shortcut Keys. File Menu. Edit Menu. View Menu. Insert Menu. Format Menu. Tools Menu. Chart Menu. Data Menu. Windows Menu. Help Menu.



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.