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

• Excel Module 2 - Gathering and Presenting Data
• Excel Module 4 -– Advanced Formulas and Functions
• Excel Pivot Table Specialist
• Excel Macros –Specialist
• Excel Business Intelligence and Dashboards
• VBA in Excel Part 1

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)