Main Pages

Trainingwarehouse > Courseware > IT Series > Excel > Excel 2007 > Excel 2007 Advanced

Excel 2007 Advanced in colour Ref: EX27AV Days of training: 1 Prerequisites: Excel 2007: Intermediate or equivalent experience 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 list management Validating cell entries Exploring database functions PivotTables and PivotCharts Working with PivotTables Rearranging PivotTables Formatting PivotTables PivotCharts Exporting and importing Exporting and importing text files Exporting and importing XML data Querying external databases Analytical options 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 Conditional formatting with graphics SmartArt graphics

Excel 2007 Advanced Instructor Manual in colour Ref: TIEX27AV Price: £19.95 (Excluding VAT at 20%)		Quantity:

Excel 2007 Advanced Student Manual in colour Ref: TMEX27AV 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 2007 Advanced A5 Student Manual in colour Ref: T5EX27AV 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 2007 > Excel 2007 Advanced