Need an Excel Expert to format a workbook and apply conditional formatting.
- or -
Post a project like this2394
$$$
- Posted:
- Proposals: 9
- Remote
- #1713995
- Awarded
Economist - BI/BA Consultant - Microsoft Certified Solution Associate - Tableau - Alteryx
Bogota
1267140352760768831116245812301581398726147104416636801744347
Description
Experience Level: Expert
Estimated project duration: 1 day or less
General information for the business: sell online
Description of every module: I have an excel workbook with different KPIs (total 7 to 8 worksheets with around 30 rows in each worksheet) and the data in the workbook.
Description of requirements/functionality: Tasks:
Apply conditional formatting to the data (monthly from June 2016 until now) in the workbook based on RAG rating. I mean I have an excel sheet containing a variable number of columns that I want to fill each cell with a colour (Red Amber or Green) based on whether the cell value is higher than, the same as, or lower than the value in the cell above it. Also, set up traffic lights in Excel to show variances between between dates.
Apply weightage to the KPIs based on RAG rating.
Format the workbook in a professional manner.
Specific technologies required: MS Excel
Extra notes: This is an urgent requirement as this shouldn't take much time for someone working on Excel
Description of every module: I have an excel workbook with different KPIs (total 7 to 8 worksheets with around 30 rows in each worksheet) and the data in the workbook.
Description of requirements/functionality: Tasks:
Apply conditional formatting to the data (monthly from June 2016 until now) in the workbook based on RAG rating. I mean I have an excel sheet containing a variable number of columns that I want to fill each cell with a colour (Red Amber or Green) based on whether the cell value is higher than, the same as, or lower than the value in the cell above it. Also, set up traffic lights in Excel to show variances between between dates.
Apply weightage to the KPIs based on RAG rating.
Format the workbook in a professional manner.
Specific technologies required: MS Excel
Extra notes: This is an urgent requirement as this shouldn't take much time for someone working on Excel
Prabu K.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
17%
Last project
6 May 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Prabu
Can you list all the conditions and share sample recordPrabu K.15 Sep 2017Can share my screen and the details if you require.
TSOLUTIONS15 Sep 2017Can you share teamviewer access?
502670
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies