Completed

Help with Excel spreadsheet for my business

I own a construction company where we buy old homes, renovate them, and then sell them for a profit (most of the time). I have a very limited experience with Excel spreadsheets but my goal is to build one that is very user friendly, but with more of a data analysis component (charts, graphs, etc). I have separate tabs for each project with a lot of data, but I would like to have it so that the main components automatically populate to one place (the first couple of tabs can be summary tabs) so that I can always have a visual summary of all of the projects combined.

Right now this spreadsheet is very time consuming for me because I am manually inputting the data from each project to my summary tab, and also risk making typos because the data is not driven there automatically. Also, totals and averages are very important to see, but every time I add a new project, I have to revise the formulas to account for the most recent project and that also gets to be more tedious. I know excel has features that could make it automatic any time I create a new project but I don't know how to do that. Lastly, I am a visual person and work very well with charts & graphs, although I have no idea how to create those on excel. I am looking for someone that can take a look at my spreadsheet make the necessary changes to make it work much better for me.

I prefer not to make this spreadsheet public as it contains a lot of confidential material, rather I will send the spreadsheet directly to the person I hire for this job. I am looking for someone with strong Microsoft Excel skills and also someone that has experience analyzing businesses with multiple projects.

Skills: Business Analysis, Charts, Data Processing, Excel

See more: how to maintain accounts in excel sheet format, free accounting spreadsheet templates for small business, monthly business expense template, excel templates for business accounting, small business spreadsheet for income and expenses, daily income and expense excel sheet, excel templates for business, excel spreadsheet for business expenses, excel yearly business plan spreadsheet, importing multiple text files single excel spreadsheet, excel spreadsheet business forecasting plan free, locking formulas excel spreadsheet, examples excel spreadsheet small business includes salary, excel spreadsheet business plan sample, multiple formulas excel, run excel spreadsheet multiple computers, business services evaluation excel spreadsheet, excel spreadsheet formulas, excel spreadsheet formulas webpage, multiple email addresses row excel spreadsheet mail merge

About the Employer:
( 2 reviews ) Littleton, United States

Project ID: #18944112

Awarded to:

Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor More

$150 USD in 3 days
(209 Reviews)
6.8

10 freelancers are bidding on average $103 for this job

pm9887

Hi There, Need to know more about the complete job description. I have good experience in all type of backend work and spreadsheet task. Let's discuss and work together. Thanks Prakash

$50 USD in 3 days
(50 Reviews)
5.4
nvchien94

Hello there, I am an Excel coder and also I worked as business analyst at big manuf global company for 4 years. I can work with you to create the file you want. I am now working as solo freelancer so I can give foc More

$150 USD in 1 day
(55 Reviews)
4.6
jsb1156

Experienced project professional, US based, MBA, EXCEL and MS Project expert; strong estimating background, experienced with complex formulas, LOOKUPS, PIVOTS, and charts towards the delivery financial analytics. Se More

$90 USD in 3 days
(17 Reviews)
3.9
IbexEnterprises

Hi There, I am very much interested in doing this project. I am new freelancer here but having a very rich experience in MS Excel. Regards, Kundan Singh

$100 USD in 0 days
(5 Reviews)
1.7
abhimadankr

I read job description and I can do your project.I can even work on urgent basis and complete your project soon..contact me for more information

$55 USD in 2 days
(0 Reviews)
0.0
$144 USD in 2 days
(0 Reviews)
0.0
cibivjacob

Please share the details, I will try to complete the task as early as possible with great accuracy and in time. Please give me a chance. I have more than 10 years of experience in the IT field.

$55 USD in 3 days
(0 Reviews)
0.0
MirzaYaar302

I present myself if you want and expert. you will be 100% satisfied its my guarantee. For detail discussion reply me.

$100 USD in 3 days
(0 Reviews)
0.0
ikire

Dear Client, Good Day! I'm writing this proposal to express my intention to work and help you with this project. With my knowledge, skills and experience as CERTIFIED PUBLIC ACCOUNTANT will guarantee you the best and More

$138 USD in 3 days
(0 Reviews)
0.0