Excel

Microsoft Excel Level 1
Lesson 1
• The Excel program
• The workbook environment
Lesson 2
• Entering and correcting data
• Saving a file
• Using formulas
• Opening a second file

Lesson 3
• Working with ranges
• Working with functions
• Editing cell contents
Lesson 4
• Inserting rows and ranges
• Moving data
• Copying data
• Absolute references
• Using the Fill Series feature
Lesson 5
• Formatting a worksheet
• Number formats and text alignment
• Copying and pasting formats
• Special and custom formatting

Lesson 6
• Using the Print Preview command
• Printing a large worksheet
• Additional print options
Lesson 7
• Using a multiple-sheet workbook
• Creating a chart
• Outlining

Microsoft Excel Level 2
Curriculum
Lesson 1
• Creating a chart sheet
• Creating an embedded chart
• Comparing chart sheets with embedded charts
Lesson 2
• Chart types
• Modifying embedded charts
• Adding and deleting chart items
• Moving and sizing chart items
Lesson 3
• Formatting chart text
• Formatting labels
• Formatting the chart
• Printing a chart sheet
Lesson 4
• Adding graphic objects
• Formatting graphic objects
• Using graphic objects to enhance worksheets and
Lesson 5
• Single-level sorting
• Multiple-level sorting
• Sorting options
• Design considerations
Lesson 6
• Filtering a list
• Multiple-condition criteria
• Managing a filtered list

Microsoft Excel Advanced

Lesson 1: Customizing the work area
• Creating and using styles
• Using templates
Lesson 2: Advanced formula construction
• Using names
• Using the IF function
• Using the VLOOKUP function and HLOOKUP
• Using IS functions
Lesson 3: Using pivot tables
• Creating pivot tables
• Modifying pivot tables
• Grouping and summarizing data in a pivot table
Lesson 4: Working with multiple worksheets
• Working with workbooks
• Linking cells in different workbooks
Lesson 5: Consolidating and analyzing data
• Consolidating data from more than one worksheet
Lesson 6: Using protection and display options
• Using comments
• Protecting workbooks

Lesson 7: Introduction to macros
• Running macros
• Recording a macro