Creating Butterfly Charts in Excel with Pivot Tables

• Excel
• Data Visualization

Building a Color-Coded Calendar Grid in Excel

People are always badmouthing Excel and working in various new and powerful data visualization tools. In this video, we duplicate...

• Excel
• Data Visualization

Going Text to ROWS with Power Query

Text to Columns is a common tool in Excel (although the Text to Columns feature in Power Query, called Split...

• Excel

A Beginner’s Guide to Power Query

Power Query is Excel's new ETL tool - whether you’re talking about Excel or Power BI, when you extract, transform, and load the data into a report, you’re doing it with Power Query.

• Excel
• Power Query