Teaching analytics with modern Excel
Subscribe for more Excel tips and tricks My recent "Spreadsheet Blessing" ended with the wish that you "find no hard-coded cells." One of the downsides of Excel is that because it is …
Continue Reading about Ctrl + G, Literally a Go-To Excel Shortcut →
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 →
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 →
Use shift + F11 to insert a new worksheet in Excel.A pretty self-explanatory one -- but also a huge time-saver, and also proof that Excel is magic :) PS: A reader mentioned to me that some GIFs …
Another quick formatting tip: Ctrl + Shift + _ will erase all border formatting from selected cells in Excel. …
