Microsoft Excel — The Simplest Way to Understand PowerQuery

Peruse The Mashable Black Friday Sales Spreadsheet!

Image for post
Image for post
Mashable provides a Google Spreadsheet Link for Black Friday deals
Image for post
Image for post
Black Friday Deals Spreadsheet Link

This is Where PowerQuery Comes In…

Image for post
Image for post
Black Friday Deals — PowerQuery into Excel

Not Quite Done Yet!

Image for post
Image for post
Spreadsheet with a few interface automations

Now to Test It

What are Deals on Kindle Devices?

Image for post
Image for post
Search for Kindle sales
Image for post
Image for post
Filtered List of Sales for Kindle

Interested in TV (or related) Sales?

Image for post
Image for post
Filter on TV — 26 items (TV and related items)

About Don

Image for post
Image for post

“It’s time for different”

“What Do You Do?”

Connect with Don!

It’s time for DIFFERENT— On a mission to challenge the status quo to a more productive and effective end… #digital #Excel #data #analytics

Get the Medium app