# Microsoft Excel for Engineers and Scientists Training ## Engineers and scientists learn to harness the power of Microsoft Excel and apply it to technical tasks.

Our hands-on Microsoft Excel engineering science training shows how to:

• Use Excel to create powerful model / analysis tools using formulas and functions.
• Use logic and perform table lookups using formulas and functions.
• Build interfaces (UI's) and adaptive technical displays.
• Perform numerical analysis and use Solver for design optimization.
• Build technical charts and format them.
• Create custom worksheet functions to solve tough calculations.   Virtual Live: \$150.00

In Person: \$190.00

## Detailed training syllabus.

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

## Model / Analysis Problem Worksheet Layout for Engineers and Scientists

• How to organize and layout engineering / science input and output ranges on the worksheet
• Using the various types of cell references in your engineering / science formulas effectively
• Formula construction and debugging methods for engineers and scientists
• Evaluating equations over 1-d and 2-d ranges
• How to use and manage cell and range names in your formulas to track model information and data
• How to organize, manage and transmit large amounts of information between worksheets and workbooks for large engineering / science models and problems
• What is a worksheet function, what is an argument list, and what is nesting?

## Worksheet Table Design, Lookups, and Filtering for Engineers and Scientists

• Worksheet table design fundamentals for engineers and scientists
• How engineers and scientists can use Excel tables and structured reference to build adaptive formulas
• Using VLOOKUP and HLOOKUP to perform basic table lookups
• Using MATCH and INDEX to perform complex table lookups
• Performing interpolation on a worksheet table
• Using the INDIRECT function to toggle between worksheet tables
• Sorting and filtering fundamentals for engineering and science tables

## Key Excel Worksheet Functions for Engineering and Science Problems

• How to use basic functions like SUM, COUNTA, AVERAGE, MAX, MIN, SUBTOTAL... in your engineering / science formulas
• Using functions like SUMIFS, MAXIFS, MINIFS, AVERAGEIFS, and COUNTIFS to analyze data
• How to use trig functions and math functions like RADIANS, COS, SIN, ATAN, ATAN2, ROUND, TAN, SQRT, LN, LOG... in your formulas
• Using the IMAGINARY, COMPLEX... complex number functions in your formulas
• How to use statistical functions like STDEV.S, SKEW, FREQ, RANK... in your engineering / science formulas
• Using functions like MINVERSE, MMULT, TRANSPOSE... in your formulas

## Creating Logic Formulas for Your Engineering and Science Model / Analysis Problems

• Logic review for engineers and scientists including how to figure out logic triggers in problems
• How to use the relational operators: <, >, <=, >=, < >, = to build basic logic formulas
• Review of the IF, AND, OR logical functions for engineers and scientists and how they are used to build logic in formulas
• Using the IF function to toggle different engineering and science formulas in a cell
• Using the IF and IS functions to provide error protection in your engineering / science formulas
• Creating formulas that appear and disappear when needed using the IF and IS functions
• Creating IF...ELSE IF logic in formulas using nested IF's or the IFS function
• Building formulas that calculate between a start and stop point using the IF, AND, OR functions

## User Interface (UI) Fundamentals for Engineering and Science

• Overview of how engineers and scientists can use Data Validation to construct robust user interfaces
• Controlling numbers, text, dates, and lists in cells using Data Validation
• Creating dynamic logic constraints for Data Validation
• What is the difference between using ActiveX and Form controls, why use them on a worksheet to control data entry?
• Creating and integrating ActiveX controls in your worksheet interfaces
• Using Conditional Formatting in engineering and science model / analysis problems to color cells based on logic
• Using the different Conditional Formatting rules in your interface construction
• Designing Conditional Formatting that uses adaptive logic formulas
• Building dynamic engineering and science diagrams using shapes, linked pictures, and Conditional Formatting

## Performing Integration and Differentiation in Excel for Engineers and Scientists

• How engineers and scientists can perform numerical integration in Excel using the Trapezoid, Simpson's 1/3, and Simpsons 3/8 rule
• How engineers and scientists can perform differentiation in Excel using the Forward Difference, Central Difference and Backward Difference expressions

## Solving Linear and Non-Linear Equations in Excel for Engineers and Scientists

• Performing Newton's method on the worksheet to solve a non-linear engineering / science equation
• Using Goal Seek to solve a non-linear engineering / science equation on the worksheet
• Performing the Gauss Seidel method on the worksheet to solve a system of linear engineering / science equations
• Performing the Inverse Matrix method on the worksheet to solve a system of linear engineering / science equations

## Using Solver and Performing Simulations in Excel for Engineers and Scientists

• How engineers and scientists can perform the 4th Order Runge Kutta method on the worksheet to solve ODE's
• How to perform the boundary value Equilibrium method on the worksheet
• Using Goal Seek to solve a Shooting method boundary value engineering / science problem
• What is Solver and how can it be used in engineering and science to perform design optimization?
• Design optimization problem formulation on the worksheet for engineers and scientists
• How to load and run Solver on the worksheet
• Design strategies for running Solver on multiple worksheets and in multiple workbooks

## Building and Formatting Engineering / Science Charts

• Organizing tables that an Excel chart can read
• Embedding charts on a worksheet vs. creating chart sheets
• XY Scatter, Log, Column, Line and Pie chart design for engineers and scientists
• Creating limit lines and a secondary axis on your chart
• Chart formatting strategies including overall look and color, data labels...
• Combining two or more chart types in one chart (combo charts)
• How to link a chart to a user interface

## How to Use VBA UDF's to Solve Advanced Engineering / Science Calculations and Logic

• What is a VBA function and how can they be employed in solving advanced engineering and science calculations?
• How to create a VBA function using variables, loops, logic, and other functions
• How to run a function procedure from a worksheet formula as a UDF
• Overview of creating numerical method techniques as functions  ## Free Repeats ## US Military Discounts ## Excel skills needed for the training.

Select this Excel training if you or your group have:

• Used Excel's Ribbon interface, dialog boxes, and shortcut menus
• Opened and saved a workbook file
• Typed in a worksheet cell before
• Copied and pasted data in Excel
• Created a simple worksheet formula like =A1+A2

## The training details.

• Audience:   Engineers, scientists and technicians
• Duration:   9:00 - 5:00 CT
• # of Days:   1-day
• Instruction Type:   Hands-on, live, instructor taught training
• Full Excel Manual Included:   Our 2200 + page EAE manual full of Excel tips, how-to-do topics and Excel examples included with the training. Details >
• Excel Versions:   2010-2019, Microsoft 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:

Phone Number: 1.805.498.7162

Business Hours: 8:30 - 5:00 PM PT

email: question@emagenit.com  