Microsoft Excel 2003: Level 3

Revision: TE1315_20060318

Course Length:

1 Day

Course Description:

In this course, you will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. This is one of a series of courses that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Who Should Attend:

Students wanting to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data should attend this course. The course is also for students preparing for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam.

Benefits of Attendance:

Upon completion of this course, students will be able to:

• Customize workbooks.
• Collaborate with others using workbooks.
• Audit worksheets.
• Analyze data.
• Work with multiple workbooks.
• Import and export data.
• Structure workbooks with XML.

Prerequisites:

Students should have taken Microsoft® Office Excel 2003: Level 1 and Microsoft® Office Excel 2003: Level 2 or have equivalent knowledge.

Course Outline:

• Chapter 1: Streamlining Workflow
  1. Creating a Macro
  2. Editing a Macro
  3. Customizing Access to Excel Commands
  4. Applying Conditional Formatting
  5. Adding Data Validation Criteria
  6. Updating a Workbook's Properties
  7. Modifying Excel's Default Settings
• Chapter 2: Collaborating With Others
  1. Protecting Files
  2. Sharing a Workbook
  3. Setting Revision Tracking
  4. Reviewing Tracked Revisions
  5. Merging Workbooks
  6. Adjusting Macro Settings
  7. Administering Digital Signatures
• Chapter 3: Auditing Worksheets
  1. Tracing Cell Precedents
  2. Tracing Cell Dependents
  3. Locating Errors in Formulas
  4. Locating Invalid Data and Formulas
  5. Watching and Evaluating Formulas
  6. Grouping and Outlining Data
• Chapter 4: Analyzing Data
  1. Creating a Trendline
  2. Creating Scenarios
  3. Performing What-If Analysis
  4. Developing a PivotTable© Report
  5. Developing a PivotChart© Report
  6. Performing Statistical Analysis with the Analysis ToolPak
• Chapter 5: Working With Multiple Workbooks
  1. Creating a Workspace
  2. Consolidating Data
  3. Linking Cells in Different Workbooks
  4. Editing Links
• Chapter 6: Importing And Exporting Data
  1. Exporting to Microsoft Word
  2. Importing a Word Table
  3. Importing Text Files
• Chapter 7: Structuring XML Workbooks
  1. Developing XML Maps
  2. Importing, Adding, and Exporting XML Data
  3. Managing XML Workbooks
  4. Applying XML View Options
• Appendix A: Microsoft Office Specialist Program