Help excel

Job Description:

All the following instructions are to be carried out in the Performance worksheet.

1. a) Select B5:G11 and apply a Data Bar conditional format.

b) Change the color of the data bars to grey.

2. a) Select B13:G13 and apply a Green-Yellow Color Scale conditional format.

b) Apply the Format Painter to copy the conditional formatting to B26:G26.

3. a) Select B31:H37 and apply a traffic light icon conditional format.

b) Modify the format so that values >=90% get a green light, >=80% get an amber and everything else is red

4. a) Select H5:H11 and apply a conditional format to highlight the top two values.

b) Select H18:H24 and apply a conditional format to highlight values greater than 1.

5. Select A18:H24 and add a conditional formatting rule to fill the whole row with medium blue where the salesperson name matches the selection in cell L3.

6. Select B18:G24 and apply a conditional formatting rule that highlights all the cells between the values shown in F16 and G16 in red.

7. In cells L4, L5 and L6, use the lookup function of your choice to lookup the total sales, average actual/target ratio and average customer satisfaction rate for the selected salesperson in cell L3.

8. In cell L3, create a drop-down list of the names of seven salespeople.

Skills: Excel, Data Processing, Data Entry, Visual Basic, Microsoft Office

About the Client:
( 1 review ) Teaneck, United States

Project ID: #35918602

Awarded to:

(89 Reviews)

73 freelancers are bidding on average $12 for this job


Hello, I am an Excel expert and I can help you right away. Please send me a message so that we can discuss more.

$15 USD in 1 day
(512 Reviews)

1. I am an expert in Excel, sure I can assist you in the Project. Also expert in Statistics, regression analysis, Linear regression analysis, p value, ANOVAs, etc. I use excel and other statistical software like SPSS, More

$80 USD in 3 days
(91 Reviews)

Hello, I can help you. I am an expert in Microsoft Excel & Automations, Sheets Add-Ins, custom formulas, filtering, pivot tables, charts, sorting, data extraction from websites, data extraction for multiple Excel and c More

$10 USD in 1 day
(90 Reviews)

Sir, I have read the description and understood the work in better way… I’m very interested to work on this project… and ready to start work immediately, if you award me this project. I will provide 100% quality and More

$11 USD in 1 day
(72 Reviews)

Hi I have read your description carefully. I have rich experiences in ⭐ Excel, Web Scraping, formula, vba, macro, data entry. ⭐ I worked on many similar projects. I can guarantee the quality of the job. Please kindly m More

$11 USD in 1 day
(12 Reviews)

Hi Sir. I read your requiemrent and I can do this project. I am a professional Excel VBA developer, writing advance Excel formulas, Creating customized templates to automate repetitive tasks, developing dashboard More

$11 USD in 1 day
(24 Reviews)

Hello, I am available to start immediately. I look forward to the opportunity to work with you on this project. Best regards.

$10 USD in 1 day
(20 Reviews)

Hi, I am proficient in excel and i have 9+ Years of experience in Excel, i can make any reports with Automation, data cleaning , data extract, Visualization Dashboards and i shall give you 100% accuracy with timely de More

$11 USD in 1 day
(23 Reviews)

Hello Client, After carefully reading through your project description, I realized that you want me to help you with your Excel file attached. I will use my Microsoft Excel Skills and Visual Basic ability to provide y More

$10 USD in 1 day
(4 Reviews)

Hello, I see you need help in excel. I am an excel expert and I read the instructions and they are straight forward. I can deliver the work quickly and in excellent quality and a good price. Happy to chat!

$11 USD in 7 days
(7 Reviews)

i saw your requirement . i have good skills in excel to complete this task. if you are interested please approve to do this task.

$10 USD in 1 day
(2 Reviews)

Hi there! I am confident that I am the perfect candidate for this job, hence I would like to submit my proposal for your consideration. I have rich experience in Visual Basic, Data Processing, Microsoft Office, Data E More

$30 USD in 1 day
(2 Reviews)

Hello Sir/Madam, As per your project details(Given instructions from to,It is clear that what is your exact requirement, I would like to do this project ASAP by applying my technical skills if you give More

$11 USD in 7 days
(2 Reviews)

Hello, According to your project description, I am confident that the work can be completed accurately and on time. It is my pride to make you happy. It is my pleasure to bid for your job, and I will deliver in the sh More

$11 USD in 1 day
(1 Review)

Hey there, hope you are having a wonderful day. I am very interested in this project and would like to offer you my services for your project I have more than 6 years experienced in Microsoft Office (Excel, Excel Macro More

$11 USD in 1 day
(1 Review)

I'm new here and I'm trying to make a good impression and I'm not going to spare myself because I deal with Microsoft Office and Excel on a daily basis and I'll do your job efficiently and error-free. I don't do all th More

$11 USD in 7 days
(0 Reviews)

Hey , this project sounds really exciting. I know it can be a rocky road to finding the right Virtual Assistant has the skills you need, and who is actually motivated to work closely with you, and that you can trust to More

$11 USD in 7 days
(0 Reviews)

I have excellent typing and database management , Ms Office Automation experience and have served well in large companies. Above all, I am a Muslim and the glory of a Muslim is that he keeps his promise while being ho More

$10 USD in 3 days
(0 Reviews)

I can follow all your Instructions and finish it TODAY | at the LOWEST price. The money will be not a problem for us. I am also willing to provide a sample of your work to demonstrate my capabilities. I am certified More

$10 USD in 1 day
(1 Review)

Excellent typing skills. Knowledgeable of computer programming. Capable of performing and executing rapid and perfect work within Microsoft programs, google platform, and more. Responsible and independent; has time to More

$10.5 USD in 7 days
(0 Reviews)