Microsoft Excel: Macro Not Working? Here’s How You Troubleshoot It.

Microsoft Excel: Basic PowerQuery — Stock Price Data From Google Sheets

Microsoft Excel — 5 Default Settings You Want to Change Now

Have you Considered These? Thank Me In The Comments! :-)

Microsoft Excel — Sharing PowerQuery Queries Between Excel Workbooks

Overview

The more you use PowerQuery (“Get and Transform” in Excel 2016), you will encounter situations where you want to share a query with others or use a query in a different…

MS Excel — I Finally Get It! Unpivot in Power Query is Awesome!

“Necessity is the mother of invention…”

Microsoft Excel — 5 Tips for Understanding a Complicated Spreadsheet

Eliminate The Pain of This Typically Painful Process

Microsoft Excel — RSS News Feed Into Excel Using PowerQuery?

This was the Challenge Question I Got Today

The Challenge?

Microsoft Excel — The BASICS of Data Transformation

Key Concepts Essential to Shaping Data For…

Microsoft Excel — How To Create A Date-Variable Dynamic Report Header

No Need to Change Your Header — Make it Dynamic!

MS Excel: WARNING! Analytics & Dashboards — This Is A Post For Accountants…

But Any Business Analyst Type Would Benefit!