Uploaded August 2023 | Updated November 2026, 2 hours ago
So the bossman wanted some Excel help. Here we go again π₯
0:00 - Combine data without copy pasting
0:44 - Fill the blank cell with value from above
1:27 - Running totals
2:00 - Filter Top 10 values
2:28 - How to highlight the top 10 values?
3:11 - Autofit in a jiffy
3:33 - Format Painter Magic
4:12 - Many totals in one click
4:43 - Rounding labels to 1000s
5:23 - Get everything in line with a click
5:57 - 19 powerful Excel shortcuts
πΊ WATCH NEXT
==============
19 Excel Shortcuts you must know - youtu.be/Q8fghk3DQxY
Boss vs me - the playlist - youtube.com/playlist?list=PLmejDGrsgFyDffiw_NAM7emJ4A4pvf9CC
π Be an Excel BOSS
==================
with my advanced Excel course
chandoo.org/wp/excel-school-program
#bossvsExcel
So the bossman wanted some Excel help. Here we go again π₯
0:00 - Combine data without copy pasting
0:44 - Fill the blank cell with value from above
1:27 - Running totals
2:00 - Filter Top 10 values
2:28 - How to highlight the top 10 values?
3:11 - Autofit in a jiffy
3:33 - Format Painter Magic
4:12 - Many totals in one click
4:43 - Rounding labels to 1000s
5:23 - Get everything in line with a click
5:57 - 19 powerful Excel shortcuts
πΊ WATCH NEXT
==============
19 Excel Shortcuts you must know - youtu.be/Q8fghk3DQxY
Boss vs me - the playlist - youtube.com/playlist?list=PLmejDGrsgFyDffiw_NAM7emJ4A4pvf9CC
π Be an Excel BOSS
==================
with my advanced Excel course
chandoo.org/wp/excel-school-program
#bossvsExcel









![Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards]
Its hot π₯΅ its coldπ₯Ά, its just a dashboard that is bold
In this video, let me share 3 powerful and amazing ways to create heatmaps in Excel. We can use them to visualize matrix (pivot) style data for dashboards or MIS reports.
In the video:
0:00 - Introduction to Excel Heatmaps
0:24 - Heatmap 1 using Conditional Formatting
3:16 - Heatmap 2 using Images in Cell
9:34 - Heatmap 3 using bubble chart in Excel
15:29 - In conclusion
You will also learn how to use new PIVOTBY function in the video.
Sample file: https://chandoo.org/wp/wp-content/uploads/2026/08/heatmap-3-ways-demo.xlsx
Related videos:
Map chart in Excel - https://youtu.be/qNNn5uiZxOE
Variance chart in Excel - https://youtu.be/REpNnsdHxlY
Dynamic chart with Check boxes - https://youtu.be/L3WFN0bGv8I
How to add avg. line to Excel charts - https://youtu.be/S2RRGqR_MNw
#Excel #dashboards #dataanalytics Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards]](https://i.ytimg.com/vi/Q3oqqYQz2gM/mqdefault.jpg)
