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, 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

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

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

Advanced Excel, Development, Discussion, Excel Tips & Tricks, Tips, VBA

A method for quickly importing and working with CSV files (part 2)

This is part 2 in which I explain how I solved the problem. Make ...

 ​Read More