Microsoft Excel 2003 Advanced Level Training Course – Birmingham, UK

Blythe Valley Business Park
Birmingham, UK

Features of Excel training

- 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

- Names of ranks / Define named ranges
- Using named ranges in formulas
- Functions and HLOOKUP / Using VLOOKUP
- Use HLOOKUP
- Linkage of several books / Use formulas to bind books
- Create a workspace
- Data Import / Import from external sources
- Using Microsoft Query
- Pivot tables and charts / Creating a PivotTable
- Changing field values
- Creating a chart
- Templates and styles / Working with Templates
- Working with styles
- Macros / Creating macros
- Add custom controls
- Data Analysis / Use GoalSeek
- Using Solver
- Using Data Tables
- Stage Manager
- The safety and correction
- Excel File Protection
- Protecting worksheet
- Using data validation
- Using text to speech
- Customizing Excel 2003
- Customizing Toolbars
- Personalization
- Collaboration and consolidation
- Share books
- Sending Books
- Consolidating data

Course fee: £250 excl. VAT

Contacts: JB Consulting Ltd,  0800 019 6882