Find Jobs
Hire Freelancers

I would like to hire an Excel Expert

$30-250 USD

Đã hoàn thành
Đã đăng vào hơn 5 năm trước

$30-250 USD

Thanh toán khi bàn giao
We're a service company running a volume of ~100 appointments each day. We log each appointment in an excel table with the following info for each column: Date, servicing employee, job#, customer name(first, last; one cell), service address (street number & name, zip code; one cell), and then 4 columns pertaining to the outcome of the appointment: Complete, Authorization, Part, Reschedule. We're looking to create a pivot table in which we can display the data on a chart by technician & date. We'd like to be able to see the following info displayed: -total # of appointments -total # of appointments with missing data (no appointment outcome recorded) -total # of appointments by zip code (with ability to filter by multiple search criteria) and a few more. Will need to discuss with the person to work on this. We will potentially need to hire this person for more spreadsheets to integrate with this one (or start a database?). There is likely a simpler solution to what we're trying to achieve in the grand scheme.
Mã dự án: 17542122

Về dự án

25 đề xuất
Dự án từ xa
Hoạt động 6 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
Đã trao cho:
Avatar người dùng
Hi, I have been working with Excel as a data analyst for 5 years. I'm happy to help you creating these pivot tables. If you really have a hundred records a day it is worth considering a database solution. If you use a database for storing records and Excel works only as an interface, I can build a tool that can be used simultaneously by multiple users at the same time. Regards, Balint
$300 USD trong 4 ngày
5,0 (131 nhận xét)
7,0
7,0
25 freelancer chào giá trung bình $142 USD cho công việc này
Avatar người dùng
Hello, I can help with you in your project Excel Expert I have more than 5 years of experience in Data Entry, Data Processing, Database Programming, Excel, Visual Basic. We have worked on several similar projects before! We have worked on 380+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$180 USD trong 3 ngày
4,9 (389 nhận xét)
8,1
8,1
Avatar người dùng
Hello, I’m an expert in Excel pivot tables. Please send me a message so that we can discuss more....
$200 USD trong 3 ngày
4,9 (408 nhận xét)
7,6
7,6
Avatar người dùng
Hello! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects, including pivot tables, are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to develop some pivot tables to display data for your service company and this is something I can develop for you. I'm a very experienced and skilled MS Excel developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$200 USD trong 7 ngày
4,9 (281 nhận xét)
7,7
7,7
Avatar người dùng
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
$250 USD trong 5 ngày
4,9 (427 nhận xét)
7,1
7,1
Avatar người dùng
Hi, I will provide you a easy GUI for data filling and automation system for pivot table reporting. User will just enter data through easy to sue GUI form, which will be saved in main sheet and report will update auto. I am Excel expert with over 7 years of professional experience.I have completed over 150 Excel related projects here. Thanks
$40 USD trong 1 ngày
4,9 (277 nhận xét)
6,8
6,8
Avatar người dùng
Hello, I am an experienced Data Analyst with advanced excel skills. I can deliver you quality work really fast. I can build you a data model in excel and a fully automated dashboard that will show all the information you want. Please check my portfolio to see my work. Thanks!
$150 USD trong 3 ngày
4,9 (54 nhận xét)
6,7
6,7
Avatar người dùng
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.
$155 USD trong 3 ngày
5,0 (128 nhận xét)
6,5
6,5
Avatar người dùng
Hi, As you want creation of Pivot and charts for your existing excel sheet containing room and service database. I will design the same for you with perfect quality. Please share your data sheet so that I can do this task for you. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Mohan
$150 USD trong 3 ngày
5,0 (95 nhận xét)
6,2
6,2
Avatar người dùng
- Have good expertise in Excel programing and macros. - Based on the logged appointments containing the Date, Employee, Job#, address details and the outcome of the appointment On button clicks the the totals on the Number of appointments Data missing Listing the data based on multiple search criteria can be displayed. . My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
$70 USD trong 3 ngày
4,6 (56 nhận xét)
6,1
6,1
Avatar người dùng
Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. You can find in my portfolio a sample of a dynamic dashboard (made with pivot tables). This kind of dashboard is easy to update with new data and is fully controlled by the filters from the left side of it. I can create a custom dynamic dashboard for your data on your template (charts type, information showed, color codes, custom filters, etc.) I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$180 USD trong 3 ngày
5,0 (22 nhận xét)
5,3
5,3
Avatar người dùng
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanced Formulas, Creating Pivot table and Charts, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$250 USD trong 3 ngày
4,8 (100 nhận xét)
5,8
5,8
Avatar người dùng
Hello there!, I am highly interested in your project I read your project descriptions carefully before bidding. your 100% satisfaction is assured if you allow me to serve. First please chat with me we can talk about briefly. Regards, Sanju Peter
$100 USD trong 3 ngày
4,9 (38 nhận xét)
5,1
5,1
Avatar người dùng
Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.
$30 USD trong 1 ngày
4,9 (32 nhận xét)
4,9
4,9
Avatar người dùng
Hi, I am interested in this project. I would be happy to discuss about your requirement. Regards...................................................
$120 USD trong 5 ngày
5,0 (8 nhận xét)
4,5
4,5
Avatar người dùng
Hello, I've read through your description and I have in the past done a very similar project for a delivering agency, I would use your pivot table recommendation and probably add a dynamic pivot table that would automatically update as you added more jobs, along with a search box so that you could search for specific jobs/customers/etc without having to filter multiple times. If you had any other recommendations or things you'd like to see within the spreadsheet I would be more than happy to oblige. We can discuss this over messages if you're interested and then decide how to approach it in the best way possible to suit your needs.
$88 USD trong 2 ngày
5,0 (14 nhận xét)
3,8
3,8
Avatar người dùng
Hi, I have twenty years experience using MS Excel including developing with VBA so I'm sure I can help you with your project. I have also worked extensively with pivot tables and creating easy to use spreadsheets for clients. I would love the opportunity to discuss your project further should my bid prove acceptable. Regards steve
$105 USD trong 3 ngày
5,0 (6 nhận xét)
3,2
3,2
Avatar người dùng
Hi, I have 4+ years of experience in Excel Work . I am very Interested in your Project and also Im ready to Start Immediately. I assure you will like my Work very much and I will deliver you project timely and there will be no Delay in my Work. I will start work ASAP. I am here for long term work Relationship. So will give you 101% best output from my end, So that you consider me for Future Job. My all skills matched with your requirements, So I can easily help you to complete this project. Kindly let me know once you are here, So we can discuss further in details. Thanks and Regards, Inderjeet
$150 USD trong 4 ngày
4,5 (3 nhận xét)
3,4
3,4
Avatar người dùng
Hello, I'm VB languages expert, I have a lot of successful VBA applications and VB.NET and SQL migrations, I think I'm the expert that you're looking for.
$155 USD trong 3 ngày
5,0 (1 nhận xét)
2,4
2,4
Avatar người dùng
14+ solid years of experience in Big Data Analytics, Information Technology, Excel Expert and Information Technology. AREAS OF EXPERTISE ● Big Data Analytics ● Big Data Sales ● Data Extraction ● Excel VBA● Data Entry ● Data Processing ● Data Extraction ● Email Handling
$155 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
I am a expert in vba
$55 USD trong 3 ngày
5,0 (1 nhận xét)
0,0
0,0

Về khách hàng

Cờ của UNITED STATES
Pelham, United States
5,0
1
Phương thức thanh toán đã xác thực
Thành viên từ thg 8 9, 2018

Xác thực khách hàng

Các công việc khác từ khách hàng này

Create a 10-minute PowerPoint Slideshow
$30-250 USD
Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.