Many people know how to use MS Excel 2010, but very few have mastery over it.
MS Excel 2010 Advanced Training Course from pdtraining delivered in Napier, Christchurch, Hamilton is designed to enhance the skills of professionals through knowledge and expertise development in MS Excel 2010.
To become an Excel expert, you need both understanding and application. Local functions, math and statistical functions, INDEX and editing VBA functions, MATCH and VLOOKUP are some of the functions that must be mastered.
Topics an Advanced Course Includes
In an advanced course on Excel 2010, participants improve their skills in:
- Logical and statistical functions
- Financial and date functions
- Lookups and data tables
- Advanced data management
- Exporting and importing
- Analytical tools
- Macros and customer functions
These broad categories include both advanced and basic functions of Excel 2010. An advanced course must cover lookup functions such as VLOOKUP, MATCH and INDEX along with data validation and database functions such as DSUM. A professional course must teach the analytical features of Excel such as Goal Seek and Solver, SmartArt graphics, running and recording macros, conditional formatting with graphics, and how to query external databases.
Preparation for Excel 2010 Exams
Advanced training course on Excel 2010 helps participants to prepare for:
- Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and,
- Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888)
For beginners and intermediate levels, Pd training offers Introduction and Intermediate courses for Excel 2010, which helps participants to gradually improve their skills in MS Excel 2010.
Skills Developed after Advanced Training in Excel 2010
After completing the advanced course in Excel 2010, a participant will have achieved skills in:
- Logical functions
- Math and statistical functions
- PMT functions
- Data functions
- Calculation of time
- Creation of array formulas
- Using VLOOKUP, MATCH and INDEX
- Validation of data
- Import & export of text files and XML data
- Using Analysis ToolPak, Goal Seek & Solver
- Editing VBA modules
- Creation of scenarios and custom functions
- Running and recording of macros
Achieving mastery over MS Excel 2010 assists companies and individuals to analyse, manage and share information in multiple ways. It makes management, organisation and analysis simple and accessible so that smarter decisions can be made easily.
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.