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.
Metro Vancouver Instagram Promo Videographer Category: Adobe Premiere Pro, After Effects, DaVinci Resolve, Final Cut Pro, Motion Graphics, Video Editing, Video Production, Videography Budget: $30 - $250 CAD
Activate Number in WhatsApp Manager Category: Account Management, Social Media Management, Technical Support, Web Services Budget: $10 - $30 USD
28-May-2026 21:56 GMT
Condo Wall Removal Verification Category: Building Architecture, Building Design, Building Engineering, Civil Engineering, Engineering, Structural Engineering Budget: $250 - $750 USD
28-May-2026 21:55 GMT
High-Volume Email/SMS Marketing Category: Analytics, Digital Marketing, Email Marketing, Google Adwords, Internet Marketing, Mailchimp, SendGrid, Twilio Budget: $250 - $750 USD
28-May-2026 21:54 GMT
Paid Media Managers - 100% remote, ASAP, 12+ months Category: A / B Testing, Advertising, Amazon Ads, Digital Marketing, Facebook Marketing, Google Ads, Google Adwords, Internet Marketing, Marketing Strategy, Search Engine Marketing (SEM) Budget: min €36 EUR
Concrete Anchor Bolt Design for Foundation Category: AutoCAD, Building Architecture, Building Design, Civil Engineering, Construction Engineering, Engineering Drawing, Materials Engineering, Structural Engineering Budget: min $50 USD
28-May-2026 21:52 GMT
Google Ads Campaign for Product Sales Category: Advertising, Google Ads, Google Adwords, Google Analytics, Keyword Research, Lead Generation, SEO Budget: $25 - $50 USD
28-May-2026 21:47 GMT
Integrate WP, WooCommerce & Ingram Category: API Integration, HTML, Inventory Management, Order Processing, PHP, Web Development, Web Design, WooCommerce, WordPress Budget: $250 - $750 USD