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?

  • Using the data form
  • Finding data
  • Sorting information
  • Creating sub totals
  • Removing duplicate entries (2007 and 2010)
  • Formatting data as a table (2007 and 2010)
  • Using autofilter
  • Using the subtotal function
  • Filtering data using the advanced filter
  • Setting criteria
  • Extracting data to other locations
  • Filtering for unique records
  • Creating named ranges
  • Linking a name to a validation list
  • Using the Name Manager (2007 and 2010)
  • Creating and modifying a pivot table
  • Recalculating the pivot table
  • Filtering the pivot table (2007 and 2010)
  • Searching the pivot table (2010)
  • Customising field names
  • Changing field formatting
  • Drilling down to underlying data
  • Creating separate worksheet data from page/report fields
  • Pivot charts
  • Using slicers (2010)
  • Defining ranges
  • Consolidating data
  • Creating links in consolidated data
  • Setting and applying a view
  • Adding custom view to the quick access toolbar (2007 and 2010)

Book this course

Course leader

Susan Howard

Head of Project Management & IT 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