Microsoft Excel 2003 Training Outline


  1. The Fundamentals
    1. Starting Excel
    2. What's New in Excel 2003?
    3. Understanding the Excel Program Screen
    4. Using Menus
    5. Using Toolbars and Creating a New Workbook
    6. Hiding, Displaying, and Moving Toolbars
    7. Filling Out Dialog Boxes
    8. Keystroke and Right Mouse Button Shortcuts
    9. Opening a Workbook
    10. Saving a Workbook
    11. Moving the Cell Pointer
    12. Navigating a Worksheet
    13. Entering Labels in a Worksheet
    14. Entering Values in a Worksheet and Selecting a Cell Range
    15. Calculating Value Totals with AutoSum
    16. Entering Formulas
    17. Using AutoFill
    18. Previewing and Printing a Worksheet
    19. Getting Help from the Office Assistant
    20. Changing the Office Assistant and Using the "What's This" Button
    21. Closing a Workbook and Exiting Excel
  2. Editing a Workbook
    1. Entering Date Values and using AutoComplete
    2. Editing, Clearing, and Replacing Cell Contents
    3. Cutting, Copying, and Pasting Cells
    4. Moving and Copying Cells with Drag and Drop
    5. Collecting and Pasting Multiple Items
    6. Working with Absolute and Relative Cell References
    7. Using the Paste Special Command
    8. Inserting and Deleting Cells, Rows, and Columns
    9. Using Undo, Redo, and Repeat
    10. Checking Your Spelling
    11. Finding and Replacing Information
    12. Advanced Printing Options
    13. File Management
    14. Inserting Cell Comments
  3. Formatting a Worksheet
    1. Formatting Fonts with the Formatting Toolbar
    2. Formatting Values
    3. Adjusting Row Height and Column Width
    4. Changing Cell Alignment
    5. Adding Borders
    6. Applying Colors and Patterns
    7. Using the Format Painter
    8. Using AutoFormat
    9. Creating a Custom Number Format
    10. Creating, Applying, and Modifying a Style
    11. Formatting Cells with Conditional Formatting
    12. Merging Cells, Rotating Text, and using AutoFit
  4. Creating and Working with Charts
    1. Creating a Chart
    2. Moving and Resizing a Chart
    3. Formatting and Editing Objects in a Chart
    4. Changing a Chart's Source Data
    5. Changing a Chart Type and Working with Pie Charts
    6. Adding Titles, Gridlines, and a Data Table
    7. Formatting a Data Series and Chart Axis
    8. Annotating a Chart
    9. Working with 3-D Charts
    10. Selecting and Saving a Custom Chart
    11. Using Fill Effects
    12. Mapping Data
    13. Modifying a Map
  5. Managing Your Workbooks
    1. Switching Between Sheets in a Workbook
    2. Inserting and Deleting Worksheets
    3. Renaming and Moving Worksheets
    4. Working with Several Workbooks and Windows
    5. Splitting and Freezing a Window
    6. Referencing External Data
    7. Creating Headers, Footers, and Page Numbers
    8. Specifying a Print Area and Controlling Page Breaks
    9. Adjusting Page Margins and Orientation
    10. Adding Print Titles and Gridlines
    11. Changing the Paper Size and Print Scale
    12. Protecting a Worksheet
    13. Hiding Columns, Rows and Sheets
    14. Viewing a Worksheet and Saving a Custom View
    15. Working with Templates
    16. Consolidating Worksheets
  6. More Functions and Formulas
    1. Formulas with Several Operators and Cell Ranges
    2. Using the Formula Palette to Enter and Edit Formulas
    3. Creating and Using Range Names
    4. Selecting Nonadjacent Ranges and Using AutoCalculate
    5. Using the IF Function to Create Conditional Formulas
    6. Using the PMT Function
    7. Displaying and Printing Formulas
    8. Fixing Errors in Your Formulas
    9. Mathematical Functions (Reference)
    10. Financial Functions (Reference)
    11. Date and Time Functions (Reference)
    12. Statistical Functions (Reference)
    13. Database Functions (Reference)
  7. Working with Lists
    1. Creating a List
    2. Using the Data Form to Add Records
    3. Finding Records
    4. Deleting Records
    5. Sorting a List
    6. Filtering a List with the AutoFilter
    7. Creating a Custom AutoFilter
    8. Filtering a List with an Advanced Filter
    9. Copying Filtered Records
    10. Using Data Validation
  8. Automating Tasks with Macros
    1. Recording a Macro
    2. Playing a Macro and Assigning a Macro a Shortcut Key
    3. Adding a Macro to a Toolbar
    4. Editing a Macro's Visual Basic Code
    5. Inserting Code in an Existing Macro
    6. Declaring Variables and Adding Remarks to VBA Code
    7. Prompting for User Input
    8. Using the If…Then…Else Statement
  9. Working with Other Programs
    1. Inserting an Excel Worksheet into a Word Document
    2. Modifying an Inserted Excel Worksheet
    3. Inserting a Linked Excel Chart in a Word Document
    4. Inserting a Graphic into a Worksheet
    5. Opening and Saving Files in Different Formats
  10. Using Excel with the Internet
    1. Adding Hyperlinks to a Worksheet
    2. Browsing Hyperlinks and using the Web Toolbar
    3. Saving a Workbook as a Non-Interactive Web Page
    4. Saving a Workbook as an Interactive Web Page
    5. Using Queries to Retrieve Information from the Web
  11. Data Analysis and PivotTables
    1. Creating a PivotTable
    2. Specifying the Data a PivotTable Analyzes
    3. Changing a PivotTable's Calculation
    4. Selecting What Appears in a PivotTable
    5. Grouping Dates in a PivotTable
    6. Updating a PivotTable
    7. Formatting and Charting a PivotTable
    8. Creating Subtotals
    9. Using Database Functions
    10. Using Lookup Functions
    11. Grouping and Outlining a Worksheet
  12. What-If Analysis
    1. Defining a Scenario
    2. Creating a Scenario Summery Report
    3. Using a One and Two-Input Data Table
    4. Understanding Goal Seek
    5. Using Solver
  13. Advanced Topics
    1. Creating and Using Custom Toolbars
    2. Creating a Custom AutoFill List
    3. Changing Excel's Options
    4. Password Protecting a Workbook
    5. File Properties and Finding a File
    6. Sharing a Workbook and Tracking Changes
    7. Merging and Revising a Shared Workbook
    8. Using Detect and Repair

 

Contact Us | Courses | New! Office 2007 Preview! | Methodology | Sample Lab Exercise