# Engineering Calculations

## Excel Tips: Quick Fixes for Data Messes

Data Cleanup with Power Query One of the first things you need to do when handling complex engineering problems in Excel is to ensure your […]

## Calculate Slope in Excel

It’s easy to calculate a slope in Excel using the SLOPE function, but it’s also possible to use chart trendlines and simple arithmetic as well.

## Engineering Notation in Excel

In this post, you’ll learn how to display numbers in Excel using engineering notation, how engineering notation differs from scientific notation, and how custom formats

## Unit Aware Calculations in Excel

Every engineer knows that for the results of engineering calculations to be correct, the units of the input values must be correct. In the case

## Using Excel Form Controls to Control Spreadsheet Inputs

Excel provides another way to ensure input values meet certain criteria other than data validation: form controls like combo boxes, list boxes, and radio buttons.

## Using Excel Data Validation to Avoid Errors

Excel’s data validation tool allows you to constrain a cell’s inputs to meet certain criteria. This can help prevent errors from occurring. In the example

## Solving Non-Linear Equations in Excel with Goal Seek

In addition to solving nonlinear equations like the Colebrook equation graphically, you can also solve them numerically using a feature called Goal Seek. Our worksheet

## Solving a System of Simultaneous Linear Equations in Excel

Systems of linear equations can be solved in Excel using formulas that perform matrix calculations. This worksheet is set up to find three unknowns in

Scroll to Top
Complete... 50%