I have an excel sheet which I want to develop into a well designed, visually appealing dashboard.
The sheet takes 5 numbers per day to be input - these cannot be extracted so require a manual input. Cash, Card, Dept A, Dept B and Dept C.
There are fields for number of staff hours at rate A, B and C per day, which is input per week - or populated from the previous week if no change.
There are also fields for a monthly input of rent value, utilities, other costs, which are divided by the number of days in the month.
The data is displayed in a table showing +/- on the previous week, and the true value of profit of Dept B and everything else by day. The days are summarized for the week. A seperate table shows the average of year to date and last 4 weeks of the daily percentages as part of a 100% week.
The weekly takings is also shown in a graph, compared to previous years.
At present it's clunky, unappealing. It needs updating and a visually appealing dashboard created which takes no maintenance other than the daily sales input and monthly costs change.
LinkedIn Lead-Gen Post Creation Category: Article Writing, B2B Marketing, Content Writing, Copywriting, Creative Writing, Graphic Design, Lead Generation, Social Media Marketing Budget: ₹12500 - ₹37500 INR
04 Nov 2025 17:04 GMT
Cybersecurity Certification Consultant for Aviation Category: Aerospace Engineering, Aviation, Cisco, Computer Security, Internet Security, Network Administration, Risk Assessment, Systems Engineering Budget: $2 - $8 AUD
04 Nov 2025 17:03 GMT
On-Site Verification in Incheon Category: GPS, Local Job, Mobile App Development, Mobile Development, Mobile Repair, Photo Editing, Photo Retouching, Photography Budget: $10 - $45 USD
04 Nov 2025 17:03 GMT
E-commerce Website Development Category: ECommerce, PHP, SEO, Web Application, Web Design, Web Development Budget: ₹2000 - ₹6000 INR
04 Nov 2025 17:01 GMT
Unlock Protected PDF File Category: Adobe Acrobat, Editing, PDF, Photoshop, Word Budget: ₹600 - ₹1500 INR
30-Second Photorealistic AI Cinematic Category: 3D Animation, 3D Modelling, 3D Rendering, AI Animation, AI Art Creation, AI Design, AI Development, AI Rendering, Animation, Illustration Budget: $30 - $250 USD
04 Nov 2025 16:57 GMT
Expand Our Fitness App Influencer Network Category: Content Creation, Digital Marketing, Email Marketing, Fitness, Health, Influencer Marketing, Lead Generation, Market Research, Social Media Management, Social Media Marketing Budget: $250 - $750 USD
04 Nov 2025 16:56 GMT
Friendly Phone Support Assistant Category: Customer Service, Customer Support, Data Entry, Data Management, Email Handling, Excel, Phone Support, Virtual Assistant Budget: $25 - $50 USD
