For Course Information and to Register for Microsoft Excel 

Description

Welcome to “Excel VBA Vanguard: Comprehensive Programming “. Specifically tailored for corporate professionals aiming to advance their Excel capabilities, this course will provide you with a solid foundation in Excel’s VBA programming language.

Key Benefits:

VBA Mastery: Learn how to use VBA Editor, macro-enabled files, and object properties to automate and enhance your Excel tasks in your current and future roles.

Advanced Automation: Gain the knowledge to use variables, manipulate data using expressions, and create sub and function procedures for sophisticated automation tasks.

Effective Decision-Making: Master the use of decision structures to create procedures that execute code based on specific conditions, enhancing your ability to handle complex data scenarios.

User Interface Design: Learn how to create user-friendly forms with validated data entry controls, enhancing the usability of your Excel workbooks.

Debugging Skills: Identify and rectify compile-time, run-time, and logical errors in code, improving the reliability of your VBA programming tasks.

Career Advancement: With VBA skills becoming increasingly relevant in the corporate world, this two-day course offers you a significant competitive edge in the job market and in your career progression.

By the end of this two-day course, you will emerge as an Excel VBA Vanguard, capable of harnessing the full potential of Excel’s VBA for sophisticated data manipulation and automation tasks. Empower yourself in today’s data-driven corporate world with this skill upgrade.

Course Information

Pre-requisites
To gain the most from this course participants need to have experience in working with Excel at a Higher level.

Aim
This course aims to provide you with the skills and knowledge necessary to use VBA in Excel.

Learning Outcomes
At the completion of this course you should have the skills and knowledge to:

• Use VBA Editor, macro-enabled files, object properties and methods, attach code to events and buttons, and use the Object Browser to get information about objects.
• Use the variables of relevant data types, manipulate data by using expressions, get input from the user, declare and use variables and procedures of correct scope, create Sub and Function procedures, and call one procedure from another.
• Use decision structures to create procedures that execute code, based on specific conditions, and use loop structures to execute specific code repeatedly.
• Add a user form to your project and add controls to the user form, handle events attached to controls in a user form, and validate the data entry in the controls.
• Identify compile-time, run-time, and logical errors in code, use the debugging tools, and write errorhandling code to trap errors.

Additional Course Information

Face-to-Face Available for Canberra or Webinar.

Price: $960

Available Dates:

Please Contact Us

When registering for this course you are agreeing to the following cancellation/reschedule policy.
Cancellation/Reschedule Policy
To re-schedule or cancel a booking, please notify Wizard with 5 full working days’ notice, prior to the commencement of the course.
*Cancellation is required in writing*
– Should we receive less than 5 full working days notice, the full course costs will be charged.
– We are happy to accept a substitution prior to the commencement of the course.
– Substitutions must have application knowledge at the appropriate level.
– If unable to attend due to sickness, a free se-sit will be offered if a medical certificate can be provided.