Topics like logical functions, math & statistical functions, VLOOKUP, MATCH, INDEX and editing VBA functions, are covered in depth.
This dynamic advanced Excel training course is available now throughout Australia, including Brisbane, Sydney, Melbourne, Adelaide, Canberra and Perth.
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.
The new PD Training rooms come equipped with free wi-fi, a recreational gaming area with Nintendo Wii and the Advanced Excel 2010 Training Course in Brisbane also includes a free lunch with the cost of the course.
Free street parking is also available and we are close to public transport as well.
All students receive post Advanced Excel 2010 Training Course from the instructor for 12 months, a certificate of completion and small class sizes are guaranteed to result in a better training experience for you.
Best Advanced Excel 2010 Training Class including use of a cool games room, great lunch and bottomless espresso, free soft drink and unlimited health snacks all day – book in the next Advanced Excel 2010 Course now – small interactive class, definitely the BEST course, BEST Trainers and and BEST training environment!