Excel 2007
Introduction to Excel
-
1
Setting Up Your Excel Environment ✓
Familiarize yourself with the Excel 2007 environment.
-
2
-
3
Modifying Columns, Rows, and Cells ✓
Learn how to modify rows, columns, and cells in Excel.
-
4
Formatting Text ✓
Learn all about formatting text in Excel.
-
5
Creating Simple Formulas ✓
Learn how to create a simple formula in Excel.
-
6
Working with Cells ✓
Learn how to cut, copy, and paste, as well as how to drag and drop data in Excel.
-
7
Excel Basics
-
8
Creating Complex Formulas ✓
Learn how to create a complex formula in Excel.
-
9
Working with Basic Functions ✓
Learn how to use functions to find values for a range of cells.
-
10
Sorting, Grouping, and Filtering Cells ✓
Learn how to sort, group, and filter cells in Excel.
-
11
Formatting Tables ✓
Learn how to use styles to format tables in Excel.
-
12
-
13
Working with Worksheets ✓
Learn how to name, add, delete, group and ungroup, and freeze worksheets.
Doing More with Excel
-
14
Using Templates ✓
Learn how to create a new workbook using an Excel template.
-
15
Using What-If Analysis ✓
Learn how to use a what-if analysis tool called Goal Seek.
-
16
Working with Charts ✓
Learn how to insert and modify Excel charts to communicate information.
-
17
Using Conditional Formatting ✓
Learn how to apply, modify, and delete conditional formatting rules in Excel.
-
18
Creating PivotTables ✓
Learn how to use PivotTables in Excel for stronger data analysis.