Find Jobs
Hire Freelancers

build an excel template with pivot table, for account management

$250-750 USD

Closed
Posted almost 8 years ago

$250-750 USD

Paid on delivery
Need a template created that will allow me help me with account management. This project will not involve data entry-- just creating the template for me. I am wanting to create an Excel with all of the users of certain products. There are about 70 accounts with different products and user numbers. There are about 30 different products. It would be the same template for all of them. I then want to have a pivot table so I can view certain things across all of the accounts at once. Would be open to suggestions about doing this in Access but I am not as familiar with that program.
Project ID: 10155022

About the project

32 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

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
32 freelancers are bidding on average $354 USD for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$500 USD in 4 days
5.0 (809 reviews)
8.8
8.8
User Avatar
Hi, I would love to work on this project. I am a qualified chartered accountant (CPA equivalent). I have 8 years of professional experience in Microsoft Excel including working with financial modeling, macros and dashboards. Please contact with further details if interested. Regards CA Raghav Bansal
$333 USD in 5 days
4.9 (95 reviews)
6.6
6.6
User Avatar
Dear Sir/Madam, I’m happy to help you on this task. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project and have already done lots of similar pivot based modeling and data analysis tasks for various clients and businesses. If you'd like to view my qualifications, experience and previous work, take a look at my Freelancer Portfolio, and if you are comfortable with those please contact me. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards,
$250 USD in 2 days
5.0 (185 reviews)
6.7
6.7
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$300 USD in 5 days
4.8 (177 reviews)
7.1
7.1
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$350 USD in 10 days
4.9 (117 reviews)
6.3
6.3
User Avatar
Hello there, I am an expert in Excel and have done more than 475 spreadsheet templates here on freelancer with excellent ratings. I reviewed the requirements brief you shared and have a high level understanding of what you are looking for. However, I would need more detailed requirements like the details that you want to capture for users and products and any look and feel preferences (color combinations, logos etc.) that you may have. Based on those, would be able to suggest the best way to go about creating the template and how it will allow you to view details in pivot tables.. Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to hear from you. Thanks and Regards, Rishi
$277 USD in 5 days
4.8 (100 reviews)
6.5
6.5
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
$300 USD in 3 days
4.9 (72 reviews)
5.6
5.6
User Avatar
Dear Client, I would like to propose to build the information system based on Power Pivot. Once, we set the design we just need to change the database and this will work on new data. Please share more information about the type of template you required. Thank you. Regards, Havit Nepal
$750 USD in 14 days
5.0 (12 reviews)
5.6
5.6
User Avatar
Hello, I am interesting to your project and placed bid for your consideration. With my experience in excel formulas, template's and macro I am confident that I will able to complete your project as per timeline and requirement. I have read project desc and understand the need. I will use excel & VBA to create your template. Appreciate if we can talk thought pm before project awarded. Looking forward to hearing good news from you. Thanks & Regards, GS-Anggara
$250 USD in 3 days
4.9 (27 reviews)
4.3
4.3
User Avatar
HI, I m good at building software with Excel, Please contact me for further details of your project. Thanks!
$277 USD in 5 days
4.6 (12 reviews)
4.1
4.1
User Avatar
Hi, I am here to assist you regarding pivot table...As I have been working on related task for past years & I will be able to complete your task with quality of work..I will use some VBA coding if needed...You will be happy after getting your files....
$530 USD in 7 days
5.0 (3 reviews)
3.8
3.8
User Avatar
I am an accountant from the Philippines. I have more than 7 years of experience in the field of Accounting, Finance and Tax. I have also worked before in oDesk for three years but had to stop because I accepted a full time work here in the Philippines. I have experience in Quickbooks Pro, Quickbooks Online and SAP Business One. I can assure you that I will give my best to this engagement if ever hired.
$277 USD in 10 days
4.2 (3 reviews)
2.9
2.9
User Avatar
Dear Sir I can start the job from now. I am free from all tasks. I can design forms, query, report in access. This project meet my best skills. So I think I am the right freelancer that you are looking for. I want to say you to see my profile.
$250 USD in 2 days
4.2 (1 review)
1.1
1.1
User Avatar
Dear Sir, I read your whole job description very carefully and I understand your whole task very clearly. You can select me for a good result. Regards Moo
$333 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi! Ready to create nessesary table for you. Have a great experience with Excel. So please, feel free to message me any time.
$277 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would need to see an example of the source data in advance, along with instructions on what the required output should be. Once ascertained, I can make a start and determine whether delivery date can be brought forward
$600 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will be able to complete this project as per expectations and on time. Kindly consider.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Thank you for posting this job on Freelancer. Producing a pivot table that will allow you to view information on the customers all at once can be done. I would love to be given the opportunity to work on a dashboard that outlines key results for you, such as which products sell the best to which customers. I'm sure we can come up with things you want to see when you are looking at your data and I can absolutely help bring those figures to life. I really enjoy being able to tell a story with the data that my customers have and integrating visual elements such as charts or graphs to help the customer work with the data they have. If you have any questions please let me know. Hope to hear from you. Hoang
$250 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$277 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi From what you describe, considering the data volume only, it does not seem to me that you would require to use access instead of excel. Also, since the only functionality mentioned is the use of pivot tables to analyse data, again excel seems to be a good response. I will be happy to help you create an excel allowing you to store your accounts users and products, as well as to create templates in the same file as well as pivot tables. I am also including in this bid a remote skype base demo of how to create pivot table yourself so that you are independent in the future to evolve the excel file. Finally I am familiar with some free software tools for analysing data, with some more information about you analysis needs / requirements I would be able to give some suggestions to which ones that would best respond to your needs / requirements.
$500 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
New York, United States
5.0
7
Payment method verified
Member since Feb 18, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.