Trainingwarehouse
  • View Cart
  • Checkout
  • Items Ordered:, Cart Value:

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