I need an Excel or Power BI expert

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?

Evner: Excel, Forretnings Analyse

Se mere: i need a local independent sales rep for my new business, i need a local wordpress expert near morro bay ca, i need a wordpress/buddypress expert, i need excel data entry, i need excel expert, i need to design few photorealistic renders of a new type of house, i need a c programmer expert in belfast, i need a facebook it expert, i need a freelance creative expert for my advertising requirements, i need an android ble expert in boston, i need a wordpress ecommerce expert, i need a wordpress website expert, i need excel freelancer, i need excel help, i need excel help in agra, i need to hire an expert in photoshop, I need someone to design a logo for a new cleaning company. , i need a social media expert that can manage media pages for a gym, I need excel work, I need a data entry expert for my multiple projects. If you have knowledge please bid. Details will be shared in message with th

Om arbejdsgiveren:
( 0 bedømmelser ) Delaware, United States

Projekt ID: #24074564

44 freelancere byder i gennemsnit $131 på dette job


Greetings! Ranked the #1 business and finance provider on since 2010, I thank you for the opportunity to work on this important project. Since 2010, I have completed more than 1,600 projects totalin Flere

$570 USD in 15 dage
(444 bedømmelser)

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 Flere

$220 USD in 4 dage
(321 bedømmelser)

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, Flere

$130 USD in 3 dage
(233 bedømmelser)

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 in 7 dage
(77 bedømmelser)

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 i Flere

$140 USD in 2 dage
(113 bedømmelser)

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 Flere

$160 USD in 7 dage
(42 bedømmelser)

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 tha Flere

$150 USD in 5 dage
(55 bedømmelser)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Flere

$100 USD in 2 dage
(140 bedømmelser)

Hi, I am an expert in Power BI and I can complete your project in a day. Please send me your files I will complete for free and will send you the link of my work, After checking the work you can decide to award me. You Flere

$45 USD in 7 dage
(87 bedømmelser)

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 på 1 dag
(167 bedømmelser)

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 in 3 dage
(89 bedømmelser)

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 in 7 dage
(97 bedømmelser)

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. • Exce Flere

$200 USD in 3 dage
(94 bedømmelser)

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, Flere

$90 USD in 2 dage
(32 bedømmelser)

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 Flere

$90 USD in 2 dage
(17 bedømmelser)

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 Flere

$30 USD på 1 dag
(39 bedømmelser)

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 Flere

$200 USD på 1 dag
(54 bedømmelser)

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 discus Flere

$100 USD in 3 dage
(16 bedømmelser)

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 solv Flere

$45 USD in 3 dage
(4 bedømmelser)

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 va Flere

$100 USD på 1 dag
(2 bedømmelser)