Beginning Microsoft Excel VBA Training for Business Professionals Workshop Outline

Our "workhorse" Microsoft Excel VBA workshop for business that shows you the basics of using VBA to command Excel, process and reconcile data, create charts, build dashboards, command Word and PowerPoint and more. Read below and see how our 12+ years of Excel training can help supercharge your Excel skills >>>

Call us at:   1.805.498.7162     1.805.558.9277--

Newsletter	Contact Us	Training Help

Microsoft Visual Basic for Applications (VBA, macros) can be used in conjunction with Microsoft Excel to construct automated business tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using Microsoft Visual Basic with Excel, powerful business analysis tools can be developed quickly and with minimum cost. VBA can be used for business tasks like report generation, creating dashboards, communicating with business databases, analyzing business data, reconciling data, automating worksheet construction, business model calculations, creating charts, the list is endless. This workshop covers the fundamentals of using VBA programming and as well as how to apply it in real world situations.

• What is VBA?

• How to use the Visual Basic (VBA) Editor and its debugging tools

• Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)

• How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint

• How to use Microsoft Excel VBA to analyze data on single and multi worksheets

• How to use Excel VBA to perform calculations on data

• How to create summary sheets using VBA

• How to create basic dashboards in Microsoft Excel using VBA

• How to create and format single and multiple charts using VBA

• Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel 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

• How to download data from the web using VBA

• How to automate the data analysis tool pack add-in using VBA

• 2-day workshop

• Personal examples: Covered in-class

• Excel Versions: 2000-2007

• Type: Business Professionals

• Platform: Windows

• Training Materials: Included, 1600+ page manual including our Excel Add-Ins

• Training Method: Hands-on

In this beginning Excel VBA  2-day "hands-on" business workshop or self-study manual, you will learn:

Day 1

• Overview of how Microsoft Visual Basic (VBA) and Excel are used in business problems

• VBA Editor review including using the VBA debugger and the purposes of VBA projects, modules and procedures

• Excel macro language review (VBA) including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling

• Overview of commanding Excel using VBA including a discussion of objects, properties and methods

• How to analyze business data on single Excel worksheets using loops and logic.

• How to create charts using VBA

Day 2

• How to analyze data on multi worksheets and build summary sheets

• How to access the Windows file and folder system to open and close workbooks being processed

• How to protect your code against errors

• How to use Excel and VBA to create basic dash boards

• How to create your own custom business worksheet functions in VBA

• How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint

• How to use the Excel Visual Basic macro recorder to record Excel tasks in VBA and then interpret the code

• How to download data (stock market report, historical tables...etc) from web pages automatically

• How to automate the data analysis tool pack add-in like regression analysis using VBA

• Business professionals with a solid understanding of how Microsoft Excel works.

   

• East and West coast dates, times and prices on Signup page. Use the Signup buttons above to view.

• For a complete outline, consult the Workshop Outline section below. Read about EMAGENIT and our Customers.

• Our webcast workshops are taught live with voice, hands-on and broadcast directly to your computer from our facility (details). We can reach anywhere that has internet broadband.

Public Location: Thousand Oaks, CA

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, CA which is in the vicinity of Los Angeles county (LA County), Ventura county, Santa Barbara county and San Diego county. We hold all of our courses on-site nation wide. We also webcast (webinar) our public workshops, consult our webcast page for more information.

Our public workshops are a short commute for those living in:

For more information about our public workshops, visit our public workshops page our call us at 805.498.7162.

Submit a question to us via email at begvba@emagenit.com

Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at 1.805.498.7162 or 805.558.9277 for more information about this workshop.

EMAGENIT NASA Award for Excel

EMAGENIT received an award for its involvement with NASA JPL in helping redesign and integrate their conceptual Rover mission software in Microsoft Excel. Click the picture above for more detail about our Rover involvement. To learn more about the NASA mission to mars click here.

Awards & Customers

Typical Workshop Examples

Basic Programming Skills Using VBA and Excel

Data Processing in Excel Using VBA (Different Worksheet or Workbook Output)

Automated Chart Construction Using VBA

How to Create Summary Workbooks Analyzing Multi- Worksheets and Workbooks

Basic Dashboard Design Using VBA, Worksheets, Shapes, Cell Colors...etc

Basic VBA Techniques for Downloading Data from the Web and Databases

How to Command Microsoft PowerPoint and Microsoft Word Using VBA