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 Capability

Need a bespoke solution?

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

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Tweets
Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine