Export excel dashboard to powerpoint in one click

  Рет қаралды 76,540

Skillnator

Skillnator

Күн бұрын

Пікірлер: 50
@anwerarafathsana5655
@anwerarafathsana5655 Жыл бұрын
This is really great opportunity those who interested to explore Dashboard. Thank you for share your knowledge.
@naveenkarthik3305
@naveenkarthik3305 Жыл бұрын
You are one of the best teachers I have seen
@PariSanthanakrishnan
@PariSanthanakrishnan Жыл бұрын
Great work and timely video! Thanks for creating this content!!
@nydiaodendaal8951
@nydiaodendaal8951 Жыл бұрын
Thank you so much for sharing this video - I definitely need to learn more about VBA code. Please forward me to code to open Powerpoint from Excel. Just finished watching your other video, creating interactive dashboards in 5 steps. This is really an amazing video, thank you!
@anillpatel
@anillpatel 3 ай бұрын
Fantastic Video presentation. Very useful feature for creating PP Dashboard from Excel.
@raghavarya4430
@raghavarya4430 Жыл бұрын
This is really amazing sir... Please continue to make videos like this...Very useful ❤
@vverabing
@vverabing Жыл бұрын
exciting! Good explained as well. thank you
@claudiosilva8772
@claudiosilva8772 Жыл бұрын
Great video. You the best !!!I learned a lot. But I don't know much about VBA, Would love to learn it though.
@adekoyejodada585
@adekoyejodada585 6 ай бұрын
This is so impressive.
@sneha_kittu
@sneha_kittu Жыл бұрын
You are a life saver!!thank u so much...
@inezwong2515
@inezwong2515 Жыл бұрын
Thank you so much, it is very helpful
@metomeid1693
@metomeid1693 Ай бұрын
nice...thank you ..mantaps❤
@FikileDibakwane
@FikileDibakwane Жыл бұрын
This is great! Thank you.
@diydoc
@diydoc Жыл бұрын
Amazing video!!!
@Vee-of4eb
@Vee-of4eb Жыл бұрын
Really helpful video, thank you, will be using this very soon!! But I do need to learn more about VBA code - please can you send me details about this as you mentioned in your video?
@subhasarkar7135
@subhasarkar7135 Жыл бұрын
Great, I have subscribed your channel, thanks for sharing valuable videos
@skillnator
@skillnator Жыл бұрын
Thanks and welcome!
@iftekharraju318
@iftekharraju318 Жыл бұрын
Excellent... Thanks a lot..
@skillnator
@skillnator Жыл бұрын
Most welcome!
@mohamedhelemish8421
@mohamedhelemish8421 Жыл бұрын
Thank you so much. What about if I have three or four different sheets instead of one sheet?
@vinay94095
@vinay94095 Жыл бұрын
Hi, It was very good technique shown from excel to PPT But can made a crash course for macro, bcoz i want to learn it
@skillnator
@skillnator Жыл бұрын
Its a work in progress. Will try to release it soon!
@msmrd1986
@msmrd1986 Жыл бұрын
رائع جداً 👍
@all-rounder9307
@all-rounder9307 10 ай бұрын
Brilliant, which Font & size you have used
@RhymskyRebusi
@RhymskyRebusi 3 ай бұрын
good day sir me i ask a question how to create this kind of excel to make it editable in powerpoint not photos type.
@heidimedina9856
@heidimedina9856 2 ай бұрын
Do you have a VBA programing video?
@aamiraltaf17
@aamiraltaf17 11 ай бұрын
Please arrange a crash course for VBA coding
@Sumit-pc4ws
@Sumit-pc4ws Жыл бұрын
Can we operate slicer in ppt
@anandkumar-xu3yq
@anandkumar-xu3yq Жыл бұрын
you are superb
@skillnator
@skillnator Жыл бұрын
Thank you!!
@analizacayabyab3139
@analizacayabyab3139 Жыл бұрын
Amazing
@vinayaksangale3578
@vinayaksangale3578 Жыл бұрын
pl give vba code
@alistairstanger2940
@alistairstanger2940 Жыл бұрын
Very nice. But how does it update the same presentation with new values each month for example? It seems it just creates a new presentation each time?
@skillnator
@skillnator Жыл бұрын
Hi, thank you for your question. You will need to tweak the code a bit to achieve this. In the section of the code which says "Set up a power point file", put in the following code: 'Set up a power point file On Error Resume Next Set PApp = GetObject(, "Powerpoint.Application") If PApp Is Nothing Then Set PApp = New PowerPoint.Application End If If PApp.Presentations.Count = 0 Then Set PPres = PApp.Presentations.Add Else Set PPres = PApp.ActivePresentation End If Set PLayout = PPres.SlideMaster.CustomLayouts(1) ''''''''''''''' Furniture Category ''''''''''''''''''''''''''''' Rest of the code remains the same. With this modification, the code will create a new presentation if none is open already. If there is one open already, then it will add a new slide to the one currently open presentation. Hope that helps!!
@karthiktharol
@karthiktharol Ай бұрын
@skillnator.. Hi. I am facing an issue while using the code. The following error is popping up while executing: "Runtime Error '1004': CopyPicture method of Range class failed". I tried different ways.. once in 5 or 6 times its working, All other cases this error is popping up. Do you have any solution for this???
@signal03
@signal03 Жыл бұрын
Awesome presentation! But I could not find the VBA code.
@skillnator
@skillnator Жыл бұрын
Hi, You can dowlonad the file from below link. There are two files in there, please download the one with "xlsm" extension. Once you open the file, go to VBA editor (keyboard shortcut Alt + F11). You should be able to see the entire code there. Hope that helps. drive.google.com/drive/folders/1ZsA2-2knQSnrteNWJ13UL67xTS4zHBFX?usp=share_link
@wamanechannel8848
@wamanechannel8848 5 ай бұрын
@leorcannegutierrez9485
@leorcannegutierrez9485 8 ай бұрын
Where's the code?
@genesissantiago659
@genesissantiago659 Жыл бұрын
Where are you from sir? you are great!!
@skillnator
@skillnator Жыл бұрын
Thank you! I am from Canada 🇨🇦
@tanyashiawallace7500
@tanyashiawallace7500 Жыл бұрын
I need the crash course :( I'm not versed in the coding.
@anandkumar-xu3yq
@anandkumar-xu3yq Жыл бұрын
Please make crash course on VBA
@skillnator
@skillnator Жыл бұрын
Sure will release soon!!
@chandu9036
@chandu9036 3 ай бұрын
Code not found in description
@gopikrishnakasarapu5891
@gopikrishnakasarapu5891 6 ай бұрын
VBA PROGRAMMING COURSE PLEASE
@carlossousa8744
@carlossousa8744 Жыл бұрын
Showwwwww
@poojamathur4627
@poojamathur4627 3 күн бұрын
Pls share this vba code in chat
@darlingtondlipenga8145
@darlingtondlipenga8145 Жыл бұрын
I dont know anything about VBA
@omidmollazadeh3791
@omidmollazadeh3791 5 ай бұрын
Where is code??
Microsoft Excel Beginners to Advanced - Lecture 1
3:29
Skillnator
Рет қаралды 10 М.
Mom Hack for Cooking Solo with a Little One! 🍳👶
00:15
5-Minute Crafts HOUSE
Рет қаралды 23 МЛН
BAYGUYSTAN | 1 СЕРИЯ | bayGUYS
36:55
bayGUYS
Рет қаралды 1,9 МЛН
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН
99.9% IMPOSSIBLE
00:24
STORROR
Рет қаралды 31 МЛН
Secrets to Building Excel Dashboards in Under 15 Minutes & UPDATES with 1 CLICK!
13:20
Build a Dynamic Budget vs Actuals Dashboard on Excel (Variance Analysis)
16:08
Make an Interactive Excel Dashboard in 4 Simple Steps!
19:41
Kenji Explains
Рет қаралды 357 М.
The Biggest Mistake Intermediate React Developers Make
18:32
Cosden Solutions
Рет қаралды 42 М.
These CSS PRO Tips & Tricks Will Blow Your Mind!
8:48
Coding2GO
Рет қаралды 532 М.
Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!
17:59
PK: An Excel Expert
Рет қаралды 547 М.
Build the ULTIMATE Excel Dashboard from Scratch
20:42
Kenji Explains
Рет қаралды 437 М.
Mom Hack for Cooking Solo with a Little One! 🍳👶
00:15
5-Minute Crafts HOUSE
Рет қаралды 23 МЛН