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 12+ years of Excel training can help supercharge your Excel skills >>>

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

Newsletter Contact Us Training Help

The Benefits of Using Microsoft Excel VBA Data Analysis 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.

What You Learn at a Glance

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

 

Workshop and Self-Study Manual Content

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

Intended Audience

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

Training Options, Signup and Self-Study

   

  • Our Beginning Excel VBA workshop also covers the information presented in this workshop. East and West coast date, 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.

EMAGENIT's Training Location

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:

  • Los Angeles, CA

  • Palmdale, CA

  • Westwood, CA

  • Santa Barbara, CA

  • San Fernando Valley, CA

  • Santa Clarita, CA

  • Newbury Park, CA

  • Westlake Village, CA

  • Camarillo, CA

  • Calabasas, CA

  • Sherman Oaks, CA

  • Reseda, CA

  • Woodland Hills, CA

  • Hollywood, CA

  • Fillmore, CA

  • Ventura, CA

  • Moorpark, CA

  • Simi Valley, CA

  • Santa Monica, CA

  • Oxnard, CA

  • Pasadena, CA

  • Agoura, CA

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

Information Request

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.

First Name:
Last Name:
Company:
Zip Code:
Country:
Work Number:
Ext:
e-mail
Information type:
Send me on-site information and pricing
Send your latest public workshop schedule and pricing
Contact me directly via the phone number provided
Keep me informed about EMAGENIT workshops and products
Privacy Policy
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
 



Additional Pages

Microsoft Excel Classes  Microsoft Excel VBA Courses  Microsoft Excel Training  Microsoft Excel Macros  Microsoft Excel VBA Consulting  Microsoft Excel Add-Ins

Copyright © 2002-2010 EMAGENIT All Rights Reserved