Teaching analytics with modern Excel
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 →
I've been reading Traction: How Any Startup Can Achieve Explosive Customer Growth by Gabriel Weinberg and Justin Mares. I heard Weinberg on the James Altucher Show and was compelled to read his …
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 …
Recently I wrote a post about how creativity isn't so important as being helpful to your audience.I write in part for self-help. My own post showed me how I'd been doing something wrong. All Hearts, …
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 →
