Excel VBA Fundamentals
for Engineers and Scientists Training

Excel VBA Fundamentals for Engineers and Scientists Training

Since 1998

Next Date: Click Dates|Signup

View All Dates | Signup

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 will show you how to shorten your repetitive, multi-step, time consuming Excel tasks from hours to seconds at the click of a button.

Questions? 1.805.498.7162   Customers >

We cover Excel for Mac.

Learn More >

 Excel for Mac Training

US Military, DOD Discounts

Learn More >

EMAGENIT US Military Discounts
Excel Worksheet Layout
> > > >
< 1 > Delete

Key topics covered in our Excel VBA fundamentals for engineers and scientists.

What is VBA and How is It Used in Excel
A Complete Review of the Excel VBA Editor and Its Features
A Complete Review of VBA Including Procedures, Loops, Logic, Variables, Functions, Properties, Methods and Objects
How to Control Arrays, Key Excel Elements and Cell Formats in VBA
How to Control Workbooks, Worksheets and Track Ranges in VBA
How to Use VBA to Manage and Transfer Worksheet Data
How to Use VBA For...Next Loops, Logic and Calculations to Process Data on Worksheets
How to Manage Model and Analysis Projects Using VBA
How to Use VBA For Each...Next Loops to Find Excel Elements Like Workbooks and Worksheets
How to Use Excel VBA to Create and Control Business Charts
How to Run Your VBA Procedures from Excel

*Click to view. Scroll >>>>

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.

More Excel Training Options

Microsoft Excel for
Engineers / Scientists

Syllabus / Signup >
Microsoft Excel for Engineers / Scientists
Next Date:
See Schedule

Microsoft Excel Data Analysis for
Engineers / Scientists

Syllabus >
Microsoft Excel Data Analysis for Engineers / Scientists
Available Onsite Only

Intermediate Excel VBA for
Engineers / Scientists

Syllabus >
Intermediate Excel VBA for Engineers / Scientists
Available Onsite Only

Advanced Excel VBA Methods for
Engineers / Scientists

Syllabus / Signup >
Advanced Excel VBA Methods for Engineers / Scientists
Next Date:
See Schedule

Microsoft Excel-Aided
Engineering and Science

Syllabus >
Microsoft Excel-Aided Engineering and Science
Available Onsite Only

Calling Fortran DLLs from Excel VBA for Engineers / Scientists

Syllabus >
Calling Fortran DLLs from Excel VBA for Engineers / Scientists
Next Date:
See Schedule

Microsoft Excel Dashboards for
Combined Audience

Syllabus / Signup >
Microsoft Excel Dashboard Training
Next Date:
See Schedule

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