Call us today: 0800 028 3045

Microsoft Excel Course – Module 3 Data Analysis

Is it right for me?

Our Excel Module 3 - Data Analysis course is ideal for those who would like to learn more about data analysis techniques in Excel.

It is designed for experienced users of Excel. You should be confident in creating and editing worksheets and be able to write basic formulas.

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

Versions available

2003, 2007, 2010

Related courses in our range

What does it cover?

Organising data using the Excel database

  • Using the data form (2003)
  • Finding data
  • Sorting information
  • Creating sub totals
  • Removing duplicate entries (2007 and 2010)

Analysing data in the database

  • Formatting data as a table (2007 and 2010)
  • Using autofilter
  • Using the subtotal function

Using the advanced filter to analyse data

  • Filtering data using the advanced filter
  • Setting criteria
  • Extracting data to other locations
  • Filtering for unique records

Analysing information using Pivot Tables

  • Creating and modifying a Pivot Table
  • Recalculating the Pivot Table
  • Filtering the Pivot Table (2007 and 2010)
  • Searching the Pivot Table (2010)

More with Pivot Tables

  • Customising field names
  • Changing field formatting
  • Pivot Charts
  • Using Splicers (2010)

Ranges, labels and lists

  • Creating named ranges
  • Using a range name in a formula
  • Linking a name to a validation list
  • Using the Name Manager (2007 and 2010)

Summarising data using data consolidation

  • Defining ranges
  • Consolidating data
  • Creating links in consolidated data

Creating views in large spreadsheets

  • Setting and applying a view
  • Adding a Custom View to the Quick Access Toolbar (2007 and 2010)

“The course trainer was very good, providing a clear and easy to follow course format.”

Vicki Cobb, Administration Assistant, Total Gas & Power Limited (GAS)

Course Summary

  • Duration: 1 day
  • Price: £185.00+VAT
  • Location: Crawley
  • Select date:

Send to a colleague

Please enter details below and click 'submit'

Tailor this course

If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.

Alternatively, enter your details below and one of our team will contact you.


Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.


Thales Training & Consultancy. Registered in England and Wales. Registered Office: Sackville House, Northwood Park, Gatwick Road, Crawley, West Sussex RH10 9XN. Registered in England Number: 1597499. Thales Training serve the local area of Crawley, Gatwick, West Sussex, Surrey and Kent as well as offering training courses at locations around the UK