Find Jobs
Hire Freelancers

Create an Excel Reporting Workbook

$30-250 USD

Completed
Posted about 7 years ago

$30-250 USD

Paid on delivery
Create a workbook that will output summary tables and graphs from raw data that will dropped into the spreadsheet on a monthly basis. On a monthly basis we will copy and paste data that will be of a consistent format into an input sheet. This data will be in time series format and will be increasing month on month. From this raw data, the workbook should automatically summarise the data in tables and charts in a presentable format. I attach a copies of sample output and input sheets for illustrative purposes. This information is sample data but matches the format we would use. The output tables in the first 3 tabs are very close to what we need, although I will pin this down once we start working.
Project ID: 12845332

About the project

35 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I am good at Excel and graphs with pivot tables. I have seen the attached document. Looking forward to discuss in the chat.
$150 USD in 2 days
5.0 (952 reviews)
8.1
8.1
35 freelancers are bidding on average $113 USD for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$150 USD in 2 days
4.9 (383 reviews)
8.1
8.1
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$200 USD in 10 days
4.9 (277 reviews)
7.7
7.7
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD in 3 days
4.9 (429 reviews)
7.7
7.7
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$150 USD in 3 days
4.9 (286 reviews)
7.2
7.2
User Avatar
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please contact me to discuss the details. Just FYI, I own a small business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$120 USD in 2 days
4.8 (188 reviews)
7.1
7.1
User Avatar
Hi there, MS Excel expert here I will prepare the required standard spreadsheet using Pivot Table where you will input your monthly data and will find the tables and graphs automatically in dashboard tab Feel free to discuss further & award THanks
$72 USD in 3 days
5.0 (82 reviews)
6.4
6.4
User Avatar
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 USD in 3 days
4.8 (120 reviews)
6.3
6.3
User Avatar
$$$$(250 Dollars)$$$$$ Hello. I can do your project according to your description and THE BEST REPORTING. I would also complete your with the highest precision . Please contact with me
$250 USD in 3 days
4.9 (141 reviews)
6.3
6.3
User Avatar
Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data from Multiple Sheets, Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra
$30 USD in 3 days
4.8 (99 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
5.0 (25 reviews)
5.1
5.1
User Avatar
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$99 USD in 2 days
4.6 (45 reviews)
5.6
5.6
User Avatar
Good day! I've read your project description and I am interested in getting this work done for you. I have an enormous amount of experience in working with Excel and I am absolutely confident that I can get this work done for you better and more neatly than anybody else here. I am also happy to let you know that my schedule is clear right now to start working on your projet immediately. You can rest assured I would get this work done for you on time covering all your requirements, if you let me handle this work for you. Thank you and I look forward to working with you. Best regards, Alex
$250 USD in 7 days
5.0 (7 reviews)
4.4
4.4
User Avatar
Greetings I am a Chartered Accountancy student and I provide a range of services majorly focusing on excel, data entry, word, accountancy and other allied services. I have been working on this platform for two years now and have got good reviews for my work. Looking at the project description I can assure you that I can execute this efficiently and can start working immediately. I am extremely flexible with time and can dedicate more than 12 hours a day on this project. I believe in making long term relationship and client satisfaction is my top priority. Looking forward to hearing from you and discuss in details. Regards Jitin Goyal
$55 USD in 2 days
4.8 (26 reviews)
4.6
4.6
User Avatar
Hey there, From the sounds of it, you need an Excel expert who can write optimized formulas, VBA code and presents data in a simple and clear way to prepare dashboard for call centre. Is that sounds about right? I have an extensive knowledge of Excel included VBA. I have also a strong database and analytic background that could be a profit in your project. I've successfuly completed many Excel projects for random clients. Always on time and budget. I worked more that five yeas as a analytics and reporting team leader in telecom call centre and prepared many dashboards there. What is your favorite way to comunicate? I there any posibility to get more details about this project? Ps. This could be one of my first projects on Freelancer.com, so give me the chance to proof that i'm really good business partner. Best regards, Rafael
$30 USD in 2 days
4.9 (17 reviews)
4.5
4.5
User Avatar
Hello, I have read your job description. I have proper experience about many data entry, research, internet research, market research, information research, data collection, data input, MS word, Excel sheet, power point etc. If you give me a chance to do that, I will try my best level for you. Best regards, Bilkis
$45 USD in 3 days
5.0 (6 reviews)
2.7
2.7
User Avatar
Your file is using Pivot Chart with slicers. It has links with External files. Your Input sheet is blank. Evidently you need macro to transfer/ restructure the data. This box has limited space and no provision for attachments. I am Mechanical Engineer, proficient in MS Access, Excel Macro, Pivot Table/charts with slicer, dashboard, functions and formulas. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Proficient in Google Sheet Worked on Macro, VB, Pivot, User Form, Google Sheets Proficiency in Office tools, SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis Completed few Contests at Freelancer For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.
$135 USD in 3 days
3.9 (9 reviews)
3.5
3.5
User Avatar
Hello, In my current work I create and optimise similar reports on daily basis. What I offer is creating an Excel report with pivot tables and charts also in a printable to pdf layout. I can provide a VBA macro if there is a need to change the view depending on needs, ex. in January it's better to present Y2Y and last 12 months results but in midyear a YTD chart is reasonable. Within 1st day I will present a raw report. 2nd day is for adjusting layout colors to brand and adding VBA. Other days are for any corrections.
$66 USD in 4 days
5.0 (1 review)
0.7
0.7
User Avatar
A proposal has not yet been provided
$138 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Oxford, United Kingdom
5.0
3
Payment method verified
Member since May 23, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.