Main Pages

Trainingwarehouse > Courseware > IT Series > Excel > Excel 2003 > Excel 2003 Advanced

Excel 2003 Advanced in colour Ref: EX23AV Days of training: 1 Prerequisites: Excel 2003: Intermediate or equivalent experience Working with advanced formulas Using names Using decision-making functions Creating nested functions Using financial functions Lookups and data tables Working with lookup functions Using MATCH and INDEX Creating data tables Advanced list management Creating subtotals Validating cell entries Exploring database functions Working with data forms Working with PivotTables and PivotCharts Working with PivotTables Rearranging PivotTables Formatting PivotTables Working with PivotCharts Exporting and importing Exporting and importing text files Exporting and importing XML data Querying external databases Using analytical options Working with Goal Seek and Solver Working with the Analysis ToolPak Working with scenarios Working with views Working with macros Running and recording a macro Working with VBA code Function procedures Interactive Web pages Creating interactive Web spreadsheets Publishing PivotTables on the Web Using SharePoint services Document Workspaces Appendix A : Smart documents Discussing smart documents Appendix B : MOS exam objectives maps Core exam objectives Expert exam objectives

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

Excel 2003 Advanced Student Manual in colour Ref: TMEX23AV 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 2003 Advanced A5 Student Manual in colour Ref: T5EX23AV 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 2003 > Excel 2003 Advanced