Do you need to improve your advanced Excel skills?
To gain mastery in Excel 2010, consider participating in MS Excel 2010 Advanced Training Course from pdtraining in Napier, Christchurch, Hamilton and other cities in New Zealand.
This third and final course in the Excel 2010 series comes after MS Excel 2010 Introduction Training Course and MS Excel 2010 Intermediate Training Course. It really helps tie the previous two courses up and elevate Excel skills to an expert level.
Topics like logical functions, math & statistical functions, VLOOKUP, MATCH, INDEX and editing VBA functions, are covered in depth. Topics covered in this advanced excel 2010 course include:
- Use logical functions (IF, OR, AND & NOT)
- Use math & statistical functions
- Use the PMT function
- Use data functions (YEAR, DAYS360 & NETWORKDAYS)
- 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 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.