Building a dynamic Excel dashboard on Mac (part 1)
This series will show you how I built this entire dashboard from start to finish using standard Excel features (no add-ins or custom coding). I used the Mac version of Excel for this entire video and I think you'll be surprised to see that it can do almost everything you could do with a PC.
Part 2: • Building a dynamic Excel dashboard on Mac ...
If you want the free template files, like the one in this video, you can grab them on the newsletter: https://excel.kit.com
Or you can just buy the whole toolkit here: https://exceldashboardtemplate.com/
00:00:00 Intro
00:00:40 The sheets
00:02:33 Structuring your table
00:03:11 Finding sample data
00:03:38 Pivot tables
00:06:46 What to add
00:08:41 Know your audience
00:10:37 Layout & Color