zAnalysis

How to: Power Query File From Folder

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

 Read More

zAdvanced Excel, Dashboard Tips & Tutorials, zAnalysis, zDashboards, zData Visualizations, zGeneral

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

zAdvanced Excel, Dashboard Tips & Tutorials, zAnalysis, zDashboards, zData 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

zAnalysis, zDashboards, zDevelopment, zNo VBA, zTips

Excel Requests – HTTP for Humans

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

 Read More

zAnalysis, zData Disasters, zDiscussion

Newspapers – Read Your Sources!

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

 Read More

zAdvanced Excel, zAnalysis, zDashboards, zMath, zNo VBA, zSensitivity Analysis

Easy One-Way Sensitivity Analysis on Weighted Sum Models in Excel (Part 2)

Wow, it’s been a while since my last article. I’ve actually been pretty busy ...

 Read More

zAdvanced Excel, zAnalysis, zDashboards, zMath, zNo VBA, zSensitivity Analysis

Easy One-Way Sensitivity Analysis on Weighted Sum Models in Excel (Part 1)

This article describes what I like to call “Easy One Way Sensitivity Analysis” in ...

 Read More

zAnalysis, zFormulas, zMath, zNo VBA

Numbering Grouped Data for Pivot Tables

We’ve all had some experience with Excel’s automatic numbering.  For example, if you have ...

 Read More

zAnalysis, zDashboards, zNo VBA, zProject Management, zSpreadsheet Tricks

A Dynamic Dashboard for Project Durations and Costs in Excel

Make sure to checkout A Dynamic Dashboard for Project Durations and Costs in Excel (part ...

 Read More