Using Filters
Evan Paulus
Excel's Filters are one of the most useful tools for quickly navigating through a large set of data. Learn these few tricks and you'll save a ton of time.
Read MoreTips for Excel Users
Select Objects Only
Evan Paulus
The Select Objects option and Selection Pane are useful when using Excel Objects.
Read MoreDisplaying Text - CONCATENATE & TEXT
Evan Paulus
Usually you can use the Cell Format option to change the appearance of the cell contents. But other times you may want to force the contents to be more dynamic. These two functions (CONCATENATE and TEXT) can help you to do just that.
Read MoreRemove Duplicates
Evan Paulus
Learn how to use the Remove Duplicates feature of Excel to produce a quick summary table.
Read MoreRelative and Absolute Cell References
Evan Paulus
A quick guide to understanding those dollar signs ($) in your formulas and how to use them to make your Excel experience simpler.
Read MoreRANDom Selection
Evan Paulus
Learn who wins your office raffle with this little trick using the RAND function.
Read MoreThe IF Function
Evan Paulus
The IF function asks a simple question with only two answers. Learn how to extend this to include more than one response.
Read MoreSUMPRODUCT
Evan Paulus
SUMPRODUCT is a useful function when you have an inventory of items with associated costs and you're interested in evaluating the total cost of the list.
Read MoreSUMIF and SUMIFS
Evan Paulus
At the core of Excel is the ability to perform basic mathematical operations on one of more values. The SUMIF and SUMIFS functions allow you to extend that ability by adding only when certain conditions are met.
Read MoreVLOOKUP and INDEX/MATCH
Evan Paulus
Becoming an expert in VLOOKUP and the INDEX/MATCH function combo will help you navigate your way through any Excel table.
Read More