MS Excel 2007 Advanced – Training Course in London, England
London, UK
Why choose us for your Excel course?
Tailored training lets you take your work throughout the day to learn how to complete giving immediate results REAL
- Develop a support network of people from other organizations in a similar role to yourself (in our regular courses)
-Training offered in a patient, calm manner to relieve the stress of students eager
- Improve your career prospects through training certified
- Follow our training team before and after your course ensures that all its objectives have been met
Course Contents
Unit 1: Advanced
Topic A: Logical functions
Topic B: Mathematics and statistics functions
Topic C: Financial functions
Topic D: Displaying and printing formulas
Unit 2: searchable data tables
Topic A: Using search functions
Topic B: Using MATCH and INDEX
Topic C: Creating data tables
Unit 3: Managing the Advanced list
Topic A: Validating cell entries
Topic B: Exploring database functions
Unit 4 PivotTable and PivotChart
Topic A: Working with PivotTables
Topic B: Rearranging PivotTables
Topic C: Formatting PivotTables
Topic D: Dynamic Graphics
Unit 5: Exporting and importing
Topic A: Exporting and importing text files
Topic B: Exporting and importing XML data
Axis C: Start of external databases
Unit 6: Analytical options
Topic A: Goal Seek and Solver
Topic B: The Analysis ToolPak
Topic C: Scenarios
Topic D: Views
Unit 7: Macros and custom functions
Topic A: Running and recording a macro
Topic B: Working with VBA code
Topic C: Creating Functions
Unit 8: Conditional formatting and SmartArt
Topic A: Conditional formatting with graphics
Topic B: SmartArt graphic
Tailored training lets you take your work throughout the day to learn how to complete giving immediate results REAL
Develop a support network of people from other organizations in a similar role to yourself (in our regular courses)
Training offered in a patient, calm manner to relieve the stress of students eager
Improve your career prospects through training certified
Follow our training team before and after your course ensures that all its objectives have been met
Course Contents
Unit 1: Advanced
Topic A: Logical functions
Topic B: Mathematics and statistics functions
Topic C: Financial functions
Topic D: Displaying and printing formulas
Unit 2: searchable data tables
Topic A: Using search functions
Topic B: Using MATCH and INDEX
Topic C: Creating data tables
Unit 3: Managing the Advanced list
Topic A: Validating cell entries
Topic B: Exploring database functions
Unit 4 PivotTable and PivotChart
Topic A: Working with PivotTables
Topic B: Rearranging PivotTables
Topic C: Formatting PivotTables
Topic D: Dynamic Graphics
Unit 5: Exporting and importing
Topic A: Exporting and importing text files
Topic B: Exporting and importing XML data
Axis C: Start of external databases
Unit 6: Analytical options
Topic A: Goal Seek and Solver
Topic B: The Analysis ToolPak
Topic C: Scenarios
Topic D: Views
Unit 7: Macros and custom functions
Topic A: Running and recording a macro
Topic B: Working with VBA code
Topic C: Creating Functions
Unit 8: Conditional formatting and SmartArt
Topic A: Conditional formatting with graphics
Topic B: SmartArt graphic
Course Fee: £250 excl. VAT
Contacts: JB Consulting Ltd, 0800 019 6882
Your Comment