Microsoft Excel sets the standard for spreadsheet programs. Its versatility and functionality have made it the most popular spreadsheet program for Windows. It boasts an impressive set of tools to create, analyze, and share spreadsheets. With Excel 2002, Microsoft has added new features such as context-sensitive smart tags, new task panes, and Document Recovery to this popular product. ExcelÕs compatibility with other Office 2002 products and its improved collaboration and Web integration features, including the ability to add data from Web sources, make it the perfect tool for sharing information on the Internet or intranets.
Excel 2002 for Windows: Visual QuickStart Guide offers a friendly, gentle tour through all the features of Excel 2002. Starting with worksheet basics, readers will learn to edit, use functions, format cells, and add graphic objects. Then this Visual QuickStart Guide moves on to charts, printing, databases, Web publishing, and advanced techniques in Excel. This visual guide can be used as a task-based reference or as a tutorial.
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.
Overview
Microsoft Excel sets the standard for spreadsheet programs. Its versatility and functionality have made it the most popular spreadsheet program for Windows. It boasts an impressive set of tools to create, analyze, and share spreadsheets. With Excel 2002, Microsoft has added new features such as context-sensitive smart tags, new task panes, and Document Recovery to this popular product. ExcelÕs compatibility with other Office 2002 products and its improved collaboration and Web integration features, including the ...