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.
Customer Chat Response Setup Category: AI Chatbot Development, AI Content Creation, AI Text To Text, Automation, Chat Operation, Chatbot Integration, Customer Service Chatbot, Customer Support Budget: ₹750 - ₹1250 INR
22-Dec-2025 11:04 GMT
Logo and Gold Card Design Category: Adobe Illustrator, Photoshop, Branding, Card Design, Graphic Design, Illustration, Logo Design Budget: ₹600 - ₹700 INR
22-Dec-2025 11:03 GMT
Isometric Ingredient Assembly Animation Category: 2D Animation, 2D Animation Explainer Video, 3D Animation, 3D Modelling, After Effects, Animation, Graphic Design, Illustration, Video Editing, Visual Design Budget: ₹600 - ₹1500 INR
Professional AI Avatar Creation Category: AI Animation, AI Design, AI Text To Speech, Animation, Caricature & Cartoons, Graphic Design, Logo Design, Video Production Budget: $250 - $750 AUD
Indian ecom seller account and product listing handler Category: Amazon, Content Writing, Conversion Rate Optimization, Copywriting, Internet Marketing, Keyword Research, Product Descriptions, SEO Budget: ₹1500 - ₹12500 INR
22-Dec-2025 10:52 GMT
EBAY ACCOUNT BELOW STANDARD Category: Account Management, Content Writing, Customer Service, Digital Marketing, EBay, Market Research, Product Descriptions, SEO Budget: $30 - $250 USD
22-Dec-2025 10:51 GMT
PDF Text Conversion & Formatting Category: Data Analysis, Data Entry, Data Management, Data Processing, Data Visualization, Excel, Microsoft Office, PDF Budget: ₹12500 - ₹37500 INR