Please be aware that due to COVID-19, classroom courses until April 30, 2021 will be switching to online offerings. MORE INFO >>
At EPIC Training our primary concern is the health and safety of our attendees, instructors, and team members.
Due to COVID-19 we are moving our courses online as an alternative to classroom training. There will be no classroom courses scheduled until at least after April 30, 2021.
Thank you for your understanding.
View Online Courses Now

Course Catalogue.

Intermediate Excel & VBA in Engineering

7 Professional Development Hours

After Participating in this course, you will be able to:

  • Master the shortcuts and important modules of the Microsoft Excel Software
  • Implement the advanced functions of the software, such as vertical and horizontal lookups and conditional operators
  • Use Pivot Tables to facilitate data analysis
  • Create user interfaces in Excel with buttons, lists, drop-down menus, etc.
  • Write basic scripts in VBA to automate processes

In most engineering work environments, the Microsoft Excel software is used as a spreadsheet to do simple calculations and create charts. But did you know that this software can do way more? Much more than a simple spreadsheet, the Microsoft Excel software comes with numerous powerful functions that can be used to facilitate the processing and analysis of data.

The most interesting and often overlooked aspect of Excel is VBA (Visual Basic for Applications), which is the programming language within Excel, that can be used to create sophisticated user interfaces and unlock the real processing power of Excel.

Students must bring their laptops. Please see the SPECIAL FEATURES and REQUIREMENTS section on our website.

Course Outline :

  • Vertical and horizontal lookups                     
  • Conditional operators: if, and, or
  • Mathematical functions
  • Filters, sorts, lists and tables
  • Charts
  • Pivot Tables
  • Buttons, drop-down menus
  • VBA: macros, forms, variables, loops

Who Should Attend:
Anyone who works with Microsoft Excel: Engineers • Technologists • Technicians • Project Consultants • Managers • Analysts

Course Rating
4.9 out of 5

Overall rating of this course by its previous attendees!


Almost all of EPIC's seminars and webinars offer :

  • Continuing Education Units (CEUs) and
  • Professional Development Hours (PDHs)

These course credits will help attendees earn training requirements for their associations or provincial governing bodies.

Select an EPIC course location below to request this topic in that city. Please note: Cities are disabled if there is already a current offering.
This course can be customized and delivered to a group at your facility saving time and money.
Brochure Downloads

EPIC has many catalogs you can download containing courses in your area!