02
Nov

Excel Tips: Using Colors

Posted by on · · · · | Blog

Most folks want visual clues to make things easier to read and to comprehend. Our brains can identify and process visual clues many times faster than they can process text or numeric information. Using colors in spreadsheets can not only help us navigate, they can also facilitate comprehension. There are a lot of different techniques […]

Read More
21
Sep

Excel Tips: Using Autofilters and Subtotal() – Part Two

Posted by on · · · · | Blog

[In Part 1 of this series, we discussed how to use Autofilters to manage large sets of data, enabling you to work with only the records that are relevant. In this article we will explore how the Subtotal function in Excel can leverage the power of filters even more.] Sample Data Our sample data set […]

Read More
21
Sep

Excel Tips: Using Autofilters and Subtotal() – Part One

Posted by on · · · · | Blog

Like most programs these days, Microsoft Excel is far more powerful than most folks realize. While you may not use 90% of its power, I will share with you what I think are two of the most power features that beginning Excel users can master right away. They are easy to access and understand and […]

Read More