Course Outline

Lesson 1 : Introduction

What You Will Learn
Excel 2007 Interface
Ribbon and Tabs
Document Windows
Navigation Tips

Lesson 2 : Creating and Manipulating Data

Entering Data
AutoFill a Series
Fill Non-Adjacent Cells
AutoFill on Multiple Sheets
Creating Custom Lists
Series Formatting

Lesson 3 : Managing Worksheets

Copying Worksheets
Inserting and Deleting Worksheets
Hiding Worksheets

Lesson 4 : Data Integrity

Validation Criteria
Character Validation
Drop-Down Lists

Lesson 5 : Modifying Cell Content

Cut, Copy, Paste
Transposing Data
Copy Cell Format Only
Removing Duplicates
Data Validation

Lesson 6 : Changing Views

Zoom Features
Workbook Views
Page Layout View
Repeating Cell Content
Freeze Panes
Split Windows
Viewing Multiple Windows
Saving Hot Links
Hiding the Ribbon

Lesson 7 : Formatting Data

Formatting Worksheets
Worksheet Backgrounds
Watermarks

Lesson 8 : Modifying Rows and Columns

Inserting Rows
Inserting Columns
Cutting and Inserting Columns
Modifying Cell Width/Height
Inserting Multiple Rows and Columns
Inserting and Deleting Cells
Formatting Rows and Columns
Hiding/Unhiding Rows and Columns

Lesson 9 : Formatting Numbers

Currency Format
Format Painter
Formatting Dates
Special Formats
Cell Styles

Lesson 10 : Formatting Text and Tables

Fonts, Fills, and Alignment
Comments
Merging and Splitting Cells
Inserting Hyperlinks
Formatting as a Table
Summary Function

Lesson 11 : Understanding Formulas

Using Operations
Creating Formulas
AutoSum
Common Functions
Searching for Functions
Copying Formulas
Absolute Cell References

Lesson 12 : Referencing Formulas

Dependent References
Multiple Sheet References
Consolidating Data
Consolidating with Links

Lesson 13 : Ranges and Dates

AutoSum
Cell Names
Formulas with Cell Names
COUNT
COUNTA
Date Formulas

Lesson 14 : Subtotals

Overview
Subtotal Options
Selecting Visible Data

Lesson 15 : Lookups

Lookups Purpose
VLOOKUP
VLOOKUP Exact Match
HLOOKUP
HLOOKUP Exact Match

Lesson 16 : Conditional Logic

IF Syntax
IF Statement
Nested IF
Nested IF Syntax

Lesson 17 : More Conditional Logic

AND
OR
NOT
IFERROR
SUMIF
AVERAGEIF
COUNTIF
SUMIFS
AVERAGEIFS
COUNTIFS

Lesson 18 : Financial Formulas

Future Value
Payment
Goal Seek
Changing Rate
Scenario Manager

Lesson 19 : Text Formulas

Case Formulas
Paste Column Widths
Operations in Paste Special
Skip Blanks
AutoCalculate
Fix Number Fields
Trim Spaces
Substitute Text

Lesson 20 : Introduction to Charts

Chart Types
Instant Chart
Update Chart
Column Chart
Picture Fill
Adjust Chart Size
Line Chart
Scatter Chart

Lesson 21 : Formatting Charts

Chart Styles
Chart Layouts
Add Labels
Axis Options
Chart Title
Legends
Data Labels

Lesson 22 : Conditional Formatting

Highlight Cells Rules
Top/Bottom Rules
Data Bars
Color Scales
Custom Formatting Rule
Text Formatting

Lesson 23 : Adding Graphics to Spreadsheets

Insert Pictures
Modifying Pictures
Insert Shapes
Insert SmartArt
Apply Themes

Lesson 24 : Outlining, Sorting, and Filtering

Group and Ungroup
Sort Data
Sort Multiple Levels
Filter Data
Advanced Filter
Conditional Sorting and Filtering
Sorting and Filtering Data Attributes

Lesson 25 : PivotTables

Overview
Creating PivotTables
Choosing Fields
Sub Fields
PivotTable Layout
Filtering PivotTables
Totals
Modifying PivotTable Data
PivotCharts

Lesson 26 : Protecting Data

Workbook Passwords
Protecting Workbooks
Hiding Worksheets
Unlocking Cells

Lesson 27 : Collaboration

Document Properties
Formatting Comments
Document Inspector
Sharing a Workbook
Track Changes
Accept/Reject Changes
Information Rights Management
Using IRM
Signature Line
Mark as Final

Lesson 28 : Saving a Workbook

Save As Previous Version
Templates
Save As PDF
Save As Web Page
Macro-Enabled Workbook

Lesson 29 : Printing

Page Orientation
Page Breaks
Print Area
Margins
Headers and Footers
Scaling