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 »
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
Nested IF Functions in Excel Read More »
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
Named Arrays in Excel 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 »
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,
Evaluating Derivatives of Equations in Excel with VBA Read More »
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
Enhance Productivity with the Quick Access Toolbar Read More »
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
Engineering Surface Charts in Excel Read More »
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
Dynamic Linear Regression in Excel with LINEST Read More »
You’ll also receive regular tips to help you master Excel for engineering.
