Develop advanced knowledge and practical skills in Microsoft Excel 2010.
To gain skills in excel 2010, consider participating in MS Excel 2010 Advanced Training Course delivered by pdtraining in Dunedin, Christchurch and other cities in New Zealand.
This Excel 2010 advanced training course running in Auckland, Wellington, Hamilton, Dunedin, Christchurch and Tauranga, is rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Excel 2010: Intermediate.
Participants will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will also learn how to import and export data, and how to query external databases.
This course will help participants prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888).
For comprehensive certification training, participants should complete the Introduction, Intermediate, and Advanced courses for Excel 2010.
Advanced Excel Course Modules Include:
Introduction
- Introduction
- Personal learning goals of each participant
- Plan and structure for the day
Logical and statistical functions
- Logical functions
- Math and statistical functions
Financial and date functions
- Financial functions
- Date and time functions
- Array formulas
- Displaying and printing formulas
Lookups and data tables
- Using lookup functions
- Using MATCH and INDEX
- Creating data tables
Advanced data management
- Validating cell entries
- Exploring database functions
Exporting and importing
- Exporting and importing text files
- Exporting and importing XML data
- Getting external data
Analytical tools
- Goal Seek and Solver
- The Analysis ToolPak
- Scenarios
Macros and customer functions
- Running and recording a macro
- Working with VBA code
- Creating functions
Pdtraining delivers 1000’s of professional development courses each year in Wellington, Auckland, Napier, Christchurch, Hamilton, Dunedin and Tauranga, so you can be assured your training will be delivered by a qualified and experienced trainer.
All public MS Excel 2010 Advanced Training courses include am/pm tea, lunch, printed courseware and a certificate of completion. Customised courses are available upon request so please contact pdtraining on 1300 121 400 to learn more.