Welcome to "PK: An Excel Expert", your digital mentor in the world of Excel and VBA. As a Microsoft Certified Professional with over 15 years of cross-industry experience, I am here to simplify complex concepts, making them accessible to everyone.
From regular tutorials for all skill levels to specialized playlists like 'VBA Tutorial' and 'Dynamic Graphs', this channel is designed to equip you with the knowledge to create dynamic graphs, automations, and BI dashboards.
Whether it's VBA automation, MIS Reports, Power Pivot, or beyond, you'll find a wealth of information here. Subscribe today and join our community of continuous learners, thriving in a data-driven world.
Subscribe our new KZread Channel:
www.youtube.com/@NeotechNavigators
Пікірлер
You go way too fast thru your step by step even if I replay the video multiple times. It would help if you had text on the side
Thank you sir❤❤❤ But i can not connect month with spin button that formula not work for me
Pak, bagaimana cara menulis program ini? Program Serupa Ini Tanpa Melihat Tanpa Mengetahui Metode Peta Buku Bagaimana Anda mengumpulkan program untuk setiap bidang? Misalnya, bagaimana cara mengkompilasi Properti Program Akuntansi tanpa mengetahui parameternya? Untuk merakit suatu program, apakah Anda perlu mempelajari fitur-fitur program tersebut, lalu kembali dan membuat program dengan menulis kode menggunakan Excel? Tolong bantu saya dalam hal ini.
Dear sir Please your whatapps no
Amazing! Great idea to make visually appealing KPI 👍
💞
Thanks
Tq sir
Welcome
Thank you very much. Great job. I learned something new thanks to you. Greetings from Turkey. Stay healthy.
Most welcome
GRAND TOTAL KO DAILY TREND MI Kise dikahye
Will add in the next version
Sir is softtware price
Please visit the link given in the description or www.pk-anexcelexpert.com
Great!! Can you do this on Pivot Chart??
Yes, of course. Will create a separate video on this
So helpful. Short and concise to the point. Just 1 observation, @1:46, if we want the progress bar to disappear after 100% completion, just change False to True in the last line before End Sub.
Hello it was very helpful , facing a error stock in and out date not fetching in the summary sheet , could you help me
Thank you for your neat explanation, its really helpful to learn the excel options and making dashboards.
Glad it was helpful!
Thank you sir
Welcome
Such an amazing video PK. I love your videos.
Thanks for your valuable feedback
This was a masterpiece. I have been trying to do the progress bar for some time now to no avail. Thank you for this.
Glad I could help!
I can not insert checkbox in each cells, how is that? thanks the INSERT Tab in my excel doesn't have insert checkbox
It is available in the latest version of Excel. You can use our PK's Utility Tool V3.0 to insert the check box. Visit our website WWW.PK-AnExcelExpert.Com for free download it.
Hi, could you please help me to prepare the stacked coin chart (instead of bar) in a bar chart in excel file
Will try to create it soon
why I can't auto size picture on user form its always bigger pls help me
Hello sir i have on problem can you solve please i maked data entry form with list box but i want to hide that background excel that apper
Hi. I have purchased this worksheet but am not able to download it.
Please check your email.
Is there a tutorial that uses Google Sheets?
Please watch below given video: kzread.info/dash/bejne/o4mMmc-uYpPSkbA.html
How to share user form with end user and is it use multiple user at a time.
We have some other applications with multi user and database is in MS access. You can visit our website WWW.PK-AnExcelExpert.Com for more information.
docs.google.com/spreadsheets/d/1xKkLyEZgau7OGIlYU_xb-gXjQPHwE3QIdRvf_0u_hX4/edit?usp=drivesdk
Hello.How to calculate working hours per month in dynamic calendar
Will upload soon
how to make it in excel 2016, the filter function is missing. any solution?
Thank you for the video. Where can I find the dataset?
In the description
Thanks 🎉
Most welcome
Thank you! You are the Legend ^^ I'm Vietnamese
Most welcome
😮من فضلك الرابط لتحميل الملف
www.pk-anexcelexpert.com/pro-gantt-chart-in-excel-with-data-entry-form
PK please create google sheet versions of these great Excel videos.
Please watch below video kzread.info/dash/bejne/Z3-As86alrjWhso.html
tank u man💕💕
Most welcome
when we add the data in the month of Jan the same data automatically gets in the other months till Dec. whats the solution for that? anyone, please guide me
Kia baat hy sir Kiya Baat hy
🙏👍
Nice
Thanks 🙏👍
Really thanks for the session.. but monthly summary data is not updating as expected
Let me check
PK sir, could you make Gantt chart with dynamic dependency which changes the Gantt chart automatically means how to add predecessors dynamically
Will upload soon
this is amazing :)
Thanks
How to download this file
Visit www.PK-AnExcelExpert.Com
Hi Can you please help me, how did you hide all the tabs in it, with hyperlink, I am unable to do it. Please help.
بارك الله فيك اخي الكريم، مانوع لوفيس؟
Thanks
Can you please guide me how to print out these all test pdf files with one click or one button? I have to 2500. Pdf files print out
Could you please explain the concept of applying (1+1/6)
Thank you for making out time to put together this clip. I have tried to do the conditional formating for the webbing text but it keeps showing the wrong symbol. What can i do??
Hello, I need help with mine. I’m creating a template for the workers in my cells I have Star time Time out Lunch Total hrs Rate (differents amounts) So far everything is good but now I want to automate the total payment with the cells total hrs and rate but if I don’t have any values in my cells shows me a #VALUE! But if I fill out all my cells the formula works fine. I want to have for permanent template 😢
How can i get all the formula for attrition?
I don’t have a option of this developer
Hi how can I download this template thanks
can I control the result?