| Preface |
|
v | |
|
Microsoft Windows 2000 Professional |
|
|
1 | (1) |
|
|
|
3 | |
|
Investigating the Windows 2000 Operating System |
|
|
|
|
|
1 | (1) |
|
Creating, Saving, and Managing Files |
|
|
|
|
|
1 | (1) |
|
Introducing Microsoft Office XP |
|
|
3 | |
|
Preparing Promotional Material for Delmar Office Supplies |
|
|
|
Microsoft Excel 2002---Level I Tutorials |
|
|
1 | (1) |
|
Using Excel to Manage Financial Data |
|
|
3 | |
|
Creating an Income Statement |
|
|
|
Working with Formulas and Functions |
|
|
1 | (1) |
|
|
|
|
Developing a Professional-Looking Worksheet |
|
|
1 | (1) |
|
Formatting a Sales Report |
|
|
|
Working with Charts and Graphics |
|
|
1 | (1) |
|
Charting Sales Data for Vega Telescopes |
|
|
|
Microsoft Excel 2002---Level II Tutorials |
|
|
1 | (1) |
|
|
|
3 | |
|
|
|
|
Working with Multiple Worksheets and Workbooks |
|
|
1 | (1) |
|
Tracking Cash Flow for the Lakeland Boychoir |
|
|
|
Working with Excel's Editing and Web Tools |
|
|
1 | (1) |
|
Collaborating on a Workbook and Web Page |
|
|
|
Developing an Excel Application |
|
|
1 | (1) |
|
Creating a Stock Reporter for Harris & Burton |
|
|
|
Microsoft Excel 2002---Level III Tutorials |
|
|
1 | (1) |
|
Data Tables and Scenario Management |
|
|
3 | |
|
Performing a Cost-Volume-Profit Analysis for Front Range Rafting |
|
|
|
Using Solver for Complex Problems |
|
|
1 | (1) |
|
Determining the Optimal Product Mix for Grill Rite Grills |
|
|
|
Importing Data into Excel |
|
|
1 | (1) |
|
Working with a Stock Portfolio for Davis & Larson |
|
|
|
Enhancing Excel with Visual Basic for Applications |
|
|
1 | (1) |
|
Creating a Quality Control Application for Datalia Inc. |
|
|
|
Additional Case 1 Sales Invoicing for Island Dreamz Shoppe |
|
|
1 | (1) |
|
Additional Case 2 Performance Reporting for Biodeck, Inc. |
|
|
1 | (1) |
|
Additional Case 3 Negotiating Salaries for the National Basketball Association |
|
|
1 | (1) |
|
Additional Case 4 Analyzing Product Mix for Stardust Telescopes |
|
|
1 | (1) |
| Appendix 1 Working with Logical Functions |
|
1 | (1) |
|
Recording Employee Financial Data |
|
|
| Appendix 2 Integrating Excel with Other Windows Programs |
|
1 | (1) |
|
Creating Integrated Documents for the Lighthouse |
|
|
| Appendix 3 Creating Custom Formats |
|
1 | (1) |
|
Formatting Stock Market Data |
|
|
| Appendix 4 Saving Pivot Tables in HTML Format |
|
1 | (1) |
|
Creating Interactive Pivot Tables for the Web |
|
|
| Index |
|
1 | (14) |
| Task Reference |
|
15 | (14) |
| MOUS Certification Grid |
|
29 | (6) |
| File Finder |
|
35 | |