# Excel

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

## Nested IF Functions in Excel

In the last section, you saw how an IF function can be used to return one of two possible values. What if you have more

## Named Arrays in Excel

Excel allows you to apply names to arrays, which will make calculations on a series of data easier to understand as well. Worksheet 03y contains

## 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,

In this chapter, we’ll cover some techniques to improve your productivity. The first one is the Quick Access Toolbar. When you first learned Excel, you

## Engineering Surface Charts in Excel

Surface charts are a good way of displaying 3-dimensional data in Excel. Use them when you have two independent variables and a third variable that’s

## 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%