Course 4101: Advanced Training for Microsoft Office Excel 2003

Introduction This course provides an overview of the advanced capabilities of Microsoft® Office Excel 2003, including the following: working with Excel and other Office programs, organizing data, performing calculations on data, analyzing data, working with pivot tables, working with graphics and charts, working with database data and macros, publishing on the Web and using XML, and collaborating in Excel.

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

Modules & Lessons Advanced Training for Microsoft Office Excel 2003 Pre-Assessment Pre-Assessment Working with Excel and Other Office Programs Lesson Introduction Creating a Template from an Existing Worksheet Modifying Workbook Settings Using Custom Data Formats Sharing Data Between Excel and Other Office Programs Organizing Data Lesson Introduction Limiting the Data That Appears on the Screen Performing Calculations on Filtered Data Validating Data Changing Data Appearance Based on Value Summarizing and Grouping Multiple Sets of Data Performing Calculations on Data Lesson Introduction Naming Cell Ranges Creating Formulas to Calculate Values Finding and Correcting Errors in Calculations Analyzing Data Lesson Introduction Defining and Editing Alternative Data Sets Defining Multiple Alternative Data Sets Working with Goal Seek and Solver Analyzing Data with Descriptive Statistics Working with PivotTables Lesson Introduction Creating and Using PivotTables Editing PivotTables Creating PivotTables from External Data Working with Graphics and Charts Lesson Introduction Formatting and Resizing Graphics Creating a Chart Creating a Dynamic Chart Using PivotCharts Working with Database Data and Macros Lesson Introduction Locating and Retrieving Data from a Database Summarizing List Data Introducing Macros Creating and Modifying Macros Publishing on the Web and Using XML Lesson Introduction Converting an Excel Workbook to XML Using XML Data Capabilities and Retrieving Web Data Publishing Worksheets and PivotTables on the Web Collaborating in Excel Lesson Introduction Sharing and Comparing Workbooks Managing Comments Tracking and Managing Changes 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