Home > Excel Class Guide > Advanced Excel VBA

Advanced Excel VBA Class for Business and Industry

Advanced Excel VBA Training

Learn to command the advanced abilities of Excel VBA and userforms to create interface driven data processing, analysis, and dashboard tools.

  • Our 3-day class covers how to combine userforms, events, ActiveX controls, and VBA with other Excel elements to develop powerful UIs.
  • It demonstrates how to use UIs to control forms, data processing, databases, reports, and charts.
  • Also covered are topics like how to control folders / files; automating Excel's data tools for rapid reporting; scanning multiple data folders / workbooks; and text file processing.
  • Also discussed is how to develop dashboard tools that display various statuses and KPIs.
  • Join us and our class will show you how to unleash Excel VBA's full potential and much more >.

Next Class: 10/19/2022

More Dates >

No time to attend, get a manual instead.

Covers the VBA topics needed to design powerful UI driven data processing, database, and calculation tools for Excel.

  • Contains our complete Excel VBA write-up spanning from beginning Excel VBA to advanced Excel VBA topics.
  • Shows you how to create hi-tech Excel VBA interfaces from userforms, ActiveX controls, events, charts...
  • Also covers topics like multi-folder data processing, solving complex data sets; analyzing text files, and querying databases.
  • 1000's of lines of useful code, 100's of real world examples, and the proven strategies we use to develop Excel VBA software. Learn More >
  • Buy a manual now, apply the price towards a class later. Manuals come free with our classes.
See What You Master
Close
What's in the class.
Free Repeats
Repeat your Excel workshop your Excel class with us for an entire year for free.
Free Repeats
NASA Project
See how we helped NASA with the Mars Rover using Excel.
NASA
Discounts
We provide discounts to active / retired US Military and DOD.
Discounts
Customers
View our customers like Apple, Boeing, and the US Army.
Customers

Key Excel VBA topics covered in class.

Advanced Excel VBA Preview

Click to enlarge, scroll < > if hidden.

Pricing and class options.

virtual learning

Online Virtual Learning

  • Price: $850.00
  • Live, hands-on, talk to the instructor training
  • Bring your own problems to class
  • Online Details >
Dates / Signup >
virtual learning

Public In-Person Learning

  • Price: $950.00
  • Live hands-on training
  • Bring your own problems to class
  • We can supply a computer
Dates / Signup >
corporate learning

Onsite Hands-On Learning

  • We come to you and solve your problems
  • We cover in person in the USA and Canada
  • We cover the world virtually using your time zone
Details >

Detailed 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 Syllabus

Day-1

VBA Editor, Excel VBA Language, and Object Review (Discussed Where Needed)

Advanced Workbook and Folder Control Using Excel VBA

Advanced Report Methods Using VBA, Excel's Data Tools, and PivotTables

Advanced Worksheet Data Processing Using Excel VBA Loops and Logic

VBA Methods for Creating Text Files and Reading Text File Downloads

Searching for Data in Multiple Workbooks, Worksheets, and Folders Using VBA

Advanced Chart Report Generation Using Excel VBA

Day-2

Using VBA to Store Program Settings in the Windows Registry

 Creating Advanced UIs with Worksheets, Controls, Events, File / Folder Pickers, and Ribbon

Developing Advanced UIs Using VBA Userforms, ActiveX Controls, and Events

Assembling Advanced Worksheet Dashboards Using Excel VBA

Constructing Advanced Project Status and Calendar Tools Using Excel VBA

Day-3

 Creating and Managing Advanced Model and Analysis Problems with Excel VBA

Advanced Report Generation Using Excel VBA

Using SQL, ADO, and UIs to Query / Integrate Databases, Workbooks, and Text Files

Report Generation Using Word, PowerPoint, Outlook, and Excel VBA

Additional Classes:
Beginning Excel
for Business / Industry
Intermediate Excel
for Business / Industry
Advanced Excel
for Business / Industry
Excel Dashboard Design
for Business / Industry
Beginning Excel VBA
for Business / Industry
Excel VBA Data Processing
for Business / Industry
Advanced Excel VBA
for Business / Industry
Learn the key Excel topics and problem solving skills you need to quickly accomplish everyday Excel workplace tasks. Learn to use tables, formulas, functions, and Excel's data tools to quickly perform calculations, analyze data, and create reports. Learn about Excel's advanced querying, formula, and data processing capabilities and use them to build automated calculation and reporting tools. Learn to assemble Excel's pre-made features to create powerful hi-tech dashboards that integrate, analyze, and visualize your data. Learn to build time-saving Excel VBA tools that automate common data processing, calculation, and formatting tasks in seconds. Learn to create powerful data tools in Excel VBA that quickly process, integrate, and report data from multiple sources, files, and folders. Learn to command the advanced abilities of Excel VBA and userforms to create interface driven data processing, analysis, and dashboard tools.

Excel VBA skills needed for our class.

Select this Excel VBA training if you or your group have:

  • Used the Excel VBA language before
  • Used variables, loops, and logic before and know how they basically operate
  • Used objects, properties, and methods before in code to control a program
  • Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM, MATCH, COUNTIF, COUNTA...
  • Used Excel drawing shapes and built charts manually
  • Used Excel's data processing tools like Autofilter, Sort, Remove Duplicates, and PivotTables

The class details.

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 >

Contact us by form.

Click to View Form
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2022

EMAGENIT All Rights Reserved