Microsoft Office Excel

Lesson 1: Performing Calculations

• Create Basic Formulas 
• Calculate with Functions 
• Copy Formulas and Functions 

Lesson 2: Modifying a Worksheet

• Manipulate Data 
• Insert and Delete Cells, Columns, and Rows 
• Search for Data in a Worksheet 
• Spell Check a Worksheet 

Lesson 3: Formatting a Worksheet

• Modify Fonts 
• Add Borders and Color to Cells 
• Change Column Width and Row Height 
• Apply Number Formats 
• Position Cell Contents 
• Apply Cell Styles 

Lesson 4: Printing Workbook Contents

• Print Workbook Contents Using Default Print Options
• Set Print Options
• Set Page Breaks

Lesson 5: Managing Large Workbooks

• Format Worksheet Tabs
• Manage Worksheets in a Workbook
• Manage the View of Large Worksheets

Lesson 6: Calculating Data with Advanced Formulas

• Manage Cell and Range Names
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions

Lesson 7: Organizing Worksheet and Table Data

• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Calculate Data in a Table or Worksheet

Lesson 8: Presenting Data Using Charts

• Create a Chart
• Modify Charts
• Format Charts

Lesson 9: Inserting Graphic Objects

• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes I
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects

Lesson 10: Collaborating with Others

• Protect Files
• Share a Workbook
• Set Revision Tracking
• Review Tracked Revisions
• Merge Workbooks
• Administer Digital Signatures
• Restrict Document Access

Lesson 11: Working with Multiple Workbooks

• Create a Workspace
• Consolidate Data
• Link Cells in Different Workbooks
• Edit Links

Lesson 12: Importing and Exporting Data

• Export Excel Data
• Import a Delimited Text File