Excel Advanced 2010

Computer Training Solutions
In Fleet Street, Reading, Birmingham and another venue.

Want to speak to an Advisor about this course?
Want to speak to an Advisor about this course?
Students that were interested in this course also looked at...
See all

Important information


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

Where and when

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

Frequent Asked Questions

· Requirements

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

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
Creating data tables

Advanced data management
Validating cell entries
Exploring database functions

PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables

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

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

Achievements for this centre

Students that were interested in this course also looked at...
See all