Training Overview

This training is designed for power users or those who typically would produce spreadsheets of a more complicated nature and who wish to further develop their skills. Also for those wishing to analyses data using Excel as a database.

What you need to know beforehand:

You should have already attended Excel Intermediate training prior to this course and/or know how to create a basic IF Function and Vlookup.

Course Objectives

By attending this training workshop, you will learn –

  • How to utilise the Add-ins in order to produce sophisticated reports containing relevant information.
  • The power and adaptability of macros.
  • Time efficient and effective creation, manipulation and reporting of data to support business decisions.


Course Content

  • Using Excel as a Database
  • Formatting as a Table
  • Quick Analysis
  • Nested IF Statements
  • Combined Functions i.e. IF, Vlookup, And, Offset, Match, Choose
  • Sorting
  • Filtering
  • Data Validation
  • Pivot Tables
  • Slicers
  • Forecast Sheets
  • Using Views and Creating Reports
  • Goal Seek
  • Scenarios
  • Data Tables
Have a question?

Let’s get this conversation started. Tell us a bit about your requirements and we’ll be in touch.

What you need to bring for these courses when delivered as a virtual classroom.

For virtual classroom courses, you will need:

  • Computer with Internet Access
  • Microphone and Headset
  • Webcam
  • Microsoft Teams
  • A dual monitor setup is recommended for IT training
Upcoming Courses
Get in touch via our contact form or call us on 01473 414 414