Formulas

OFFSET Function in Excel

The OFFSET function in Excel is a powerful tool that allows you to return a reference to a range that is offset from a starting […]

Weighted Standard Deviation in Excel

In this post, you’ll learn how to calculate a weighted standard deviation in Excel. A weighted standard deviation calculates the spread in a data set

Using Cell Names in Excel

As previously mentioned, one of the biggest complaints that engineers have against Excel is that it’s difficult to understand formulas in a spreadsheet. Formulas refer

Troubleshooting Engineering Formulas in Excel

Excel has built-in tools that are very useful for troubleshooting formulas, even if the formulas are complex. The example worksheet will calculate the force in

Solving Systems of Simultaneous Nonlinear Equations in Excel

Unlike simultaneous linear equations, simultaneous non-linear equations cannot be solved using linear algebra. However, we can extend the concept of using Goal Seek from solving

Managing and Adding Named Cells in an Excel Worksheet

If you ever want to modify a named range because you’ve made a mistake or you want to assign a different cell to the variable,

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

Iteration in Excel with Goal Seek

Excel provides us with a quick and easy way to perform simple numerical iteration in Excel. The tool is called Goal Seek, and it first

Scroll to Top
Complete... 50%