Excel 2010
Excel Basics
-
1
Getting Started with Excel ✓
Learn your way around the Excel 2010 environment.
-
2
-
3
Modifying Columns, Rows, and Cells ✓
Learn how to modify rows, columns, and cells in Excel.
-
4
Formatting Cells ✓
Learn all about formatting text in Excel.
-
5
-
6
Creating Simple Formulas ✓
Learn how to create a simple formula in Excel.
-
7
-
8
Common Tasks in Excel
-
9
Creating Complex Formulas ✓
Learn how to create a complex formula in Excel.
-
10
Working with Basic Functions ✓
Learn how to use functions to find values for a range of cells.
-
11
-
12
-
13
-
14
Formatting Tables ✓
Learn how to use styles to format tables in Excel.
Doing More with Excel
-
15
Reviewing and Sharing Workbooks ✓
Learn how to track changes, add comments, compare two versions of a worksheet, and share a worksheet.
-
16
Using Templates ✓
Learn how to create a new workbook using an Excel template.
-
17
Working with Charts ✓
Learn how to insert and modify Excel charts to communicate information.
-
18
Working with Sparklines ✓
Learn how to insert sparklines and change their type and appearance.
-
19
Using Conditional Formatting ✓
Learn how to apply, modify, and delete conditional formatting rules in Excel.
-
20
Creating PivotTables ✓
Learn how to use PivotTables in Excel for stronger data analysis.
-
21
Using What-If Analysis ✓
Learn how to use what-if analysis to answer different types of questions.