Table of Contents

Excel 2003
(back to Class Materials) (back to Course List)

Essentials | Intermediate | Advanced

Essentials

• Getting Started

  • Explore Excel

  • Changing the Active Cell

  • Navigate Between Worksheets

  • Close and Open Workbooks

  • Name and Save a Workbook

  • Preview & Printing a Worksheet

  • Using Help

  • Close a Workbook and Exit Excel

• Creating Workbooks
  

  • Opening New Workbooks

  • Types of Data

  • Keying Data in a Worksheet

  • Commenting

  • Renaming & Deleting a Workbook

• Modifying Worksheets

  • Add and Delete Worksheets

  • Insert and Delete Rows, Columns & Cells

  • Copy & Paste Columns, Rows & Cells

  • Moving Cells & AutoFill

• Formatting Worksheets

  • Formatting Text

  • AutoFormat

  • Changing Auto Format Options

  • Adding Colors & Patterns

  • Adding Borders

  • Column Width & Row Height

  • Numeric Formats

  • Alignment of data

• Printing Workbooks

  • Print Options

  • Hiding Data

  • Headers & Footers

• Elements

  • Adding Images

  • Modifying Images

  • Adding WordArt

  • Adding AutoShapes

  • Chart Terminology

  • Chart Wizard

(back to top)

Intermediate

• Formatting Worksheets

  • Naming Cells & Ranges

  • Naming Constants

  • Creating Lists

  • AutoFilter

  • Designated Lists

• Elements

  • Diagramming

  • Organizational Charts

  • Adding a Hyperlink

• Formulas

  • Creating Formulas

  • Relative & Absolute

  • External References

  • Named Constants

  • Functions

• Enhanced Worksheets

  • Fonts & Merging

  • Shading & Format Painter

  • Renaming & Color Worksheet Tabs

• Charts

  • Format Charts

  • Insert Images

  • Print Charts

• Finding & Replacing Data

  • Files Search

  • Find, Replace, and Go To

(back to top)

Advanced

• Templates, Styles & AutoFormats

  • Templates

  • Styles

  • AutoFormat

  • Changing AutoFormat Options

• Importing & Exporting Data

  • Import from Word

  • Delimited Data

  • Exporting Data

• Using Multiple Worksheets

  • Consolidation

• Advanced Functions

  • IF

  • Date & Time

  • LOOKUP

• Analysis Tools

  • What-If

  • Goal Seek

  • Data Table

  • Scenarios

• Pivot Tables

  • Pivot Tables

• Macros

  • Recording a Macro

• Sharing & Collaboration

  • Consolidating Data

  • Creating Shared Workbooks

  • Resolving Workbook Confilcts

  • Tracking Changes

  • Show History of Changes

  • Removing Shared Use of Workbook

(back to top)