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.
Amazonpaymentservices Pay Integration for WordPress Category: API Integration, ECommerce, Payment Gateway Integration, PayPal API, PHP, SSL, Web Design, Web Development, WooCommerce, WordPress Budget: $10 - $30 USD
17 Dec 2025 11:02 GMT
Telegram Channel Software Promotion Category: Content Strategy, Copywriting, Digital Marketing, Facebook Marketing, Internet Marketing, Marketing Strategy, Sales, Social Media Marketing Budget: $10 - $30 USD
17 Dec 2025 11:01 GMT
Boost Sales with PPC Ads - 17/12/2025 05:46 EST Category: Advertising, Conversion Rate Optimization, Google Ads, Google Adwords, Internet Marketing, Keyword Research, PPC Marketing, SEO Budget: $15 - $25 USD
17 Dec 2025 11:00 GMT
PVC Pipes Salesman Required in Kenya Category: Business Development, Customer Service, Data Entry, Excel, Internet Marketing, Lead Generation, Market Analysis, Market Research, Marketing, Sales Budget: $30 - $250 USD
17 Dec 2025 10:58 GMT
Android Auto Call Recorder Category: Android, Android App Development, Android SDK, API Development, FastAPI, IPhone, Java, Laravel, Mobile App Development, Node.js Budget: ₹12500 - ₹37500 INR
BGMI ESP App Development Category: Android, Documentation, Game Design, Game Development, IOS Development, IPad, IPhone, Mobile App Development Budget: ₹12500 - ₹37500 INR
17 Dec 2025 10:51 GMT
I need Non-Drop Instagram 5000 Followers Boost Category: Content Creation, Digital Marketing, Instagram, Instagram Marketing, Social Media Management, Social Media Marketing, Social Networking, Twitter Budget: ₹600 - ₹1500 INR
