Beginning Excel VBA Training
for Engineers and Scientists

Beginning Excel VBA for Engineers and Scientists

Since 1998

Next Date: Click Dates|Signup

View All Dates | Signup

Learn the essential design strategies and programming skills for creating powerful Excel VBA tools.

Our beginning Excel VBA training for engineers and scientists shows you the secrets behind developing powerful, useful, cost effective data analysis and modeling tools in Excel.

Questions? 1.805.498.7162   Customers >

The details about our beginning Microsoft Excel VBA training.

  • Audience:   Engineers, scientists and technicians
  • Duration:   8:30 AM - 4:30 PM
  • # of Days:   2-days
  • Instruction Type:   Hands-on, live, instructor taught training
  • Full EAE Manual Included:   2200 + page Microsoft Excel Aided Engineering and Science manual full of Excel tips, how-to-do topics and Excel examples included with the training. Details >
  • Excel Versions:   2007-2019, Office 365, Windows and Mac
  • Free Repeats:   Repeat your Excel training. Details >
  • Personal Examples:   We review our attendees personal examples in our training instruction
  • Available Training Formats:
Beginning / Intermediate Excel VBA Self-Study Manual
Learn More >
Beginning/Intermediate Excel VBA Self Study
Our full EAE manual is included in our training.
Excel Worksheet Layout
> > > >
< 1 > Delete

Key topics covered in our beginning Excel VBA 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 beginning excel VBA training 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 beginning Excel VBA fundamentals that engineers and scientists need to know to build useful time saving tools in Excel.

The skills you need for our beginning Excel VBA training.

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

Our beginning Excel VBA for engineers and scientists training syllabus.

About Our Outline: We focus our beginning Excel VBA training on what our customers need. When training begins, we analyze those needs and shift our beginning 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

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 Training for
Engineers / Scientists

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

Advanced Excel VBA Training for
Engineers / Scientists

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

Microsoft Excel-Aided
Engineering and Science

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

Interfacing FORTRAN with Excel VBA for Engineers / Scientists

Syllabus >
Interfacing FORTRAN with Excel VBA for Engineers / Scientists
Available Onsite Only

Microsoft Excel Dashboards for
Combined Audience

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

If you need to contact us about our beginning Excel VBA 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

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved