Microsoft Excel 2003 Level 3 Training Course

Functions, Analysis & Automating

Course length – 1 day


Delegates should have knowledge of the topics from, or have attended, the Excel Level 1 and Level 2 courses. It is essential that they have an understanding and are able to use calculations and simple formula.


  • Working with Excel functions
  • What if analysis
  • Using data valuation
  • Create and change PivotTables
  • Analyse your data
  • Share and track the changes to data
  • Record a macro
  • Creating templates
  • Customising Excel


Working with Excel Functions
  • Logical (IF, SumIF, CountIF)
  • Vlookup, Hlookup
  • Database functions
  • Nested functions
Naming Ranges
  • Define, change and use names
What If Analysis
  • Data tables
  • Scenarios
  • Goal seek & solver
  • Conditional formatting
  • Creating and changing a PivotTable
  • Formatting the PivotTable
  • Changing the layout
  • The PivotTable fields
  • Using calculations
  • Refreshing the PivotTable
Data Validation
  • Restrict data input
  • Creating a data validation list
Shared Workbooks
  • Sharing your workbook with others
  • Resolving conflicts
  • Tracking changes
  • Viewing change history
  • Remove a workbook from shared use
  • Use the reviewing toolbar
  • Recording and using simple macros
  • Assigning a macro to a shortcut key or button
  • Create and use a template
Customising Excel
  • Options, menus and toolbars

Topics not what you require? More information required? Contact us to discuss.

The topics in this course can be mixed and matched with Excel Level 2 and/or Excel Level 1 if required.


1 to 1 training: £299 + VAT per day
Each additional person: £40 + VAT per day

We come to you.  Courses take place at your offices.