We have two Excel workbooks that are attached containing financial and cost centre data. The reports need enhancements to improve their usability, automation, and dynamic visualisation. Below are the specific tasks:
1. Dynamic Date Selection:
a) Add "From" and "To" date pickers or dropdowns in each workbook.
b) Configure the worksheets to dynamically filter data based on the selected date range.
2. Automated Calculations:
Ensure all calculations in the sheets are automated, including totals for invoices and cost centres when new rows (invoices) or columns (cost centres) are added.
3. Dynamic Graph Updates:
Configure the existing graphs to automatically adjust and update as new data (rows or columns) are added.
4. Future-Proof Design:
As mentioned above, the reports will have additional rows for invoices and new columns for cost centres added over time. Ensure that all calculations, summaries, and visualisations incorporate these updates automatically without manual intervention.
Subscriber Membership Community Manager Category: Content Creation, Content Strategy, Growth Hacking, Social Media Management, Social Media Marketing, Twitter Budget: $30 - $250 USD
Líder en Expansión de Performance Marketing Category: B2B Marketing, Business Development, Digital Marketing, Facebook Marketing, Internet Marketing, Sales Management, Search Engine Marketing (SEM), Social Media Marketing Budget: $250 - $750 USD
03-Nov-2025 22:58 GMT
Cinematic Vlog Video Editing -- 2 Category: Adobe Premiere Pro, After Effects, Color Grading, DaVinci Resolve, Final Cut Pro, Video Editing, Video Production, Videography Budget: $25 - $50 USD
03-Nov-2025 22:57 GMT
Amazon Sports Memorabilia Listing Category: Amazon, Amazon Web Services, Brand Management, Content Writing, Copywriting, Digital Marketing, EBay, Internet Marketing, Market Research, Product Descriptions Budget: $250 - $750 USD
Edit Two Happy and Fun Videos Category: A / V Editing, Adobe Premiere Pro, After Effects, Audio Editing, Final Cut Pro, Motion Graphics, Video Editing, Video Post Editing, Video Production, Video Services Budget: $10 - $30 AUD
