Microsoft Excel for Engineers / Scientists Class

Class overview.

What makes our training different?

Live, hands-on, industry topics
Bring your problems, ask tough questions
Taught by an engineer
Limited class size

Our 1-day class shows you the essential Excel skills needed to assemble a wide variety of problem solving tools that can be rapidly scaled and upgraded.

From laying out problems and passing data between worksheets; to building calculations using formulas, functions, lookups, and logic; to building adaptive interfaces, displays, and charts; to building your own custom worksheet functions using LAMBDA or VBA; our class covers a wide range of must know Excel topics.

Join us and our class will show you the design strategies, assembly methods, and Excel features that you can use to quickly solve a variety of engineering and science problems.

Some key topics we cover in class.

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

Prerequisites for our Excel training.

Used Excel's Ribbon interface, dialog boxes, and shortcut menus
Opened and saved a workbook file
Entered data in a worksheet cell before
Copied and pasted data in Excel
Created worksheet formulas like =A1+(A2*A3)

Class time, duration, manual, and repeats.

Audience: Engineers, scientists and technicians
Duration: 9:00 - 5:00 CT
# of Days: 1-day
Instruction Type: Live, hands-on, taught by engineer
Class Manual: Our complete Excel manual for engineering and science (EAE). Details >
Excel Versions: 2010-2019, Microsoft 365, Windows and Mac
Repeats: Repeat your Excel training. Details >

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.

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

How to organize and format problem input and output ranges on the worksheet
Using various relative, mixed, and absolute cell references effectively in formulas
Formula design and debugging methods for engineering and science problems
Using names and arrays to organize and transmit data between worksheets and workbooks
Creating and filling formulas over 1-d and 2-d table problems
How to use string concatenation to merge text and build logic in your formulas that adapt to changing parameters
Numerical methods you can quickly build and solve using cell references, names, and the iteration feature of Excel
Using Goal Seek to solve non-linear equations on the worksheet

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

Designing worksheet and Excel tables for easy lookups and data storage
How to create an Excel table and control its formats, filters, rows, columns...
Using Excel table structured references to build worksheet functions that adapt to changing table structure
Using Excel's Sort, Filter, Copy, and PasteSpecial features to rapidly organize table data
Using an Excel table's quick analysis tools and Slicers to quickly calculate and filter table data

Using Key Excel Worksheet Functions in Engineering and Science Problems

How to create and use basic functions like SUM, COUNTA, AVERAGE, MAX, MIN, SUBTOTAL... in your formulas
How to nest worksheet functions in your formulas to perform complex engineering / science calculations
Using functions like SUMIFS, COUNTIFS, MAXIFS... in your formulas to analyze data based on logic
Performing trig and math operations in your formulas using functions like RADIANS, COS, ATAN2, ROUND, SQRT, LN, LOG...
Using the IMAGINARY, COMPLEX... complex number functions in your formulas
How to use statistical functions like STDEV.S, SKEW, FREQUNECY, RANK... in your engineering / science formulas
How to perform array operations on the worksheet using the MINVERSE, MMULT, TRANSPOSE... functions

How to Build Worksheet UIs and Dynamic Displays for Your Problems

Using Data Validation to create cell drop down lists and control number, date, and text entry in your worksheet UIs
How to create self-adjusting cell drop down lists using dynamic names and names piggy backed on Excel tables
Creating and integrating ActiveX and Form controls in worksheet UIs
Using Conditional Formatting to flag (i.e., format) cells in your problems based on logic triggers
Dynamically displaying cell values in shapes and creating linked pictures that update in your UIs

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

Using VLOOKUP, XLOOKUP, and HLOOKUP to perform basic engineering and science table lookups
Using XMATCH, MATCH, and INDEX to perform complex table lookups as well as return entire rows and columns
Using key functions to perform interpolation on a worksheet table
Using the INDIRECT function and string concatenation to toggle worksheet tables in formulas

Creating Logic to Control Your Worksheet Calculations

Logic review for engineers and scientists including how to figure out logic triggers in problems
How to use the relational operators: <, >, <=, >=, < >, = and IF, AND, OR, NOT... to build logic formulas
Using simple logic to activate and deactivate a worksheet formula
Using the IF and IS functions to determine if cells are blank, contain numbers, contain text, have errors...
Creating formulas that appear and disappear when needed using the IF and IS functions
Creating IF...ELSEIF logic in formulas using nested IF's or the IFS function
Using the IF functions to toggle between different engineering and science formulas in a cell

Building and Formatting Engineering / Science Charts

How to create XY Scatter, Log, Column, Line, Pie... charts on a worksheet or chart sheet
Formatting chart data series, data labels, gridlines, axis limits...
Linking chart data labels and titles to cell output
Creating limit lines and a secondary axis for your charts
How to display multiple tables in a chart, great for trade studies, differing x axis increments...
How to combine two or more chart types in one chart (i.e., combo chart)

How to Create Custom Worksheet Functions Using LAMBDA and VBA

How to use a LAMBDA Function to create your own worksheet function
What are parameters and how to use them
How to add a LAMBDA function to Name Manager
How to create a custom VBA Worksheet Function (UDF)
How to design logic and run Excel Functions in your custom VBA function
How to debug your custom worksheet functions

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 info@emagenit.com >

Microsoft Excel for Engineers and Scientists

Use Microsoft Excel's hidden capabilities to rapidly assemble engineering and science tools.