MOS4007 - Excel Programming with VBA
Duration: 3 days
Price: $1156.11
Description
Students learn the Visual Basic for Applications language as well as the Excel classes and objects needed to create VBA scripts to automate Excel. Participants create procedures and functions using the VBA language and Excel objects. The PivotTable object is used to create macros that add interactivity to the standard Pivot Table. As well, debugging and error handling techniques are reviewed.
Learning Objectives
• Introducing Visual Basic for Applications
• Working with Procedures and Functions
• Understanding Objects
• Using Expressions, Variables, and Intrinsic Functions
• Controlling Program Execution
• Working with Forms and Controls
• Working with the PivotTable Object
• Debugging Code
• Handling Errors
Method of Delivery
• Onsite/Live class instructions or Online web seminar
• Lectures
• Open discussion
• Case studies
• Surveys
Chicago Downtown Location:
20 N. Wacker Dr. Suite 1200
Chicago, IL 60606
Direct: +1 (312) 804-9992
Fax: +1 (312) 803-2223
Toll Free: (866) 482 8275
E-mail: info@ecgmn.com
All names and logos are registered trademarks of their respective owners.
eConsulting Group®, Agile Expert™, Business Analyst Expert™, Database Management Expert™, Hands On Project Management™, Healthcare IT Expert™, Human Resource Expert™, Link2Task™, Link2Project™, Management Expert™, Network Security Expert™, Office Management Expert™, Programming Expert™, Project Book™, Project Management Expert™, Project Management Specialist™, Project Manager Master Level™, Project2Market™, Renewable Energy Management Expert™, Six Sigma Expert™, Social Media Expert™, We Build Project Managers™, and Web Development Expert™ are registered certificates and trademarks of eConsulting Group, Inc.
PMI-ACP, PMI, CAPM, PMP, Project Management Professional, and PMBOK® Guide are registered marks of the Project Management Institute, Inc.
GI Bill® is a registered trademark of the U.S. Department of Veterans Affairs (VA). More information about education benefits offered by VA is available at the official U.S. government Web site at https://www.benefits.va.gov/gibill.