Advanced Excel Functions

Live Online Learning (1 Hour)

Discover a new range of useful advanced Excel functions, in this interactive live online training session.

If you are already familiar with basic functions, this Advanced Excel Functions for advanced users training session will take your knowledge to the next level.

You will first enjoy a detailed overview of how to write and structure Excel functions. Next, you will discover a series of text, date and numeric functions, which will transform the way you summarise and calculate data.

This Advanced Excel Functions training session is suitable for users of Excel 2013 and 2016.

What Will I Learn?

How to use advanced Exel functions: an overview - Familiarise yourself with Excel’s functions, including how to build them, where to find them, and how to use Insert Function.

How to use Count function - Understand the variations of the Count function to target and count data.

How to use Round function - Learn how to efficiently round your data to the nearest whole number.

How to use Text functions - Combine text and numbers into one cell, and change text properties.

How to use Date functions - Discover the powerful date and time functions to carry out calculations on dates and date ranges.


You should have a good knowledge of Microsoft Excel, creating and editing workbooks, and an understanding of how functions work.

Taking the Learn Excel Formulas and Functions for Beginners and How to Use Excel Lookup courses first might also be beneficial.

What Are Live Online Sessions?

Live Online gives you all the benefits of classroom training, but from the comfort of your home or office. Sessions take place on a shared online screen, where your friendly trainer will guide you and your class through the learning topic.

These interactive sessions also give you the opportunity to practice what you’ve learnt, as you take control and demonstrate your new skills to your trainer. Two-way text or voice chat is always available, for when you want to discuss a topic, need help, or want to ask any questions.


£95 per person, per session

Maximum Group Size:

6 people

Request Training

t: 0203 941 4100 | e:

Course Content

  • What are the advanced Excel functions
  • How to build functions
  • Where to find functions on the ribbon
  • How to use the Insert function
  • How to use different count functions to count the correct data
  • How to round-up data to the nearest whole number
  • How to combine text and numbers into one cell
  • How to change text properties
  • How to use date and time functions to carry out calculations on data ranges