Excel Advanced - Formulas and Functions

Course summary
1 day
230 - 275 GBP excl. VAT
Professional Training
Next available date: 12/08/2020 09:30 - Online courses
Course Dates
Online courses
12/08/2020 09:30  (English)
245 GBP
03/09/2020 09:30  (English)
240 GBP
10/09/2020 09:30  (English)
238 GBP
18/09/2020 09:30  (English)
236 GBP
STL courses

Excel Advanced - Formulas and Functions

Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... At the end of this course you will have a greater understanding of building complex formulas using nested functions (such as IF statements). ; ; 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. ; ; Also available is the Excel Advanced - For Power Users course.

STL virtual classroom training

We all have to accept our preferred face-to-face method just isn't an option right now. However, virtual classroom training that we have developed offers some benefits which can make it seem less of a compromise and more of a viable interim training solution. 

Our virtual classroom training is delivered by the same team responsible for achieving industry leading customer satisfaction ratings with face-to-face training, so rest assured you are in safe hands.

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 formulasUsing nested IF statementsCreating compound logical tests using AND, OR, NOT functions with IF statementsNesting LOOKUP functionsSource table structure information using CHOOSE functionUsing MATCH function to locate dataThe INDEX function for retrieving information by locationUsing a nested formula containing INDEX, MATCH and MATCH (two-way lookup)Advanced functions in formulasUsing COUNTIFS,SUMIFS, and AVERAGEIFS for tabulating data based on single/multiple criteriaStatistical functions; MEDIAN, MODE, RANK, LARGE, SMALL, ROUND, MODAGGREGATE function to sum data in ranges with errorsUse a variety of Financial functions such PMT, FV, IRRData and Text FunctionsSmarter ways to calculate date and time; TODAYNETWORKDAYS, WORKDAY, DATEDIF Use TYPE to identify data type of existing cell contentsText functions; UPPER, PROPER, FIND, MID, SEARCH, LEFT, RIGHT, LENTRIM excess space in cellsIntroduction to Array formulasUsing embedded Excel Array formulasCreate an Array formulaAuditing formulasTracing formula precedents, dependents, and errorsCorrecting errors in formulasCombining IF with VLOOKUP to suppress error messagesUsing the IS information functionError checking functions; ISERR, ISERROR, IFERROR


List price £350 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video


Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....

Read more and show all courses with this provider

Request information - obligation free

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

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award


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.

Contact information for STL


Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number

Reviews by course attendees

Average rating 4.8

Based on 373 reviews

Patrick Doherty
Most useful topic: Pivot tables
Course participant
This course has opened my eyes to the versatility of Excel. I used to be in admiration of people who can manipulate volumes of data
Jeni Morrison
Most useful topic: amount of new formulas
Request information

Find out more about this Excel Advanced - Formulas and Functions course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here