MICROSOFT EXCEL 2010

Level 1

Getting started

Spreadsheet terminology

The Excel environment

Getting help

Navigating a worksheet

Entering and editing data

Entering and editing text and values

Entering and editing formulas

Working with pictures

Saving and updating workbooks

Modifying a worksheet

Moving and copying data

Moving and copying formulas

Absolute and relative references

Inserting and deleting ranges, rows, and columns

Using functions

Entering functions

AutoSum

Other common functions

Formatting

Text formatting

Row and column formatting

Number formatting

Conditional formatting

Additional formatting options

Printing

Preparing to print

Page Setup options

Printing worksheets

Charts

Chart basics

Formatting charts

Managing large workbooks

Viewing large worksheets

Printing large worksheets

Working with multiple worksheets

Graphics and screenshots

Conditional formatting with graphics

SmartArt graphics

Screenshots

Level 2

Using multiple worksheets and workbooks

Using multiple workbooks

Linking worksheets with 3-D formulas

Linking workbooks

Managing workbooks

Advanced formatting

Using special number formats

Using functions to format text

Working with styles

Working with themes

Other advanced formatting

Outlining and subtotals

Outlining and consolidating data

Creating subtotals

Cell and range names

Creating and using names

Managing names

Tables

Sorting and filtering data

Advanced filtering

Working with tables

Web and sharing features

Saving workbooks as Web pages

Using hyperlinks

Sharing workbooks

Advanced charting

Chart formatting options

Combination charts

Graphical elements

Documenting and auditing

Auditing features

Comments in cells and workbooks

Protection

Workgroup collaboration

Templates and settings

Changing application settings

Using built-in templates

Creating and managing templates

PivotTables and PivotCharts

Working with PivotTables

Rearranging PivotTables

Formatting PivotTables

Using PivotCharts

Level 3

Logical and statistical functions

Logical functions

Math and statistical functions

Financial and date functions

Financial functions

Date and time functions

Array formulas

Displaying and printing formulas

Lookups and data tables

Using lookup functions

Using MATCH and INDEX

Creating data tables

Advanced data management

Validating cell entries

Exploring database functions

Exporting and importing

Exporting and importing text files

Exporting and importing XML data

Getting external data

Analytical tools

Goal Seek and Solver

The Analysis ToolPak

Scenarios

Macros and custom functions

Running and recording a macro

Working with VBA code

Creating functions