# Excel

## MMULT Excel Function for Matrix Multiplication

Since a worksheet is essentially a gigantic matrix, it’s no surprise that matrix multiplication in Excel is super easy – we just need to use […]

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

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

## Numerical Integration in Excel

There are two primary ways to perform numerical integration in Excel: 1. Integration in Excel via the Spreadsheet This type of numerical integration is largely

## Linear Interpolation in Excel

To perform linear interpolation in Excel,  use the FORECAST function to interpolate between two pairs of x- and y-values directly. In the example below, the

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

## Engineering Notation in Excel

In this post, you’ll learn how to display numbers in Excel using engineering notation, how engineering notation differs from scientific notation, and how custom formats

## Catenary Cable Tension Calculator in Excel

In this post, you’ll learn how to create a catenary cable tension calculator in Excel by solving an implicit equation. The example will show specifically

Scroll to Top
Complete... 50%