Session 1

Section A: Introduction

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

Section B: Creating and Manipulating Data

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

Section C: Managing Worksheets

• Copying Worksheets
• Inserting and Deleting Worksheets
• Hiding Worksheets

Section D: Data Integrity

• Validation Criteria
• Character Validation
• Drop-Down Lists

Section E: Modifying Cell Content

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

Section F: 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

Session 2

Section A: Formatting Data

• Formatting Worksheets
• Worksheet Backgrounds
• Watermarks

Section B: 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

Section C: Formatting Numbers

• Currency Format
• Format Painter
• Formatting Dates
• Special Formats
• Cell Styles

Section D: Formatting Text and Tables

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

Section E: Understanding Formulas

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

Session 3

Section A: Referencing Formulas

• Dependent References
• Multiple Sheet References
• Consolidating Data
• Consolidating with Links

Section B: Ranges and Dates

• AutoSum
• Cell Names
• Formulas with Cell Names
• COUNT
• COUNTA
• Date Formulas

Section C: Subtotals

• Overview
• Subtotal Options
• Selecting Visible Data

Section D: Lookups

• Lookups Purpose
• VLOOKUP
• VLOOKUP Exact Match
• HLOOKUP
• HLOOKUP Exact Match

Section E: Conditional Logic

• IF Syntax
• IF Statement
• Nested IF
• Nested IF Syntax
• Section F: More Conditional Logic
• AND
• OR
• NOT
• IFERROR
• SUMIF
• AVERAGEIF
• COUNTIF
• SUMIFS
• AVERAGEIFS
• COUNTIFS

Session 4

Section A: Financial Formulas

• Future Value
• Payment
• Goal Seek
• Changing Rate
• Scenario Manager

Section B: Text Formulas

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

Section C: Introduction to Charts

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

Section D: Formatting Charts

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

Section E: Conditional Formatting

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

Section F: Adding Graphics to Spreadsheets

• Insert Pictures
• Modifying Pictures
• Insert Shapes
• Insert SmartArt
• Apply Themes

Session 5

Section A: 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

Section B: PivotTables

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

Section C: Protecting Data

• Workbook Passwords
• Protecting Workbooks
• Hiding Worksheets
• Unlocking Cells

Section D: 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

Section E: Saving a Workbook

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

Section F: Printing

• Page Orientation
• Page Breaks
• Print Area
• Margins
• Headers and Footers
• Scaling