Amazing PowerPoint Dashboard With Dynamic Excel Backend

54,929

622 21

Published 2018-06-01

Amazing PowerPoint Dashboard With Dynamic Excel Backend
✅ FREE 2 months of Skillshare Premium* ► skl.sh/2NaGiBb

☕ Buy Me A Coffee (via Paypal): www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted…

🔥 Subscribe for more awesome Excel and PowerPoint content: tinyurl.com/ydfdlk9o

This is a demonstration of how a beautiful dashboard designed in PowerPoint can be taken to the next level with an Excel file, which is dynamically and automatically connected to all the charts and values of the dashboard. This allows for dynamically updating all charts and values without leaving the PowerPoint presentation mode.

In order to enable updating the respective dashboard chart immediately after changing the values in Excel (even after closing and reopening both files), I added some VBA code in the background.

For everyone interested in how this was build I will upload a tutorial video in the near future.

Stay tuned and subscribe if you like to see more videos of this kind.

Music

We Are One by Vexento youtube.com/user/Vexento
soundcloud.com/vexento
Music promoted by Audio Library • We Are One – Vexento (No Copyright Mu...

[* = Affiliate Link]

#powerpoint #dashboard #excel

All Comments (20)

@theofficelab 5 years ago

I just uploaded a three part tutorial on how to create this dashboard. Tutorial Part I: https://www.youtube.com/watch?v=oU0WqM7cQfk Tutorial Part II: https://www.youtube.com/watch?v=eKRpslgdX0w Tutorial Part III: https://www.youtube.com/watch?v=Z8WUSIgYKsg I hope you like it.
@elfarodesanblas2274 5 years ago

I came looking for copper and found GOLD.
@avinashrt4158 5 years ago

promo looks cool.. waiting for the show 😎
@hdwise1723 6 years ago

Awesome work, mate! I am excited for the tutorial to come...
@cavatappi93 6 years ago

amazing, can't wait to watch the tutorial :)
@JohnOchuro 4 years ago

this is very nice! as someone getting into this, I find this very useful
@numnut5214 2 years ago

A Legend was born🔥🔥😎
@DictatorTarco 6 years ago

I found your channel following a reply you left to a top comment on another video, don't usually read the comments and this video was a lucky find. Great video and I am looking forward to see how you did it. subcribed
@adzdzikru8834 4 years ago

amazing, Thank You
@hallowelt55555 6 years ago

just wow!
@Samuimarvelproperties 5 years ago

Hi I subscribed helping you to reach the 100 mark pretty soon. Hope the next 8 subscriber don't take 6 month to come ... Anyway it does look great
@syedmuhammadkazmi8766 2 years ago

I got excellent learning experience....👍
@theintellectualnovice7089 3 years ago

Awesome video, Do you know where we can locate the dataset?
@bhagyarajallu1789 5 years ago

Just awesome ,can you do a video on how to work with pivot table filters with a dynamic multiple select drop down ,instead of slicer
@msrayn04 5 years ago

Hi, this is just what I am looking for. My question is how do I set up Excel so that I can pull it into the dashboard? Do you have a tutorial on that? I need this for my end of the year report. Thank you and this is great.
@hariyantowidjaja6167 4 years ago

Amazing, can i get bot of files?
@nishokjesudasen2762 4 years ago

Hi how do I download the back ground template
@T4skMast3r 6 years ago

Very nice, did you end up doing the tutorial?
@HongKong1842 3 years ago

It worked at the beginning and as I continue, although naming all the labels and text correctly, the excel lost control with powerpoint. I could not find out the reason. I re-do part of the charts, copying them over and it worked for a moment again. But then it stop synchonizing. I am really puzzle. Could you please help?