MS Excel 2010 Advanced Training Course

This third and final course in the Excel 2010 series, 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.

This dynamic training course is available now throughout the US including Atlanta, Baltimore, Boston, Charlotte, Chicago, Dallas, Los Angeles, Manhattan, Miami, Orlando, Philadelphia, and Seattle.

Learning Outcomes - MS Excel 2010 Advanced Training Course

By the end of this training course, participants will:

• 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

Times

Public classes start at 9:00am and finish around 4:30pm.

Class Size

Public classes will be a small relaxed group of between 4 and 12 people.

The small group helps ensure that everyone will gets a chance to ask questions and learn at their own pace.

What is provided?

All participants will be provided with morning tea, afternoon tea, printed bound courseware to keep and a MS Excel 2010 Advanced Training Course Certificate of Completion.

Certificates of Completion are issued to each participant