# Excel

## Trigonometric Functions in Excel

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 […]

## Save and Load Excel Solver Models

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

## Gaussian Fit in Excel

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

## Solving Systems of Simultaneous Nonlinear Equations in Excel

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

## Nonlinear Curve Fitting in Excel Using Charts

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

## Multiple Linear Regression in Excel

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

## Evaluating Derivatives of Equations in Excel with VBA

We can extend the concept of finite differences into VBA if we know the function and aren’t constrained to dealing with tabular data. For example,

## Dynamic Linear Regression in Excel with LINEST

Excel also can perform a regressions with a function. The function LINEST can find the equation of a best fit line through data. LINEST uses

Scroll to Top
Complete... 50%