Since a worksheet is essentially a gigantic matrix, it's no surprise that matrix multiplication in Excel is super easy. Matrix Multiplication in Excel with the MMULT function You can multiply matrices in Excel thanks to the MMULT function. This array function returns the product of two matrices … Read more about Matrix Multiplication in Excel

## 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. (Ok, I just made that up, but it seems about right.) Not surprisingly, then, it ends up in a ton of Excel calculations. Below, I've put together a … Read more about Pi in Excel

## 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 that can be treated as one entity. There are two types of arrays: one-dimensional (values in rows OR columns) or two-dimensional (values in rows … Read more about 3 Steps to Working with Array Formulas in Excel

## Colored Vector Plot in Excel

In the last blog post, I showed how to use VBA to create a vector plot in Excel. That plot was just a simple black and white vector plot. So in this post I'll show you how to take that chart to the next level with a color scale to indicate the magnitude of the vectors, like the one below: The … Read more about Colored Vector Plot in Excel

## Create a Vector Plot in Excel

For some time now, I've been interested in figuring out how to create a vector plot in Excel. I didn't really have a need for it personally, but I thought it would be an interesting challenge and might be helpful to someone else. Here's what I came up with, created completely in Excel: Creating … Read more about Create a Vector Plot in Excel

## 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 for hyperbolic curve fitting in Excel. There's no built-in tool for curve-fitting these functions in Excel, but we can get it done with a little bit of math … Read more about Hyperbolic Curve Fitting in Excel

## Design Sensitivity Analysis in Excel 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 assume that they are repeatable and we can know exactly what they will be beforehand. However, the fact is that all variables that affect the … Read more about Design Sensitivity Analysis in Excel with Data Tables

## Numerical 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 glance it may seem like a simple tool, but applying it properly can allow you to do some powerful things in Excel. You can find the Goal Seek tool in the What-If … Read more about Numerical Iteration in Excel with Goal Seek