Find Jobs
Hire Freelancers

Create Excel template to generate report from data in Excel Sheets

$30-250 USD

Completed
Posted over 10 years ago

$30-250 USD

Paid on delivery
We require someone to design a template/dashboard in Excel that can extract data from Excel sheets and generate a professional report that can be saved or printed (A4 portrait). The report will have predefined values and will use monthly medical data associated with the use of medications (benzodiazepines & anti-psychotics) in nursing homes, including monthly statistics plus trends over time (i.e. monthly data over the period of 1 year etc). The use of pie-charts is to be avoided (other graph styles are preferred which are best suited to the report and the type of data used); and the use of colours in the report is to be limited only to areas where appropriate. This is a professional report that will be provided to corporate personnel. The report must also include a logo along with copyright information which will be supplied. We will also provide the reporting requirements and examples of the data used to the successful bidder.
Project ID: 5177950

About the project

27 proposals
Remote project
Active 10 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
Hello there. I have high Maths, Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I'm experienced with import and report tools for excel with different output formats and graphs. Please view some of my reviews in order to feel more assured I'm capable of delivering the product you want. I also provide support for any final product I develop and deliver. I would gladly appreciate this opportunity to work with you. Best regards, Bruno Martins
$110 USD in 3 days
5.0 (59 reviews)
5.4
5.4
User Avatar
Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay
$122 USD in 5 days
5.0 (810 reviews)
8.8
8.8
27 freelancers are bidding on average $146 USD for this job
User Avatar
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$200 USD in 0 day
4.9 (333 reviews)
7.7
7.7
User Avatar
Hi, I have previously been involved in a couple of projects where report is generated from Excel using Excel VBA. The report I have worked on earlier had Header/Footer, Logo, Paragraphs, tables as per specified template and charts. The report generated can be saved in Excel/ Word/ PDF format. Let me know and provide further details. Regards, Arul
$175 USD in 3 days
5.0 (175 reviews)
7.4
7.4
User Avatar
Hi, I'll be happy to help you with this but I need to see the file or have more info on the type of data that you will be providing and if possible some samples of the required report
$100 USD in 1 day
4.8 (256 reviews)
7.7
7.7
User Avatar
Dear Sir/Madam I'm happy to help you on this I am an expert in excel dashboard creation and I can develop a PERFECT model for you You can visit my profile to see my reliability ;-) If you are comfortable with those, please reply to this message.. so I can send you some sample dash board created I look forward to hearing from you Best regards Priyal
$150 USD in 3 days
5.0 (195 reviews)
6.8
6.8
User Avatar
I am an Excel expert. Please take a look at my reviews and consider me positively to discuss the project.
$134 USD in 3 days
5.0 (166 reviews)
6.5
6.5
User Avatar
Hi, I intend to generate the template with usage of VBA where ever possible to take relevant data from other sheets. I will be happy to discuss further on this requirement with you. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc.. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$200 USD in 5 days
5.0 (74 reviews)
6.1
6.1
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$222 USD in 10 days
4.9 (124 reviews)
6.3
6.3
User Avatar
Good day! Im Sonny Aldave one of the top virtual assistant provider in Freelancer.com from Philippines. Please check this link: https://www.freelancer.com/freelancers/Philippines/Virtual_Assistant/ my username is Weblazer. To be one of the top provider it requires hard work and dedication. I did similar to this project and the client was very happy with my work. I hope you will consider me for this job and i can start immediately. Im available for full time or part time job. Profile Link: http://www.freelancer.com/u/weblazer.html NOTE: Why i have 61% completion rate? Because i have lots of previous projects and i dont want to delete it im still hoping that they will give me another projects. I suggest to check my reviews: www.freelancer.com/u/weblazer.html Thanks and regards, Sonny Aldave Freelancer
$144 USD in 3 days
4.8 (44 reviews)
6.2
6.2
User Avatar
Hello! I can design a professional report/dashboard. I have over 12 years of experience in investment banking, financial research&analysis and accounting, including 4 years at a Big-4 audit firm.
$84 USD in 3 days
5.0 (65 reviews)
5.6
5.6
User Avatar
HI, Excel VBA expert here,I think you have a excel master file of data and on the basis of that file you want to generate the reports. What I can offer (based on the info you have given so far). 1. A user interface in master file that can be a form/on excel sheet on which you can select the criteria for the data you want to have on the report. 2. On the button click in the master file the required report will be generated and it will get saved, may be in the same folder as the master file on your PC or any other location on your PC. Regards.
$75 USD in 3 days
5.0 (29 reviews)
4.3
4.3
User Avatar
***I've done a similar project..********** Good Day!....I'm an Expert in Excel VBA Automation. Having 6+yrs of Exp. Have developed & designed various Excel based projects, dashboards, templates & trackers by using Excel VBA Macros and also with Advanced Excel Functions as well. Please check few of my Project samples at my Portfolio in order to know about my Excel Programming skills. Similar Project: Survey Dashboard Kindly award me the project and share with me the details. Glad to assist you. Looking forward from you.
$150 USD in 2 days
4.7 (22 reviews)
4.6
4.6
User Avatar
Hi MedeHealth, I am Dung from Viet Nam. I am interested in your project and I will do it for you. Thanks, Dung
$55 USD in 3 days
5.0 (4 reviews)
3.3
3.3
User Avatar
I am a professional software engineer. I am ready to take this work. I am expert in excel. my skill set and experience are best suitable for your requirement. Please assign this task to me I will make sure your work will be completed 100% accurate to your full satisfaction.
$77 USD in 3 days
4.9 (8 reviews)
3.2
3.2
User Avatar
A proposal has not yet been provided
$100 USD in 3 days
4.3 (2 reviews)
2.4
2.4
User Avatar
Good morning, I have more than 13 years' experience in programming, and I have made several reports in excel and powerpoint (I mention powerpoint because I use the charts from excel to feed the pages). I am also an expert in preparing formulas and macros (since I am a programmer) and so I can solve the issues to obtain the data. I think my bid is fair, but nonetheless you let me know. Looking forward to work with you. Diego Fernando Prado Riestra
$125 USD in 5 days
5.0 (3 reviews)
1.8
1.8
User Avatar
Sir or Ma'am, I am a professional data analyst with the Department of Defense specializing in advanced data modeling utilizing expert level knowledge of Microsoft Excel. I have significant experience building the type of product you are asking for. It sounds like you need several pivot tables developed which will feed into some logic functions to generate statistical data. The type of data you describe in your post sounds like mostly quantitative and temporal data which may be cross referenced by facility location. These types of data are fairly straightforward from an analytic perspective and should involve minimal manipulation from the end user of an excel report tool upon completion. Unless there is any more advanced data simple drop down boxes could be used to pull the required information from your data set and generate completed reports in whatever format you desire. Please do not hesitate to contact me for references or questions.
$50 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am an Excel, Analytics and VBA expert with 5 years of experience. I will be frank with you. Data analysis and dashboard creation is a niche job and requires a keen understanding of reporting structure. Do take a look at my Freelancer portfolio to understand my expertise in the area. http://www.freelancer.in/u/rbaby9.html. My offering towards the project: 1) Structured Reporting. 2) Advance Excel Formulae to retrieve KPI/KRI/Trends. 3) Outliers to identify Problem Statements (helps in managerial decisions). 4) Advance features using VBA (Print reports with a command, Automated emails for sending Dashboards) Regards Rohit Baby MVR InfoSols
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sirs, I am extremely proficient at data entry, data processing and the use of Microsoft Excel. My job as an accountant requires this. I have been working with Excel for over ten years and have the ability to prepare tables and design graphical representations/template of the financial information and present to management teams in organisations where I have worked in an accounting capacity. I have also prepared trend analysis which I am sure you desire for this assignment. I do understand the professional report which you are desirous of presenting to corporate personnel having done so myself on numerous occasions. The insertion of the logo and copyright information is a simple cut and paste process but I will also format these to ensure they are suitably positioned strategically on the template. Finally, I have always received commendation for completing monthly financial reports and general assignments in a timely manner. Please feel free to contact me should you need to discuss further details. Yours respectfully, J. Scott-Crossley
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
一个有效的提议尚未被提供
$200 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Adelaide, Australia
5.0
56
Payment method verified
Member since Nov 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.