View Cart
Checkout
Items Ordered:, Cart Value:
Products
Courseware
Crisp Self-Development
CustomCourse
Search
Home
Up
Info
E-mail
Main Pages
Instructor-Led Courseware
CustomCourse
Crisp Self-Development
Free Personalisation
Newsletter
Tel: 01507 313501
Trainingwarehouse
|
Courseware
|
IT Series
|
Excel
|
Excel 2010
| Excel 2010 MOS Advanced
Trainingwarehouse
>
Courseware
>
IT Series
>
Excel
>
Excel 2010
>
Excel 2010 MOS Advanced
Excel 2010 MOS Advanced
Ref: EX21AV
Days of training:
1
Prerequisites:
Excel 2010: Intermediate or equivalent experience
Logical and statistical functions
Logical functions
Math and statistical functions
Financial and date functions
Financial functions
Date and time functions
Array formulas
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
Exporting and importing
Exporting and importing text files
Exporting and importing XML data
Getting external data
Analytical tools
Goal Seek and Solver
The Analysis ToolPak
Scenarios
Macros and custom functions
Running and recording a macro
Working with VBA code
Creating functions
Excel 2010 Advanced Instructor Manual in colour
Ref: TIEX21AV
Price: £19.95
(Excluding VAT at 20%)
Quantity:
Excel 2010 Advanced Student Manual in colour
Ref: TMEX21AV
Price: (4 or fewer items) £16.95
(Excluding VAT at 20%)
Price: (5 to 19 items) £15.26
(Excluding VAT at 20%)
Price: (20 or more items) £13.56
(Excluding VAT at 20%)
Quantity:
Excel 2010 Advanced A5 Student Manual in colour
Ref: T5EX21AV
Price: (7 or fewer items) £11.95
(Excluding VAT at 20%)
Price: (8 to 19 items) £10.76
(Excluding VAT at 20%)
Price: (20 or more items) £9.56
(Excluding VAT at 20%)
Quantity:
Trainingwarehouse
>
Courseware
>
IT Series
>
Excel
>
Excel 2010
>
Excel 2010 MOS Advanced