Course 4124: Advanced Training for Microsoft Excel 2002

Introduction This course provides an overview of the advanced capabilities of Microsoft® Excel 2002, including the following: performing calculations and formatting data, combining and organizing data, analyzing alternative sets of data, creating charts and pivot tables, automating repetitive tasks with macros, publishing data to the web, and collaborating with others.

This course has been certified as Microsoft Office Specialist Approved Courseware, and covers all exam skill standards.

Modules & Lessons Advanced Training for Microsoft® Excel 2002 Pre-Assessment Pre-Assessment Performing Calculations and Formatting Data Lesson Introduction Creating Formulas to Calculate Values Finding and Correcting Errors in Calculations Making Numbers Easier to Read Formatting Data Based on Its Value Creating Rules to Validate Data Limiting the Data that Appears on the Screen Creating a Template from an Existing Workbook Combining and Organizing Data Lesson Introduction Working with More Than One Set of Data Summarizing Multiple Sets of Data Grouping Multiple Data Lists Organizing Data into Levels Retrieving Data from a Database Looking Up Information in a Data List Analyzing Alternative Sets of Data Lesson Introduction Defining and Editing Alternative Data Sets Defining Multiple Alternative Data Sets Varying Your Data to Get a Desired Result Finding Trends in Data Creating Charts and PivotTables Lesson Introduction Creating Dynamic Lists with PivotTables Editing PivotTables Creating PivotTables from External Data Creating a Dynamic Chart Using PivotCharts Automating Repetitive Tasks with Macros Lesson Introduction Introducing Macros Creating and Modifying Macros Creating a Toolbar to Hold Macros Creating a Menu to Hold Macros Running a Macro When a Workbook Is Opened Publishing Data to the Web Lesson Introduction Saving a Workbook as a Web Page Publishing Worksheets as Web Pages Publishing a PivotTable as a Web Page Working with Structured Data Collaborating with Others Lesson Introduction Sharing a Data List Managing Comments in a Workbook Tracking and Managing Changes in a Workbook Identifying Which Revisions to Keep Protecting Workbooks and Worksheets Post Assessment Post Assessment Reference and Glossary Quick Reference Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled