Excel

Intro to Excel VBA User Defined Functions

I’ve received several requests lately to discuss Excel Macros and VBA (Visual Basic for Applications), which is the programming language built into Excel and other […]

Using Excel’s INDEX and MATCH Functions to Look Up Engineering Data

In the past, I’ve written about using the VLOOKUP function to pull data from tables into engineering calculations. However, you will probably find (if you

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

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

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

Scroll to Top
Complete... 50%