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 […]
[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 […]
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 […]
Techcrunch has posted an interesting article describing a new partnership between Google and public interest journalism website ProPublica to assemble a nationwide hate crimes index. The need for trustworthy facts on the details and frequency of hate crimes and other incidents born of prejudice has never been more urgent. At this point, there is simply […]
