Curve Fitting in Excel
I’ve discussed linear regression on this blog before, but quite often a straight line is not the best way to represent your data. For these […]
Curve Fitting in Excel Read More »
I’ve discussed linear regression on this blog before, but quite often a straight line is not the best way to represent your data. For these […]
Curve Fitting in Excel Read More »
Recently I wrote about linear interpolation in Excel and showed how to do this in a worksheet. In this post, I’ll show you how to
Linear Interpolation VBA Function in Excel Read More »
Now that we have User Defined Functions under our belts, let’s take a look at Excel VBA subroutines. What’s an Excel Subroutine? Basically, Excel VBA
Intro to Excel VBA Subroutines Read More »
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
Intro to Excel VBA User Defined Functions Read More »
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
Using Excel’s INDEX and MATCH Functions to Look Up Engineering Data Read More »
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
Tips for Using the CONVERT Function in Excel Read More »
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 Read More »
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
Complex Numbers in Excel Read More »