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 […]
OFFSET Function in Excel Read More »
Formulas
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
Weighted Standard Deviation in Excel Read More »
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
Using Cell Names in Excel Read More »
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
Troubleshooting Engineering Formulas in Excel Read More »
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
Solving Systems of Simultaneous Nonlinear Equations in Excel Read More »
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,
Managing and Adding Named Cells in an Excel Worksheet 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 »
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
Iteration in Excel with Goal Seek Read More »
