convert excel sales tracking workbook with pivot tables to google sheets

Completed Posted Jul 6, 2015 Paid on delivery
Completed Paid on delivery

Do not bid on this unless you are an expert in Google Sheets.

We have an excel workbook that acts as our sales tracking, forecasting and reporting program (attached). It relies heavily on pivot tables for tracking. We need to move it into the collaborative space and make it more "live". We need someone to take it and make a perfect replica of it in Google Sheets.

Here is a basic orientation of the sheet:

(1st tab) summary

(Last 2 Tabs) All data is pulled from the tables on the Billed Data & Booked Data tabs

(2nd & 3rd Tabs) The data is pulled into these tabs to 1. put both data sets together, 2. make it easier to manually manipulate it for running scenarios, 3. report in certain month-by-month formats

(4th & 5th Tabs) Pivot Table printable reports

(middle tabs) printable charts for reporting common metrics

please ask any intelligent and valid questions to help determine accurate bid and completion time.

Data Entry Data Processing Database Programming Excel

Project ID: #8013501

About the project

9 proposals Remote project Active Jul 7, 2015

Awarded to:

raghav1101

Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. I have 2 years of experience in Google sheets. Please contact w More

$421 USD in 5 days
(60 Reviews)
5.9

9 freelancers are bidding on average $459 for this job

dynamitewebsol

Hello sir, i read your requirements very-well and ready to start work from now. Hope you will give me a chance to do work with you, waiting for your reply, Thank you

$500 USD in 5 days
(19 Reviews)
5.4
sajidmahmud

Hello I am sajidmahmud I see your project and i do it as your acceptation.I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,SEO,Internet Marketing,Social Media,Lead,Telemarket More

$600 USD in 10 days
(141 Reviews)
5.3
treshakhanom

Hello Sir/Madam,i am ready to start your job as per your requirement Thanks this great opportunity,if you like than we can discuss further, awaiting for your positive response.I have been working in the field of Data-E More

$400 USD in 7 days
(45 Reviews)
5.0
fatimatuzzohura

Extensive Excel and pivot table development experience Excellent familiarity with all Microsoft Office applications Strong skills in maintaining accurate Excel spreadsheets High ability to meet strict project deadli More

$555 USD in 10 days
(17 Reviews)
3.7
leelaaswanth

will give you 100% accurate and efficient output.......................................................................................

$365 USD in 10 days
(13 Reviews)
3.2
ssumit2606

I am a certified Excel expert with knowledge of advanced concepts of Excel. I can produce the replica of same sheet in Google Spreadsheet as I work day in day out in Google sheets only. Please let me know when to star More

$277 USD in 10 days
(8 Reviews)
2.8
taurusdata

I believe it is a simple process of uploading the file to Google Sheets and it will auto -convert. So will need the file in a format that can be uploaded to Google sheets, then we will have to review integrity of data More

$555 USD in 10 days
(0 Reviews)
0.0
RubyWolf1

I used Google sheets extensively in my corporate position as an event coordinator and buyer. I had to manage event expenses and budgets and created google sheets and shared it with specific people within the organizati More

$666 USD in 10 days
(0 Reviews)
0.0