Microsoft Excel™ level 3 live e-learning: Working with Data training course

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.

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