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.
[Simplicity] Project for Eliot R. -- 2 Category: Audit, Data Analysis, Data Entry, Data Management, Data Processing, Legal, Legal Research, Research Budget: $15 - $25 USD
HR Meeting Support for Documentation Category: Admin Support, Business Writing, Customer Service, Data Entry, Documentation, Report Writing, Research, Time Management Budget: $250 - $750 AUD
01-Aug-2025 22:00 GMT
Ai video editing Researcher needed Category: 3D Animation, After Effects, AI Animation, AI Art Creation, AI Content Creation, AI Design, AI Graphic Design, Animation, Graphic Design, Video Editing Budget: $2 - $8 USD
3D Rendering of Residential Plans Category: 3D Architecture, 3D Design, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Architectural Rendering, Building Architecture Budget: $250 - $750 CAD
01-Aug-2025 21:55 GMT
Shopify Store Creation and Marketing Specialist Category: Digital Marketing, ECommerce, Payment Gateway Integration, Product Research, Shopify, Shopify Development, Shopify Templates, Social Media Marketing, Web Design Budget: $2 - $8 USD
01-Aug-2025 21:53 GMT
Bespoke Florist Website Redesign for E-commerce Category: Creative Design, ECommerce, Graphic Design, PHP, Shopping Cart Integration, Web Design, Web Development, Website Optimization Budget: $250 - $750 CAD
