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...]

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

## 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 can quickly become a challenge to keep track of all those generated design iterations so that they can be recalled quickly. One way is to create separate … [Read more...]

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

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