Excel 2003 Level 3 Advanced

Course Overview

Microsoft Office Excel 2003 has helped you to perform tasks like running calculations on data and sorting and filtering numeric data. Now it is time to learn how to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. This course will advance your Excel skills.

Course Objective

Learn to 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.

Target Student

This course is for students who wish to create macros, collaborate with others, review and analyze worksheets, create pivot tables and pivot charts, integrate multiple data sources, and import and export data. Additionally, this course is also for students who are preparing for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam.

Prerequisites

It is recommended that students should have completed the Systematix courses Microsoft Office Excel 2003: Level 1 and Microsoft Office Excel 2003: Level 2 or similar working knowledge of Excel 2003 such as creating, editing, formatting, and printing worksheets that include charts and sorted and filtered data.

We offer a range of Excel training courses

Streamlining Workflow
  • Add Data Validation Criteria
  • Apply Conditional Formatting
  • Create a Macro
  • Customize Access to Excel Commands
  • Edit a Macro
  • Modify Excel's Default Settings
  • Update a Workbook's Properties
Collaborating with Others
  • Adjust Macro Settings
  • Administer Digital Signatures
  • Merge Workbooks
  • Protect Files
  • Review Tracked Revisions
  • Set Revision Tracking
  • Share a Workbook
Auditing Worksheets
  • Group and Outline Data
  • Locate Errors in Formulas
  • Locate Invalid Data and Formulas
  • Trace Cell Dependents
  • Trace Cell Precedents
  • Watch and Evaluate Formulas
Analyzing Data
  • Create Scenarios
  • Create a Trendline
  • Develop a PivotChart¬© Report
  • Develop a PivotTable¬© Report
  • Perform Statistical Analysis with the Analysis ToolPak
  • Perform What-If Analysis
Working with Multiple Workbooks
  • Consolidate Data
  • Create a Workspace
  • Edit Links
  • Link Cells in Different Workbooks
Importing and Exporting Data
  • Export to Microsoft Word
  • Import Text Files
  • Import a Word Table
Structuring XML Workbooks
  • Apply XML View Options
  • Develop XML Maps
  • Import, Add, and Export XML Data
  • Manage XML Workbooks