MS Excel - advanced

Unlock the power of Microsoft Excel 2003. Excel is a spreadsheet package that provides the tools to access, process, analyse and display numeric and financial information, accurately and professionally.

This is the third of three MS Excel courses offered by Tooling Intelligence. If you don't already have a good understanding of Excel you will need to look at our MS Excel Introduction or MS Excel intermediate course.

Course outline

  • Using Lookup Tables
    • Vlookup
    • Hlookup
  • Consolidation
    • Data by Category
    • Data by Position
    • Repeating a Consolidation
  • Pivot Tables
    • Pivot Table Concepts
    • Creating a Simple Pivot Table
    • Data Buttons
  • Number Formats
    • Number Format Codes
    • Creating Your Own Formats
  • Manipulation Information
    • IS Functions
  • Analysis Tools
    • Goal Seek
    • Solver Command
    • Scenario Manager
    • View Manager
  • Printing Reports
    • Custom Reports
    • Summary Reports
  • Protecting
    • Workbooks & Worksheets
    • Cell Ranges
    • Formulas
    • Charts