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.
Beginner UI/UX Designer (Full time Internship) Category: Design, Figma, Graphic Design, UI / User Interface, User Experience Research, User Interface / IA, User Research, UX / User Experience, Web Design Budget: ₹100 - ₹500 INR
27 Aug 2025 16:03 GMT
Enforce Login Before Stripe Checkout Category: HTML, Payment Gateway Integration, PayPal API, PHP, Stripe, Web Design, Web Development, WordPress Budget: $10 - $30 USD
27 Aug 2025 16:01 GMT
Open Organize 500+ PNG Pictures Posted Category: Article Writing, Book Writing, Copy Typing, Data Entry, Data Processing, Excel, PDF, Word Budget: $250 - $750 USD
Sales Performance Power BI Dashboard Category: Business Intelligence, Data Analysis, Data Management, Data Modeling, Data Processing, Data Visualization, Excel, Power BI, Statistics, Visual Basic Budget: ₹750 - ₹1250 INR
Excel Formula Specialist Needed Category: Data Analysis, Data Entry, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic Budget: $15 - $25 USD
Small business Digital Marketing Management Category: Digital Marketing, Facebook Ads, Google Ads, Internet Marketing, Link Building, Marketing, SEO, Social Media Marketing Budget: $10 - $30 USD
27 Aug 2025 15:56 GMT
Merchant Loan Website Development Category: API Development, Database Management, Graphic Design, HTML, PHP, Web Design, Web Development Budget: $250 - $750 USD
27 Aug 2025 15:53 GMT
Hindi Voice Artist for Short Film Category: Audio Editing, Audio Production, Audio Services, Commercials, Voice Artist, Voice Assistance Devices, Voice Over, Voice Talent Budget: ₹600 - ₹1500 INR
27 Aug 2025 15:52 GMT
Elementor Website Fix and Adjust Category: Elementor, HTML, PHP, Web Design, Web Development, Website Optimization, WordPress Budget: $30 - $250 USD
