Analysis

How to: Power Query File From Folder

Get file from Folder Get File From Folder is what Microsoft has named the ...

 ​Read More

Advanced Excel, Analysis, Dashboard Tips & Tutorials, Dashboards, Data Visualizations, General

Highlighted Timeline Chart in Excel Without VBA: Raw and Uncut

Introduction I built a chart that let’s you highlight a series from a smaller ...

 ​Read More

Advanced Excel, Analysis, Dashboard Tips & Tutorials, Dashboards, Data Visualizations

Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks

No matter where you fall on the political spectrum, you’ll love the chart I’ve ...

 ​Read More

Analysis, Dashboards, Development, No VBA, Tips

Excel Requests – HTTP for Humans

Written by Bjoern Stiel APIs are the lifeblood of the internet, providing access to ...

 ​Read More

Analysis, Data Disasters, Discussion

Newspapers – Read Your Sources!

Update – Apologies for the bad proofreading job in the original blog post. Before writing ...

 ​Read More