AVERAGE – Excel Function
The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be
SMALL – Excel Function
What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()
LARGE – Excel Function
What it does: The LARGE() Function provides the n-th largest piece of data from an array. Plain English: The LARGE() Function
COUNTIFS – Excel Function
What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria. Plain English:
Using AUTOFILL in Excel – Part 2
(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste
Using AUTOFILL in Excel – Part 1
The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the
Using IFERROR to trap and handle errors
When I first found out about IFERROR, I was a little confused. “There’s a formula to use if we generate an error?