Microsoft Excel for Engineers and Scientists - Class

Learn to combine Excel's formulas, functions, charting, LAMBDA, and GUI abilities to build powerful problem-solving tools.

Next Class: Check Dates

Microsoft Excel for Engineers and Scientists Training

How our class will boost your Excel skills.

Boost Microsoft Excel Training

Our 1-day class shows you the fundamental Excel skills needed to assemble a wide variety of problem-solving tools. Our class covers the Excel essentials like how to develop technical formulas; use names; create logic; build data tables; design technical charts; and use key functions.

It also discusses how to layout problems, link data, perform lookups, analyze data sets, and build numerical methods on the worksheet. We also cover how to design GUIs for your problems; create adaptive illustrations; and build custom functions for tough calculations using LAMBDA and VBA.

Read our detailed outline > below and see what you'll discover in our class.

Take a video tour of what you'll learn.

Video Play
  • Complete formula, debugging, cell reference, and cell naming review
  • How to layout your problem on the worksheet and build input / output ranges
  • Designing formulas for use in engineering and science problems; 1-d and 2-d table problems
  • Using cell references, names, Goal Seek, and Excel's iteration capability to quickly solve numerical analysis problems
  • How to efficiently access and calculate data from multiple worksheets and in different workbooks
  • Designing worksheet and Excel tables to store and filter data
  • How to use Data Validation to create cell drop down lists and control worksheet cell entry in your UIs
  • How to use ActiveX controls, shapes, and Conditional Formatting to build UIs and dynamic technical illustrations
  • Using key Excel worksheet functions in engineering and science problems
  • Performing lookups, interpolating, and toggling between tables using the VLOOKUP, XLOOKUP, INDIRECT... functions
  • Creating formula logic that toggles equations; detects blank cells and errors; performs IF...ELSEIF logic...
  • How to format and create charts, limit lines, secondary axis, carpet plots...
  • How to create your own custom worksheet functions using LAMBDA and VBA

Some key topics we cover in class.

Microsoft Excel Training Topics

4 ways to train.

Class syllabus.

How we run the class: We focus our training on what our customers need. When training begins, we analyze those needs and shift our training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.
Class PDF

Download Class Brochure

Key Formula Topics, Using Names, and Problem Setup on the Worksheet

How to Create Excel and Worksheet Tables to Store and Filter Data

Using Key Excel Worksheet Functions in Engineering and Science Problems

How to Build Worksheet UIs and Dynamic Displays for Your Problems

How to Lookup Table Data, Interpolate, and Toggle Tables in Formulas

Creating Logic to Control Your Worksheet Calculations

Building and Formatting Engineering / Science Charts

How to Create Custom Worksheet Functions Using LAMBDA and VBA

Additional Class Information

Prerequisites for our Excel training.

Class time, manual, and repeats.

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: Mon-Fri 8:00 AM - 7:00 PM CT

You can email us at >

Form >
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2023

EMAGENIT All Rights Reserved