PK: An Excel Expert
PK: An Excel Expert
  • Видео 766
  • Просмотров 31 784 386
Credit Rating Meter Chart in Excel | | Step by Step Tutorial
#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 RUclips 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
ruclips.net/video/kpLnxV3a1bE/видео.html
Download our free Excel utility Tool and improve your p...
Просмотров: 2 116

Видео

Vehicle Movement Register System V1.0 in Excel
Просмотров 6 тыс.14 дней назад
#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 RUclips Channel: www.youtube.com/@NeotechNavigator...
Complaint Management System V1.0 in Excel
Просмотров 13 тыс.28 дней назад
#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
Просмотров 4,9 тыс.Месяц назад
#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 RUclips Channel: www.youtube.com/@NeotechNavigators Need Consulting Servicing in Power BI, Excel or V...
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 RUclips 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 | St...
Quick date formats using formula in single cell
Просмотров 4,4 тыс.3 месяца назад
Quick date formats using formula in single cell
Auto Invoicing in Excel using Formula (No VBA) | Step by Step tutorial
Просмотров 6 тыс.3 месяца назад
Auto Invoicing in Excel using Formula (No VBA) | Step by Step tutorial
Birthday List Management System in Excel | Step by Step tutorial
Просмотров 4,7 тыс.3 месяца назад
Birthday List Management System in Excel | Step by Step tutorial
Sales Funnel info graphics in Excel | Step by step tutorial
Просмотров 6 тыс.4 месяца назад
Sales Funnel info graphics in Excel | Step by step tutorial
Dynamic chart for Top Selected Employees with GROUPBY and TAKE function
Просмотров 4,3 тыс.4 месяца назад
Dynamic chart for Top Selected Employees with GROUPBY and TAKE function
HR Attrition and Head Count Analysis Dashboard in Excel | Complete Tutorial
Просмотров 20 тыс.4 месяца назад
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
Просмотров 19 тыс.5 месяцев назад
Employee Performance Rating Card and Dashboard in Excel
Printable Holiday and Event Calendar in Excel - FREE Download
Просмотров 4,2 тыс.5 месяцев назад
Printable Holiday and Event Calendar in Excel - FREE Download
Monthly Attendance sheet in Excel with Check boxes - FREE Download
Просмотров 35 тыс.5 месяцев назад
Monthly Attendance sheet in Excel with Check boxes - FREE Download
Candle info-graphics chart in Excel | Step by step tutorial
Просмотров 6 тыс.5 месяцев назад
Candle info-graphics chart in Excel | Step by step tutorial
Smart To-do List with Excel's New Checkbox Feature
Просмотров 25 тыс.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 тыс.6 месяцев назад
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 тыс.8 месяцев назад
Dynamic Moving Average in Excel: Mastering the AVERAGE OFFSET Combo
Magic Search Bar V3.0: Reloaded with Multiple worksheet and Specific column Search
Просмотров 48 тыс.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 тыс.9 месяцев назад
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!
Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!
Просмотров 478 тыс.10 месяцев назад
Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!

Комментарии

  • @JunardGemBagay-cc4sk
    @JunardGemBagay-cc4sk День назад

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

  • @waseemmohammad9957
    @waseemmohammad9957 День назад

    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 День назад

    Great Tutorial! Thanks!

  • @heidar_dev
    @heidar_dev 2 дня назад

    thanks for this stunning and practical video.

  • @DBALextras
    @DBALextras 2 дня назад

    Thank you for this very good tutorial!

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 2 дня назад

    Excellent sir

  • @rakeshyadav43
    @rakeshyadav43 2 дня назад

    Unable to download dataset for practice if possible share link where we download for practice

  • @rakeshyadav43
    @rakeshyadav43 2 дня назад

    This very beautiful Power BI dashboard Sir

  • @pratikshapagar9647
    @pratikshapagar9647 2 дня назад

    i want to use treemap but am using excwl2013 version which doesnt have treemap feature what should i do

  • @lijovarghese6377
    @lijovarghese6377 2 дня назад

    Hi bose this same thing is possible to Google sheet?

  • @aniketgharge6026
    @aniketgharge6026 2 дня назад

    Hello PK, can you create a video on how to write a dynamic email in this sheet ?

  • @francishubertovasquez2139
    @francishubertovasquez2139 2 дня назад

    Hindi ka na ba nagkasya beast sa karsunsilyo ng asawa mo na pinagtataguan mo ha.

  • @francishubertovasquez2139
    @francishubertovasquez2139 2 дня назад

    Umaangal ka yata beast ha? Kanino mo gustong ipa pet kita? He he!

  • @muhammadhashim6152
    @muhammadhashim6152 3 дня назад

    Excellent sir.

  • @MVBreakbeat1
    @MVBreakbeat1 3 дня назад

    Thank You very much for the VBA.DoEvents....I was running in circles until I saw how you used it.

  • @krishnajagadeesh6307
    @krishnajagadeesh6307 3 дня назад

    Please make monthly monthly sales chart Jan 500 Feb 1000 Mar 400 Apr 60000 May 100000 Jun 600 July Aug Sep Nov Dec

  • @user-su4tq9dn9r
    @user-su4tq9dn9r 3 дня назад

    good.🙏 please create video for vba projects.

  • @jonr6680
    @jonr6680 3 дня назад

    Trigger warning: credit rating!!

  • @pgkannan
    @pgkannan 3 дня назад

    Thank you so much PK

  • @wongpeggy4363
    @wongpeggy4363 3 дня назад

    Hi can I know how am I to work out a workers dormitory rent, electricity etc Some there are prorated charges

  • @rj_lab
    @rj_lab 3 дня назад

    Thank you Bhai! You are DOPE! Salamat from Manila!

  • @promieniowanie6628
    @promieniowanie6628 3 дня назад

    this is amazing. Thank You

  • @ZeceOAse18
    @ZeceOAse18 3 дня назад

    Great info. Many thanks!!! P.S: is possible to somehow add multiple dates for holiday? example:to add that someone is in holiday from 12-26 aug? and not to add by hand each day for each employ?

  • @dinahany233
    @dinahany233 4 дня назад

    thanks for the best project tutorial .. god bless u

  • @monikayadav4872
    @monikayadav4872 5 дней назад

    I am trying to applying this code in my data and it actually worked and created multiple workbooks but not all. I have to create 124 workbooks but it actually created only 12. When it comes to 13 its shows run time error '1004' please help to resolve the issue

  • @annabathulavekatagovindara8883
    @annabathulavekatagovindara8883 5 дней назад

    My thanks to Hon'ble PK sir It has been nine years since I retired as a transport manager and today I am very happy that they have shown me a good software Avgraju

  • @hafizsanee8929
    @hafizsanee8929 6 дней назад

    Hi sir, how if check box is TRUE, and i want it automatically insert data as '$10' in other column.. and this column can be =sum at the bottom.. pls help..

  • @tier1athlete829
    @tier1athlete829 6 дней назад

    Can I add new column continually between A & B to keep adding in new data & keep calculating the rolling average within a single row to the left of the rolling average column?

  • @luckypallu
    @luckypallu 6 дней назад

    Amazing !!! I like the way you explain.

  • @varshinigss-rz1ek
    @varshinigss-rz1ek 6 дней назад

    Check box isn't working sir! Which version of excel are u using

  • @MT-pe4pm
    @MT-pe4pm 7 дней назад

    What if I want nothing showing if the search box is blank? I don't want to show all data when the search box is blank.

  • @Altaf_Alam
    @Altaf_Alam 7 дней назад

    Sir you teach very well.. It help us a lot ❤ Sir sometimes when i reverse the order of vertical axis so it is reverses but only the categories not the series... Plz reply what is the problem there😊

  • @furqanhaider9
    @furqanhaider9 7 дней назад

    where is the link to dataset?

  • @madhuroy7604
    @madhuroy7604 8 дней назад

    Please sir add download the trial version this file

  • @madhuroy7604
    @madhuroy7604 8 дней назад

    Please sir download the trial version file

  • @viptech3491
    @viptech3491 8 дней назад

    Beautiful

  • @riadmakram5227
    @riadmakram5227 9 дней назад

    i know it's a repeated question, but i can't find (insert==>Checkbox), even when i downloaded the tutorial sample file, check boxes were (True & false) no check boxes

    • @PKAnExcelExpert
      @PKAnExcelExpert 9 дней назад

      Check boxes are available in the office 365. You can download our Utility tool to insert the quick check boxes

  • @marioalday5966
    @marioalday5966 9 дней назад

    The needle is not scalating with the remaining elements of the gauge. How can i set it to belong to the goup?

  • @marioalday5966
    @marioalday5966 9 дней назад

    sorry but i miss the macros on the downloaded workbook.

  • @ajayverma-hn3zt
    @ajayverma-hn3zt 9 дней назад

    sir in office 2016 filter function does not work . error comes now. now what to do.

  • @abhirock12
    @abhirock12 10 дней назад

    Do you have something for comparisons between multiple teams ?

  • @rkumar4950
    @rkumar4950 10 дней назад

    Can you make any user form for transport booking management

  • @shenvimangu
    @shenvimangu 10 дней назад

    This bulk emailer will work for any domain email addresses? apart from gmail? I mean recipient email

  • @zakimoustapha7296
    @zakimoustapha7296 11 дней назад

    With all my respect to you, Excel is not à multiple user system, so why are you talking about admin and privileges. In my opinion, Excel is good for a single user

  • @sharonvoosa8160
    @sharonvoosa8160 11 дней назад

    tq

  • @jefferyashiboye3734
    @jefferyashiboye3734 11 дней назад

    Trying to add sms to my project so that when I deposit a clients account he or she should receive sms can you assist me please sir

  • @jefferyashiboye3734
    @jefferyashiboye3734 11 дней назад

    I love this But sometimes let us know the truth 😂, you pay for this not download

  • @adrsh6054
    @adrsh6054 12 дней назад

    How to make this as searchable drop-down list insert coment

    • @adrsh6054
      @adrsh6054 12 дней назад

      Pls make video for this

  • @nadag.youssef1719
    @nadag.youssef1719 12 дней назад

    Thank you so much, but how do that for all months in one excel file?

  • @osoriomatucurane9511
    @osoriomatucurane9511 13 дней назад

    Savvy, outstanding! Unmatched or unparalled skill. PK, the Excel Legend