## Using Scenario Manager to Track Design Iterations in Excel

If you’re anything like me, you often use Excel to experiment with different parameters or inputs to see how they might affect a design. It […]

## What-If Analysis in Excel for Engineering Calculations

Excel has a great set of little-known tools hidden within the Data tab of the ribbon. They are considered “Forecasting” tools, but they are incredibly

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

## Installing the Power Query Add In for Excel 2010/2013

Power Query is a powerful data gathering tool included in all installations of Excel 2016. But what do you do if you’re not using Excel

## Bilinear Interpolation in Excel

Linear interpolation allows us to improve an estimate based on a set of x- and y-values. What if you are working with x-, y- and

## Adding Specific Values in Excel with SUMIF and SUMIFS

Have you ever needed to sum only specific values in a range of data, and exclude others that did not meet the necessary criteria? The

## 3 Ways to Update a Scatter Chart in Excel

At some point, you’ll probably need to update a scatter chart in Excel. Perhaps you’ll need to import new data, but in some cases the

Scroll to Top
Complete... 50%