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 out my new Excel course designed for job seekers at You can also find me at


Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: