Excel Module 3 – Data Analysis Course

Book this course

Course description

Excel is used extensively for data analysis – it is one of its most powerful features.  Beyond Excel’s basic features, there are a range of advanced tools and techniques that can be used to make analysing data quicker, easier and more efficient.

Using powerful methods such as advanced filters, pivot tables, and data consolidation, we show you how to organise, analyse, and summarise your data in a more effective way, enabling you to get more out of it.

Is it right for me?

If you’re already an experienced Excel user, confident in creating and editing worksheets and writing basic formulas, this advanced Excel training course will enhance your current skill level.

What will I get out of it?

By the end of the course you will be able to:

  • Work with databases to summarise, analyse and filter information
  • Build Pivot Tables for easy data analysis
  • Use Excel tools to more effectively manage large spreadsheets
  • Create and work with data ranges
  • Consolidate data from multiple worksheets and workbooks
Excellent. The trainer was relaxed, assured and extremely knowledgeable Probably the best external training I've had.  Would thoroughly recommend this training to others, it was superb!
Business Performance Manager, Scotia Gas Networks

What does it cover?

  • Creating a table of data
  • Table formatting
  • Adding data using Excel tables
  • Adding total rows
  • Converting to an ordinary range
  • Using autofilter
  • Setting custom autofilter options
  • Using the search filter
  • Adding subtotals
  • Filtering data using the advanced filter
  • Setting criteria
  • Extracting data to other locations
  • Filtering for unique records
  • Creating named ranges
  • Finding and highlighting named ranges
  • Using the Name Manager
  • Creating and modifying a pivot table
  • Recalculating the pivot table
  • Filtering the pivot table
  • Searching the pivot table
  • Organising data
  • Sorting information
  • Creating sub totals
  • Removing duplicates
  • Customising field names
  • Changing field formatting
  • Drilling down to underlying data
  • Creating separate worksheet data from page/report fields
  • Pivot charts
  • Using slicers
  • Consolidating data
  • Creating links in consolidated data

Book this course

Course leader

Susan Howard

Head of Technical, Digital and Project Management

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Latest insight from Thales L&D

Free download

Enhance Magazine - Issue 19

Welcome to our latest issue of Enhance. Businesses are facing ever more challenging times in terms of global and local...

Read full article

Blog article

How Prepared are You? Episode Two: An Ageing Workforce

With all the changes I see occuring, one of the questions I'm most interested in is: how are organisations preparing...

Read full article

White paper

A Useful Guide to L&D Curriculum Design

Employee engagement has become one of the most frequently cited buzzwords in the HR and L&D world, and with good...

Read full article