Description
This course is designed to take those who use Excel regularly, but want to become an expert, to the next level. At the end of this session, you will understand nested functions and their syntax, and dive into XLOOKUP, MATCH, and INDEX. We will also teach you how to audit your workbooks for function errors.

Objectives

  • Understand and use named ranges in functions
  • Explore Excel Lookup and Reference functions
  • Use formula auditing tools to manage function errors

Course Level

Level 3 Advanced

Course Duration

60 Minutes

Course Delivery

Online

No products in the basket.

Related Courses

Build your custom training package

View our full package of courses here

Office 365 Training

Customised Training

We work closely with you to develop a bespoke training plan that aligns with your needs and goals. We cater to various learning styles, offering a range of training methods to make sure everyone can enrich their learning.

Exceptional Expertise

Our trainers are recognised as Microsoft Innovative Educators & Experts. We keep up to date with the latest developments and provide training on all Office 365 apps.

Full Flexibility

Our Microsoft trainers can deliver webinars, small group workshops, drop-in sessions or traditional face-to-face training, with maximum accessibility and convenience.

Leadership Coaching

Our services extend to coaching your leadership team, guiding them through change management and helping them effectively support their teams with Microsoft technology.