Great Shelford, Cambridge
1 day course
£225.00 (ex. VAT)

This is our 1 day advanced Microsoft Excel training course focusing on formulae and functions, perfect for those who would like to be able to use the popular functions in Excel on a regular basis.

If you have attended our Intermediate course or have a good basic knowledge of Excel already but now find yourself needing to improve your calculations further then this course will teach you the right functions you need to work with data faster.

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

Course Outline

Advanced Autofill

  • Flash Fill
  • Fill Options

Advanced Formatting

  • Styles and Themes
  • Custom Number Formatting
  • Conditional Formatting
  • Quick Analysis Tool

Formulae

  • Refresh on Formulae and basic Functions
  • Absolute referencing ($)
  • Mixed referencing
  • Use Names in a formula

Advanced Functions

  • Text Functions to Clean Data
  • IF and Nested Functions – IF / COUNTIF /SUMIF
  • Logical Functions  – using AND / OR
  • Lookup Functions  – VLOOKUP / HLOOKUP
  • Date Functions – TODAY / NOW / NETWORKDAYS

Auditing Worksheets (if time)

  • Formula Auditing
  • Formula Evaluator
  • Checking Errors
  • Watch Window
  • GoTo Special

Book This Course

Public Course Dates

This course is taught at our training centre in Cambridge.  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.

Company Group Training

We also provide group training for companies on dates that work for them. This can be done via our training centre, on-site or virtually. Please submit your details here for more information.

Online Training

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

Related Courses

Microsoft Excel Introduction

Microsoft Excel Intermediate

Microsoft Excel Advanced Formulae & Functions

Microsoft Excel Advanced Validate & Summarise

Microsoft Excel Dashboards Made Easy

Microsoft Excel Expert Formulae

Microsoft Excel Power Pivot and Power Query

Microsoft Excel VBA