Microsoft Excel 2007 Step Up (Advanced)

Oaks Training

Course introduction

A 2-day hands-on overview of Excel 2007 features not covered in the Foundation module. A follow-on (Advanced Level) course suitable for users seeking to be introduced to many commonly used Excel features. Learn how to consolidate data and use Excel like a database to filter and retrieve data using Excel functions. With the use of Pivot table, you will learn how to generate dynamic reports through data field selection and criteria quickly and easily. With sufficient hands-on exercises for you to practice key lessons taught to enforce understanding on Microsoft Excel and experience Excel's ability to greatly reduce your time in scenario planning and data analysing.

Target Audience

Learners who have completed our Microsoft Excel 2007 Foundation module or are very well versed with the Excel features covered from that module.

Public Sector - Division 1, 2 & 3
Private Sector - Applicable to All

Course Outline

  • Working with Templates
  • Working with Data Validation
  • Using Advanced Functions
  • Working with Database
  • Filtering Data
  • Using Database Functions
  • Consolidating Data
  • Working with Charts
  • Auditing Worksheets
  • Working with Pivot Table

Available Course Sessions

Please click here to stay updated on upcoming sessions.

Trainer Profile

Oaks Trainer's

More than 15 years of training experience.
Certified trainers by ACTA, MOS or ITE.
Highly regarded by many learners.