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 entered in a worksheet. The syntax for the… Read more about Matrix Multiplication 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 comprehensive guide… Read more about Pi 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 AND columns). An array formula is… Read more about 3 Steps to Working with Array Formulas 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… Read more about Colored 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 the… Read more about Create a Vector Plot 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 and creativity.… Read more about Hyperbolic Curve Fitting in Excel
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 performance of a design exhibit […]
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 […]
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 workbooks or worksheets […]
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: Scenario Manager Goal Seek Data Table Scenario Manager The scenario […]
Read Full Article
Read for later
Articles marked as Favorite are saved for later viewing.
Scroll to Top
Separate tags by commas
To access this feature, please upgrade your account.