Microsoft Excel 2007 Advanced Training Course / Birmingham, UK

Blythe Valley Business Park
Birmingham, UK

- Highly qualified instructors certified by Microsoft as competent to train in Excel
- ALL Microsoft Excel software versions available
- Monitoring email and telephone support for 90 days following its course
– Receive all the exercise files to a CD to keep practicing in the office
- Certificate of Completion
- 96% of delegates rate our courses as very good or higher
- Small classes of 10 or less
- Regular monthly or bi-monthly dates in all our training
- Training times are 9:30-4:30
- Lunch and free parking included
- 5% discount offered for credit card payments made on the day of the reservation
- Full 100% Money back guarantee if not satisfied with any aspect of your course

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