![PK: An Excel Expert](/img/default-banner.jpg)
- Видео 766
- Просмотров 31 784 386
PK: An Excel Expert
Индия
Добавлен 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 RUclips 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 RUclips Channel:
www.youtube.com/@NeotechNavigators
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...
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!
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
Unable to download dataset for practice if possible share link where we download for practice
This very beautiful Power BI dashboard Sir
i want to use treemap but am using excwl2013 version which doesnt have treemap feature what should i do
Hi bose this same thing is possible to Google sheet?
Hello PK, can you create a video on how to write a dynamic email in this sheet ?
Hindi ka na ba nagkasya beast sa karsunsilyo ng asawa mo na pinagtataguan mo ha.
Umaangal ka yata beast ha? Kanino mo gustong ipa pet kita? He he!
Excellent sir.
Thank You very much for the VBA.DoEvents....I was running in circles until I saw how you used it.
Please make monthly monthly sales chart Jan 500 Feb 1000 Mar 400 Apr 60000 May 100000 Jun 600 July Aug Sep Nov Dec
Will try to create
good.🙏 please create video for vba projects.
Sure I will
Trigger warning: credit rating!!
Thank you so much PK
Most welcome
Hi can I know how am I to work out a workers dormitory rent, electricity etc Some there are prorated charges
Thank you Bhai! You are DOPE! Salamat from Manila!
Welcome 😊
this is amazing. Thank You
You're very welcome!
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?
thanks for the best project tutorial .. god bless u
Most welcome
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
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
Thanks for your valuable feedback.
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..
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?
Amazing !!! I like the way you explain.
Most welcome
Check box isn't working sir! Which version of excel are u using
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.
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😊
where is the link to dataset?
Please sir add download the trial version this file
Please sir download the trial version file
Beautiful
Thanks
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
Check boxes are available in the office 365. You can download our Utility tool to insert the quick check boxes
The needle is not scalating with the remaining elements of the gauge. How can i set it to belong to the goup?
sorry but i miss the macros on the downloaded workbook.
sir in office 2016 filter function does not work . error comes now. now what to do.
Do you have something for comparisons between multiple teams ?
Can you make any user form for transport booking management
Will create soon
This bulk emailer will work for any domain email addresses? apart from gmail? I mean recipient email
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
tq
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
I love this But sometimes let us know the truth 😂, you pay for this not download
How to make this as searchable drop-down list insert coment
Pls make video for this
Thank you so much, but how do that for all months in one excel file?
Savvy, outstanding! Unmatched or unparalled skill. PK, the Excel Legend
Thanks for your valuable feedback 🙏