Advanced Excel

Module 1: Advanced Worksheet Functions
Session 1: Names
Session 2: Using Names
Session 3: Conditional & Logical Functions
Session 4: And, Or, Not
Session 5: Look Up Functions
Session 6: Other Useful Functions

Module 2: Data Consolidation
Module 2: Views, Scenarios, Goal Seek & Solver
Session 1: Views & Scenarios
Session 2: Goal Seek & Solving

Module 3: Using Excel To Manage Lists
Session 1: Excel, Lists, List Terminology
Session 2: Sorting Data
Session 3: Adding Sub Totals to A List
Session 4: Filtering A List
Session 5: List Statistics
Session 6: Pivot Tables
Session 7: Managing Pivot Tables

Module 4: Charts
Session 1: Introduction to Charting
Session 2: Formatting Charts

Module 5: Templates
Session 1: Introduction to Templates

Module 6: Auditing
Session 1: Auditing Features

Module 7: Other Formatting
Session 1: Formatting Cells

Module 8: Other Excel Features
Session 1: Inserting, Formatting, & Deleting Objects
Session 2: Reviewing
Session 3: Proofing Tools