Find Jobs
Hire Freelancers

build an excel template with pivot table, for account management

$250-750 USD

Closed
Posted about 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: 10155649

About the project

18 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
18 freelancers are bidding on average $442 USD for this job
User Avatar
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$555 USD in 10 days
4.7 (83 reviews)
6.5
6.5
User Avatar
I think you could definitely benefit from doing this in Access. There are many benefits to building a database system which I would be more than happy to discuss your project and the befit edits in more details and demo some of the projects I have worked on as well as go over my experience. Below is some background on my work and myself. I have developed numerous systems in Access (utilizing VBA). I have developed a wide range of systems from small systems used by non-profits to average size systems used by small/medium business as well as enterprise systems being used by a Fortune 50 company. I have all the necessary experience and feel that I would be a perfect fit for your project. I would be more than happy to discuss your project as well a go over my experience and demo some of the systems I have built or am building. I hope to hear from you. Background: I am a software developer with 12+ years experience. I am currently consulting for a Fortune 50 company doing work primarily in Access and Excel with VBA. I have extensive experience in other aspects of software development as well. I am employed full-time, for the last 5 years, doing .NET development. I have built several large enterprise solutions during this time. I am very knowledgable in the following: .NET, VB, C#, HTML, javascript/jQuery, SQL, Access, Excel, VBA, Flash, Actionscript, PHP. I am new to Freelancer but am trying to build a solid profile. If you would like to talk before awarding this project let me know. Hope to hear from you.
$500 USD in 20 days
4.1 (18 reviews)
5.8
5.8
User Avatar
Greetings! Could you please send me some samples of the data you have as well as some results representation mockup you'd like to see? Or at least samples of dataflow to let me propose to you a mockup to approve and implement? Please feel free to contact me. Regards, Sergey
$400 USD in 7 days
4.9 (14 reviews)
4.7
4.7
User Avatar
Sir! I'm a Certified Microsoft Office Specialist (Excel, PowerPoint, Word level Master). And i was business analyst for last 5 days for a intentional outsourcing company. No one here can match my skills when it comes to data visualization. Pivots and dashboards are mine speciality. If you still have concerns, please allow me to create something for a test to present you my skills and efficiency. I would be happy to do that. looking forward to hear from you!
$444 USD in 5 days
4.7 (3 reviews)
2.4
2.4
User Avatar
Hello there. My name is Tony and I have extensive building Pivot tables since 2004. I have built Pivot Tables in the Oil & Gas Industry to classify Reserves by Geographic region and Reserves Type (Proven, Probable and Possible). This is a very similar task and would be able to build this template for you with quick turnaround. You will be able to select dropdown items from the pivot table that allow you to view cross-sections of your data by account and/or product. You would also be allowed to view a global summary. Please contact me if you would like to discuss this project further. I look forward to speaking woth you. Tony
$444 USD in 3 days
5.0 (1 review)
0.4
0.4
User Avatar
Hi! I'm an advanced user of MS Excel. Pivot table and reports are what I have been doing for the company I work for 5 years now. My role includes extracting data and converting it to information for our management. Pivot tables are one of them. The price and time frame can still be changed based on what we can mutually agree on.
$555 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$500 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$305 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir I am the right freelancer for the project to be done. I have a strong skill on Access Database design. I can start this project right now. I will do it as soon as you need.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I also not suggesting Access. You can customise your requirement in excel which is difficult in Access. My expertise in pivot table shall make it user friendly.
$277 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Expert in Excel. Taking time off from Financial/Merchandise Planning career and can dedicate myself fully to any task. I work quickly, efficiently, and always double check my work.
$555 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I’ve already worked for 2 year as Management Consultant and 2 years as Operations Planning Manager for a big retail company, in which, for one of my responsibilities, I managed the early budget 2 years in a row for the operations department, with more than USD 12 million in my responsibility. And also builded several data analysis and templates for the operations and commercial departments. I was graduated as Civil Engineer from a top university in Brazil and data analysis is not a problem for me. It will be hard to find an excellent and professional freelancer as I am and you will be glad you did it. I am new to the freelancer website but with extensive experience in the workforce. Please feel free to contact me if you have any further questions or if you want some previous task to test my abilities.
$333 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm currently working as account manager in a sporting goods company in the Philippines. I work on the database of our consignment clients and their products for distributions with different SKU. I use excel and pivot to monitor Inventory and in analyzing the sales and distribution for each branch of my consignment accounts. I see that there could be similarities in what you need and what I'm currently doing. I suggest for your template to be a simple database type with some formulas and functions in some columns mainly for the products and user number. A simple database format can be easy to sustain especially if you have additional products.
$250 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. I have done the same template and I can send you a sample of my work to check if that's what you are looking for.
$600 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Every day working with excel, can make tables such configuration as you want, Transpose it. Low price. Short Term.
$250 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Based upon my experience, I do pivot tables all day as a director of digital marketing. If you have any questions, feel free to ask. I would love to see the hard data and how you would like to cumulate the data into an easy to view format.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$250 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Noida, India
0.0
0
Member since Apr 7, 2012

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.