Microsoft Excel 2003 Advanced Training Course

ADVANCED DATA ENTRY AND FORMATTING TECHNIQUES

• Restricting Cell Entries to Specific Numbers, Dates or Times
• Restricting Cell Entries to Specific Entries in a List
• Creating a Custom Number Format
• Applying Conditional Formatting to a Worksheet

NAMING RANGES

• Defining a Range Name
• Using a Range Name in a Formula
• Selecting a Named Range

USING ADVANCED FUNCTIONS

• Using the VLOOKUP Function
• Using the HLOOKUP Function
  Using the DSUM and DAVERAGE Functions

CREATING A CUSTOM WORKBOOK TEMPLATE

• Creating a New Workbook Template
• Modifying the Default Workbook Template Style
• Basing a New Workbook on a Custom Workbook Template

AUDITING A WORKSHEET

• Tracing Precedents and Dependents in a Worksheet
• Tracing Errors in a Worksheet
• Watch and Evaluate Formulas

LINKING MULTIPLE WORKBOOKS

• Entering a Formula to Link Multiple Workbooks
• Creating a Workspace

FILTERING AND SUMMARIZING WORKSHEET DATA

• Adding Subtotals to a List
• Applying an Advanced Filter to a List
• Outlining a Worksheet

ANALYZING WORKSHEET DATA

• Creating a PivotTable Report
• Resetting the Summary Function in a PivotTable Report
• Creating a PivotChart Report
• Creating and Displaying a Scenario
• Using the Analysis ToolPak
• Using Solver

IMPORTING AND EXPORTING DATA

• Importing Data in a Text File into Excel
• Importing Data in a Database File into Excel
• Importing Data from a Web Page into Excel
• Exporting Excel Data to Other Applications

WORKING WITH OTHER EXCEL USERS

• Tracking Changes in a Workbook
• Responding to Proposed Changes and Comments in a Workbook
• Protecting a Shared Workbook
• Protecting an Unshared Workbook
• Merging Revised Copies of a Workbook
• Additional Security Features