![PK: An Excel Expert](/img/default-banner.jpg)
- 767
- 31 860 413
PK: An Excel Expert
India
Приєднався 27 кві 2013
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 UA-cam Channel:
www.youtube.com/@NeotechNavigators
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 UA-cam Channel:
www.youtube.com/@NeotechNavigators
Pro Gantt Chart in Excel with Data Entry Form || Complete Tutorial
#gantt #ganttchart #projectmanagement
Hello Friends,
In this video, you will learn how to create a Pro Gantt Chart in Excel with Data Entry Form. This is ready to use template and easy to customize. You can use it for your Project Management Dashboard.
Below is the Download link of Pro Gantt Chart in Excel with Data Entry Form:
www.pk-anexcelexpert.com/pro-gantt-chart-in-excel-with-data-entry-form
Subscribe our new UA-cam Channel:
www.youtube.com/@NeotechNavigators
Need Consulting Servicing in Power BI, Excel or VBA:
Email Us at info@PK-AnExcelExpert.Com
Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
ua-cam.com/video/kpLnxV3a1bE/v-deo.html
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/pks-utility-tool-v3-0-free
See our Excel Products:
www.pk-anexcelexpert.com/products/
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/category/blogs/charts-and-visualization/
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/category/templates/
Dashboards: www.pk-anexcelexpert.com/excel-dashboard/
Watch the best info-graphics and dynamic charts from below link:
ua-cam.com/play/PLbDvAYjpWJ7CEAHn-iuGSeLbUtFnYekHr.html
Learn and download best excel Dashboard template:
ua-cam.com/play/PLbDvAYjpWJ7CpupRYMRkXSN0L92t7nUuF.html
Learn Step by Step VBA:
ua-cam.com/play/PLbDvAYjpWJ7BcoaFQD-syOrZzNSLZycwH.html
Website:
WWW.PK-AnExcelExpert.com
Facebook:
PKAnExcelExpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5o1o8i4w
Pinterest:
www.pinterest.com/PKAnExcelExpert/
LinkedIn:
www.linkedin.com/company/pk-anexcelexpert
Twitter:
priyendra_kumar
Instagram:
pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcelexpert
Hello Friends,
In this video, you will learn how to create a Pro Gantt Chart in Excel with Data Entry Form. This is ready to use template and easy to customize. You can use it for your Project Management Dashboard.
Below is the Download link of Pro Gantt Chart in Excel with Data Entry Form:
www.pk-anexcelexpert.com/pro-gantt-chart-in-excel-with-data-entry-form
Subscribe our new UA-cam Channel:
www.youtube.com/@NeotechNavigators
Need Consulting Servicing in Power BI, Excel or VBA:
Email Us at info@PK-AnExcelExpert.Com
Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
ua-cam.com/video/kpLnxV3a1bE/v-deo.html
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/pks-utility-tool-v3-0-free
See our Excel Products:
www.pk-anexcelexpert.com/products/
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/category/blogs/charts-and-visualization/
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/category/templates/
Dashboards: www.pk-anexcelexpert.com/excel-dashboard/
Watch the best info-graphics and dynamic charts from below link:
ua-cam.com/play/PLbDvAYjpWJ7CEAHn-iuGSeLbUtFnYekHr.html
Learn and download best excel Dashboard template:
ua-cam.com/play/PLbDvAYjpWJ7CpupRYMRkXSN0L92t7nUuF.html
Learn Step by Step VBA:
ua-cam.com/play/PLbDvAYjpWJ7BcoaFQD-syOrZzNSLZycwH.html
Website:
WWW.PK-AnExcelExpert.com
Facebook:
PKAnExcelExpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5o1o8i4w
Pinterest:
www.pinterest.com/PKAnExcelExpert/
LinkedIn:
www.linkedin.com/company/pk-anexcelexpert
Twitter:
priyendra_kumar
Instagram:
pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcelexpert
Переглядів: 2 245
Відео
Credit Rating Meter Chart in Excel | | Step by Step Tutorial
Переглядів 3 тис.День тому
#creditscore #excelcharts #exceldashboard Hello Friends, In this video, we have explained how to create a Credit Rating Meter Chart in Excel. It is ready to use template for any KPI. You just need to enter the current value and Max value of your KPI. Below is the download link of Credit Rating Meter Chart in Excel: www.pk-anexcelexpert.com/credit-rating-meter-chart-in-excel Subscribe our new UA...
Vehicle Movement Register System V1.0 in Excel
Переглядів 6 тис.21 день тому
#userform #vehiclemasters #exceltemplates Hello Friends, In this video, we have demonstrate the Vehicle Movement Register System V1.0 in Excel. This is a ready to tool to manage the vehicle movements. Download link for Vehicle Movement Register System V1.0 in Excel www.pk-anexcelexpert.com/vehicle-movement-register-system-v1-0 Subscribe our new UA-cam Channel: www.youtube.com/@NeotechNavigators...
Complaint Management System V1.0 in Excel
Переглядів 13 тис.Місяць тому
#exceltemplates #userform #vba Hello Friends, In this video, we have demonstrated our new Excel VBA tool Complaint Management System V1.0. This is ready to use tool for the process of managing customer complaints or IT Ticketing or Service Request Management. It is an Excel and VBA based Tool. Data is saved in the same Excel. Download this tool from below given link: www.pk-anexcelexpert.com/co...
Project Management Students dashboard in Power BI | Step by Step tutorial
Переглядів 5 тис.Місяць тому
#projectmanagement #powerbi #businessintelligence Hello Friends, In this video, we have explained how to create a good looking Project Management Students dashboard in Power BI. This is an Education dashboard and It can be used in the Project Management Institutes. Below is the download link of Project Management Students dashboard: www.pk-anexcelexpert.com/project-management-student-dashboard-...
Magic Search and Highlight in Excel | Step by Step tutorial
Переглядів 6 тис.Місяць тому
Hello Friends, In this video, we have explained how to create a magic search and highlight in Excel using Conditional formatting, ActiveX control and form controls in Excel. Below is the download link for this file: www.pk-anexcelexpert.com/magic-search-with-highlight-in-excel Subscribe our new UA-cam Channel: www.youtube.com/@NeotechNavigators Need Consulting Servicing in Power BI, Excel or VB...
Employee and Supervisor Chart with Arrow info graphics
Переглядів 3,9 тис.2 місяці тому
#excelchart #exceltricks #visualization Hello Friends, In this video, we have explained how to create an Employee and Supervisor Chart with Arrow info graphics. Subscribe our new UA-cam Channel: www.youtube.com/@NeotechNavigators Download the practice file below link: www.pk-anexcelexpert.com/employee-and-supervisor-chart-with-arrow-info-graphics Comparative Analysis Dashboard in Power BI | Ste...
Quick date formats using formula in single cell
Переглядів 4,5 тис.3 місяці тому
Quick date formats using formula in single cell
Auto Invoicing in Excel using Formula (No VBA) | Step by Step tutorial
Переглядів 6 тис.4 місяці тому
Auto Invoicing in Excel using Formula (No VBA) | Step by Step tutorial
Birthday List Management System in Excel | Step by Step tutorial
Переглядів 4,9 тис.4 місяці тому
Birthday List Management System in Excel | Step by Step tutorial
Sales Funnel info graphics in Excel | Step by step tutorial
Переглядів 7 тис.4 місяці тому
Sales Funnel info graphics in Excel | Step by step tutorial
Dynamic chart for Top Selected Employees with GROUPBY and TAKE function
Переглядів 4,4 тис.5 місяців тому
Dynamic chart for Top Selected Employees with GROUPBY and TAKE function
HR Attrition and Head Count Analysis Dashboard in Excel | Complete Tutorial
Переглядів 21 тис.5 місяців тому
HR Attrition and Head Count Analysis Dashboard in Excel | Complete Tutorial
New Excel Functions: Master GROUPBY and PIVOTBY with Real-World Examples
Переглядів 7 тис.5 місяців тому
New Excel Functions: Master GROUPBY and PIVOTBY with Real-World Examples
Employee Performance Rating Card and Dashboard in Excel
Переглядів 20 тис.5 місяців тому
Employee Performance Rating Card and Dashboard in Excel
Printable Holiday and Event Calendar in Excel - FREE Download
Переглядів 4,4 тис.5 місяців тому
Printable Holiday and Event Calendar in Excel - FREE Download
Monthly Attendance sheet in Excel with Check boxes - FREE Download
Переглядів 38 тис.5 місяців тому
Monthly Attendance sheet in Excel with Check boxes - FREE Download
Candle info-graphics chart in Excel | Step by step tutorial
Переглядів 6 тис.6 місяців тому
Candle info-graphics chart in Excel | Step by step tutorial
Smart To-do List with Excel's New Checkbox Feature
Переглядів 26 тис.6 місяців тому
Smart To-do List with Excel's New Checkbox Feature
Discover the Magic Excel VBA UDF to Perfectly Space in Names
Переглядів 2,8 тис.6 місяців тому
Discover the Magic Excel VBA UDF to Perfectly Space in Names
Convert your boring bar chart into Stylish charts
Переглядів 6 тис.7 місяців тому
Convert your boring bar chart into Stylish charts
Data Cleaning using LAMBDA Function in Excel
Переглядів 9 тис.7 місяців тому
Data Cleaning using LAMBDA Function in Excel
Mastering Merged Queries & PIVOT Column Techniques in Power Query
Переглядів 6 тис.8 місяців тому
Mastering Merged Queries & PIVOT Column Techniques in Power Query
Revolutionize BI Sales: Power BI Dashboard Design for Mobile
Переглядів 3,3 тис.8 місяців тому
Revolutionize BI Sales: Power BI Dashboard Design for Mobile
Dynamic Moving Average in Excel: Mastering the AVERAGE + OFFSET Combo
Переглядів 7 тис.9 місяців тому
Dynamic Moving Average in Excel: Mastering the AVERAGE OFFSET Combo
Magic Search Bar V3.0: Reloaded with Multiple worksheet and Specific column Search
Переглядів 49 тис.9 місяців тому
Magic Search Bar V3.0: Reloaded with Multiple worksheet and Specific column Search
Excel BIG Update: Python is HERE! What You Need to Know NOW!
Переглядів 15 тис.9 місяців тому
Excel BIG Update: Python is HERE! What You Need to Know NOW!
How to WOW Your Boss: 3D Progress Circle in Excel 🚀
Переглядів 15 тис.10 місяців тому
How to WOW Your Boss: 3D Progress Circle in Excel 🚀
Mind-Blowing Excel Hack: 3D Waffle Charts in Just Steps
Переглядів 9 тис.10 місяців тому
Mind-Blowing Excel Hack: 3D Waffle Charts in Just Steps
New Excel Magic Search V2.0: Case-Sensitive Multi-Column Search!
Переглядів 68 тис.10 місяців тому
New Excel Magic Search V2.0: Case-Sensitive Multi-Column Search!
Great!! Can you do this on Pivot Chart??
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: ua-cam.com/video/qUX7mu20laM/v-deo.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 ua-cam.com/video/5KLQlafUpVg/v-deo.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?
Bhai, I need to know one more option in the pivot table along with these top and bottom performer conditions how can we sort them in ascending or in descending order
Thank u!
Most welcome
Thankyou so much! Very helpful in simple way!
Most welcome
Hi sir i edited my message to thank you so much for this video i had a question before but it was solved Thank you again for the explain it was awesome, clear and useful in real life
You are most welcome
why when you change the month or year the data will still the same and will not change.
Dear Brother, I followed each step but some how I can't enter the text in new password text box. What is the issue, I followed your code and checked multiple times where did I made a mistake. But the code is exactly same. Please let me know how can enable the new password text box
Great Tutorial! Thanks!
Most welcome
thanks for this stunning and practical video.
Most welcome
Thank you for this very good tutorial!
Most welcome
Excellent sir
Thanks