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
• llustrate 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