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.
College Essay Assistance -- 2 Category: Academic Writing, Article Writing, Content Writing, English (US) Translator, Essay Writing, Ghostwriting, Proofreading, Report Writing, Research Writing, Writing Budget: $30 - $250 USD
26-Aug-2025 03:56 GMT
Convert JAR to a Webapp Category: Backend Development, Database Design, Frontend Development, J2EE, Java, JavaScript, JSP, Web Development Budget: $30 - $250 USD
Catalan to English, Spanish and French (Long term) Category: Catalan Translator, English (US) Translator, French Translator, Spanish Translator, Translation Budget: $20 Deadline: Asap (Budget: $8 - $15 AUD
26-Aug-2025 03:53 GMT
Niche Discovery: Amazon Keyword Research Category: Amazon, Data Analysis, Data Mining, Internet Marketing, Keyword Research, Link Building, Market Research, Product Research, Research, SEO Budget: $30 - $250 USD
26-Aug-2025 03:52 GMT
Daily Financial Analysis Dashboard Category: Data Analysis, Data Processing, Data Visualization, Excel, Excel Macros, Financial Analysis, Microsoft Access, Visual Basic Budget: ₹750 - ₹1250 INR
