Excel 2002 for Windows
Visual QuickStart Guide
Published on 24. August 2001
Book
Paperback/Softback
320 pages
978-0-201-75844-3 (ISBN)
Description
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.
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.
More details
Language
English
Place of publication
Berkeley
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 178 mm
Width: 228 mm
Thickness: 15 mm
Weight
481 gr
ISBN-13
978-0-201-75844-3 (9780201758443)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
Book
01/2004
Peachpit Press Publications
€23.51
Article exhausted; check for reprint
Previous edition
Book
06/1999
Addison Wesley
€19.80
Article exhausted; check for reprint
Person
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.
Content
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.
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.