Microsoft Excel™

classroom training

Level 2: Intermediate Microsoft Excel

Take your Excel skills to a new level as you build on the basics and begin to master this powerful application

This fun and interactive course builds on your basic Excel skills and teaches you to really take control of this flexible software. During the day, you'll use a variety of techniques to analyse and present data, control spreadsheet access by users, and look up information from Excel databases. Discussing real business situations, you'll understand how various techniques can be employed to save time and improve data quality.

This course will give you a solid understanding of Excel formulas, and their myriad applications in business situations. However, rather than just learning lists of functions, you'll learn how to think like Excel and use builtin tools to create any formula you need. Using simulated business exercises and reallife examples, you'll see how Excel can fit into all areas of a business to make things easier, quicker and more efficient.

"Really great course; made a dry subject very interesting and enjoyable." - Michael Dean, Informa Telecoms & Media, London, UK

Why take this course with us?

At Naturally Spreadsheets, we understand the gulf that exists between basic Excel usage and effective Excel usage. Making the jump from displaying data clearly through figures and charts, to actually analysing data and performing effective calculations can be one of the hardest things to achieve. We take the pain out of this important step by working with you to understand Excel's capabilities and relating these to existing knowledge.

When you attend this course, you will leave with a rock-solid understanding of what Excel is really capable of, why various techniques should be employed, and how to achieve amazing results with some of Excel's key formulas.

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.