Microsoft Excel 2007 Advanced Training Course / Birmingham, UK
| March 25, 2010 |
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
Similar Events
Event Location: All Events, Birmingham, United Kingdom
This Event Reviews: none
Rate this Event:

Review this event