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

zExcel Tips & Tricks, Dashboard Tips & Tutorials, zAdvanced Excel

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

Dashboard Tips & Tutorials

Dynamically Select Different Chart Types – Excel Dashboard Tips

Most of us employ Excel to analyze data in search of some insights. For ...

 Read More

Dashboard Tips & Tutorials

Interactive Excel Dashboard Tips Using Slicers and Pivot Charts

We, as data analysts and Excel experts, are always trying to hunt down new ...

 Read More

Dashboard Tips & Tutorials

How to Build Sparkline Charts in Excel – MS Excel Tutorials

Sparklines allow quick and easy visualization of data. These charts do not require you ...

 Read More