Functions

Since a worksheet is essentially a gigantic matrix, it’s no surprise that matrix multiplication in Excel is super easy – we just need to use

Excel’s convert function works well to convert between simple units. However, in engineering, there’s often compounds units where simple units are either multiplied together or

Excel has several functions for rounding numbers. Function Description INT Rounds down to the nearest integer ROUND Rounds the number to a specified number of

Excel contains a variety of trigonometric functions: Basic functions Hyperbolic functions Inverse functions Miscellaneous SIN SINH ASIN PI() COS COSH ACOS RADIANS TAN TANH ATAN

There are two more advanced summing functions that we’ll discuss – SUMPRODUCT and SUMSQ. SUMPRODUCT multiplies individual components in arrays together and then returns the

This section and the next will cover the advanced summing functions available in Excel. The SUMIF and SUMIFS functions enable you to sum values in

Excel features many of the common mathematical functions that you’ll encounter in engineering: logarithms, exponentials, square roots and factorials. This section covers three example problems

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