Advanced Microsoft Excel VBA Training for Business Professionals Workshop Outline

• Onsite, Self-Study, Public, Webinar

The capability exists within Microsoft Excel and VBA to construct complex dashboard driven analysis and data processing business tools. These business tools can go far beyond simple macros becoming actual applications. Excel has a vast array of automated features like graphics, ActiveX controls, worksheets, userforms and cell ranges that when combined together allow these dashboard driven programs to be created. When you tie other programs and computer languages to Excel through VBA like Word, PowerPoint, Access, SQL Server, Lotus Notes, C and VB .Net, Excel VBA can tap into these environments obtaining the functionality it does not have. This workshop focuses on using all of these elements to construct sophisticated data processing and analysis programs in Microsoft Excel.

• What is VBA?

• An advanced review of the Excel VBA language

• Advanced VBA data processing techniques for multi worksheets and multi workbooks

• Advanced summary worksheet construction in Excel using Excel VBA

• Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA

• How to read text files using VBA.

• Advanced VBA programming techniques for creating multiple charts from multiple data sheets

• How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics

• Advanced excel dashboard construction

• How to create and use userforms in VBA (wizards)

• How to create event driven programs using VBA

• Advanced VBA error protection techniques

• How to create custom toolbars and menus to run your VBA code

• How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA

• Advanced VBA techniques for communicating with other languages and programs

• 3-day workshop

• Personal examples: Covered in-class

• Excel Versions: 2000-2010

• Type: Business Professionals

• Platform: Windows

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

• Training Method: Hands-on

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

Day-1

• Microsoft Excel VBA language overview

• Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA

• How to read text files using VBA.

• Advanced VBA data entry, data processing and data summation techniques for multi worksheet and multi workbook problems

• Advanced techniques to reconcile data in Excel using Excel VBA

• Advanced VBA programming techniques for creating multiple charts from multiple data sheets

• How to control drawing shapes, ActiveX controls and Excel's coordinate system with VBA (Worksheet Form Construction)

• How to create VBA events for action driven applications in Microsoft Excel

Day-2

• How to develop business user interfaces on the worksheet using ActiveX controls and Excel VBA

• VBA wizard overview

• Overview of using userforms to create business wizards

• How to create userforms in VBA

• How to create controls and graphics on userforms

• How to command userforms and their ActiveX controls with VBA

• Excel VBA wizard design tips

• How to create toolbars and menus to control your VBA wizards

• How to control Excel’s toolbar and menu system with VBA

 Day-3

• How to use graphics, userforms, drawing shapes, ActiveX controls and Excel VBA to create advanced dashboards in Excel

• Advanced command of Microsoft Word and PowerPoint using Excel VBA (report generation tools)

• How to command databases using DAO, ADO and OLE DB in VBA

• Introduction to using ADO OLE DB to query workbooks and text files

• How to distribute your Excel programs

• How to control other languages like Perl and C

• Microsoft Excel VBA users with a good knowledge of Microsoft Excel and basic understanding of the VBA language.

• It is intended for all types of business professionals.

Public Location: Thousand Oaks,CA, Directions/Thousand Oaks Info

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 advancedvba@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.

Training Schedule, Enrollment, Self-Study

1

Public Signup	Webinar Signup	Self-Study
Schedule, Pricing, Enroll	Schedule, Pricing, Enroll	Self-Study Manual

• Training manual (1800+ pages) included with workshop

• Repeat the workshop as many times a you like. Click here for details

• Our webinar (webcast) is broadcast live exactly when the workshop is being taught. You can talk directly to the teacher and see the teacher's computer screen. It is hands-on instruction

• Read about EMAGENIT and our Customers

Advanced Summary Workbook Construction, Data Processing and Windows Folder/File Access Using VBA

Advanced Multi Chart Construction, Microsoft PowerPoint Control and Microsoft Word Control Using VBA

Advanced VBA Techniques for Downloading Data from the Web and Databases

Advanced Worksheet Form Construction Using ActiveX Controls, Worksheets and Shapes

Advanced Dashboard Construction Using Userforms, Shapes, Worksheets and ActiveX Controls