Help excel
Budget $10-11 USD
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.
Awarded to:
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.
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
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
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
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
Hello, I am available to start immediately. I look forward to the opportunity to work with you on this project. Best regards.
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!
i saw your requirement . i have good skills in excel to complete this task. if you are interested please approve to do this task.
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
Hello Sir/Madam, As per your project details(Given instructions from Sr.no.1 to Sr.no.8),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
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
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
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
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