|
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users
| How to filter in Excel | find data in your list- 2012-05-14 06:54:55-04 |
Excel Filter If you are using a list in Excel, a key skill to have is the ability to filter. Filtering allows you to extract records that meets certain criteria out of your list, so for example if you wanted to find all the transactions you had with a particular company between certain dates, a [...]
Read more...
|
| Sorting in Excel | Excel sort- 2012-05-14 06:56:21-04 |
Welcome to this post about sorting in Excel. This tutorial refers to Excel 2007/2010 and later. A couple of things about sorting before you start. The whole experience will be pretty painless if you tidy up your list to make sure you have the following: Formatted headers No gaps of empty rows/columns Have the [...]
Read more...
|
| SumifS function| SumIf multiple criteria Part 1 – text and numbers- 2012-05-14 07:15:42-04 |
The SumifS function is a new function that was brought in in Excel 2007. Essentially, it is an upgrade for the SumIf function in the sense that it allows you to sum numbers based on more than one criteria. I plan to do another post on this to show you how to use SumIFS with dates. [...]
Read more...
|
|