Search courses 👉
Professional Training
4.8 (759 Reviews)

Excel Advanced - Formulas and Functions

STL, In London (+21 locations)
Length
1 day
Price
230 - 325 GBP excl. VAT
Next course start
18 December, 2024 (+38 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
230 - 325 GBP excl. VAT
Next course start
18 December, 2024 (+38 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Excel Advanced - Formulas and Functions

STL courses


  • At the end of this course, you will have a greater understanding of building complex formulas and functions. You will be able to create advanced nested functions to produce solutions and outcomes in your data sets.

    You will find quicker ways to customise formulas by taking advantage of the built-in functions available in Excel. Save time by learning more sophisticated search and auditing techniques when working with data-heavy spreadsheets.

    You will be introduced to the latest functions available in Excel 365, as well as less well-known but powerful existing functions.

    In addition to learning a wide range of new formulas, you will also discover best-practice for setting up Excel files so they are flexible, appropriate, well-structured, and transparent.

    Also available is the Excel Advanced - For Power Users course.

What to expect

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • Face-to-Face and Online Instructor led .
  • And more... .

Upcoming start dates

Choose between 38 start dates

18 December, 2024

  • Virtual Classroom
  • Online
  • English

6 February, 2025

  • Virtual Classroom
  • Online
  • English

14 February, 2025

  • Classroom
  • London
  • English

31 March, 2025

  • Virtual Classroom
  • Online
  • English

15 May, 2025

  • Classroom
  • London
  • English

22 May, 2025

  • Virtual Classroom
  • Online
  • English

14 July, 2025

  • Virtual Classroom
  • Online
  • English

14 August, 2025

  • Classroom
  • London
  • English

4 September, 2025

  • Virtual Classroom
  • Online
  • English

27 October, 2025

  • Virtual Classroom
  • Online
  • English

13 November, 2025

  • Classroom
  • London
  • English

18 December, 2025

  • Virtual Classroom
  • Online
  • English

6 February, 2026

  • Virtual Classroom
  • Online
  • English

12 February, 2026

  • Classroom
  • London
  • English

30 March, 2026

  • Virtual Classroom
  • Online
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

Suitability - Who should attend?



Our Microsoft Excel Formulas course is suitable for those with an advanced working knowledge of Excel who want a greater understanding of more sophisticated formulas and functions within Excel.

You may also wish to consider one of our finance for non financial managers courses.

Training Course Content



Building complex formulas

Nested functions best practice
Writing functions more efficiently using Formatted Tables
Get an understanding of how nested functions get executed

Statistical and forecasting functions

LARGE, SMALL, ROUND
CORREL and SLOPE
FORECAST.LINEAR
FORECAST.ETS

Date, Time and Text Functions

Smarter ways to calculate date and time
WORKDAY, DATEDIF, EDATE, WEEKNUM
Text functions:
UPPER, PROPER, FIND, MID, SEARCH, LEFT, RIGHT, LEN
TRIM excess space in cells
TEXTJOIN and CONCAT

Introduction to Array formulas

Using embedded Excel Array formulas
TREND, GROWTH, FREQUENCY
UNIQUE, SPILL, SORT (365)
SORTBY, FILTER (365)
Creating bespoke Array formulas

Advanced Lookup and Reference

XLOOKUP and XMATCH
ADDRESS
INDIRECT
OFFSET
CHOOSE

Auditing formulas

Tracing formula precedents, dependents, and errors
Correcting errors in formulas
Combining IF with VLOOKUP to suppress error messages
Using the IS information function
Error checking functions; ISERR, ISERROR, IFERROR

Expenses



List price £350, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

Request information - obligation free

Contact form

Fill out your details to find out more about Excel Advanced - Formulas and Functions.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Reviews by course attendees

Average rating 4.8

Based on 759 reviews.
Reviews are published according to our review policy.
Write a review!
Shamim
5/5
11 Jul 2024

There was a lot to cover and I believe it should be a 2 day course as there was not enough time to cover everything plus a lot of info squeezed in one day -it's better for memor...

Show more
Maya
5/5
11 Jul 2024

Make the course slightly shorter. It was a bit long towards the end and the text function explanation was not necessary.

Atlas
5/5
11 Jul 2024

Marius was great. Explained everything really clearly and had lots of useful examples. I will definitely be using all these functions.

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads