Call us at:   1.805.498.7162     1.805.558.9277

Microsoft Excel training options for business, engineering and science Innovative Microsoft Excel software design View our customer list from our over 14 years in business Phone numbers, email address and contact form Learn about EMAGENIT Home page containing upcoming Microsoft Excel classes and other EMAGENIT services Self-study Microsoft Excel manuals for business, engineering and science Microsoft Excel consulting services Microsoft Excel training schedule and prices

Home > Microsoft Excel Workshops > Beginning Microsoft Excel VBA Training for Business Professionals

Beginning Microsoft Excel VBA Training

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.

Goto to the workshop signup, view different signup options
Free Workshop Repeats

Microsoft Excel Workshops -  Free RepeatsAll 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

Why Not Go Online For Your TrainingOur 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

  • Time Saving Excel VBA Skills You LearnWhat 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.

For our public workshops, you travel to us in Thousand Oaks, CA

Our webinar (webcast) is broadcast live, is voice interactive, hands-on training

Beginning Microsoft Excel VBA Self Study for Business, Note: manual supplied with workshop

 

Hotel and Directions Training Location

 

Learn about our onsite workshops Learn about our live Microsoft Excel training webcasts Close Training Areas

 

Typical Workshop Examples

Complete VBA Review

Programming Strategy Review; Complete VBA Review

 

How to Control Ranges and Cells Including Formatting

How to Control Ranges and Cells Including Formatting, Naming, Locating Information, Finding Data Boundaries and Using Worksheet Functions in VBA

 

How to Control Workbooks and Worksheets

How to Control Workbooks and Worksheets Using VBA Including Adding, Opening, Deleting and Closing

 

How to Process Data on Worksheets

How to Process Data on Single Worksheets, Multiple Worksheets and in Multiple Workbooks

 

Basic Dashboard Design Using VBA

Basic Dashboard Design Using VBA, Worksheets, Shapes, Charts and Cell Colors

 

How to Use Excel VBA to Download Data

How to Use Excel VBA to Download Data from the Web and Databases

 

How to Use VBA to Command Microsoft PowerPoint and Word

How to Use VBA to Command Microsoft PowerPoint and Word

 

 

 

Site Map 

Copyright © 2002-2013 EMAGENIT All Rights Reserved