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.
Remote Customer Data Entry Clerk Category: Customer Service, Data Entry, Data Management, Data Processing, Excel, Image Processing, Typing, Word Budget: $15 - $25 USD
Full-Stack E-Commerce Store Build Category: API Development, ECommerce, Full Stack Development, HTML, PHP, Vue.js, Web Development, Web Design Budget: $1500 - $3000 USD
US Construction CFO Email Leads Category: CRM, Data Collection, Data Entry, Data Management, Database Development, Email Marketing, Excel, Leads Budget: $30 - $250 USD
Luxury Estate Video Tours Gurgaon Category: After Effects, Cinematography, Color Grading, Drone Photography, Video Editing, Video Production, Video Services, Video Tours Budget: ₹600 - ₹1500 INR
Urgent Pixel-Perfect Responsive HTML Fixes Category: Bootstrap, CSS, Figma, Frontend Development, HTML, HTML5, JavaScript, Web Design, Web Development Budget: $10 - $30 USD
10-Sep-2025 21:53 GMT
Forum Setup With Badged Groups Category: Forum Software, MyBB, MySQL, Payment Gateway Integration, PHP, PhpBB, Web Development, WordPress Budget: €30 - €250 EUR
