Advanced Excel, Dashboards, Data Visualizations, General, No VBA

Microsoft Excel Visio Data Visualizer Add In for Excel: A Quick Guide

IntroductionI wanted to let you know about a really cool new add in for ...

 ​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, Excel Tips & Tricks, VBA

Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick

Turn any image into an Excel file? Ever think about turning your face or ...

 ​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

Advanced Excel, Dashboard Tips & Tutorials, Excel Tips & Tricks

Advanced Excel Tutorial – VLOOKUP() Speed in Excel | Excel TV

CORRECTION Several people pushed back on the video I release this morning and I ...

 ​Read More

Advanced Excel, Formulas, No VBA

“Everyday” Random Shuffling with Formulas

In this article, we’ll talk about how to complete random shuffling with only formulas. ...

 ​Read More