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 one of those hidden gems in Excel that I wish I had found much sooner. Given that we spend so much time working with data in mixed unit systems, this …
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 calculate a derivative in Excel. Just like with numerical integration, there are two ways to perform this calculation in Excel: Derivatives of Tabular Data in a Worksheet Derivative of a …
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 another piece of software to perform calculations with these numbers. There is built-in capability to work directly with complex numbers in Excel. How to Enable Complex Number Calculations in Excel …
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. This tool is called the Excel Solver Add In. And although it comes with every purchase of Excel it has to be enabled in your installation before you can use …
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 on the situation. The same holds true for linear regression in Excel. There are four ways you can perform this analysis (without VBA). They are: Chart Trendlines LINEST function “Old …
Linear Regression in Excel: 4 Alternative Methods Read More »
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 to insert radio buttons to allow the spreadsheet user to select between various basic shapes. Then, in the second post, I showed how to use the output from the radio …
Mass Moment of Inertia Calculator in Excel, Pt. 3 Read More »
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 of four basic shapes in Excel. I started by using radio buttons to allow a spreadsheet user to select the basic shape for which they would like to calculate moment …
Mass Moment of Inertia Calculator in Excel, Pt. 2 Read More »
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, this demonstration will illustrate how to use a few advanced Excel features to create a custom engineering “app” within Excel. If you could use a spreadsheet like this, then you …
Mass Moment of Inertia Calculator in Excel, Pt. 1 Read More »
You’ll also receive regular tips to help you master Excel for engineering.
Learn advanced engineering techniques in Excel with this limited time free video training.
Click the button below to get started today.
