Microsoft Excel VBA Data Analysis for Business Workshop Outline

Our Data Analysis workshop covers how to turn Microsoft Excel using VBA into a data processing machine that saves you enormous amounts of time and money. From reconciling data in multiple workbooks and multiple worksheets to automated chart construction, Excel can do things other programs simply cannot. 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

Visual Basic for Applications (VBA) can be used in conjunction with Microsoft Excel to automate data analysis tasks. In particular, VBA can be used to lock in on and parse business data then automatically engage Excel's data processing tools to perform the analysis tasks you want. When the analysis is completed, VBA can then be used to automatically create reports on Excel worksheets or in other applications such as Word and PowerPoint. VBA can also be used to create your own custom data analysis tools.

This workshop focuses entirely on automating data analysis in Microsoft Excel using Excel VBA. Topics discussed include:

• Microsoft Excel data analysis tool review (autofilter, advanced filter, sort, Microsoft Query, pivot tables)

• Review of Microsoft Excel data analysis worksheet functions

• Review of key VBA language elements concentrating on data analysis 

• Review of key Microsoft Excel objects used in data analysis in Excel

• How to program key Excel data analysis tools in VBA

• How to use key Excel data analysis worksheet functions in VBA

• How to automate report construction in Microsoft Word and PowerPoint

• How to access the Windows file system to open multiple files at once

• How to process data on multiple worksheets and create summary sheets

• VBA data analysis programming techniques for data sorting, parsing and labeling

• VBA data analysis programming techniques for analyzing data by daily, weekly, monthly, quarterly and yearly groupings

• VBA programming techniques for opening and scanning text files

• How to use VBA to automate construction of Excel charts

• How to use Microsoft Query and VBA DAO to query a business database

• How to automate a Microsoft Query connection and pivot table refresh

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

Day-1

• Review of Microsoft Excel data analysis tools

• Review of Microsoft Excel data analysis worksheet functions

• How to automate Microsoft Excel data analysis tools using VBA

• How to use Microsoft Excel data analysis worksheet functions in VBA

• How to automate Excel chart construction using VBA

• How to process data on multiple worksheets and create summary sheets

• How to access the Windows file system to open multiple Excel files at once

Day-2

• VBA data analysis programming techniques for parsing, labeling, extracting and sorting business data on the worksheet

• VBA data analysis programming techniques for automating report generation in Word and PowerPoint

• How automate queries and database access using ADO and DAO

• Business professionals with beginning Excel VBA experience and a solid understanding of how Microsoft Excel works.

• Our Beginning Excel VBA workshop also covers the information presented in this workshop. 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 dataanalysis@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.