This is really great opportunity those who interested to explore Dashboard. Thank you for share your knowledge.
@naveenkarthik3305 Жыл бұрын
You are one of the best teachers I have seen
@PariSanthanakrishnan Жыл бұрын
Great work and timely video! Thanks for creating this content!!
@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!
@anillpatel3 ай бұрын
Fantastic Video presentation. Very useful feature for creating PP Dashboard from Excel.
@raghavarya4430 Жыл бұрын
This is really amazing sir... Please continue to make videos like this...Very useful ❤
@vverabing Жыл бұрын
exciting! Good explained as well. thank you
@claudiosilva8772 Жыл бұрын
Great video. You the best !!!I learned a lot. But I don't know much about VBA, Would love to learn it though.
@adekoyejodada5856 ай бұрын
This is so impressive.
@sneha_kittu Жыл бұрын
You are a life saver!!thank u so much...
@inezwong2515 Жыл бұрын
Thank you so much, it is very helpful
@metomeid1693Ай бұрын
nice...thank you ..mantaps❤
@FikileDibakwane Жыл бұрын
This is great! Thank you.
@diydoc Жыл бұрын
Amazing video!!!
@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 Жыл бұрын
Great, I have subscribed your channel, thanks for sharing valuable videos
@skillnator Жыл бұрын
Thanks and welcome!
@iftekharraju318 Жыл бұрын
Excellent... Thanks a lot..
@skillnator Жыл бұрын
Most welcome!
@mohamedhelemish8421 Жыл бұрын
Thank you so much. What about if I have three or four different sheets instead of one sheet?
@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 Жыл бұрын
Its a work in progress. Will try to release it soon!
@msmrd1986 Жыл бұрын
رائع جداً 👍
@all-rounder930710 ай бұрын
Brilliant, which Font & size you have used
@RhymskyRebusi3 ай бұрын
good day sir me i ask a question how to create this kind of excel to make it editable in powerpoint not photos type.
@heidimedina98562 ай бұрын
Do you have a VBA programing video?
@aamiraltaf1711 ай бұрын
Please arrange a crash course for VBA coding
@Sumit-pc4ws Жыл бұрын
Can we operate slicer in ppt
@anandkumar-xu3yq Жыл бұрын
you are superb
@skillnator Жыл бұрын
Thank you!!
@analizacayabyab3139 Жыл бұрын
Amazing
@vinayaksangale3578 Жыл бұрын
pl give vba code
@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 Жыл бұрын
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Ай бұрын
@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 Жыл бұрын
Awesome presentation! But I could not find the VBA code.
@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
@wamanechannel88485 ай бұрын
❤
@leorcannegutierrez94858 ай бұрын
Where's the code?
@genesissantiago659 Жыл бұрын
Where are you from sir? you are great!!
@skillnator Жыл бұрын
Thank you! I am from Canada 🇨🇦
@tanyashiawallace7500 Жыл бұрын
I need the crash course :( I'm not versed in the coding.