Excel VBA Fundamentals
for Engineers and Scientists Training

Excel VBA Fundamentals for Engineers and Scientists Training

Since 1998

Public / Live Online

Next Date: Click Dates|Signup

All Dates | Signup

*Our live, hands-on, instructor led Excel online training is running as scheduled above. Public training resumes on 5/4.

Learn the essential Excel VBA design strategies and programming skills for creating useful data, modeling and reporting tools in engineering and science.

Our Excel VBA fundamentals training for engineers and scientists will show you how to shorten your repetitive, multi-step Excel tasks from hours to seconds at the click of a button.

Questions? 1.805.498.7162   Customers >

Excel Worksheet Layout
Scroll Picture > > >
< 1 > Delete

Take a tour of our Excel VBA fundamentals for engineers and scientists.

What is VBA and How is It Used in Excel
Click to expand and take a tour of our Excel VBA fundamentals training.

Our 2-day hands-on live Excel VBA fundamentals for scientists and engineers demonstrates how to use Excel VBA to control key Excel tools and capabilities that are useful in engineering and science. Our Excel VBA training starts off with a full review of the VBA Editor, procedure types and the core VBA language. Our training then shows how to build various calculations (expressions) in VBA using different operator types, VBA functions and Excel worksheet functions. Building and using logic is also covered. After the programming basics have been reviewed, how to identify and control key Excel elements like worksheets, workbooks, ranges, cells, charts and Pivot Tables using VBA is covered throughout the training.  It also discusses how to automate key Excel tasks like formatting worksheets, copying and pasting data, adding and deleting columns and rows, sorting and filtering, grouping, removing duplicates, finding data... After Excel control is discussed, it then shows you how to use loops and logic to create powerful data analysis tools that scan worksheets and workbooks in Excel VBA. In addition to data processing, it also discusses modeling basics including worksheet layout, information transfer and custom worksheet function assembly. Last basic report generation is discussed using VBA to control Word and PowerPoint. It is the Excel VBA fundamentals that engineers and scientists need to know to build useful time saving tools in Excel.

The skills you need for our Excel VBA fundamentals training.

Select this Excel VBA training if you or your group have:

Our Excel VBA fundamentals for engineers and scientists training syllabus.

About Our Outline: We focus our Excel VBA fundamentals training on what our customers need. When training begins, we analyze those needs and shift our Excel VBA training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.

Day-1

Visual Basic Editor, Module and Procedure Review

Excel VBA Language and Programming Review for Engineers and Scientists

Creating Engineering and Science Calculations in Excel VBA (Expression and Function Overview)

Creating and Using Arrays in VBA

Workbook and Worksheet Management Using Excel VBA

  Using Excel VBA to Manage Ranges and Cells

Day-2

Analyzing Engineering / Science Worksheet Data and Arrays Using VBA For...Next loops

Scanning for Engineering / Science  Data in Workbooks and Worksheets Using VBA For...Each Next loops

Managing Worksheet Models and Creating Custom Worksheet Functions (UDF)

Using Excel VBA to Control  Key Engineering and Science Tools in Excel

Using Excel VBA to Create Charts and Pivot Tables

How to Create Simple Engineering and Science Report Tools Using Excel, VBA, PowerPoint and Word

The details about our Microsoft Excel VBA fundamentals training.

Excel VBA Fundamentals for Engineers and Scientists Self Study Manual
Learn More >
Excel VBA Fundamentals for Engineers and Scientists Self Study
Our full EAE manual is included in our training.

If you need to contact us about our Excel VBA fundamentals training.

Contact us directly through email or phone.

Contact us by form.

Click to View Form
Facebook Contact Us Newsletter
Need Help? Please call us at 1.805.498.7162

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2020

EMAGENIT All Rights Reserved