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 RU-vid Channel: www.youtube.com/@NeotechNavigators
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
Hello PK, if I don't have the filter function in my excel, what are the alternative solutions in order to populate the tasks to the corresponding month in the "calendar sheet", thank you very much.
I have Watched your ultimate speedometer videos which is really very good. Both part. But my question is can we connect it with data. Because I have connected it but is not running. Please suggest.
Sir good afternoon, I wouldlike to inform you that I don't have Microsoft 365, so I cannot use Unique formula and vstack formula, so how to do for location window in office 2007/2013 ? Please help me or guide me asap
Very useful. I am looking for a format for our company vehicles. We have 30 vehicles, and each vehicle is used by our employees for work purposes. Most of them are pickups. So I want to track the service due, KM run, and send reminders to the driver for periodical servicing in advance, if any accident, I want to record it, and fault at an employee or third person, because if it is by employee, then company will recover the repair cost from employees salary. Then I want to record traffic fines, how many accidents and traffic fines were inflicted by one employee due to his negligence and current KM, major service history, etc.. Do you have such a format?
Great tutorial PK! Thanks! (btw. about the PK 3.0 addin, it's kinda cool and I like the features and macros, but the ribbon layout, the button structure and the overall look isn't professional, I use a 29" screen but even so the ribbon doesn't fit on this big screen etc... this is important because we have to search a lot for different features, it's kinda messy and doesn't improve the work efficiency - - so if you want some help/advice to redesign your layout in xml and create an optimized ribbon structure with menu-s and different button types, then I would be happy to help to make a better pro-looking ribbon version of this pro tool!)
in below Vlookup Formula two values are given for look up and that's why it is not working but in video it is working --- how ? =Vlookup(A5&C3,'Mark Leave'! A:E,5,0) ........ how A5 and C3 both searched in Vlookup -- C3 is horizontal column also---- it is giving error to me. Please help to solve this
I want to add a neme list to the email body. And that list range keeps changing. It means Row count is fluctuating. Please teach me the way to do that.
Hello sir, I seen your video it’s help me a lot, but I have a one query that I save photo using recordno and textbox value, I use format given bellow Dim img_name As String If Dir(ThisWorkbook.Path & Application.PathSeparator & "Images", vbDirectory) = "" Then MkDir (ThisWorkbook.Path & Application.PathSeparator & "Images") End If img_name = ThisWorkbook.Path & Application.PathSeparator & "Images" & Application.PathSeparator & _ Me.txtrecord.Value & Me.txtname & ".jpg" FileCopy Me.txtimageurl.Value, img_name sh.Range("G" & iRow).Value = img_name Image saved in folder with name = (Rec001 Ajay) after search data When I update I want this changes as bellow Needs Changeses • If I change name in textbox then image name should be change, • If I change image then save image with same name in folder, • Don’t make duplicate image with another name Can you help me sir….
The procedure to buy this Vehicle Movement Register System V1.0 is very cumbersome. Please make it easy & user friendly. I like the Vehicle Movement Register System V1.0 system but alas: nor able to buy it.