Excel Module 3 - Data Analysis, Thales Training Consultancy

EXCEL MODULE 3 - DATA ANALYSIS

Duration:

1 day

Price:

£175.00

Locations Available:

Basingstoke
08 Jul 08
17 Sep 08
09 Oct 08

Crawley
29 May 08
24 Jun 08*
05 Aug 08

Suitable for

This 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. Delegates should be confident in creating and editing worksheets and be able to write basic formulas.

Objectives

By the end of the course participants 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

Related Courses In Our Range·

Excel Module 2 – Gathering & Presenting Data
Excel Module 4 – Advanced Formulas & Functions
Excel Module 5 – Advanced Data Management
Excel – Pivot Table Expert
Excel Advanced – Macros
VBA in Excel Part 1
VBA in Excel Part 2

Versions Available

97, 2000, XP and 2003

All courses marked with * are now available in Microsoft Office 2007 in addition to our usual choice of versions

Course Content

Organising data using the Excel database·

Using the data form·
Finding data·
Setting find criteria·
Sorting information·
Creating sub totals

Analysing data in the database·

Applying the auto filter·
Setting custom autofilter options·
Using the subtotal function (2000, XP, 2003)·
Using the list feature (2003 only)

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 PivotTables·

Creating a PivotTable·
Modifying the PivotTable·
Recalculating the PivotTable·

More with PivotTables·

Customising field names·
Changing field formatting·
Pivot Charts (2000,XP and 2003 only)

Ranges, labels and lists·

Creating named ranges·
Using a range name in a formula·
Linking a name to a validation list

Summarising data using data consolidation·

Defining ranges·
Consolidating data·
Creating links in consolidated data

Creating views in large spreadsheets·

Setting up your view·
Creating a view·
Applying a view