Advanced Excel 2010 Training Course is the third and the final course in the Excel 2010 series.
Develop mastery over Excel 2010 by participating in MS Excel 2010 Advanced Training Course from pdtraining in Los Angeles, Manhattan and other cities.
The course includes topics such as logical functions, math & statistical functions, VLOOKUP, MATCH, INDEX, editing VBA functions, and more. The course is preceded by MS Excel 2010 Intermediate and Introductory Training Courses.
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 Atlanta, Baltimore, Boston, Charlotte, Chicago, Dallas, Los Angeles, Manhattan, Miami, Orlando, Philadelphia, and Seattle, 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. Customized courses are available upon request, so please contact pdtraining on 855 334 6700 to learn more.