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

Dashboard Tips & Tutorials

Sorting in Excel Dashboards

We all aware of harnessing the power of VBA to dynamically sort dashboards based ...

 ​Read More

Dashboard Tips & Tutorials

Dynamic Labels – Excel Dashboards Tips

Many a times we want to include chart titles in our dashboards, but we ...

 ​Read More

Dashboard Tips & Tutorials

Auto Resizing an Excel Spreadsheet For Your Dashboard

Do you know that Excel allows us to zoom to a specified area in ...

 ​Read More