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
  • IF with AND, OR functions
  • Combine VLOOKUP with MATCH
  • XLOOKUP
  • IFERROR
  • Advanced Sorting
  • Advanced Filtering
  • Data Validation
  • Data cleansing using Power Query and Copilot
  • Removing Duplicates
  • Grouping in Pivot Tables
  • Calculated Fields in Pivots
  • Pivot Table Options
  • Slicers
  • Forecast Sheets
  • Goal Seek
  • Data Tables
  • Worksheet Auditing
  • Scenarios
  • Office Scripts (was basic Macros)
  • Dynamic Charts
  • Form Controls
Have a question?

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

"*" indicates required fields

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