Naturally
Spreadsheets
Helping organisations and individuals succeed
through better spreadsheet and data skills

Microsoft Excel™


Live E-learning

UK: +44 (0)20 7164 6959
USA: +1 (617) 431 3011
Naturally
Spreadsheets
...a Navanter brand

Level 4: Advanced Data in Excel


VLOOKUPs are incredibly useful in Excel for dealing with basic to moderate data sets. However, they have limitations and not all data types respond to VLOOKUP formulas. In this advanced data course, you'll go beyond VLOOKUP to learn how Excel's advanced lookup functions can tame the most complex data sets and reporting requirements.

Using functions such as SUMPRODUCT, INDEX and MATCH, you'll learn how to return results when multiple criteria are true, how to look up data in two directions, and how to create unique lookup values when they don't already exist.

Who should attend?

Intermediate to advanced users who want to take their skills to the next level and report on complex data sets


"I've found Excel training difficult to follow in the past, however the hands-on approach today was much more effective." - Zoe Carnegie, Ten Group, London, UK

Key topics

Referencing other workbooks
Conditional functions
The SUMPRODUCT function
Lookups with CONCATENATE
Looking up data: INDEX and MATCH
Two-dimensional lookups
Controlled data de-duping
Linking Excel to PowerPoint & Word
Creating dynamic dashboards

Why take this course with us?

Having worked on a huge spectrum of data applications, from sales and marketing, through accounting, to surveys and business information, Naturally Spreadsheets is ideally placed to help you find meaning in the most complex data sets. We understand the importance of data, and we also understand just how diverse data sets can be in different industries. As with all our training, this interactive e-learning course will help you to see how the techniques covered can be applied in real-life situations in your own job. The combination of discussion, demonstration and hands-on exercises will give you the perfect recipe for Excel success.

Book a live e-learning Microsoft Excel™ course

We use PayPal to securely process our card payments. To book and pay immediately by credit card, please select your course and currency from the list below. To book online and receive an invoice, or if you are a business customer based outside the UK and should not be charged VAT, please use the form on this page.

If you have multiple delegates to register, save yourself time and money by contacting us directly to make a bulk booking and discuss volume discounts.

All courses are priced at £129 +VAT or $159 +VAT. Booking a course via PayPal constitutes having read and agreed to our terms & conditions.

Who can attend our live e-learning courses?

All live e-learning classes are open to anyone, regardless of location. They are 2 hours in length, and run at 09:00-11:00 Eastern time (USA), or 14:00-16:00 GMT/BST (UK time).

Forthcoming training course dates



9th May 2019
GBP £129 +VAT
USD $159 +VAT

25th September 2019
GBP £129 +VAT
USD $159 +VAT

Live E-learning training courses from Naturally Spreadsheets...

Excel Live E-learning Level 1: The Basics

In this first step, you'll look at how Excel can be used in a business environment, and understand how to apply its functionality in your role. Click here for the full course outline.

Excel Live E-learning Level 2: Using Formulas

This course builds on your basic knowledge to help you use Excel's built-in helpers to create and use any formula. Click here for the full course outline.

Excel Live E-learning Level 3: Working With Data

In this highly interactive module, you'll trace the journey of data from beginning to end, from controlling the quality of data as it enters Excel, manipulating and tidying data within the software, and displaying it in the most effective way for different data types and uses. Click here for the full course outline.

Excel Live E-learning Level 4: Advanced Data

In this advanced data course, you'll go beyond VLOOKUP to learn how Excel's advanced lookup functions can tame the most complex data sets and reporting requirements. Click here for the full course outline.

Excel Live E-learning: Presenting Excel in PowerPoint

In this interactive course, you'll learn how to use Excel and PowerPoint's tools in combination to create slides which engage the audience to get your message across Click here for the full course outline.

Classroom training courses from Naturally Spreadsheets...

Excel Classroom Level 1: Introduction to Microsoft Excel

In this first step, you'll look at how Excel can be used in a business environment, and understand how to apply its functionality in your role. Click here for the full course outline.

Excel Classroom Level 2: Intermediate Excel

This course builds on your basic knowledge to help you use Excel's built-in helpers to create and use any formula, as well as using data validation, nested formulas and pivot tables. Click here for the full course outline.

Excel Classroom Level 3: Advanced Microsoft Excel

In this advanced Excel course, you'll use hands-on learning to tackle the most demanding data types using formulas such as INDIRECT, INDEX, MATCH and SUMPRODUCT, as well as some of Excel's most useful advanced tools. Click here for the full course outline.