1001 Freelance Projects
Latest Projects from
Freelance Marketplaces
View Project
View this project in detail
(Note: you will be redirected to external marketplace)
Project title:
Enhance and Automate Excel Reports
Posted by:
External project from PeoplePerHour
Started:
28-Nov-2024 12:07 GMT
Description:
Project Requirements:

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.
Project ID:
3410239
Project category:
Project budget:
View this project in detail
(Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
Wedding Photo Touch-Ups
Category: Photoshop, Digital Art, Image Processing, Photo Editing, Photo Retouching, PHP
Budget: $250 - $750 USD
28 Aug 2025 22:04 GMT
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
28 Aug 2025 21:58 GMT
Seasoned Deposition Attorney Needed
Category: Attorney, Employment Law, Legal, Legal Analysis, Legal Consultation, Legal Research, Legal Writing, Litigation
Budget: min $50 USD
28 Aug 2025 21:58 GMT
Modern Car Warranty Logo Design
Category: Branding, Creative Design, Graphic Design, Illustration, Logo Design, Photoshop, Visual Design
Budget: €8 - €30 EUR
28 Aug 2025 21:57 GMT
Custom Double-Sided Yard Signs -- 2
Category: Packing & Shipping, Print Design, Shipping, Sign Design
Budget: $30 - $250 USD
28 Aug 2025 21:55 GMT
.NET Real-Time Ludo Game Development
Category: .NET, .NET Core, ASP.NET, C#, Programming, PHP, Redis, SQL, Web Development
Budget: ₹5000 - ₹10000 INR
28 Aug 2025 21:54 GMT
Seeking a sales partner for AI solutions — commission-based compensation
Category: Business Intelligence, Sales
Budget: $250 - $750 USD
28 Aug 2025 21:54 GMT
Discord Server Moderator Needed
Category: Conflict Resolution, Discord, Event Planning, Social Media Management
Budget: $10 - $30 USD
28 Aug 2025 21:53 GMT
2D to 3D creation -- 3
Category: 3D Animation, 3D Logo, 3D Modelling, 3D Rendering, Banner Design, Generative Design, Graphic Design, Industrial Design, Industrial Engineering, Photoshop Design
Budget: €8 - €42 EUR
28 Aug 2025 21:51 GMT
Browse All Projects
Projects by Skills ...
android
ajax
asp
aspnet
cms
cpp
csharp
css
delphi
design
drupal
excel
facebook
flash
html
java
javascript
joomla
iphone
mysql
photoshop
php
python
ruby
seo
sql
sysadm
translate
typing
twitter
vbnet
xml
wordpress
writing
New!
Проекты на русском
(Projects in Russian)

Copyright © 2005-2024
1001 Freelance Projects