|
Call us at: 1.805.498.7162 1.805.558.9277 |
![]() |
![]()
|
Home > Microsoft Excel Workshops > Beginning Excel VBA Training for Engineering and Science |
|
|
Beginning Excel VBA Training Outline for Engineers and ScientistsLearn to use Excel and VBA to build technical tools that can save you and your company time, effort and expense. Our 2-day "hands-on" Excel VBA training shows engineers and scientists the basics of using Excel and VBA. Our training shows you from an engineering & science perspective how to use VBA to command Excel, process resizing data on worksheets, fill out data forms and tables, perform calculations, create charts, create custom worksheet functions, build powerful models, build basic dashboards, use VBA to control Word and PowerPoint (report generation) and much more. Our workshop is taught by an engineer and comes with an 1800+ page manual. |
![]() |
|
|
|
| About Our Workshop |
Useful Excel VBA Skills You Learn
Who Should Take This Workshop (Prerequisites)Select this workshop if you or your group have:
Microsoft Excel Versions Taught in Workshop
Included in Our Beginning Excel VBA Workshop
Workshop Training ChoicesAvailable: Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual
Beginning Microsoft Excel VBA Training FocusMicrosoft Excel and VBA (macros) can be used to construct powerful automated engineering and science tools. Visual Basic for Applications (VBA) comes standard with Microsoft Excel as well as other office products. By using Excel and VBA, engineers and scientists can develop sophisticated tools quickly with a minimum time and cost investment. VBA can be used for tasks like automating calculations, analyzing data on multiple worksheets and in multiple workbooks, automating form creation, automating chart and report generation tools, communicating with databases, constructing elaborate dashboards, modeling the list is endless. This workshop teaches you the foundation for using Excel VBA in the engineering and science disciplines.
Beginning Excel VBA Workshop OutlineIn this 2-day "hands-on" workshop you will learn: Day-1
Day-2
Signup, Pricing and Self-StudyThe Public and Webinar buttons below will lead you to our training schedule page listing all possible dates, prices and signups for those training categories. If you are unsure what a webinar is click here. The Self-Study button will lead you to our manual page where you can get the manual pricing and the manual outline. The manual comes with the class. |
Typical Workshop Examples
Programming Strategy Review; Complete VBA Review
Range and Cell Control Including Formatting, Naming Finding Data Boundaries and Using Worksheet Functions in VBA
Automated Workbook / Worksheet Creation and Formatting
Technical Form Creation and Data Fill from Raw Data
Data Processing in Excel Using VBA (Single Worksheet, Multi Worksheet, Multi Workbook and Windows Folders)
Automated Chart Construction Using VBA
How to Create Custom Worksheet Functions for Use in Data Analysis and Modeling
Basic Dashboard Design Using VBA, Worksheets, Shapes, Cell Colors...etc
Basic VBA Techniques for Downloading Data from Databases Like MS Access, Excel Workbooks and Text Files
How to Command Microsoft PowerPoint and Microsoft Word Using VBA |
Copyright © 2002-2013 EMAGENIT All Rights Reserved