Chandoo runs a great Excel site at chandoo.org. I really like his site because he frames Excel problems from the viewpoint of a real life data analyst. He's been one and he knows what makes analysts …
Never Fear, Excel is Here (to stay!)
Image from Gartner study If you're worried that your Excel skills may soon become obsolete, take comfort. A recent Gartner study positions Microsoft as an industry leader in BI and Analytics. I'm …
Continue Reading about Never Fear, Excel is Here (to stay!) →
Excel Tip: Multiple Pivots with Report Filter Pages
If you've read my blog, you'll know that I love PivotTables.Subscribe for more Excel tips and get your free ebook on getting "Hired with Excel." One nuisance with PivotTable is report maintenance. If …
Continue Reading about Excel Tip: Multiple Pivots with Report Filter Pages →
What’s that Red Dot? Excel Cell Commenting
Cell comments in Microsoft Excel are marked with a red triangle in the upper-right of the cell. Insert a new comment with Shift + F2. These are helpful for making notes or observations of your data, …
Continue Reading about What’s that Red Dot? Excel Cell Commenting →
Quickly Insert a Row in Excel
Adding rows in Excel is part of the endless, Sisyphean work of an analyst. Here's a quicker way.Select the cells you wish to move down a row. Then hit Ctrl + Shift + = to launch a dialogue box that …
The Tangled Subtotal They Sent You
I'm not a huge fan of subtotals in Excel -- they're quite high-maintenance. Add a line or field and there's a good chance things won't add up anymore. Here's how to get rid of them so you instead put …