Closed

excel and chart data presentation

There is an open and filled reports. I will attach the open report first. Attached below is an example of the table that summarizes the insights (at HMR folder) thatwill need to be duplicated.

You will need to filter the open and filled report by business and create charts for each based from the Hiring Manager's review stage by grade.

USP Open Report Insights:

• Red indicator for both gender & ethnicity at HMR for grades 7-10

• Amber indicator for ethnicity at HMR for grade 6 including oncology

• Red indicator for gender at HMR for grade 6 (achieved for 40% for oncology)

• Red indicator for ethnicity at HMR for grades 4/5 (same for oncology)

• Amber indicator for gender at HMR for grades 4/5 (same for oncology)

• Red indicator for both gender and ethnicity for grades 2/3 (0% for both)

USP Filled Report Insights:

• Green for gender diversity at HMR for grades 7-10

• Amber for ethnic diversity at HMR for grades 7-10

• Green for gender diversity at HMR for grade 6 including oncology

• Amber for ethnic diversity at HMR for grade 6 including oncology

• Amber for both gender (37%) and ethnicity at HMR for grades 4/5 (very close to green for gender)—this includes oncology

• Only 1 grade 3 role for oncology—Amber for both gender and ethnicity

Skills: Excel, Charts, Data Processing, Data Entry, Statistics

See more: excel macro next chart data, excel chart provide csv data, excel chart data dynamic 2003, show data macro excel chart, excel vba chart data, convert word data excel chart, change chart data vba excel, display data values excel chart using vba macros, excel chart sets data, vba excel chart csv data, excel show data chart simultaneously, excel chart data csv file, excel chart source data vba, excel data presentation maps, chart excel end data, based slider line chart data provider flex, excel chart data subsection, excel chart generated csv data, joomla display excel chart data

About the Employer:
( 20 reviews ) KIAMBU,NAIROBI, Kenya

Project ID: #22277233

84 freelancers are bidding on average $27 for this job

TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$60 USD in 1 day
(348 Reviews)
6.9
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$50 USD in 1 day
(124 Reviews)
5.9
aimefx

Hi, I am an expert in Excel and I can complete your project in 1 day. I have completed many similar projects before, you can check some of my previous works here. Auto dashboard: [login to view URL] Agent Tar More

$20 USD in 7 days
(81 Reviews)
6.0
shaily1227

Hi! I can make the charts according to reports, you want the charts in excel? Looking forward for your positive response. thanks.

$30 USD in 1 day
(127 Reviews)
6.0
pm9887

Hello, I can assist you in best way, I have good experience in many type of jobs. I am good in internet research and spreadsheet task. Would like to do some samples to gain your confidence. Let's initiate chat and disc More

$35 USD in 7 days
(68 Reviews)
5.7
razvancotofana

Hello, I am an excel and VBA professional and I would be happy to assist you with your project. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, BR, Raz More

$150 USD in 7 days
(18 Reviews)
5.3
emadkhz91

Hi I can help you in this project and I can filter the open and filled report by business and create charts it is an easy job for me I can start right now and I will finish it ASAP regards emd

$30 USD in 2 days
(2 Reviews)
5.0
BHARATBEURA

HELLO, I AM INTERESTED IN DECLARING MY CANDIDACY FOR THE EXCEL EXPERT POSITION FOR YOUR PROJECT. I AM EFFICIENT IN MICROSOFT OFFICE TOOLS AND ALSO EXPERIENCE IN SORTING DATA, CATEGORIZING ITEMS, REMOVING DUPLICATES, W More

$30 USD in 1 day
(34 Reviews)
5.0
umairabdillah12

Hi There, I can help you to create charts or formulas for your spreadsheet, i will assist you till finish, i'm excel expert with many experience over 10 years. Please kindly chat me. thanks. Regards.

$30 USD in 2 days
(11 Reviews)
4.5
ksinghrajeev

Need further input to understand the work. Can you share the input file on which the report needs to be generated.

$50 USD in 5 days
(14 Reviews)
4.0
IgeS

Hi there, Hi there, I duplicate the attached report using the data from the HMR folder and following the criteria you mentioned in this job post. My rate for this job is $30 which will take a day to complete. Please More

$30 USD in 1 day
(6 Reviews)
3.8
Prompty

Hi, i understand your requirement to be filtering the data by category and putting in the table, and coloring it according to grade. Please share your data file, will be immediately. If it is one time data or otherwise More

$20 USD in 3 days
(11 Reviews)
3.9
mowachira77

Dear Sir/Madam, I have read and understood your project requirements. You need well designed charts on HRM. I am available to provide these charts using excel charts. I have experience spanning more than 5 years in sta More

$20 USD in 1 day
(12 Reviews)
3.5
samobot

"I have 10+ years of experience working with Microsoft Excel (+VBA Macros development), PowerPoint, Word. I am also very good at capturing data from internet and organizing it in a way which becomes very easy to retrie More

$10 USD in 2 days
(6 Reviews)
2.8
hkhonsari

Hi, I can do everything in Excel :). You can see a regression dashboard in my portfolio. I'm ready to do your order perfectly

$25 USD in 2 days
(1 Review)
2.0
MWAF

Dear SIr Being a professional I am ready to provide you the qualitative services that your project will be done perfectly & in time. Further details are required for the start of the project. ***** I assured you a More

$25 USD in 7 days
(2 Reviews)
1.5
smartbookaccount

Dear Sir, I trust you are well, I am a chartered accountant and an expert in excel. I am waiting for your hearing. Many thanks, kajee

$25 USD in 1 day
(1 Review)
1.0
datailem

Bid is time spent creating reports in excel. Can give time estimate should be relatively easy. Thank you

$35 USD in 2 days
(0 Reviews)
0.0
rashidqayyum

.......

$15 USD in 1 day
(0 Reviews)
0.0
rockresource

I am an expert in the English language and I will be able to handle the task efficiently within the given time. I have experience in technical, content writing and proofreading.

$25 USD in 4 days
(0 Reviews)
0.0