Beginning Excel VBA for Business and Industry - Class

Learn to automate those repetitive data processing, calculation, and formatting Excel tasks. Build tools that will solve your tasks in seconds.

Next Class: Check Dates

Beginning Excel VBA Training

How our class will boost your Excel VBA skills.

Boost Advanced Excel VBA Training

Our 2-day class shows you the critical Excel VBA skills needed to start making automated macro tools right away.

It covers the critical Excel VBA topics you need like modules and the VBA Editor; code debugging; how to use the VBA language; and program logic.

We also cover how to use Excel VBA to command key Excel elements like formatting, charts, PivotTables, sorting, filtering, and inserting / deleting rows columns.

Also discussed is how to use Excel VBA to perform key tasks like controlling workbooks / worksheets; automated calculations; table lookups; and data processing.

Read our detailed outline > below and see everything you'll discover in our class.

Take a video tour of what you'll learn.

Video Play
  • Complete review of the Excel VBA language, VBA Editor, debugging,  procedures, and modules
  • How to read cell values, perform calculations, and return values to worksheets
  • How to use functions in VBA to calculate and lookup worksheet data
  • Using VBA to create formulas for worksheet data sets and place or fill them around the data
  • Using Excel VBA to quickly format worksheet data and insert, delete, and move rows, columns, and cells
  • Tracking and controlling data workbooks and worksheets in your VBA code
  • Controlling PivotTables, Sort, AutoFilter, Text Wizard, and Remove Duplicates with VBA to rapidly process data
  • Creating basic user interfaces to run your Excel VBA tools
  • Using loops and logic to analyze / calculate large, downloaded data sets
  • Using Excel VBA to swiftly fill in pre-built reports
  • Finding and tracking data in external workbooks and worksheets with Excel VBA
  • Using Excel VBA to rapidly fill worksheet forms with data and formulas
  • Creating and formatting charts using Excel VBA

Some key topics we cover in class.

Beginning Excel VBA Training Topics

4 ways to train.

Virtual Signup
Virtual

View the dates, signup, and pricing for our hands-on live virtual training.
Virtual Signup >   Learn More >

Public Signup
In-Person

View the dates, signup, and pricing for our hands-on in-person training.
In-Person Signup >   Learn More >

Manual Information
Manual

Can't take the class, buy the self-study manual, apply the price later.
View Manual >

Onsite Details
Onsite

Learn how we can help your business save time and effort in Excel.
View Onsite Details >

Class syllabus.

How we run the class: We focus our training on what our customers need. When training begins, we analyze those needs and shift our training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.
Class PDF

Download Class Brochure

Day-1

Excel VBA Language, VBA Editor, Debugging, and Module Review (Discussed When Needed)

Reading Cell Values, Performing Calculations, and Outputting to Worksheets with VBA

Using VBA to Calculate / Lookup Data with Functions and Build Formulas

Using Excel VBA to Quickly Format Worksheet Data and Control Columns / Rows

Tracking / Controlling Data Workbooks and Worksheets with Excel VBA

Automating PivotTables and Excel's Data Tools to Rapidly Report Data

Creating Basic User Interfaces (UIs) to Run Your Excel VBA Tools

Day-2

Using Loops and Logic to Analyze / Calculate Large Downloaded Data Sets

How to Generate and Fill in Report Tables with Excel VBA

Using Excel VBA to Rapidly Fill Worksheet Forms with Data / Formulas 

Searching for Data in External Workbooks and Worksheets Using Excel VBA

Using Excel VBA to Create / Format Excel Charts

Building Custom Worksheet Functions (UDFs) to Speed Up Worksheet Tasks

Additional Class Information

Prerequisites for our Excel VBA training.

Class time, manual, and repeats.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: Mon-Fri 8:00 AM - 7:00 PM CT

You can email us at info@emagenit.com >

Form >
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved