Excel Module 5 - Advanced Data Management, Thales Training Consultancy

EXCEL MODULE 5 - ADVANCED DATA MANAGEMENT

Duration:

1 day

Price:

£190.00

Locations Available:

Basingstoke
04 Aug 08
17 Oct 08

Crawley
14 May 08
09 Jun 08*
29 Aug 08
06 Oct 08

Suitable For

Experienced users of Excel who need to manage large amounts of data across multiple worksheets and workbooks. Delegates should be experienced users of Excel. They should be able to build formulas and functions including logical, lookup and reference functions.

The course is designed to be taken after the Excel Module 4 – Advanced Formulas and Functions course or for delegates with equivalent knowledge.

Objectives

By the end of the course delegates will be able to:·

Create nested conditional formulas linking data between worksheets·
Set advanced conditional formatting and data validation options·
Connect to external data sources·
Use the What If Analysis tools

Related Courses In Our Range·

Excel Module 1 - Essentials·
Excel Module 2 – Gathering & Presenting Data·
Excel Module 3 – Data Analysis·
Excel Module 4 – Advanced Formulas & Functions·
Excel - Pivot Table Expert·
Excel Advanced - Macros·
VBA in Excel Part 1·
VBA in Excel Part 2

Versions Available

97, 2000, XP and 2003

Course Content

Interactivity Between Worksheets·

Creating data validation lists from ranges·
Nested lookups·
Conditional linking·
Creating graphs on variable data

Nested Conditional Functions·

Using the forms toolbar·
Adding check boxes·
Adding option buttons·
Setting control properties·
Nesting logical and statistical functions

Advanced Conditional Formatting And Data Validation·

Setting conditional formulas·
Applying conditional formulas to more than one cell·
Copying conditional formulas to other rows·
Colour banding·
Finding cells that have conditional formatting set·
Finding duplicate values·
Preventing duplicate values

Using External Data Sources·

Creating database queries·
Setting external data range properties·
Creating web queries

Using External Data Sources For Pivot Tables·

Creating a pivot table with an external data source·
Data source options·
Pivot table data options·
Publishing to a web page

Forecasting With What If Analysis Tools·

Using Goal Seek·
Using Solver·
Creating Scenarios·
Creating Data Tables

Functions·

PMT·
MOD·
ROW