## 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 […]

## 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

## 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

## Sensitivity Analysis Excel Calculation with Data Tables

All too often in engineering we tend to assume that the variables that affect our designs are (*fancy word alert*) “deterministic“. In other words, we

## 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

## Finding the Root of an Equation Graphically in Excel

There are several ways to find the roots of equations in Excel. The most basic way is to do so graphically, using a scatter chart.

## Two Quick Ways to Troubleshoot Broken Excel Formulas

Excel has built-in tools that are very useful for troubleshooting formulas, even if the formulas are complex. The example spreadsheet shown throughout this post calculates

Scroll to Top
Complete... 50%