Develop Advanced Skills in Excel 2010: Training Course in Parramatta, Melbourne, Adelaide

MS Excel 2010 Advanced Training Course from pdtraining in Parramatta, Melbourne, Adelaide — Develop expertise in MS Excel 2010

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 Parramatta, Melbourne, Adelaide and other cities in Australia.

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.