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.
Functions
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
3 Steps to Working with Array Formulas in Excel Read More »
Adding Specific Values in Excel with SUMIF and SUMIFS
Have you ever needed to sum only specific values in a range of data, and exclude others that did not meet the necessary criteria? The
Adding Specific Values in Excel with SUMIF and SUMIFS Read More »
Arctan Excel Functions: Use ATAN and ATAN2 to Calculate Inverse Tangent
There are two functions for calculating the inverse tangent or arctan in Excel. These two functions are ATAN and ATAN2 (“atan” is short for arctangent),
Arctan Excel Functions: Use ATAN and ATAN2 to Calculate Inverse Tangent Read More »
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
Using Excel’s INDEX and MATCH Functions to Look Up Engineering Data Read More »
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
Complex Numbers in Excel Read More »
