Did you know that you can use the same value field twice in a #PivotTable? Follow these steps to include a % total or running total on your report. …
More Filtering Fun
Yesterday I quoted a tip on filters from "Learn Excel from Mr. Excel," a great read. Filters are a powerful Excel feature. They allow you to hone in on your data. The only problem is they're a little …
Keyboard Shortcut: Rename Worksheet in Excel
Here's a nice keyboard shortcut I recently picked up. …
Continue Reading about Keyboard Shortcut: Rename Worksheet in Excel →
Why PivotTables?
You probably didn’t expect etymology in this book, but it here goes. When I probably should have been learning Excel in high school, I took a Greek class instead.I haven’t used my Greek a lot, but one …
10 Commandments for Spreadsheet Collaboration
Hell is other people's spreadsheets.There is a Russian proverb that you don't really know someone until you have shared a pound of salt with him. In the office, you don't really know someone you have …
Continue Reading about 10 Commandments for Spreadsheet Collaboration →
Excel Tip: Freeze, Formula!
I promise I didn't post this just to use this great (free!) photo from Gratisography. No, it's because this is one of the niftier Excel hacks that doesn't get much publicity.Unwinding a formula in …