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 useful for engineers performing design calculations in Excel too. The tools are contained within the "What-If Analysis" menu and are: … [Read more...]

###### GET FREE UPDATES OF NEW POSTS HERE

## 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. In this example, we'll try to find the root of the Colebrook equation. This equation is used to find the Darcy Weisbach friction factor for flow in a pipe without having to look it up on a … [Read more...]

###### GET FREE UPDATES OF NEW POSTS HERE

## 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 the force in the components of a structure made of a steel bar encased in concrete. There is a uniform load applied across … [Read more...]

###### GET FREE UPDATES OF NEW POSTS HERE

## 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 2016? If you're a user of Office 2010 Professional Plus or Office 2013, you can install a free Add In from Microsoft to gain this capability. Power Query Add … [Read more...]

###### GET FREE UPDATES OF NEW POSTS HERE

## 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 z-values, where x and y are independent variables and z is dependent on both? In that case, you can use bilinear interpolation in Excel. It works similarly to linear … [Read more...]