Develop important skills in MS Excel 2010 for effortlessly using every feature of Excel 2010.
To gain mastery in MS Excel 2010, use Microsoft Excel 2010 Advanced Training Course offered by pdtraining in Auckland and other cities.
Advanced Excel 2010 Training Course is the third and the final course in the Excel 2010 series. The course includes topics such as logical functions, math & statistical functions, VLOOKUP, MATCH, INDEX, editing VBA functions, and more.
Topics covered in this advanced excel 2010 course include:
- Use logical functions
- Use math & statistical functions
- Use the PMT function
- Use data functions
- Calculate time
- Create array formulas
- Use VLOOKUP, MATCH & INDEX functions
- Validate data
- Use database functions
- Import & export text files
- Import & export XML data
- Use Goal Seek & Solver
- Use the Analysis ToolPak
- Create scenarios
- Run and record macros
- Edit VBA modules
- Create custom functions
Finally, participants will learn about the analytical features of Excel such as Goal Seek and Solver, running and recording macros, SmartArt graphics, and conditional formatting with graphics.
Pdtraining delivers 1000’s of professional development courses each year in Auckland, Christchurch, Wellington and other cities, so you can be assured your training will be delivered by a qualified and experienced trainer.
All public Microsoft 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 0800 003150 to learn more.