Analytics & AI for Modern Excel
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 →
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 →
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 →
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 →
An increasing number of jobs in industries as diverse as healthcare operations and maritime piracy analysis require quantitative aptitude.The response to prepare for this demand is often an emphasis …
Continue Reading about Data and the Liberal Arts Edge: Discussion with Matt Walje →
Paying commissions in Excel can be tricky. Not only does the data have to be 100% correct, it is structured differently than most financial data.It's not based on subaccounts or the general ledger -- …
Continue Reading about Paying Commissions in Excel: Understand Your Data →
