Analytics & AI for Modern Excel
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 →
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 →
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® →
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 …
This tip comes courtesy of Alex at Excel Strategies. Check out his #TuesdayShortcuts series for more nifty Excel timesavers!Use Alt + A + M to remove duplicates in a set of data in Excel. …
Continue Reading about Alt A+M: Remove duplicates in Excel →
I was so unprepared for my first job interviews.A liberal arts grad, I assumed employers would have a sixth sense for my aptitude and worry about training me later. But in a rough jobs market where …
