## Follow EngineerExcel Blog on Feedspot

Or

EngineerExcel Blog by Charlie Young - 5d ago

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
Visit website
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 3w ago

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
Visit website
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 1M ago

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
Visit website
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 2M ago

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
Visit website
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 3M ago

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
Visit website
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 4M ago

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
Visit website
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 6M ago

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 […]
Visit website
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 7M ago

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 […]
Visit website
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 8M ago

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 […]
Visit website
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 9M ago

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 […]
Visit website

Articles marked as Favorite are saved for later viewing.
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .