Advanced Excel task

$20 USD

Closed

Posted

over 7 years ago

$20 USD

Paid on delivery

I have an excel sheet which is a overview of our current projects, which is attached. One project per line. • Column A display sale signed date for this project • Column D display the name of sale person for this project • Column G display the project total sale amount • Column I display the salary earned from this project. • Column J display date for first part salary payment • Column K display amount for first part salary payment • Column L display date for second part salary payment • Column M display amount for second part salary payment • Column E display name of project leader I need some advanced filter features for this sheet. Ex filter multiple columns. I need ex to easy be able to filter/display: 1. What each sale person has been paid (first and second payment) for a selected month/year, specified by project lines 2. Total salary which have been paid to each sale person for a selected month/year 3. Total sale amount per sale person for a specified month/year 4. Total sale amount for a specified month/year 5. Make some sheets where this a being visualized by some nice looking graphs/diagrams It`s important that I will be able to add new project lines in times ahead. Task must be completed within 2 days time from the date task has been forwarded to you.

Project ID: 12762929

About the project

30 proposals

Remote project

Active 7 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

30 freelancers are bidding on average $23 USD for this job

@vsprybhanu

Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience Manipulating Data from Multiple Sheets, Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I can filter the data as your requirements. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra

$25 USD in 2 days

4.9

(41 reviews)

4.5

@nevo1234

Dear sir there is no attachment to the job... I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. feel free to contact me over the web site chat for further details brgds. Itay

$20 USD in 10 days

5.0

(5 reviews)

2.9

@mshahzeb43

Hey there, I am a graduate of Bachelors of science in Software Engineering. I have done various projects of variants types for number of people. I am a developer with skills of professional level and I exhale in graphic designing too. I am also an active member of platforms providing services to the end user and have completed number of projects of different genre there. I am a diligent, hardworking individual who has proficient English speaking and writing experience. I assure you that I am a perfect solution to all the problems you want to be solved. Feel free to contact me anytime and get yourself have a good experience of a lifetime.

$20 USD in 1 day

4.7

(2 reviews)

0.9

@jahanzaibahmed30

I think i am best with my this work . I shall be grateful to you if you will gave me the chance to work with you , I know i am a beginner but I love my work . and in any effort i am going to satisfy you . Thanks

$20 USD in 1 day

0.0

(0 reviews)

0.0

@iwanhim

I am sure that I can do this job. I have skill and experience in data processing using MS Excel, include make a pivottable, make a dashboard report, and etc.

$25 USD in 2 days

0.0

(0 reviews)

0.0

@anillachedia

i will do your work. plz send me your project thanx

$25 USD in 10 days

0.0

(0 reviews)

0.0

@dpkrathour7

Hi, My name is Deepak Rathour, I can serve for all your needs for your Excel task of your given project. I offer you to chat with me so i can have a further understanding of your needs and requirements. Thanks & Regards Deepak Rathour

$23 USD in 3 days

0.0

(0 reviews)

0.0

@sonalagrawalwk

Reading the content and making subsequent entries in Excel/Spreadsheet can be done with 100% accuracy. I have experience in putting basic formulas; conditional sorting and lookup; creating pivot tables and charts; creating macros and VBA scripts; and validating data using formulas and output numbers. I can create worksheets in excel workbook and can also do formatting or conditional formatting as desired. Basic functionality of Google worksheets is similar to Excel so it is not difficult for me to work even on Google spreadsheets. I have participated earlier in assignments to do excel data validation. Personal: Good computer skills; Good maths and English skills; Understand data confidentiality; Meticulous ; and can take instructions from clients through Email/Phone/Skype. I can speak English fluently, am available on Skype (if required by client) for understanding the guidelines related to work.

$25 USD in 3 days

0.0

(0 reviews)

0.0

@mwansamatimba19

Dear Hiring Manager, I am available to take this job. I have Microsoft Office and Data Entry Skills. I also have over 3 years work experience in data entry. Please contact me for details. Yours faithfully, Mwansa Matimba

$25 USD in 10 days

0.0

(0 reviews)

0.0

@emydlo

I'm reliable person. I can help you solve your problems with your file.I would like get more detail as well. Also i would like to know how many (aprox.) record do you have...

$30 USD in 10 days

0.0

(0 reviews)

0.0

@mehulpatel0619

In June last year, I worked on an assignment that requires web research to find contact information of various business from a particular city and filled those entry into Excel Spread Sheet. I can do this job and finished given task in given time period. Thanks

$25 USD in 2 days

0.0

(0 reviews)

0.0

@Ricardo1010

I can deliver this in 2 hours maximum

$25 USD in 0 day

0.0

(0 reviews)

0.0

@hammadjk

Solution includes using dynamic subfilters or using VBA, which ever one you prefer.

$20 USD in 1 day

0.0

(0 reviews)

0.0

@COROZCOB

Hello is a pleasure hepl you with your proyect. I have abilities with: - Data Entry - Database - Logical Functions - Financial Functions - Dynamic Pivots - Charts for analysis Please chat me. Also I can make a project that can help you with business management in excel: - Kardex: Controls inventory with simultaneous purchases and sales - Level of Accounts receivable and recovery. - Level of sales - Update product prices - Validate physical and digital inventory - Analysis of products more sold - Purchases per customer and location (workplace) of each of these clients - Discount for specific customers

$20 USD in 1 day

0.0

(0 reviews)

0.0

@amiyangshu12

Dear Client, Thanks for providing me this opportunity to place bid over the project and communicate with you. I mainly deal in web development, SEO, Android App, software testing and graphic design. Along with these I am highly proficient in excel data entry & analysis which forms a a part of the day to day job. My vision is to believe in saying no to thousands of projects, so that I can really focus on the few that are truly important and meaningful to me. I believe in deep collaboration which allows me to innovate in a way that others cannot. Although I am new to freelancing and waiting for my first project in this space, I find my expertise, skills and capabilities are perfectly blends with your project requirements. I am ready to discuss with you and looking forward to hear from you. With best Regards can u provide your email or sky-pe etc for further discussion about the project. Best Regards, Amiyangshu

$20 USD in 10 days

0.0

(0 reviews)

0.0

@problemsolverng

Hi, I am a free freelancer for your on-time delivery of your project. I'll offer 50% discount on the quoted price and deliver amid tight deadline,in exchange for a good review. Best regards, Problemsolverng.

$25 USD in 2 days

0.0

(0 reviews)

0.0

@paulbennington

I have been working with excel since I it was first intorduced. I can make a simple pivot table and help buttons to explain how to use with the filters that you list.

$20 USD in 2 days

0.0

(0 reviews)

0.0

@patilpravin19816

A proposal has not yet been provided

$25 USD in 10 days

0.0

(0 reviews)

0.0

@ioanadobrin

I think what you need is a summary pivot with the possibility to filter by desired categories and expand/collapse buttons to access the significant details. A simple refresh of the pivot will incorporate into the summary ant new record. Details instructions may be added to the file, if the user is not acquainted to Excel Pivots. In addition to that, a page with graphical representation will help follow the trends and history. Best Regards, Ioana

$25 USD in 2 days

0.0

(0 reviews)

0.0

@zare2204

Retired electrical engineer with a long experience in designing el. designs, executing electrical installations on site, making material and work specifications in excel with pricing, making time schedule and cash flow diagrams. Knowledge hurry carefully I have enough time and experience. I'm not in hurry and can do this job carefully. It's hard to say more before i see the task.

$25 USD in 4 days