Microsoft Excel VBA Data Analysis for Engineers and Scientists Workshop Outline

Our Data Analysis workshop covers how to turn Microsoft Excel using VBA into a data processing system that saves you enormous amounts of time and money. From reconciling data in multiple workbooks and on multiple worksheets to automated chart construction, Excel can do things other programs simply cannot. Read below and see how our 14 years of Excel training and software design can help supercharge your Excel VBA skills >>>

Call us at:   1.805.498.7162     1.805.558.9277--

• Onsite, Self-Study*, Public*, Webinar*

*Advanced VBA covers the same basic material in a less focused format. Click here for business. Click here for engineering and science.

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 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 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 multiple data streams

• 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 database

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

Note: Our Beginning Excel VBA workshop covers most of the information presented in this workshop. The signup for Beginning VBA is below.

In this 2-day "hands-on" workshop 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 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

• Engineering and science professionals with good Excel skills and beginning VBA programming experience.

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.