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

Microsoft Excel™


classroom training

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

Level 3: Advanced Microsoft Excel


Use Excel's advanced functionality and formulas to perform powerful data manipulation

This highly interactive course will enable you to take your Excel learning to a new level. Building on your existing knowledge of IF and VLOOKUP statements, you will learn to understand different types of data and the formulas required to report in powerful ways for a variety of purposes. You will learn how time functions are used to report on performance data to illustrate successes or challenges in powerful ways.

One of the main challenges of working with Excel is learning how to communicate effectively with the software. In Advanced Microsoft Excel you will understand how Excel thinks through problems and learn to structure your formulas effectively to achieve the results you need. You will leave the course both with solid techniques to achieve instant results, and the knowledge and confidence to develop your skills further in the future.

Who should attend?

Intermediate to advanced Excel users who want to use the software's advanced techniques for processing, manipulating and displaying data.


"Really good course, really advanced." - Anna Paszek, Verdict Research, London, UK

Key topics

Working with advanced data
Understanding data types
Advanced lookup functions
Creating & editing macros
Evaluating scenarios
Advanced nested formulas
Creating interactive dashboards
Forecasting based on historical data
Linking Excel to PowerPoint and Word

Why take this course with us?

We're not IT people, but business people. Every single topic taught in our Excel courses comes from a real business application. Nowhere is this more important than in our advanced Excel course. There are hundreds of formulas and techniques in Excel, but it's impossible to learn everything at once.

We approach learning from a handson perspective, giving you real business problems, then working creatively together to find solutions. As we progress through the course, we help you to understand how these techniques can be modified to fit many business situations, equipping you with the skills and knowledge to take your learning further on your own.

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.

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.