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 →
Free Ebook: The Beginner’s Guide to Getting Hired with Excel®
An increasing number of jobs require quantitative aptitude. Where to begin? Get hired... start with Excel.This PDF is a preview of a course I developed specifically for job seekers and others …
Continue Reading about Free Ebook: The Beginner’s Guide to Getting Hired with Excel® →
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 …