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
Filtering by Category: Excel Tips & Tricks
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 More