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.
YouTube Gaming Video Edit Category: Adobe Premiere Pro, Final Cut Pro, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services, Videography Budget: $10 - $30 USD
13-Jul-2025 04:01 GMT
Coaches for Women's Entrepreneurship Programs Category: Arts & Crafts, Business Analysis, Business Coaching, Business Development, Business Plans, Entrepreneurship, Market Research, Marketing, Training Development Budget: ₹12500 - ₹37500 INR
13-Jul-2025 03:58 GMT
Convert Archicad Model to Revit Category: 3D Design, 3D Modelling, 3D Rendering, 3ds Max, Architectural Engineering, Architectural Rendering, Architecture, AutoCAD, Building Information Modeling, Revit Budget: $30 - $250 AUD
13-Jul-2025 03:57 GMT
MVP of an algo trading platform Category: API Integration, Backend Development, Frontend Development, Node.js, Product Design, Python Budget: $30 - $250 USD
