Tips for Using the CONVERT Function in Excel
One of the tips in my eBook that gets a lot of response is to use the CONVERT function to convert units in Excel. It’s …
Excel
Calculate a Derivative in Excel
A few weeks ago, I wrote about calculating the integral of data in Excel. This week, I want to reverse direction and show how to …
Complex Numbers in Excel
In some branches of engineering, it’s inevitable that you’re going to end up working with complex numbers. Fortunately, though, you don’t have to run to …
How to Enable the Excel Solver Add-In
Excel has a really powerful tool that allows you to conduct optimization, solve systems of simultaneous equations, and perform complex multi-variable regression or non-linear regression. …
Linear Regression in Excel: 4 Alternative Methods
With many things we try to do in Excel, there are usually multiple paths to the same outcome. Some paths are better than others depending …
Linear Regression in Excel: 4 Alternative Methods Read More »
Mass Moment of Inertia Calculator in Excel, Pt. 3
Today’s post is the final installment in the creation of a mass moment of inertia calculator in Excel. In the first post I showed how …
Mass Moment of Inertia Calculator in Excel, Pt. 3 Read More »
Mass Moment of Inertia Calculator in Excel, Pt. 2
In my last post, I started demonstrating how to use advanced Excel features to make a simple engineering application that calculates mass moment of inertia …
Mass Moment of Inertia Calculator in Excel, Pt. 2 Read More »
Mass Moment of Inertia Calculator in Excel, Pt. 1
Today’s post kicks off a multi-part series where I will create a mass moment of inertia calculator in Excel. The calculations themselves are simple. However, …
Mass Moment of Inertia Calculator in Excel, Pt. 1 Read More »
