I came across this for the first time today -- A spreadsheet where the columns and rows were both numbers, rather than the normal lettered columns and numbered rows:At first I thought, somebody …
The no toxic spreadsheet shortcut
Hidden rows in Excel are sketchy. They're part of the reason why some people hate Excel.They give Excel a bad name.The most famous example of hidden cells gone horribly wrong was Barclays not …
No More Blast Invites: How You’re Using LinkedIn Jobs All Wrong
Don't you hate junk mail? It's meant for a nameless, faceless "valued customer." The sender never even pretended to understand your unique needs and qualities.Blasting off job applications and …
Continue Reading about No More Blast Invites: How You’re Using LinkedIn Jobs All Wrong →
Quick bit of magic…. then a question for you
Here's a great shortcut I picked up recently: Use Ctrl + - to delete a row. Note my use of Shift + Spacebar to select the row. Cool, huh? Or was it?I've said it many times: I love Excel because there …
Continue Reading about Quick bit of magic…. then a question for you →
Still Uncool: the CLE Guidebook Launch Party
A book I read recently and highly recommend is David Meerman Scott's Newsjacking: How to Inject your Ideas into a Breaking News Story and Generate Tons of Media Coverage.Perfect timing, as the …
Continue Reading about Still Uncool: the CLE Guidebook Launch Party →
Converting a CMS Table to Excel to analyze HCPCS codes
In this video I show how to take a PDF from CMS (Centers for Medicare & Medicaid Services), convert it to Excel, and transform it into a Pivot Table-friendly table with just a few keystrokes.Check …
Continue Reading about Converting a CMS Table to Excel to analyze HCPCS codes →