Microsoft Excel for Engineers and Scientists

How our class will boost your Excel skills.

Our 1-day class shows you the Excel skills needed to assemble a wide variety of problem-solving tools. It covers the basics like how to create formulas; use names and cell references; link data; control cell inputs; use formula logic; and lookup data. It also shows how to build tables, create technical charts, and layout problems and models.

In addition to the basics, it shows how to build technical forms; use key worksheet functions; collate and process data; and solve numerical methods. We also cover how to create illustrations that update automatically and build custom functions using LAMBDA.

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

See what you can learn.

Learn about problem / model layout; formula design; cell references and naming; and creating diagrams that auto-update.

Learn to control cell inputs with Data Validation/ActiveX and flag cell values using logic/Conditional Formatting.

Learn to debug your formulas, trace cell calculation sequence, and trace where cell inputs are used in formulas.

Learn to organize data in Excel tables, process data with Excel's data tools, and use key functions that auto filter data.

Learn to use key worksheet functions, table lookups, logic, and Excel table references to perform techincal calculations.

Learn about form construction, worksheet formatting, linking sheets and workbooks, and data consolidation.

Learn to organize chart data; format charts; and create various technical charts, combo charts, and multi-table charts.

Learn to solve numerical methods in Excel and create custom worksheet functions (LAMBDA) to replace cumbersome formulas.

Problem / model layout; formula design; cell references and naming; and linking sheets
Formatting worksheets and using shapes to create technical illustrations
Filling formulas in single and two variable tables
Using the IF, AND, OR... functions and <, >, =... to make formula decisions
Controlling user cell inputs with Data Validation and ActiveX controls
How to use Conditional Formatting to flag calculation limits
Filtering and storing data in worksheet and Excel tables
Using key Excel worksheet functions to perform basic math, trig, statistical, complex, and lookup operations
Creating and formatting technical forms on the worksheet
Methods to collect and calculate data from multiple worksheets and workbooks
How to format and create charts, limit lines, secondary axis, combined charts...
Solving numerical methods on the worksheet; how to use Goal Seek and Excel’s iteration feature
Using LAMBDA to create custom functions that replace large technical formulas

Key topics we cover in our class.

4 ways to train.

Live Virtual

View the dates and signup for our hands-on live virtual training.
Virtual Signup > Learn More >

Public In-Person

View the dates, signup, and pricing for our hands-on in-person training.
In-Person Signup > Learn More >

Manual

Can't take the class, buy the self-study manual, apply the price later.
View Manual >

Onsite

Learn how we can help your business save time and effort in Excel.
View Onsite Details >

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.

Download Class Brochure

Problem / Model Layout, Formulas, Logic, and Table Design

Laying out problems and models; and formatting the worksheet
Creating technical formulas, cell references, names and using functions
How to debug formulas and trace where inputs are used in formulas
How to efficiently pass data between sheets and workbooks
Laying out worksheet tables for use in engineering and science problems
Creating and filling formulas in single and two variable tables
How to use the <, >... operators and IF, AND, IS... functions to make formula decisions

Controlling User Inputs, Flagging Cell Values, and Using Shapes to Illustrate

Using Data Validation to control cell inputs and create cell drop down lists
How to setup and use ActiveX controls to constrain user cell inputs
Using Conditional Formatting and logic to flag cell values and problem limits
How to display cell data in pictures and shapes and update it automatically

Storing, Filtering, and Calculating Data in Excel Tables

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 data
Using Excel's Sort, Filter, Copy, and PasteSpecial features to rapidly organize table data
Creating reports and calculating data using an Excel table's quick analysis tools, slicers, and filters
Calculating data subsets and tables using the UNIQUE, FILTER, and SORT functions
Creating spill over arrays to return multiple values from a formula

Using Key Worksheet Functions to Solve Problems and Process Data

Basic math operations using the SUM, AVERAGE, MAX, SUBTOTAL... functions
Analyzing data using logic functions like SUMIF, COUNTIF...
Performing trig and math operations using the RADIANS, COS, TAN, ROUND, SQRT, LN... functions
Calculating complex numbers using the IMAGINARY, COMPLEX, IMSUB... functions
Basic statistical operations using the STDEV.P, VAR.P, FREQUNECY... functions
Performing table lookups using the VLOOKUP, HLOOKUP, and XLOOKUP functions

Creating Technical Forms and Collecting Worksheet Data

Formatting and layout methods for creating technical worksheet forms
Using ActiveX controls and Data Validation to control form inputs
Using the IF, AND, OR, IS... functions to decide which values to display in a form
Collecting form data from different workbooks using mixed cell references
Using the Consolidate tool to collate data between different worksheets
Using 3-d range references to quickly access data on multiple worksheets

Building and Formatting Engineering / Science Charts

How to create XY Scatter, Log, Column, Line, Pie... charts
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
Displaying multiple tables and data points in one chart
How to combine two or more chart types in one chart (i.e. combo chart)

Performing Numerical Analysis Methods on the Worksheet

Performing integration and differentiation using the worksheet grid
Using Goal Seek to quickly solve non-linear equations on the worksheet
How to perform array operations using the MINVERSE, MMULT, TRANSPOSE... functions
Quickly solving a system of linear equations on the worksheet
Solving ODE and boundary value problems on the worksheet

Creating Your Own Custom Worksheet Functions

Using LAMBDA to create custom functions that replace your complex technical formulas
How to translate your technical formula into a LAMBDA function
What are parameters and how to use them in a LAMBDA function
How to add a LAMBDA function to Name Manager
Using your custom worksheet function in a formula
Creating a simple custom function using Excel VBA

Additional Class Information

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, 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: 2013-Present, Microsoft Excel 365, Windows and Mac
Repeats: Repeat your Excel training. Details >

If you need to contact us about our class.

Phone Number: 1.629.325.9937

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

You can email us at info@emagenit.com >

Form >

Microsoft Excel for Engineers and Scientists Live Class