PK's Utility Tool V3.0 - Free download
Vložit
- čas přidán 2. 06. 2024
- Hello Friends,
This is the 3rd version of PK's Utility Tool. We have added a lot of features to improve your productivity.
Download this utility Tool from below link:
www.pk-anexcelexpert.com/pks-...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...
Sir, what is left to comment. Nothing but LOTS OF THANKS
U have just created what we want and made our life very easy in our daily office work. I am using ver.2 so far. Tonight i will upgrade to ver 3. Thank you once again.
Most welcome🙏
Thank you! You are immensely generous. The amount of work and wisdom that goes in to this Utility is astounding.
My pleasure
YOU'RE awesome. So much to give away. May you receive an award that will compensate you for all you are giving to us for free.
Wow, thank you!
Lot of thanks PK.. This is just amazing. I already have said lots of praises for v2.0 but this like a bonus... The dynamic names is just what I needed and liked most.
Based on my work, here are some of the routines that if could be auitomated would make life even more easier.
1) Have a non-contigous range of cells copied to a particular email I am responding to. (not a new email)
2) Have a non-contigous range of cells copied to a new workbook as values and same format.
3) Currently your Quick Formating, under the Selection Tab, apply to Headers on the Top. It would nice to have the same with Headers on the Row Level too.
4) Since a lot of us are Dashboard users, it would great to have some Dashboard Formatted Objects that can be quickly added to the Dashboard. (Shapes, Icons, Dashboard Mockuptools)
5) Since you are an expert when it comes to shapes and charts, it would lovely to have these charts quickly adopted in our Dashboard. Example : Is there a way we create a doughnut chart and with your tool immediately apply the different beautiful guages and charts sytles based on a selection type in your tool?
6) Have a color palettes theme to select from?
7) Have a Rupee based format (lakhs, crores) custom formatting applied
Thanks a lot for your valuable ideas. I will try to incorporate in the upcoming version.
PK, thank you for the 3.0 add-in! It's seriously amazing and is making my work so much easier. Great job!
Glad you enjoy it!
Great help sir, I am enigneer and always struggle to apply formats or change in received report and make useful for my presentaion or offer a solution. This will save a lot of time and efforts. Great JOB ! please keep it up. Thanks again
Thanks, PK, this is awesome. Keep-up the good work!
Most welcome🙏
PK Thanks for building utility tool and keeping it updated with new features. Using your toolkit brings lot of simplicity to perform various data operations. I can imagine quantam of hard work goes behind designing such tools. Thanks for offering it at no cost. In future update if you may consider to add advanced mail merge functionality in toolkit. I mean advance mail merge which offers pdf file export with customized name as well sending email with dynamic attachment. Many thanks.
Thanks for your valuable feedback. I will try to incorporate it in next version.
Absolutely amazing Sir.
You're a greatness.
Really appreciate what you're doing, muchas gracias!
Some excellent tools for Excel. Thank you
Most welcome
Amazing and its free. Thank you very much!
Most welcome🙏
Excellent work: i have small suggestion if possible in file manager userform if you could add parent folder and subfolder file list it would be very much helpful . And thank you so much for sharing this kind of files which is incredibly useful and appreciated
Thank you PK. I’m excited to try version 3.0. The dynamic names is very useful as well as the pivot table manager. Most appreciated.
Thanks a lot🙏
Good morning, Mr. PK, the third version of your Utility Tool is amazing! I work for a few years with Excel and appreciate how much time (and knowledge) it must take to build such a tool! I congratulate you (and your Team?) for all of the fantistic Tools that you have provided the Excel Community and for free! Hopefully you will continue to make interesting and helpful Videos. Regards, Colin Huntley
Thanks for your valuable feedback🙏
Thank you so much this utilities ❤❤❤😊. And also please add a option for Reading Layout like WPS Office has.
Thanks sir.
Where can I download the excel file (= not ver3.0, but lecture's excel file which is diplayed on youtube screen) used in the lecture??
Thank you PK for all your efforts. Much appreciated 👍
Thanks🙏
Thank u bosssss. It's awesome Tool am using your tool for daily work .. and start using this version now onwards.. thank u once again... Thank u
You are most welcome
I just wanted to say thank you for letting me know about the free version 3.0 of the file. I am excited to give it a try and see how it can benefit our work.
Most welcome🙏
Thank you very much. Tool is really helpful
Most welcome🙏
Sir, my honorable teacher, words fail to express my full gratitude and thanks to you for the knowledge you give us. And for your detailed explanations attached to the valuable files.
Its my pleasure
Awesome Great Work 👍
Thank you so much 😀
No words to say thanks,
Most welcome
Thanks sir for these useful features
Please provide random decimal number generator from a defined range
example 29.90 to 30.10
Waiting for 4.0 😊😊😊
Very useful, thanks a lot
Glad it was helpful!
Great update. Thanks PK'S.
Most welcome🙏
Sir, can you explain, how you create or develop the excel add in?
Thank you for this
Can you add the function DownloadFile, as is present in SEO tools.
Here we have url, address, newfilename.
Please advice
Its really amazing. it helps a lot. one suggestion from my side is that if you can undo any function used by pk utility tools would be beneficial. as if you use any function and you want to undo.
Thanks for the tip! I will try to add in next version.
Thank you so much sir for all your efforts. The utility tool is very handy. Keep up the good work 👍🏻 Feature request - Convert selected range to pdf in one click 🙏🏻
Noted. Thanks
Wow, amazing work!
Thanks for share your project
Glad you like it!
Thanks Mr PK. Your utilities are very helpfull.
Thanks for your valuable feedback🙏
Excelent! Thanks for sharing!
Most welcome🙏
Hello
congratulations for this remarkable work !!!!
I have just watched your video and what a work !!!
is it possible to have a translation or can we modify to have the desired language
thank you, it's great
Please do you have a tutorial on how to email payslip to staffs at a go by clicking on one button
will create soon
Thank you the PK utility tool v3. I have a query when i install its reflect in the excel tab. but when i close excel and open it pk utility tab vanishes kindly help
Thank you for your share
Most welcome
Damn man! And for free...wow! Great one really!
Insert Check boxes
Create dynamic names
Same size and format
such a great improvement!!
Thanks for your valuable feedback
Dear sir your work is greatful. I have downloaded the excel sheet but after unzipping the sheet and going to properties the unlock option is not coming...
Plz rply me sir
Sir....Appreciate your effort to share this most helpful Excel add-in. Thank you so much❤❤❤❤❤❤❤❤❤
Most welcome🙏
Great work sir ji
आपने इसको कैसे बनाया है। इसका details एक वीडियो बनाए।
Thanks!
Most welcome🙏
Always different sir… great improvements sir
Thanks a lot
Its amezing super helpfull tool sir ...really u r great sir thankyou verymuch lot lot...lot....sirrrr❤❤❤❤love this tool
Thanks for your valuable feedback🙏
Thanks for sharing
Most welcome🙏
Hi I have joind your channel today. A lot of information I got. My request is to add one option of direct paste in filtered visible cells. It will save a lot of time for users.
Sure, will try to add in next version
Great ... Thanks for your Useful Support
Thanks🙏
Hi PK Sir, Thanks for sharing, Great Job, Appreciated if you add Merge by Rows Option, For example: In Column A, I have Division ABC 8 times repeated , DEF 5 time repeated, and i want merge instead of one by one i just in one click merge all the same rows
Sir please add - which we can send selected data as image or pdf through what's app.
Will try to add in next version
Thank you sir
I have to enable it everytime from add in ...any permenant solution. I also tried to download it again and paste it
if i create macro using this tool does it work ?
Wonderful my friend congratulations from Venezuela
Thanks🙏
Thanks teacher
Most welcome🙏
Wouahhhhh 👏👏👏👏
Thanks🙏
I will try to translate it in french
really a dedicated effort , Pivot table Manager very like / from Tamilnadu @ Thanjavur
Thanks🙏
Amazing... Thanks a lot 🙏
Most welcome🙏
Thanks for the share. It's amazing.
Most welcome
@@PKAnExcelExpert from last couple of days, I'm having this problem and can't fix it on my own. Can you help? ERROR FOUND IN CUSTOM UI XML OF USER ....... LINE 125, COLUMN 209, ERROR CODE: 0X80004005, UNKNOWN OFFICE CONTROL ID: SmartArtAddBullet
Thanks a lot Pk giving the Free PK 3.0 ADD Ins for New Financial year 23-24.
Add more features like sending selected data through WhatsApp & Email for Single or multiple people in one go. Also Multiple data to Multiple people in one go.
will try to add in next version
Thanks for all ...
Most welcome🙏
Very thankful you sir, you deserve for MVP i Don't understand why MS award to this hounr. Lots of thanks sir
Thanks for your valuable support
Sir hamara dil apka hova
PK Sir, first of all this is very useful tool for all excel users. i am very thankful you for available it to us. but I wanted to know that, is this 3.0 version works in excel 13 also??
Yes it will work
Thanks
Most welcome🙏
Thank you so much❤
Most welcome🙏
Hi sir
please make video for dynamic range of excel paste outlook mail body with signature
Hello PK, I would like to express my gratitude for this incredibly useful tool, especially considering that it's FREE!! However, I've encountered an issue while using the "Data Segregation Tool." I've noticed that it only seems to work when the data in the sheet is in a range rather than a table. When I attempt to segregate a table based on the values in one column, the results are incorrect, and each Excel files do not vary based on the different values in the column; all the files appear to be mere duplicates of the original
Sorry for the inconveniences. I will rectify it next version
i am really looking forward to it!@@PKAnExcelExpert
Add tool like all data convert in PowerPoint presentation which I make Excel..and avoid multiple time copy and past in ppt
Great
Thanks🙏
Excellent work.
How can I get this v3 tools in my computer?
Download it from our website.
Dear Sir can you please add some tool to make reconciliation easy.for example I have 2 employee list with dependend details .we need to identify new member dob correction name correction gender correction after cross check both data vise versa
Awesome
Thanks🙏
@@PKAnExcelExpert I have been following you since 2019, I guess. Big fan. I was waiting for v3 to come up. Been using v2 of the tool since the day you posted it. Kudos to you.
A great tool and useful in use, but I cannot take a step back when using any add-on
Thanks
Sir. Your tools is not working with office 365.
Dear Sir - Thanks a lot. Superb.
Most welcome🙏
Great Work
Thanks🙏
Thank you PK
Most welcome🙏
Sir where is a link to download Utility 3.0
When I download this 3.0 my anti virus software is deleting it by saying it has virus
This tool is not working at all in Office365. Will it work or not, or am not getting on my laptop.? Pls clarify.
Yes. I also tried it for Office 365 but it is not working.
Thank very much Sir.
Welcome
Great thanks good job
Thanks🙏
Good, helpful sir
Thanks
Excellent sir
Thanks🙏
Will this utility tool work in excel 2007?
No, It will work with Excel 2010 and above only.
top
Thanks🙏
Great sir
Thanks🙏
When V3.0 is available for download
It is available free of cost. download it from below webpage-
www.pk-anexcelexpert.com/pks-utility-tool-v3-0-free
@@PKAnExcelExpert thank you
Please include sum and match from a list.
will try to add in next version
Download khase kare
Link has been given in videos description box or visit our website www.PK-AnExcelExpert.Com
Halo
Hello Sir
Thank you for new version.
If possible you can add feature where I will select 3 columns and it will do text to column for all 3. My data is in text need to convert in text to general. Right now I need to repeat it 3 times text to column process.
Thank you in advance if I will get the solution or not.
Plz make worksheet function in VBA vlookup and aumifs to another workbook
ERROR FOUND WHEN I ADD IN EXCEL ADD ON..
ERROR: LINE NO. 125
COLUMN NO. 209
ERROR CODE: 0x800004005
UNKNOWN OFFICE CONTROL ID: SMARTARTADDBILLE
Sir Your tool is great but when I add in my Addin and after opening excel sheet it is showing runtime error kindly help
Lot of thanks PK.. This is just amazing. I already have said lots of praises for v2.0 but this like a bonus... The dynamic names is just what I needed and liked most.
Based on my work, here are some of the routines that if could be auitomated would make life even more easier.
1) Have a non-contigous range of cells copied to a particular email I am responding to. (not a new email)
2) Have a non-contigous range of cells copied to a new workbook as values and same format.
3) Currently your Quick Formating, under the Selection Tab, apply to Headers on the Top. It would nice to have the same with Headers on the Row Level too.
4) Since a lot of us are Dashboard users, it would great to have some Dashboard Formatted Objects that can be quickly added to the Dashboard. (Shapes, Icons, Dashboard Mockuptools)
5) Since you are an expert when it comes to shapes and charts, it would lovely to have these charts quickly adopted in our Dashboard. Example : Is there a way we create a doughnut chart and with your tool immediately apply the different beautiful guages and charts sytles based on a selection type in your tool?
6) Have a color palettes theme to select from?
7) Have a Rupee based format (lakhs, crores) custom formatting applied
Thanks a lot for your valuable ideas. I will try to incorporate in the upcoming version.