Home > Excel Class Guide > Advanced Excel VBA
Advanced Excel VBA Training

Advanced Excel VBA for Business & Industry

Get ready to build the hi-tech apps they said you couldn't in Excel!  Learn to command userforms, ActiveX, and just about everything else to create UI driven data processing, analysis, and dashboard tools in Excel.

Next Class: Check Dates

  • Live, Hands-On, Industry Topics
  • Bring your own problems
  • Limited class size
  • Taught by an Excel software developer
Dates / Sign Up >

Class overview.

Our 3-day class covers how to combine userforms, events, ActiveX controls, and VBA with other Excel elements to develop powerful UI driven apps. 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 fullest potential.  Key Topics >

Holiday Sale
Bolt

Key Topics

Bolt

Some key topics we cover in class.

See What You'll Learn!
See What You Master
Close
Bolt

Some Class Examples

Bolt
Advanced Excel VBA Preview
Bolt

Can't Attend? Get the Manual.

Bolt

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.
  • Buy the manual now and apply its price to a class later. Just let us know when purchasing a class. The manual comes with the class.
See the Manual >
Bolt

Class Syllabus

Bolt
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

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

Bolt

Required Class Skills

Bolt

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

Bolt

Class Details

Bolt

Duration, #days, audience details about our class.

Bolt

Contact Us

Bolt

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 >

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

Copyright © 2002-2022

EMAGENIT All Rights Reserved