Beginning Microsoft Excel VBA Training

Since 1998

Beginning Excel VBA Training for Engineers and Scientists

Engineers and Scientists

Click Dates|Signup
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.866.924.6244   Customers >

We cover Excel for Mac.

Learn More >

 Excel for Mac Training

US Military, DOD Discounts

Learn More >

EMAGENIT US Military Discounts

About our beginning Excel VBA training for engineers & scientists.

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.

Over 20+ years of Excel training experience.
Our Excel training covers what you need to succeed. How do we know? We use the same knowledge to design software for customers like NASA and BMW.
Microsoft Excel Essentials for Engineers and Scientists

The key skills learned in our beginning Excel VBA training for engineers & scientists.

Key Excel VBA skills learned:

Did you know you can take this training live online?
Can't make the public event, no problem, we broadcast it as a live, hands-on webinar. Use the All Dates | Signup button above to take the online webinar. Learn more >
Excel Online Webinars

The skills you need for our beginning Excel VBA training.

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

Free repeats with our Excel training.
All of our Excel training comes with Free Repeats. Our Excel classes have a lot to learn in them. Learn More >
Microsoft Excel Training Free Repeats

The topics covered in our beginning Microsoft Excel VBA training for engineers & scientists.

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

Having trouble deciding on a class?
We have a page that can help. Learn more about our classes on our Excel Classes Guide and Skills page. >
Microsoft Excel Essentials for Engineers and Scientists

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
  • 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
  • Excel Versions   2007-2016, Office 365, Windows and Mac
  • Free Repeats:   Repeat your Excel training as many times as you like, no date or limit
  • 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 manual is free in our training.

More Training Options

Public / Online / Onsite

Public Events
Schedule / Signup
Microsoft Excel Data Analysis for Engineers / Scientists Microsoft Excel Essentials Training for Engineers / Scientists Intermediate Excel VBA Training for Engineers / Scientists Advanced Excel VBA Training for Engineers / Scientists Microsoft Excel Dashboards Training for Combined Audience Microsoft Excel-Aided Engineering and Science Interfacing FORTRAN with Excel VBA for Engineers / Scientists
Upcoming 2018 Excel Public Events Schedule
Microsoft Excel Data Analysis for Engineers / Scientists
Available Onsite Only
Microsoft Excel Essentials Training for Engineers / Scientists
Next Date:
See Schedule
Intermediate Excel VBA Training for Engineers / Scientists
Available Onsite Only
Advanced Excel VBA Training for Engineers / Scientists
Next Date:
See Schedule
Microsoft Excel Dashboard Training
Next Date:
See Schedule
Microsoft Excel-Aided Engineering and Science
Available Onsite Only
Interfacing FORTRAN with Excel VBA for Engineers / Scientists
Available Onsite Only

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

Excel Software Design/Consulting

- Microsoft Excel Software

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

Copyright © 2002-2019

EMAGENIT All Rights Reserved