Excel 2003 Advanced, 2nd Edition + Certblaster Study Guide

1-4188-8937-7 © 2007 Publish date: January 26, 2006 188 pages

Buy Now: $25.99

Course ID: excel-2003-adv-2nd-sg

Now that you have intermediate skills using Microsoft Excel, consider upgrading your skills to the advanced level by choosing the Excel 2003 Advanced study guide from our line of MS Excel computer training books.

ProCert Labs have rated this Excel 2003 Advanced courseware 4.9/5.0 in overall quality. By following each section and participating in the hands-on assignments, you will learn the advanced-level features of Excel 2003. You will learn about creating nested functions, exporing and importing data, performing "what-if" analyses, using the Goal Seek and Solver utilities, recording and running macros, and using SharePoint services.

In addition to the high rating, this course is also approved Microsoft Excel training courseware for Microsoft Office Specialist certification. You can use this study guide to prepare yourself for your certification exams without having to attend classes. If you are pursuing certification, this is an excellent choice for self-directed training and exam preparation. In addition, the course becomes a useful reference book for future use when using Excel.

The Excel 2003 Advanced courseware is written by experts who present the information in a logical, easy-to-understand manner. Follow along unit by unit and do the activities. By the end of the course, you will have advanced skills using Microsoft Excel and will be able to use these techniques in your own spreadsheets.

Course Objectives

By choosing this courseware, you will learn how to use magnification, and split and frozen panes for navigating large worksheets. You will also learn how to control printing when working with large spreadsheets.

You will learn techniques for working with multiple worksheets including how to link workbooks with 3-D formulas, summarizing data, and printing multiple sheets.

You will learn how to adjust and customize various settings, toolbars, and menus. Apply special formatting including adding borders and shading, using styles, and adjusting a cell's orientation. Other topics include sorting and filtering using complex criteria, creating trend lines, formatting data points, creating combination charts, using graphics, using auditing features, protecting worksheets, adding comments, and using both built-in and custom templates.

Course Contents

Unit 1 introduces advanced formulas

• Using names
• Working with decision-making functions
• How to create nested functions
• Using financial functions

Unit 2 covers lookups and data tables

• Using lookup functions
• Working with MATCH and INDEX
• Creating data tables

Unit 3 discusses advanced list management

• Subtotals
• Validating cell entries
• Database functions
• Using data forms

Unit 4 covers PivotTables and PivotCharts

• Using PivotTables
• Rearranging PivotTables
• How to format PivotTables
• Using PivotCharts

Unit 5 discusses exporting and importing

• Importing and exporting text files
• Importing and exporting XML data
• Querying external databases

Unit 6 covers working with Excel's analytical options

• Using Goal Seek and Solver
• Using the Analysis ToolPak
• Using scenarios
• Using views

Unit 7 talks about working with macros

• Running and recording macros
• Using VBA code
• Function procedures

Unit 8 covers creating interactive Web pages

• How to create interactive Web spreadsheets
• How to publish PivotTables on the Web

Unit 9 talks about working with SharePoint services

• Document Workspaces

Appendix A discusses smart documents

Appendix B contains the Microsoft Office Specialist exam objectives maps

• Specialist exam objectives
• Expert exam objectives