1-866-245-5224 sales@keystonelearning.com

Excel 2003: Excel 2003 Course Overview (All Levels)

Excel 2003: Excel 2003 Course Overview (All Levels)

The Excel 2003 Course contains three levels: Beginner, Intermediate and Advanced. You can view the topics by level by clicking the links below:

Level 1: Beginner

Level 2: Intermediate

Level 3: Advanced

Excel 2003 Beginner Course Overview

Part of the Microsoft Office 2003 suite, Excel 2003 is Microsoft’s powerful spreadsheet program whose primary purpose is to help you crunch numbers – both big and small. This beginner-level course will familiarize you with the fundamentals of Excel 2003 to help you get started using the commanding program quickly.

Specific topics include:

Getting Started

    Launching Excel 2003

    Touring the Excel Window

    Getting Help



Entering Data

    Creating a New Workbook

    Navigation & Selection Techniques

    Data Entry Techniques

    Undo, Redo & Repeat

    Save vs. Save As

    Exiting Excel



Changing Worksheet Layout

    Opening & Closing Files

    Inserting Rows, Columns & Cells

    Deleting Rows, Columns & Cells

    Adjusting Column Widths & Row Heights

    Hiding Columns & Rows

    Moving & Copying Data

    Go To, Find & Replace



Formatting

    Using the Formatting Toolbar

    Number Formats

    AutoFill

    AutoComplete

    Merging & Splitting Cells

    Applying Worksheet Backgrounds



Entering Formulas

    Anatomy of a Formula

    AutoSum

    Basic Functions

    Copying Formulas



Printing

    Changing Margins & Page Orientation

    Exploring Worksheet Views

    Adding Headers & Footers

    Adding Print Titles and a Print Area

    Viewing & Setting Page Breaks

    Printing



Charts

    Creating a Chart

    Creating a Chart Sheet

    Adding & Removing Chart Data

    Format & Resize Charts



Return to Top



Excel 2003 Intermediate Course Overview

Part of the Microsoft Office 2003 suite, Excel 2003 is Microsoft’s powerful spreadsheet program whose primary purpose is to help  you crunch numbers. And, Excel 2003 is better than ever with a new results-oriented user interface. In this intermediate-level course, you’ll learn about working with large workbooks, PivotTables and much more.

Specific topics include:

Managing Workbooks

    Creating New Workbooks from a Template

    Rename & Move Workbook Tabs

    Insert & Delete Worksheets

    Copy & Paste Worksheets

    Splitting Your Worksheet View

    Freezing & Unfreezing Your View



Tables & Data Management

    Table Guidelines

    Sorting

    AutoFilter

    Advanced Filter Using Single Criteria

    Advanced Filter Using Multiple Criteria

    Automatic Subtotals



Using Cell References

    Using Relative Cell References

    Using Absolute Cell References

    Using Mixed Cell References



Auditing

    About Auditing

    Tracing Precedents

    Tracing Dependants

    Tracing Errors



Creating Web Pages from Workbooks

    Publishing a Web Page

    Viewing Your Published Web Page



Using Excel with Other Applications

    Importing Data to Excel

    Exporting Data from Excel

    Using the Microsoft Query Feature



Customizing Excel

    Customizing Toolbars

    Modifying Excel Options



Using Scenarios

    Creating & Displaying Scenarios

    Editing & Removing Scenarios

    Summarizing Scenarios



PivotTables & PivotCharts

    About PivotTables & PivotCharts

    Creating a PivotTable

    Modifying a PivotTable

    Creating a PivotChart



Return to Top



Excel 2003 Advanced Course Overview

Part of the Microsoft Office 2003 suite, Excel 2003 is Microsoft’s powerful spreadsheet program whose primary purpose is to help you crunch numbers – both big and small. And, Excel 2003 is better than ever with a new results-oriented user interface. This advanced-level course will take your Excel 2003 knowledge to a new level by covering advanced formulas and functions as well as data consolidation, data validation, conditional formatting and macros.

Specific topics include:

Collaborating

    Inserting & Deleting Comments

    Viewing & Printing Comments

    Protect Workbooks, Worksheets &  Cells

    Enable Workbook Security



Advanced Formulas & Functions

    IF Functions

    Nested IF Functions

    Using the VLOOKUP Function

    Using the HLOOKUP Function

    Using the DSUM Function



Data Consolidation

    About Data Consolidation

    Three Dimensional Formulas

    Data Consolidation by Position

    Data Consolidation by Category



Track Revisions

    Tracking Changes

    Accepting & Rejecting Changes



Data Validation & Conditional Formatting

    Working with Data Validation Rules

    Set Conditional Formatting

    Use Expressions in Conditional Formatting



Macros

    Create a Macro

    Run a Macro

    Edit a Macro



Return to Top