Lesson 1: Creating a Basic Excel Worksheet

Identify the Excel User Interface
Customize the Excel Interface
Work with Cells
Enter Data in an Excel Workbook
Obtain Help
Lesson 2: Performing Calculations in an Excel Worksheet

Create Basic Formulas
Calculate Using Functions
Copy Formulas and Functions
Lesson 3: Modifying an Excel Worksheet

Manipulate Worksheet Data
Modify Worksheet Elements
Search Worksheet Data
Modify Rows and Columns
Lesson 4: Formatting an Excel Worksheet

Modify Fonts
Spell Check a Worksheet
Apply Number Formats
Add Borders and Colour to Cells
Align Cell Contents
Apply Cell Styles
Lesson 5: Printing Excel Workbooks

Set Page Breaks
Set Page Layout Options
Print a Workbook
Lesson 6: Managing an Excel Workbook

Format Worksheet Tabs
Manage Worksheets
Manage Workbook Views
Microsoft Excel 2010 Level 2

Lesson 1: Calculating Data with Advanced Formulas

Apply Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data

Create and Modify Tables
Format Tables
Sort or Filter Worksheet or Table Data
Use Functions to Calculate Data in a Table or Worksheet
Lesson 3: Presenting Data Using Charts

Create a Chart
Modify Charts
Format Charts
Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

Create a PivotTable Report
Filter Data Using Slicers
Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects

Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment

Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates
Microsoft Excel 2010 Level 3

Lesson 1: Streamlining Workflow

Update Workbook Properties
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Lesson 2: Collaborating with Others

Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Administer Digital Signatures
Restrict Document Access
Lesson 3: Auditing Worksheets

Trace Cells
Troubleshoot Errors in Formulas
Watch and Evaluate Formulas
Create a Data List Outline
Lesson 4: Analysing Data

Create a Trendline
Create Sparklines
Create Scenarios
Perform What-If Analysis
Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks

Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links
Lesson 6: Importing and Exporting Data

Export Excel Data
Import a Delimited Text File
Lesson 7: Using Excel with the Web

Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query
Lesson 8: Structuring Workbooks with XML

Develop XML Maps
Import and Export XML Data
Microsoft Excel 2010 Level 4

Lesson 1: Manipulating Data Using Statistical and Lookup Functions

Forecast GDP Using Statistical Functions
Evaluate Sales Data Using Statistical Functions
Analyze Stock Data Using Statistical Functions
Mine Data Using the Lookup and Reference Functions
Lesson 2: Analyzing Data Using Data Analysis Tools

Analyze Sales Data Using Descriptive Statistics
Analyze Time Series Data Using Exponential Smoothing
Analyze Data Using Regression
Identify the Beta Value of a Security
Analyze Sector Data Using Correlation and Covariance Matrices
Optimize a Stock Portfolio Using Solver
Lesson 3: Working with Data Using Financial Functions

Develop an Investment Schedule Using Financial Functions
Make Investment Decisions Using Financial Functions

Lesson 4: Examining Data Using Math Functions

Analyze Sales Data Using Math Functions
Calculate Stock Returns Using Math Functions
Aggregate GDP Data Using Math Functions
Lesson 5: Manipulating Data Using Text and Information Functions

Manipulate Data Using Text Functions
Validate Data Using Information Functions
Lesson 6: Working with Templates and Charts

Create Advanced Templates
Create Advanced Charts
Lesson 7: Managing Data in Workbooks