Microsoft Excel 2003 Training - Level 3

Delegates completing the Excel level 3 course will be able to use the full functionality of this powerful programme and its many features. This is of particular relevance to anyone working with complex or interlinked calculations that must be capable of comparing the outcome of changes in a number of variables within a given scenario.

The many time saving shortcuts and in-depth understanding of the huge array of functions available will enable the delegate to undertake calculations that would most likely have been beyond them before attending the course. Included in this is statistical analysis work which will give the ability to interrogate the data within the worksheet in several ways in order to obtain information on which to base decisions or to interpret facts.

Course Outline: 

Pivot Tables

  • Create A Pivot Table
  • Use The Page Field In A Pivot Table
  • Filter Row And Column Values
  • Format A Pivot Table
  • Pivot Table Summary And Display Options
  • Show Data As Percentages In Pivot Tables
  • Create Calculated Fields
  • Create Calculated Items
  • Create A Pivot Chart

Scenarios

  • Create A Default Scenario
  • Create Scenarios
  • Use Names In Scenarios
  • Display Scenarios
  • Create A Scenario Summary Report
  • Merge Scenarios

Goal Seek

  • Use Goal Seek

Labels And Names

  • Overview Of Labels And Names
  • Create Labels
  • Create Names
  • Use Names In Formulas
  • Deleting Names

Lookup Functions

  • VLOOKUP Function
  • HLOOKUP Function
  • INDEX Function

Logical Functions

  • Using The IF Function
  • Nesting An IF Function
  • Using The AND Function
  • Using The OR Function
  • Using The NOT Function

Statistical Functions

  • Basic Statistical Functions
  • Using MODE & MEDIAN
  • Conditional Counting
  • Conditional Sum Wizard

Date And Time Functions

  • Using The NOW And TODAY Function
  • The HOUR And MINUTE Functions
  • Calculating A Future Date
  • Calculating An Age
  • Using The DATE Function

 

back to top ^