Find Jobs
Hire Freelancers

I would like to hire an Excel Expert

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 17542122

Información sobre el proyecto

25 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 4 días
5,0 (131 comentarios)
7,0
7,0
25 freelancers están ofertando un promedio de $142 USD por este trabajo
Avatar del usuario
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 en 3 días
4,9 (389 comentarios)
8,1
8,1
Avatar del usuario
Hello, I’m an expert in Excel pivot tables. Please send me a message so that we can discuss more....
$200 USD en 3 días
4,9 (408 comentarios)
7,6
7,6
Avatar del usuario
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 en 7 días
4,9 (281 comentarios)
7,7
7,7
Avatar del usuario
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 en 5 días
4,9 (427 comentarios)
7,1
7,1
Avatar del usuario
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 en 1 día
4,9 (277 comentarios)
6,8
6,8
Avatar del usuario
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 en 3 días
4,9 (54 comentarios)
6,7
6,7
Avatar del usuario
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 en 3 días
5,0 (128 comentarios)
6,5
6,5
Avatar del usuario
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 en 3 días
5,0 (95 comentarios)
6,2
6,2
Avatar del usuario
- 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 en 3 días
4,6 (56 comentarios)
6,1
6,1
Avatar del usuario
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 en 3 días
5,0 (22 comentarios)
5,3
5,3
Avatar del usuario
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 en 3 días
4,8 (100 comentarios)
5,8
5,8
Avatar del usuario
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 en 3 días
4,9 (38 comentarios)
5,1
5,1
Avatar del usuario
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 en 1 día
4,9 (32 comentarios)
4,9
4,9
Avatar del usuario
Hi, I am interested in this project. I would be happy to discuss about your requirement. Regards...................................................
$120 USD en 5 días
5,0 (8 comentarios)
4,5
4,5
Avatar del usuario
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 en 2 días
5,0 (14 comentarios)
3,8
3,8
Avatar del usuario
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 en 3 días
5,0 (6 comentarios)
3,2
3,2
Avatar del usuario
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 en 4 días
4,5 (3 comentarios)
3,4
3,4
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
2,4
2,4
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am a expert in vba
$55 USD en 3 días
5,0 (1 comentario)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Pelham, United States
5,0
1
Forma de pago verificada
Miembro desde ago 9, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.