Find Jobs
Hire Freelancers

I need an Excel or Power BI expert

$30-250 USD

Închis
Data postării: circa 4 ani în urmă

$30-250 USD

Plata la predare
I am struggling trying to find a solution for this problem. Scenario... Excel file with three worksheets titled 2018, 2019, and 2020. Each worksheet has the following columns... seller ID, seller name, total sales, total units. The rows contain a bunch of customers with the above information. Some customers are found on all three worksheets, some customers are only found on one or two worksheets. Every year we will add a new worksheet with that year's data. What I'm trying to get... I need a report (pivot table, power bi, ?what ever) that will pull the following data.. customer ID, customer name and let's say the 2019 and 2020 total sales figures side by side. Ideally, I would like an additional column with the differential between the two years figures. Can anyone suggest something to do this comparison for me?
ID-ul proiectului: 24074564

Despre proiect

44 propuneri
Proiect la distanță
Activ: 4 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
44 freelanceri plasează o ofertă medie de $131 USD pentru proiect
Avatarul utilizatorului
Greetings! Ranked the #1 business and finance provider on www.Freelancer.com since 2010, I thank you for the opportunity to work on this important project. Since 2010, I have completed more than 1,600 projects totaling more than $1.3 million on this site. I have created more than 800 business plans, financial and marketing plans, grant proposals, and Investor Memorandums in the past 10 years and additionally have raised debt and equity totaling more than $240 million to fund these ventures. I have completed Bachelor of Business Administration and Master of Business Administration degrees and have worked for over 1600 businesses in 150+ countries, including Fortune 100 companies such as American Express and Morgan Stanley, as well as FLIR, Rent-A-Center, Cisco, and others. Some Logistics: 1. I request 50% payment upon delivery of a 1 page project scope and 50% in a milestone released to me upon completion. 2. I use a questionnaire to gather data from you regarding your business, market and product/service. I would very much like to work with you. Please contact me through www.Freelancer.com to discuss specifics. 1. When do you want to start this project, and when do you need it completed? 2. Are you available for a discussion to ensure I understand this project. When is a good time? Thank you, Gregory Bair
$570 USD în 15 zile
4,9 (461 recenzii)
9,4
9,4
Avatarul utilizatorului
Hello, I can help you with your project - Excel or Power BI expert I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD în 4 zile
4,9 (371 recenzii)
8,1
8,1
Avatarul utilizatorului
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you need an Excel macro that will pull data from all your three sheets and put them side by side, while creating an additional table with duplicates/ differrencies. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $130* and can deliver within three days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 360 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$130 USD în 3 zile
4,9 (288 recenzii)
7,8
7,8
Avatarul utilizatorului
Greetings I am a specialist in excel and am keen to help you with the requirements. Look forward to hear from you Thanks RRC
$200 USD în 7 zile
4,9 (85 recenzii)
7,3
7,3
Avatarul utilizatorului
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Can achieve the requirement stated using Excel VBA automation. Will do it in such a way, you can use it yourselves after this one. Willing and looking forward to working with you. Thank you, Regards.
$140 USD în 2 zile
5,0 (142 recenzii)
6,7
6,7
Avatarul utilizatorului
Hi, I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more & start the project. Thanks
$70 USD în 1 zi
4,9 (259 recenzii)
6,7
6,7
Avatarul utilizatorului
Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.
$50 USD în 7 zile
5,0 (112 recenzii)
6,4
6,4
Avatarul utilizatorului
Hello, I can build the dashboard you want with the information you want in Power BI or excel as i have extensive knowledge in these 2 visualization tools andover 8 years in the field. Please check my portfolio to see my work. Thanks!
$160 USD în 7 zile
4,9 (54 recenzii)
6,7
6,7
Avatarul utilizatorului
Hi, Would you like to see a quick demo of your project on building an Excel report to pull data from your worksheet before you award the project? You can consider it professionally done in less than 24 hrs. Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time
$150 USD în 5 zile
4,9 (62 recenzii)
6,6
6,6
Avatarul utilizatorului
I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) and Power Bi dashboards development. I already done many projects of: • Excel Automation. • Excel Reports system. • Excel financial models. • Power Bi dashboards. • Data cleaning & filtration. • Excel dashboard designing. • Excel Solver. • Excel Optimization. • Outlook. • Microsoft Access. • Excel calculators. • Excel vba. • Excel Tracker. • Excel macro's. • Visualizations, Chart's, Table's. • word macro's. I have ability to do your project within your deadline, I need some discussion to make the things clear. Thanks.
$200 USD în 3 zile
4,7 (103 recenzii)
6,4
6,4
Avatarul utilizatorului
Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA.
$150 USD în 3 zile
4,9 (110 recenzii)
6,3
6,3
Avatarul utilizatorului
Hi, Keen to work on this project. I went through the project description. I am well versed with Excel and its various features like Pivot tables, HLookup, Vlookup, SUMIF, Left, Right, Index Match, drop down, filters, charts, graphs, conditional formatting, mail merge, dashboards and can provide the Excel that you are looking for. I have more than 15 years of working experience to my credit. I will be happy to answer any queries that you may have. Looking forward to your response. Thanks
$90 USD în 2 zile
4,9 (65 recenzii)
5,9
5,9
Avatarul utilizatorului
Hi there, If you do the solution in Power BI, you need to connect manually the new sheet that you add yearly thru power query, I think the best option you have it to do it through Excel VBA. You can have a Macro that will read and import the data of all the sheets in a workbook (except for the summary sheet) into a tabular format (in the summary sheet) and spit out or update a pivot table based on the summary sheet. This method is very flexible and will eliminate any manual process regardless how much new sheets you add in your workbook yearly. Please contact me if this is any of what you need. I’ll be standing by to help.
$90 USD în 2 zile
5,0 (28 recenzii)
5,1
5,1
Avatarul utilizatorului
Hi, I am Kelvin. I am an expert in business analysis, statistics and data analysis using tools such as PYTHON, R programming, Eviews, SPSS, Tableau, SAS, and Excel. Send me the details of your project and let's discuss the project further. regards, Kelvin.
$100 USD în 3 zile
4,9 (31 recenzii)
5,0
5,0
Avatarul utilizatorului
Hi, Good Day! Can share to me your file? I'll check if I can help you using pivot table. Because if not, maybe we need to use other format like power pivot or Power BI. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. Please consider my bid. I am also done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$30 USD în 1 zi
4,9 (56 recenzii)
5,0
5,0
Avatarul utilizatorului
I am Data Entry Expert, MS Word and MS Excel. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high quality
$200 USD în 1 zi
5,0 (54 recenzii)
4,5
4,5
Avatarul utilizatorului
Hello, I am an Excel/PowerBI professional and I can help you out with that problem. Can you send me the spreadsheet with the information mentioned? It would be easier to figure out a solution. Message me and let's solve this. Thanks!
$45 USD în 3 zile
5,0 (5 recenzii)
3,4
3,4
Avatarul utilizatorului
Greetings, Through the most part of my 35+ years career, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Normalized/cleaned up lot of data, collected from various sources and made it easily usable using Excel. Provided numerous solutions using Excel in the area of Budgets, Actuals, Revenue Projection, Billing, Gross margins, Project Estimates / Plan / Monitoring / Reporting, Performance Assessments, Resource Management, Timesheets etc. These required me to use lot of functions & formulas and very innovative Pivot table features. Keen to take up this assignment as I love working with Excel. Please refer to my portfolio "Excel Pivots and Charts". You will be able to combine these tables assuming they match in structure. I can show you the steps. Create Pivot showing yearwise Sales/Quantity data for Sellers. Also able to have the difference between years as value or %. If values change in these tables, it can be refreshed. Connect with me and I will be available online till 11pm IST. I will also provide instructions for doing this, if required. With this Bid Amount, I commit 4 hours of support. If the assignment gets over before that, we can use the remaining time for any other tasks you have. if proposed terms are the problem, we can discuss the same. Thank you for taking the time to read my proposal. Warm Regards
$100 USD în 1 zi
5,0 (2 recenzii)
2,5
2,5
Avatarul utilizatorului
Hi, i am good at data handling and mashing in EXCEL. I can generate the yoy report with necessary details for you. You may share sample data
$150 USD în 5 zile
5,0 (5 recenzii)
2,2
2,2
Avatarul utilizatorului
Hi, I am pretty sure I can make this work... This is a clear and classic case of cross JOIN (which essentially means including all rows from both the sides). Cross JOIN is going to solve this issue. having said that lets discuss it if you want it in Power BI or Excel. I can do it in both however, the efforts needed will be different based on our discussion e.g. if you want to share it with people or just show it as a chart or table. Because sharing it in Power Bi and on Excel means completely two different things. Awaiting your response. Thank you! Mandar
$140 USD în 7 zile
4,7 (2 recenzii)
1,9
1,9

Despre client

Steagul UNITED STATES
Delaware, United States
0,0
0
Membru din feb. 25, 2020

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.