Beginning Microsoft Excel VBA Training Outline for Business Professionals

Learn time saving Excel VBA skills that you can use to start making your Excel business tools right away. Our 2-day Excel VBA workshop for business shows you the basics of using VBA to command Excel, perform calculations, process and reconcile data, fill out forms and tables, create charts, build basic dashboards, command Word and PowerPoint (report generation) and much more. Our workshop is taught by a professional Excel programmer and comes with an 1800+ page manual.

Free Workshop Repeats

All of our workshops come with free repeats. We believe learning is an iterative process and not just a one time event. Details

EMAGENIT Customers and Awards

At EMAGENIT, we have trained customers like:

Janus Capital, HSBC, Deutsche Bank, Google, Apple, BMW, Capital One and Disney (View More)

We have also trained organizations like ICE, NASA, The US Army, Navy, Air Force and Marines and develop custom Excel software for the likes of Caterpillar and NASA (Award). Our diverse training background and software projects ensure you get the best Excel training drawn from real world experience not academia. We show you what you actually need to succeed.

Why Not Go Online For Your Training

Our live "hands-on" webinars enable us to train you and your company employees at different sites all over the country at once without having to collect them in one room. You can sign up for the webinar below. View Our Webinar Details Page

About Our Workshop

Time Saving Excel VBA Skills You Learn

What is VBA?
A complete review of the VBA Editor and VBA language including how to use subs, functions, variables, arrays, loops and logic
A complete programming strategy review, not just typing VBA code but how to put it together
How to use VBA to control workbooks and worksheets including adding, opening, naming and saving
How to use Excel VBA to control worksheet cells and ranges including basic tasks like calculations, formatting, copying and pasting, sorting and filtering
How to use Excel VBA to process data with shifting worksheet boundaries on single and multiple worksheets
How to copy and paste data in patterns in tables and forms using Excel VBA
How to create charts automatically using Excel VBA
How to create basic dashboards in Microsoft Excel using VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
Basic database communication using VBA DAO and ADO

Who Should Take This Workshop (Prerequisites)

Select this workshop if you or your group have:

Never programmed
Just used the macro recorder
Not programmed in over a year
Programmed but have not used objects before
Used Microsoft Excel and know its operational capabilities and its tools
Built basic worksheet formulas (=A1+A2) and used worksheet functions like SUM
Built basic charts

Microsoft Excel Versions Taught in Workshop

Our workshops cover Excel versions 2000-2013 including Excel for Mac and discuss differences when necessary.

Included in Our Beginning Excel VBA Workshop

Free Repeats
1800+ page manual filled with key Excel strategies, examples and tips
Hands-on training
Personal questions answered

Workshop Training Choices

Available: Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

Public Seminar, Live Online Webinar and Self-Study signup buttons below
For company onsite information or if you have any questions, please contact us 1.805.498.7162 or 1.805.558.9277.

Beginning Excel VBA Training Focus

Microsoft Visual Basic for Applications (VBA) can be used in conjunction with Microsoft Excel to construct automated business tools. VBA, a general purpose programming language, comes standard with Microsoft Excel. Using VBA with Excel, powerful business analysis tools can be developed quickly and with minimum cost. VBA can be used for important business tasks like data processing, model analysis, automating Excel's features and chores, chart creation, report generation, dashboard creation, controlling other programs, communicating with business databases, the list is endless. This workshop covers the fundamentals of using Excel VBA to create useful business tools for the real world.

Beginning Excel VBA Workshop Outline

In this 2-day "hands-on" workshop you will learn:

Day-1

A complete review of the VBA Editor including using the VBA debugger and the purposes of VBA projects, modules and procedures
A complete VBA language review including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
A complete overview of Excel programming strategies, not just the code but how to put it together into useful tools
How to command Excel using VBA including a discussion of objects, properties and methods
How to create and understand key paths (object expressions) that control Excel. In other words how to figure out on your own and actually use correctly the command.command.command syntax.
A complete review of using logic statements like IF and Select Case in your code and the strategies for using them in your programs
How to control workbooks, worksheets and ranges using Excel VBA
How to use VBA and worksheet functions in your code to calculate and process data
How to have your VBA code automatically adjust to changing data boundaries on the worksheet
How to perform fundamental tasks with Excel VBA like copy and paste, sort, filter, add workbooks, add worksheets, naming, building formulas ...
How to control the format and look of a worksheet using Excel VBA
How to use Excel VBA to copy and paste data in patterns in worksheet tables and fill in forms

Day-2

How to use the Excel macro recorder to record Excel tasks in VBA and then decipher the code for key property and method commands throwing the rest out
How to use VBA to analyze and perform calculations on business data from single and multiple Excel worksheets using loops and logic
How to automatically create charts in Excel using VBA
How to automate pivot tables with VBA
How to create your own custom worksheet functions using VBA
How to access the Windows file and folder system to open and close workbooks
How to use Excel and VBA to create basic dashboards
How to manage Excel models, their information, their formulas using Excel VBA
How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint
Basic overview of database control using VBA and tools called DAO and ADO

Signup, Pricing and Self-Study

The Public and Webinar buttons below will lead you to our training schedule page listing all possible dates, prices and signups for those training categories. If you are unsure what a webinar is click here. The Self-Study button will lead you to our manual page where you can get the manual pricing and the manual outline. The manual comes with the class.