Excel VBA Vanguard: Comprehensive Programming – 2 Days
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.
Face-to-Face Available for Canberra or Webinar.
Price: $960
Available Dates:
24th-25th June 2024
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.
Additional Details
Registration email/URL - techadmin@wct.com.au