I am seeking an Excel expert to transform an existing spreadsheets x 3 into a clean, smart form that efficiently tracks job progress and financials. The sheets will serve as a comprehensive tool to monitor all jobs for each customers (use one per project), incorporating a progress indicator with a color-coded system (dashboard sheet that takes key information from the main WIP sheet people will use and work from to go on a wall screen to highlight if a job has reached its quoted hours etc etc) Daily hours will be manually inputted on to a timesheet excel doc. The time sheet will need to take job number and link to WIP Sheet. The WIP Sheet will send key information to the wall TV Excel sheet (Dashboard) Key Requirements: - Transform the existing sheet into a user-friendly form with filters and sums etc. Its all there but needs tidy up and professional feel - Display values at the top for quick reference. - Implement a progress indicator using color codes to show job status against quoted hours. - Enable filtering by Job Status (New, WIP, Completed, Invoiced), Customer Name, and Date Range. - Include columns for quoted values and invoice details to track financials. This will allow invoice numbers and values to be added to the WIP sheet and the balance reduce down as we invoice customer. - Ensure compatibility with Excel 365. Ideal Skills and Experience: - Advanced proficiency in Excel, particularly Excel 365. - Experience in creating dynamic spreadsheets with filters and conditional formatting. - Ability to design intuitive forms and dashboards. - Strong understanding of financial tracking and reporting within Excel. The goal is to have a clear, efficient system that provides real-time insights into job progress and financial status. If you have the skills to bring this project to life, I would love to hear from you!