AND and OR Functions in Excel
There are additional logical functions that you can use along with the IF function to add even more logical decision-making capability. First, the AND function […]
AND and OR Functions in Excel Read More »
Absolute and Relative Cell References in Engineering Spreadsheets
Inevitably, you will often reference other cells in your calculations. There are two different types of cell references in Excel: relative and absolute. This is
Absolute and Relative Cell References in Engineering Spreadsheets Read More »
Scale, Offset, or Change the Sign of Data in Excel
The Paste Special feature allows you to quickly do some basic mathematical operations on your data. When you’ve copied a cell, you can add, subtract,
Scale, Offset, or Change the Sign of Data in Excel Read More »
How to Fit an Equation to Data in Excel
You can use Excel to fit simple or even complex equations to data with just a few steps. Determine the Form of the Equation The
How to Fit an Equation to Data in Excel Read More »
Complex Matrix Multiplication in Excel
In a recent post, I showed how you can multiply matrices in Excel. That post led to a great question from an EngineerExcel subscriber: Is
Complex Matrix Multiplication in Excel Read More »
Pi in Excel
Of all the constants in Science, Engineering, and Mathematics, pi, or the ratio between a circle’s circumference and diameter is by far the most common.
3 Steps to Working with Array Formulas in Excel
Array formulas in Excel are a great tool for performing time-series calculations or sensitivity studies on input variables. An array is a group of cells
3 Steps to Working with Array Formulas in Excel Read More »
Hyperbolic Curve Fitting in Excel
I’ve talked about the various procedures for fitting different types of curves on this blog before, but today I want to show you a technique
Hyperbolic Curve Fitting in Excel Read More »
