Sometimes we get data in Excel that makes it somewhat difficult to look at the big picture. For example, you might get a list of transactions with a date and sale price. Let's say you need to sum values in a month to use in some other analysis. With that example, it isn't easy to just look at the data and know that the first 10 rows are January's transactions, the next 12 are … [Read more...]