Complex Number Functions in Excel
If you do any engineering calculations that involve complex numbers, you’ll probably appreciate the complex number functions that are built into Excel. Excel has many …
Excel
Calculating the Integral of an Equation in Excel with VBA
If the function you want to integrate is known in terms of a variable, you can perform the integration using VBA instead of the tabular …
Calculating the Integral of an Equation in Excel with VBA Read More »
Scale, Offset, or Change the Sign of Data in Excel
The Paste Special feature allows you to quickly do some basic mathematical operations on your data. When you’ve copied a cell, you can add, subtract, …
Scale, Offset, or Change the Sign of Data in Excel Read More »
How to Fit an Equation to Data in Excel
You can use Excel to fit simple or even complex equations to data with just a few steps. Determine the Form of the Equation The …
Complex Matrix Multiplication in Excel
In a recent post, I showed how you can multiply matrices in Excel. That post led to a great question from an EngineerExcel subscriber: Is …
Pi in Excel
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. …
3 Steps to Working with Array Formulas in Excel
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 …
Hyperbolic Curve Fitting in Excel
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 …
