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 3: Working With Data in Excel


One of the main uses of Excel is that of processing and displaying 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.

During the course, you'll understand how to reduce the time spent tidying data by limiting data entry options, how to use formulas to re-format text and numerical data, and how to present data through charts and pivot tables. You'll also learn how to save time in repetitive data tasks by using macros to automate actions. Building on your knowledge of VLOOKUPs and IF statements, you'll learn how to take control of your data to increase your efficiency and gain enhanced insights into the stories that data provides.

Who should attend?

Intermediate Excel users who want to learn how to take advantage of Excel's powerful data processing capabilities


"The information was well prepared and worksheets were excellent so we could see examples." - Deborah Joseph, Datamonitor, Inc., Canandaigua, NY, USA

Key topics

What is data?
Understanding data's journey
Presenting data in charts
Creating pivot tables
Using formulas to tidy data
Preparing data for mailings
De-duping data lists
Saving time with Macros
Data validation

Why take this course with us?

As a sales-focused training company, we understand the importance of data in processing customer lists, preparing marketing databases, and fulfilling orders. As with all our live e-learning courses, we'll show you how to apply Excel's principles in real-life situations as you really get to grips with Excel's data processing capabilities. Through live demonstrations, interactive examples and personal help, we'll show you what Excel is capable of and give you the confidence to use Excel yourself back in the workplace. If you want to understand data from the point of view of a business, not from IT, then this is the course for you.

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



1st April 2019
GBP £129 +VAT
USD $159 +VAT

14th August 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.