I would like to hire an Excel Expert

$30-250 USD

Completed

Posted

over 5 years ago

$30-250 USD

Paid on delivery

Take two call log reports and create a pivot table for 2017 & 2018. Each pivot should have the following eight columns: Tracking# Tracking # region Caller City Source Source Detail Time of call rounded to the nearest 1/2 hour Date Receiving# Then report out on each pivot and advise on the following questions: 1. What were the top 10 tracking numbers with tracking number regions in 2017 and 2018 2. Aggregate all the caller city to advise which cities had the most calls in 2017 and 2018 3. What are the best performing Sources in 2017 and 2018 4. What are the best performing Source Details in 2017 and 2018 5. Aggregate the dates and show when are the busiest months in 2017 and 2018 6. Aggregate the time and show what are the busiest times of the day in 2017 and 2018 The final result should be one excel file, with seven tabs. 2017 Raw Dat 2017 PIvot 2017 Results 2018 Raw Data 2018 Pivot 2018 Results 2017 & 2018 combined results

Excel

Project ID: 17559055

About the project

15 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

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:

@SBITServices

Hello , I have checked the file and i can create a report as you requested. I have 2.5 years experience in Excel advanced concepts like Pivot table, Vlookup, Charts, Data analyser etc.. I can complete task within time with 100% accuracy. With Regards, Bhaskar

$60 USD in 2 days

4.9

(379 reviews)

7.4

15 freelancers are bidding on average $106 USD for this job

@sevillajk01

hi! let me share my skills to you. Just award the project to me and I will do the rest. I can deliver this task to you. thanks

$65 USD in 3 days

5.0

(18 reviews)

4.2

@Mfaisalshahzad00

Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satisfied client. I am regularly doing following kind of tasks: Take two call log reports and create a pivot table for 2017 & 2018. Each pivot should have the following eight columns: Thanks. Faisal S.

$100 USD in 3 days

5.0

(17 reviews)

3.8

@upendra169

Hello, I can create Pivot Table from given Data as per your requirement. I am an experienced Data Entry Operator and I have very good knowledge of MS Office Suite. Please message me so we can discuss further. Thanks

$170 USD in 2 days

4.8

(19 reviews)

3.7

@Baderah

Being a n investment banker, making presentation and financial models are central to our professional life. Therefore, I am advance user of MS Excel and Ms Power point. For more details kindly contact me

$30 USD in 3 days

4.9

(15 reviews)

3.3

@paulodayto08

Hi, Good Day! I am a PMO Analyst and my primary task is the creation of Financial Reports. I am exposed on different excel formulas and functions. I am also a VBA Macro developer which I think a big plus to complete this project. Feel free to message me anytime to discuss this project. Thank you

$100 USD in 2 days

5.0

(16 reviews)

3.5

@graphicdoll

Hi, I have Read Your Project Excel Expert. I am very Interested in your Project and also I am ready to Start Immediately. I assure you will like my Work very much and i will give you unlimited changes 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. Thanks and Regards, Inderjeet S-k-y-p-e "graphic doll"

$155 USD in 2 days

4.5

(3 reviews)

3.4

@Statxn

As an: 1- engineer in statistics and applied economic 2- specialized technician in Microsoft Office (graduated from Microsoft: Diploma MOS), I am available, able and ready to do this type of work in the best conditions.

$56 USD in 2 days

5.0

(1 review)

2.1

@shivashish556

Hi there, I just had a look at the files. I can take up the project and finish as you need. I can create an easy to use excel dashboard for you to fetch sorted data from raw dump too. Please feed free to contact me in chat. Regards, Shivashish Dubey

$99 USD in 2 days

4.8

(1 review)

0.0

@balaji2656

I'm interested

$80 USD in 2 days

5.0

(1 review)

0.1

@MaurizioAlfaro

Hello, My name is Maurizio Alfaro and I have been working with Advanced Excel and VIsual Basics for more than 4 years now, the reason I charge less than the others is because I live in Mexico and the minimum wage is very low (prices too). Please take a look at my portfolio. Best, Maurizio Alfaro.

$40 USD in 3 days

0.0

(0 reviews)

0.0

@mlaha

Hello, My name is Manu Lahariya. I have a MTech, BTech and 1+ year of work experience as an analytics associate. I have worked on multiple excel/VBA based tool. these tools were developed for market analysis, segmentation, pricing and multiple other client based requirements. I also have a very good hold over writing macros. I will deliver this assignment with utmost decency if given the opportunity to work on it. please let me know if my previous project details or any other information is required. -Regards Manu

$111 USD in 5 days