Advanced Excel task

$20 USD

Cerrado

Publicado

hace más de 7 años

$20 USD

Pagado a la entrega

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.

ID del proyecto: 12762929

Información sobre el proyecto

30 propuestas

Proyecto remoto

Activo hace 7 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

30 freelancers están ofertando un promedio de $23 USD por este trabajo

@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 en 2 días

4,9

(41 comentarios)

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 en 10 días

5,0

(5 comentarios)

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 en 1 día

4,7

(2 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 2 días

0,0

(0 comentarios)

0,0

@anillachedia

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

$25 USD en 10 días

0,0

(0 comentarios)

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 en 3 días

0,0

(0 comentarios)

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 en 3 días

0,0

(0 comentarios)

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 en 10 días

0,0

(0 comentarios)

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 en 10 días

0,0

(0 comentarios)

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 en 2 días

0,0

(0 comentarios)

0,0

@Ricardo1010

I can deliver this in 2 hours maximum

$25 USD en 0 día

0,0

(0 comentarios)

0,0

@hammadjk

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

$20 USD en 1 día

0,0

(0 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 10 días

0,0

(0 comentarios)

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 en 2 días

0,0

(0 comentarios)

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 en 2 días

0,0

(0 comentarios)

0,0

@patilpravin19816

A proposal has not yet been provided

$25 USD en 10 días

0,0

(0 comentarios)

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 en 2 días

0,0

(0 comentarios)

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 en 4 días