Excel Advanced 2010

Computer Training Solutions

£250
+ VAT
Compare this course with other similar courses
See all

Important information

Description

After completing this course you will know how to: Use named ranges in formulas Use LookUp functions Link multiple workbooks Import data Use Pivot Tables and charts Use Templates and styles Analyse data Create and use macros Protect a spreadsheet Consolidate a workbook.
Suitable for: Pre-requisites Excel 2010 Intermediate or equivalent experience

Important information

Requirements: Experience of Windows 2000 or later.Attendance on Excel 2003 Intermediate course or equivalent

Venues

Where and when

Starts Location
On request
Birmingham
Centre Court, 1301 Stratford Road, Hall Green, B28 9HH, West Midlands, England
See map
On request
Bristol
Telephone Avenue, BS1 4BQ, Avon, England
See map
On request
Fleet Street
154 - 160 Fleet Street, EC4A 2DQ, London, England
See map
On request
Reading
Soanepoint, 6 - 8 Market Place, RG1 2EG, Berkshire, England
See map

Course programme

Course content:

Advanced functions
Logical functions
Math and statistical functions
Financial functions
Displaying and printing formulas

Lookups and data tables
Using lookup functions
Using MATCH and INDEX
Creating data tables

Advanced data management
Validating cell entries
Exploring database functions

PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
PivotCharts

Exploring and importing
Exporting and importing text files
Exploring and importing XML data
Querying external databases

Analytical tools
Goal Seek and Solver
The Analysis ToolPak
Scenarios
Views

Macros and custom functions
Running and recording a macro
Working with VBA code
Creating functions

Conditional formatting and SmartArt graphics
Conditional formatting with graphics
SmartArt graphics


Compare this course with other similar courses
See all