VBA for Supply Chain and Business Professionals

With a multitude of courses available, what makes this one stand out? First and foremost, it is specifically designed for SCM and business professionals. The course material includes techniques, tools, and case study examples modeled after the instructor’s real-life industry experiences.

Instruction Dates: For booking availability, please use the contact us form to get in touch.

AB Gov’t funding may be available: Employers in Alberta can apply for government funding for professional development training. The Canada-Alberta Job Grant (CAJG) is an employer-driven training program where employers and government share the cost of training new and existing employees to increase their knowledge and skills to meet the needs of Alberta’s changing economy. Check the CAJG Applicant Guide for details.

Description: Specifically designed for business professionals who want to develop advanced analytical skills and introduce automation within their organization. Excel is a great tool, but as with any great tool it has its limitations. By using VBA you will learn how to transform Excel into a fully programmable multi-purpose automation tool with nearly endless capabilities. This course introduces you to the analytical world that goes way beyond simple macros and recorded code, and will provide the foundational knowledge you need to pursue additional VBA code writing skills.

Main Topics:

  1. Introduction to VBA
    1. The Developer tab
    2. Recording macros
    3. Editing macros
    4. Basic input/output
  2. Intermediate VBA
    1. Variables
    2. VBA loops
    3. User-Defined Functions (UDFs)
    4. When to use VBA vs Excel
  3. VBA Solutions
    1. Auto-generate PowerPoint presentations
    2. Auto-generate email with PDF attachments
    3. Auto-generate Pivot Tables

Duration: 2-days (16 hours)

Prerequisites: An intermediate or higher proficiency rating on our placement exam. (provided in advance of booking) This course is not recommended for beginners or novice Excel users.

Price: $795/person

General Information:

Class Capacity: Standard bookings require a minimum of 5 and maximum of 10 people per class (for groups of 6 or more, an assistant instructor will be provided to help facilitate and ensure everybody receives sufficient hand-on support throughout the course). If you have larger or smaller groups requiring training, please use the contact us form to let us know about your requirements. In many cases we are able to customize our offerings in order to help you access the training and support you require.

Location: Pricing for all courses is for delivering the course in the client’s offices. If a training room or suitable boardroom with the required equipment is not available, alternate arrangements can be made to book a suitable facility. If Azura Consulting handles the facility booking, it will be charged for at the cost of the booking plus a 5% administrative markup.

Equipment needed: A room equipped with a computer for each participant, along with a projector or large digital screen that can be utilized for delivering presentation material from the instructor’s computer or USB drive.  Participants can use either PC desktop computers or PC laptops, provided they have MS Excel for Windows pre-installed.

What version of Excel? This workshop will use the standard version that most corporations use today, MS Excel 2010 but if participants are using Excel 2007 or Excel 2013/2016, the workshop facilitator will help participants bridge the gap between versions as there are not many differences in the versions.

Inquire about Enrollment: For booking availability, please use the contact us form to get in touch.