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.
Travel Business Website Development Category: CMS, Graphic Design, HTML, Payment Gateway Integration, PHP, SEO, Web Development, Web Design Budget: ₹1500 - ₹12500 INR
Aplicación HoloLens 2 para Medir puntos en el entorno Category: 3D Design, 3D Modelling, 3D Rendering, 3D Visualization, Augmented Reality, C#, Programming, Computer Vision, Data Visualization, Microsoft Hololens, Software Development Budget: €30 - €250 EUR
14-Oct-2025 09:56 GMT
مشروع تصميم لوجو او اي شعار Category: Digital Marketing, ECommerce, Magento, SEO, Shopify, Web Design, WooCommerce Budget: $10 - $30 USD
14-Oct-2025 09:56 GMT
Social Media Engagement Graphics Category: Adobe Illustrator, Photoshop, Graphic Design, Illustration, Logo Design, Social Media Marketing, Visual Design Budget: ₹1500 - ₹12500 INR
