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 …
Niche, but Not Unique
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, …
Alt A+M: Remove duplicates in Excel
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 →
Join the Group! “Hired with 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 …
Shift + F2: Insert Comment in Excel
Hell is other peoples' spreadsheets! By commenting on cells with this keyboard shortcut, you make collaboration a little less evil. …
Continue Reading about Shift + F2: Insert Comment in Excel →
Want a Better Network? Start Writing.
I thought of networking as a dichotomy -- either I was out with one of Cleveland's various YP groups or secluded at home. Event-based networking was a huge goal. I even wrote a book about it. I …
Continue Reading about Want a Better Network? Start Writing. →