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 Nonadjacent 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
