Linear interpolation allows us to improve an estimate based on a set of x- and y-values. What if you are working with x-, y- and z-values, where x and y are independent variables and z is dependent on both? In that case, you can use bilinear interpolation in Excel. It works similarly to linear … [Read more...]

###### GET FREE UPDATES OF NEW POSTS HERE

## Adding Specific Values in Excel with SUMIF and SUMIFS

Have you ever needed to sum only specific values in a range of data, and exclude others that did not meet the necessary criteria? The SUMIF and SUMIFS functions enable you to do exactly this - sum values in a range of cells if they meet specified criteria. Values that don't meet the criteria are … [Read more...]

###### GET FREE UPDATES OF NEW POSTS HERE

## 3 Ways to Update a Scatter Chart in Excel

At some point, you'll probably need to update a scatter chart in Excel. Perhaps you'll need to import new data, but in some cases the new data is already contained in the worksheet. In this example, the data from column C has been plotted, but there's an additional column of data in column D that … [Read more...]

###### GET FREE UPDATES OF NEW POSTS HERE

## How to Look Up Data in 3D Excel Tables

INDEX and MATCH are great functions to use for flexible lookups of data in either 1D or 2D tables, but they can also be used to lookup data in 3D tables as well, where the output value "d" is a function of three inputs: a, b, and c. However, to use those functions in such a way, we need to use a few … [Read more...]

###### GET FREE UPDATES OF NEW POSTS HERE

## Combine UDF’s and Named Cells to Boost Efficiency in Excel

Two of my favorite Excel features are named ranges and user defined functions. It also just so happens that these two features can be used together to really boost your efficiency. User-defined functions can be created to perform calculations you find yourself doing repeatedly. You're free to do … [Read more...]