PK: An Excel Expert
PK: An Excel Expert
  • 767
  • 31 860 413
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
Переглядів: 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!

КОМЕНТАРІ

  • @Idan11k
    @Idan11k 6 годин тому

    Great!! Can you do this on Pivot Chart??

  • @busyshah
    @busyshah 17 годин тому

    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.

  • @Inferno-bc6og
    @Inferno-bc6og 17 годин тому

    Hello it was very helpful , facing a error stock in and out date not fetching in the summary sheet , could you help me

  • @khangara2
    @khangara2 20 годин тому

    Thank you for your neat explanation, its really helpful to learn the excel options and making dashboards.

  • @girl.dragon3289
    @girl.dragon3289 21 годину тому

    Thank you sir

  • @ericaunzo717
    @ericaunzo717 День тому

    Such an amazing video PK. I love your videos.

  • @makogemandel
    @makogemandel День тому

    This was a masterpiece. I have been trying to do the progress bar for some time now to no avail. Thank you for this.

  • @daddywelknowwell6516
    @daddywelknowwell6516 День тому

    I can not insert checkbox in each cells, how is that? thanks the INSERT Tab in my excel doesn't have insert checkbox

    • @PKAnExcelExpert
      @PKAnExcelExpert День тому

      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.

  • @VigneshKannaSuriapragasam
    @VigneshKannaSuriapragasam День тому

    Hi, could you please help me to prepare the stacked coin chart (instead of bar) in a bar chart in excel file

  • @user-cv8mb3jx6w
    @user-cv8mb3jx6w 2 дні тому

    why I can't auto size picture on user form its always bigger pls help me

  • @AryanKumar-ek6mg
    @AryanKumar-ek6mg 2 дні тому

    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

  • @MVPEruditionCenter
    @MVPEruditionCenter 2 дні тому

    Hi. I have purchased this worksheet but am not able to download it.

  • @paulmotion733
    @paulmotion733 2 дні тому

    Is there a tutorial that uses Google Sheets?

    • @PKAnExcelExpert
      @PKAnExcelExpert 2 дні тому

      Please watch below given video: ua-cam.com/video/qUX7mu20laM/v-deo.html

  • @ADARSHKUMAR-sw8yh
    @ADARSHKUMAR-sw8yh 3 дні тому

    How to share user form with end user and is it use multiple user at a time.

    • @PKAnExcelExpert
      @PKAnExcelExpert День тому

      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.

  • @fhozouri
    @fhozouri 3 дні тому

    docs.google.com/spreadsheets/d/1xKkLyEZgau7OGIlYU_xb-gXjQPHwE3QIdRvf_0u_hX4/edit?usp=drivesdk

  • @user-js7js6ny3k
    @user-js7js6ny3k 3 дні тому

    Hello.How to calculate working hours per month in dynamic calendar

  • @paulmotion733
    @paulmotion733 3 дні тому

    how to make it in excel 2016, the filter function is missing. any solution?

  • @user-gq6cg3ls7f
    @user-gq6cg3ls7f 4 дні тому

    Thank you for the video. Where can I find the dataset?

  • @nacerzerroug9925
    @nacerzerroug9925 4 дні тому

    Thanks 🎉

  • @WonDerAnh
    @WonDerAnh 4 дні тому

    Thank you! You are the Legend ^^ I'm Vietnamese

  • @abderrachidyahia845
    @abderrachidyahia845 4 дні тому

    😮من فضلك الرابط لتحميل الملف

    • @PKAnExcelExpert
      @PKAnExcelExpert 4 дні тому

      www.pk-anexcelexpert.com/pro-gantt-chart-in-excel-with-data-entry-form

  • @MrMosoani
    @MrMosoani 4 дні тому

    PK please create google sheet versions of these great Excel videos.

    • @PKAnExcelExpert
      @PKAnExcelExpert 4 дні тому

      Please watch below video ua-cam.com/video/5KLQlafUpVg/v-deo.html

  • @mra893
    @mra893 4 дні тому

    tank u man💕💕

  • @sherazahmed5533
    @sherazahmed5533 4 дні тому

    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

  • @775shahrukh
    @775shahrukh 5 днів тому

    Kia baat hy sir Kiya Baat hy

  • @kmanoj392
    @kmanoj392 5 днів тому

    Nice

  • @sainarasa
    @sainarasa 5 днів тому

    Really thanks for the session.. but monthly summary data is not updating as expected

  • @yogibhati3447
    @yogibhati3447 5 днів тому

    PK sir, could you make Gantt chart with dynamic dependency which changes the Gantt chart automatically means how to add predecessors dynamically

  • @gayathrisaiprakash1336
    @gayathrisaiprakash1336 5 днів тому

    this is amazing :)

  • @souravbehera934
    @souravbehera934 6 днів тому

    How to download this file

  • @DhritiSinha-o7k
    @DhritiSinha-o7k 6 днів тому

    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.

  • @user-et9pv9gs4m
    @user-et9pv9gs4m 6 днів тому

    بارك الله فيك اخي الكريم، مانوع لوفيس؟

  • @tausifali8662
    @tausifali8662 6 днів тому

    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

  • @berlinr7735
    @berlinr7735 6 днів тому

    Could you please explain the concept of applying (1+1/6)

  • @ransomchidi3786
    @ransomchidi3786 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??

  • @aimeriveros2
    @aimeriveros2 7 днів тому

    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 😢

  • @VanikaPal-i8v
    @VanikaPal-i8v 7 днів тому

    How can i get all the formula for attrition?

  • @ayesharehman6442
    @ayesharehman6442 7 днів тому

    I don’t have a option of this developer

  • @rosacenteno3194
    @rosacenteno3194 8 днів тому

    Hi how can I download this template thanks

  • @xvzw
    @xvzw 8 днів тому

    can I control the result?

  • @nagarajshekar5664
    @nagarajshekar5664 8 днів тому

    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

  • @mehdibakhtiari300
    @mehdibakhtiari300 8 днів тому

    Thank u!

  • @dionejessicaa
    @dionejessicaa 8 днів тому

    Thankyou so much! Very helpful in simple way!

  • @mohanedalwhaibi576
    @mohanedalwhaibi576 8 днів тому

    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

  • @JunardGemBagay-cc4sk
    @JunardGemBagay-cc4sk 9 днів тому

    why when you change the month or year the data will still the same and will not change.

  • @waseemmohammad9957
    @waseemmohammad9957 9 днів тому

    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

  • @tibibara
    @tibibara 9 днів тому

    Great Tutorial! Thanks!

  • @heidar_dev
    @heidar_dev 10 днів тому

    thanks for this stunning and practical video.

  • @DBALextras
    @DBALextras 10 днів тому

    Thank you for this very good tutorial!

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 10 днів тому

    Excellent sir