Online or at your own premises
1 day course
£275.00 (ex. VAT)

This is a 1 day advanced Microsoft Excel training course focusing on the most popular formulae and functions plus working with lists and Pivot Tables.  The topics are combined from our Advanced Formulae and Function and Validate and Summarise courses.

If you have attended our Intermediate course or have a good basic knowledge of Excel already you can improve your calculations further with this course.  Learn the best functions you need to work with data faster and present the data better using Excel’s reporting features.

By the end of this course you will be able to use a wide range of advanced calculations, use conditional formatting to display your data in various formats and summarise large data sets more easily.

Course Outline

Advanced Autofill

  • Flash Fill
  • Fill Options

Advanced Formatting

  • Formatting Tips
  • Conditional Formatting

Formulae

  • Refresh on Formulae and Basic Functions
  • Absolute Referencing ($)
  • Mixed Referencing
  • Use Names in a Formula

Advanced Functions

  • IF and Nested Functions – IF / COUNTIF / SUMIF /IFERROR
  • Lookup Functions  – VLOOKUP / HLOOKUP / XLOOKUP
  • Text Functions to Clean Data

Tables and Pivot Tables

  • Creating and Using Tables
  • Summarising with Pivot Tables
  • Creating Pivot Charts
  • Using Slicers/Timelines
  • Quick Analysis Tool

Book This Course

Public Course Dates

This course is taught online or at your site.  Check our current available dates for this course below and register your place. Please note that payment is not made by the booking form below – Instead, you will be sent an invoice with instructions on how to pay and confirm your place shortly afterwards.

We’re currently experiencing technical issues with this page. If no dates are shown below, please see our Course Schedule and contact us

Company Group Training

We also provide group training for companies on dates that work for them. This can be delivered on-site at your premises or virtually. Please submit your details here for more information.

Online Training

This course is taught virtually. To enquire about virtual remote training please submit your details here.

Related Courses

Microsoft Excel Power Query

Microsoft Power BI

Microsoft Excel Advanced Formulae & Pivot Tables

Microsoft Excel Introduction

Microsoft Excel Intermediate

Microsoft Excel Dashboards Made Easy

Microsoft Excel Expert Formulae

Microsoft Excel VBA