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 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.

Who should attend?

Competent Excel users who want to move away from the basics and really take advantage of the software's business possibilities.


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

Key topics

Understanding formulas
Relative and absolute references
Working with data
Controlling data quality
Lookup functions
Conditional functions
Showing trends on charts
Displaying data in pivot tables
Workbook security

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.