Back to Search Results

Training Course Summary:

This 2 day course will extend delegates’ knowledge of Excel to gain a finer appreciation of its functionality. Delegates will be introduced to the power of Auditing, Data Consolidation and techniques that make more efficient use of Excel.

Pre-Requisites:

Delegates should be familiar with Microsoft Windows and have a good understanding of Microsoft Excel XP; alternatively they may have attended the Beyond the Basics course.

Training Course Overview/Content:

Displaying & Formatting Data:
Creating and applying custom number formats. Use conditional formatting.

Auditing:
Use arrows to track the cells used in the construction of a Formulae – tracing errors, tracing dependent cells. Data validation – to validate data entries.

Conditional Processin:
Using AND / OR Logic, Nesting IF Functions.

PivotTables & Charts:
Creating and using PivotTables to analyse data. Creating an interactive PivotTable for goal seeking

VLookup & HLookup:
Look for matching data and return a result

Naming Ranges in Formulae:
Creating named ranges and using them when creating a formula

Scenario Manager:
Switching between scenarios.

Custom Views:
Create custom views of your worksheet which then can be used for printing and viewing purposes

Report Manager:
Print Views & Scenarios most often used

Graphics/Chart Graphics:
Use WordArt, Graphics, AutoShapes and look at the Drawing Toolbar. Enhance charts with Graphics and edit a Pictograph

Using Templates:
Creating and customising a template.

Goal Seek & Solver:
Resolve problems using one variable and use Solver to assist with multiple variables

Data Consolidation:
Consolidate data from several worksheets or within the same worksheet

Customisation:
Toolbars, Menus, Keystrokes

Exchanging Data/Linking Data:
Exchange/Linking Data with Other Applications, Importing and Exporting

Macros:
Creating simple personal or workbook macros. Assigning them to toolbars, worksheets or keystrokes