Unit Aware Calculations in Excel
Every engineer knows that for the results of engineering calculations to be correct, the units of the input values must be correct. In the case […]
Unit Aware Calculations in Excel Read More »
Every engineer knows that for the results of engineering calculations to be correct, the units of the input values must be correct. In the case […]
Unit Aware Calculations in Excel Read More »
Excel provides another way to ensure input values meet certain criteria other than data validation: form controls like combo boxes, list boxes, and radio buttons.
Using Excel Form Controls to Control Spreadsheet Inputs Read More »
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
Trigonometric Functions in Excel Read More »
If you’ve used solver before, you’ve noticed that every time you close out the Solver dialog and reopen, your settings are preserved. This is handy
Save and Load Excel Solver Models Read More »
A Gaussian function has many different purposes in engineering although most people probably recognize it as a “bell curve”. Most commonly, it can be used
Gaussian Fit in Excel Read More »
Unlike simultaneous linear equations, simultaneous non-linear equations cannot be solved using linear algebra. However, we can extend the concept of using Goal Seek from solving
Solving Systems of Simultaneous Nonlinear Equations in Excel Read More »
In engineering, you’ll encounter data than doesn’t follow a linear trend. In those cases, you’ll need to use nonlinear methods. Excel has a few different
Nonlinear Curve Fitting in Excel Using Charts Read More »
You saw in the pressure drop example that LINEST can be used to find the best fit between a single array of y-values and multiple
Multiple Linear Regression in Excel Read More »