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.
Minimalist Bold Logo Design Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Typography Budget: $30 - $250 USD
28 Aug 2025 22:03 GMT
Google Ads Conversion Tracking Specialist Category: Analytics, Digital Marketing, Google Ads, Google Adwords, Google Analytics, JavaScript, Lead Generation, PHP, SEO, Website Optimization Budget: $30 - $250 AUD
28 Aug 2025 22:01 GMT
Versatile Indian Model Needed Category: 3D Animation, 3D Modelling, 3D Rendering, Acting, Character Illustration, Commercials, Fashion Modeling, Maya Budget: ₹600 - ₹15000 INR
28 Aug 2025 22:01 GMT
Humorous Cartoon Comic Illustrator Needed -- 2 Category: 2D Animation, 2D Drawing, AI Art Creation, Caricature & Cartoons, Character Illustration, Creative Design, Digital Art, Graphic Design, Illustration Budget: $30 - $250 CAD
28 Aug 2025 22:00 GMT
Excel Automation for Airbnb Management Category: Business Analysis, Data Analysis, Data Management, Excel, Excel Macros, Excel VBA, Financial Analysis, Financial Modeling, PHP, Software Architecture Budget: $30 - $250 USD
28 Aug 2025 22:00 GMT
Professional Receptionist and Admin Assistant Category: Admin Support, Appointment Setting, Customer Service, Data Entry, Email Handling, Phone Support, Time Management, Virtual Assistant Budget: ₹12000 - ₹15000 INR
28 Aug 2025 21:59 GMT
Attorney for Civil Deposition Category: Employment Law, Legal, Legal Analysis, Legal Consultation, Legal Research, Legal Writing, Research Writing Budget: min $50 USD
