UK: +44 (0)20 7164 6959
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
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.
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.
