Skip to content
Microsoft Excel New Functions background

Microsoft Excel training courses

Build confidence and save hours on spreadsheets with tailored Microsoft Excel training courses. Whether you are a complete beginner or an experienced user, our hands-on courses cover everything from essential functions to advanced formulas, pivot tables, financial analysis, and data visualisation.

Led by Microsoft Certified Trainers, our corporate Excel training fits flexibly around your team:

  • All Skill Levels Covered: Progress from Excel Introduction and Excel Intermediate to Excel Advanced and Excel Super User.
  • Flexible UK Delivery: Book bespoke onsite Excel training at your offices anywhere in the UK, or join interactive live online classes.
Microsoft Excel New Functions logo

Microsoft Excel New Functions

Half Day

Excel 365 has changed with Microsoft adding a tranche of powerful new functions to  simplify tasks, streamline formulas, and make your spreadsheets more dynamic.  If you're still using VLOOKUP, IF, and COUNTIF, you're missing out on what's now possible.

On this session, we will investigate the latest Excel 365 time saving functions for filtering, sorting, and extracting data; ways to manipulate text, and stack arrays.

Download PDF Book now

What will you learn?

At the end of this Microsoft Excel New Functions course, delegates will be able to take advantage of Excel’s latest functions  to transform how you work with data.

 

Audience?

Experienced Excel users ready to learn new functions that can bridge the gap between what’s new and this is how we always used to do it.

Course Contents

Filter & Sort Functions

  • Sort
  • Sortby
  • Unique
  • Filter
  • Unique

Lookup Functions

  • Xlookup
  • Xmatch

Logic

  • IFS

Text Function

  • Textafter / Textbefore
  • Textsplit
  • Regexextract
  • Regexreplace

Array Functions

  • Tocol / Torow
  • Vstack / Hstack
  • Trimrange
  • Scan
  • Choosecols / Chooserows
  • Wrapcols / Wraprows
  • Drop / Take
  • Randarray / Sequence

Dynamic Tables

  • Groupby
  • Pivotby
  • Percentof

Course Materials

Enliten IT will provide each delegate with a pdf workbook and other useful reference materials where applicable.

“"Excellent session made fun!"”

Liz, Cashflows, Excel Intermediate

Prerequisites

This course assumes attendance of our Excel Intermediate course (or equivalent knowledge).

Additional Information

To ensure our IT training stays up-to-date with the latest industry standards, Enliten IT may update course content and training materials at any time without prior notice.

The suggested course duration is a guideline.   Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.