How to Create an Amazing PowerPoint Dashboard With Dynamic Excel Backend [Tutorial Part III]

63,693

1,120 0

Published 2018-10-31

How to Create an Amazing PowerPoint Dashboard With Dynamic Excel Backend [Tutorial Part III]

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

This is a tutorial on how to create an amazing PowerPoint Dashboard that can be dynamically updated from an Excel Backend File.

In this third and final part of the tutorial you will learn how to code two Excel VBA scripts that are required to update the respective charts or dynamic labels in the PowerPoint Dashboard File once a change in the data of the Excel Backend File has happened.

► Here you can find the other parts of the tutorial and the final dashboard demonstration video

Tutorial Part I:    • How to Create an Amazing PowerPoint D...
Tutorial Part II:    • How to Create an Amazing PowerPoint D...
Demo Video:    • Amazing PowerPoint Dashboard With Dyn...

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

❤ Music by
www.soundcloud.com/ikson
www.bensound.com/

#excel #powerpoint #dashboard

All Comments (21)

@theofficelab 5 years ago

Tutorial Part I: https://www.youtube.com/watch?v=oU0WqM7cQfk Tutorial Part II: https://www.youtube.com/watch?v=eKRpslgdX0w Demo Video: https://www.youtube.com/watch?v=Uat-xmtvA0M
@jcsalao8 5 years ago

Wonderful tutorial. You've made it as easy as you can. But alas, for like mo who is not familiar with encoding i hope you could provide a list of the script for me to see clearly. Thanks for being generous in your knowledge and skill.
@ryszarddzumyk2677 5 years ago

Thank you Alex, That's exactly what I'm looking for !! Great job!
@MsUtsavroy 3 years ago

Thanks @The Office Lab - Extremely Helpful, time saving and innovative Video. You're Gem!
@sabinabaxmann8023 4 years ago

This looks so fancy ! And is smart, too ;) And uses exactly the technics exactly what I was looking for. Tausend Dank Euch :-))
@a2venture981 5 years ago

Amazing tutorial!
@Up4Excel 2 years ago

Great bit of automation here Alex and well explained 👍 I guess anyone wanting to do this as a one-off could shortcut the process by refreshing all PowerPoint objects when anything in the Excel input area changes. I know it would be less CPU efficient but for a single presentation it would be quite a lot less coding. Worth doing more thoroughly like you for a dashboard you'll be using a while though.
@wesleylisboa352 5 years ago

Awesome! Congrats.
@alperaydyn 3 years ago

great tutorial, thanks for detailed explanation.
@MrShailendra612 5 years ago

Awesome... really hats off
@virginiarevollo5313 5 years ago

Great!! Thanks ; )
@mdshakibulhossainsikder9313 4 years ago

It is incredible..... thank you so much . i am from #Bangladesh, Asia
@ecomicare3395 2 years ago

Thanks very much for that !
@Thijsvdd 5 years ago

Great tutorial tnx! Which code do i need when i have multiple sheets with charts?
@dbritoteixeira 5 years ago

Wonderful, congratulations, here from Brazil
@Toczusiek 3 years ago

It works, thank you so much :) Note: If you are looking for solution, put a breakpoint on Worksheet_Change and debug it. Look for every line, every statement and every typos. Finally you'll get in there.
@jailtonferreira3050 5 years ago

Parabéns, excelente trabalho!
@XDTuber 5 years ago

This is pretty awesome.
@sergiomira741 4 years ago

Hi Friend.... your vídeos are great!!!!! Greetings from Colombia
@iwan2023 4 years ago

Part I and II is simple to follow. But this part III is more difficult to understand the command function in VBA for common excel user. Maybe you can tell more about each command. Thx. Good job