How To Create A Work Maintenance Manager With Dashboard & Scheduler In Excel [Free Download]

In this week’s training, I will show you how to create an incredible Work Maintenance Manager in Excel, complete with Scheduler, Dashboard & Dynamic Admin screen

#WorkMaintenanceManager #MaintenanceManager #ExcelMaintenanceSoftware

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 - Introduction
0:36 - Overview
9:00 - One Click Menu
14:50 - Browsing For Folders
16:00 - Displaying Equipment Pictures
23:30 - Adding New, Saving Orders
30:00 - Running Advanced Filters
46:00 - Loading Customer Details
52:30 - Saving Orders & Equipment
1:01:30 - Displaying Equipment Pictures
1:14:00 - Deleting Orders
1:21:00 - Saving & Updating Customers
1:22:00 - Custom Scheduler
2:00:00 - Displaying Selected Order Details
2:06:50 - Schedule Navigation
2:10:00 - Dynamic Dashboard With Pivot Tables & Slicers

JOIN OUR COMMUNITY:

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin

#WorkMaintenanceManagement #WorkOrderManagement #ExcelVBA #LearnExcel

[ccpcarlone]

Excellent job Randy
A daily maintenance report by technicians could be very useful.
Thanks again for sharing so much knowledge

[SyedMuzammilMahasanShahi]

Thank you Randy for this amazing video. I always love your work.

[salihusani]

I'm so grateful for get knowledge for free. I will appreciate if you keep releasing similar videos like this.

[alexxx]

Really excited to try this feature out! Amazing work !

[MontysHall]

Did a similar maintenance system in MS Access. Love seeing someone who echoes my internal passion for facilities….as a retired facility manager, maintaining my home has the same importance to me.

[temyraverdana]

Hi Randy, it's incredible projet.
See you next tuesday.
Thanks for your teaching

[ndingurijoseph]

Great video, thank you. I would love to see how you create a Stunning Interactive Dashboard in Excel! Showing sales, cost of sale, expenses for a multi-product business. Thanks for your teaching

[gachvangogan]

Excelente trabajo Randy, me encanta tu trabajo son geniales y espectaculares. Muchas gracias por compartir tu conocimiento.

[wkpopularmovies]

Wow. Excellent scheduling and maintenance manager,
You can add planning and reporting of daily activities to make it even better, thank you

[brenthalbach]

Awesome stuff! You continue to improve your apps every week. I’m really liking the addition of dashboards that you have been adding lately.

[josochep]

Ammazing and Always Speechless to you Mr. Randy... greeeat ... God Bless U

[primowebdesign]

wow. Awesome scheduler and maintenance manager

[mrCetus]

Randy this is amazing waiting to learn more ..I have always heard a saying that Excel cant be used as a database ..What do you think about it .

[czechyorker]

Can’t wait. This looks awesome. Thank you.

[eliastafese]

What can i say you are the best of best THANK YOU SIR.

[LarsIngeHolen]

Thank you much Randy!!! Amazing 🙏 I might have some question / request on Patreon 😊

[CloudFlyer]

Great Job Randy, thank you from the UK. I may have missed this, where do you get your Icons from for you projects, any suggestions on Icon sites?

[Acconda]

Great video, thank you. Jumping into deep end I suppose and trying to learn, mainly as a hobby and for my job as maintenance worker. So I was wondering how could I developed something that kept track of repairs implemented into this. E.g you have a component in stock, technician took a component and replaced faulty one, you can note the location of used component, the faulty component logged and at later date got fixed, then used somewhere else, so the history of that part is built up along with any parts related to it. E.g a machine and it’s hard drive for example.

[LarsIngeHolen]

Thanks Randy, cant wait … Noone like you!!!

[elmerguevara]

Amazing work! Thank you. One Suggestion in coding for determining the Last Row. Instead of using : Range("A9999").End(xlUp).Row --> maybe you can use: Range("A" & Rows.Count).End(xlUp).Row --> This way you only go down for as much as you need to instead going down all the way to 9999 then coming back up. I'm just saying if it helps speed up code