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 2: Using Formulas in Excel


The real business power in Excel comes not only from data presentation, but also from performing calculations and database lookups. This course builds on your basic knowledge to help you use Excel's built-in helpers to create and use any formula. A vital part of this, is understanding how Excel thinks and how you need to communicate to get the results you need. Once you're comfortable with this, we'll look at how Excel helps you the rest of the way.

During the course, you'll progress from first principles, to how and when to use some of Excel's most powerful formulas, from SUM, MAX and COUNT functions through to VLOOKUP, HLOOKUP and IF statements. To really apply formulas effectively, you'll also learn how to combine functions in nested formulas, and use different types of cell references to save yourself time entering formulas in different parts of a worksheet.

Who should attend?

Beginner to intermediate users who want to get really comfortable performing calculations and processing numbers


"The course was excellent and I learned new things in Excel which I never knew that are very useful." - Gail Glickman, Informa Support Services, Inc., Sarasota, FL, USA

Key topics

What is a formula?
Constructing a formula
Absolute and relative references
Calculating from other worksheets
Looking up data
Conditional functions
Nested formulas
Understanding other worksheets
Using Excel's formula tools

Why take this course with us?

Live e-learning from Naturally Spreadsheets represents a revolution in online learning. The perfect balance between the interactivity of the classroom and the convenience of e-learning, you'll spend a lively two hours with a real instructor as you take part in exercises, discussions and Q&A sessions, receiving personal attention to help you solve your spreadsheet problems. As you'll be learning with a business skills training company, you won't be faced with long lists of formulas to learn. Instead, you'll learn to think like Excel thinks and to communicate with Excel to achieve the results you need, all in a live, interactive online training session.

Google reviews:


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



27th February 2019
GBP £129 +VAT
USD $159 +VAT

22nd May 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.