In Progress

Solve an Excel problem, please!

I have 4 questions for a test on Excel that I need completed right away!

Instructions:

The Vice-President, HR has asked you to do the following:

1) Create a pivot table chart summarizing the number of 2015 ratings by job level and by 2015 ratings on a separate worksheet.

2) Create an employee listing report on a separate worksheet including the following data: employee number, job level, job code, job title, Performance Rating 2014 and Performance Rating 2015. Sort the list by job level in descending order and 2015 rating in ascending order. Ensure this report is in printable format.

3) Create a graph showing year over year ratings (as %) for 2014 and 2015 as compared to the rating guidelines. Include a data table with the graph which shows the percentages below.

4) Create a powerpoint slide that includes the graph of performance ratings and identify trends in the data. Please also note any assumptions used in the preparation of the data.

Files needed to solve are attached.

Skills: Excel

See more: example accounting problem excel, example problem excel, problem solving solve excel, problem excel solve, use excel solve accounting, case problem excel 2010, accounting problem excel, solve accounting problem excel, job scheduling problem excel, finance problem excel, problem excel outputting php, javascript slide code, counting sort code mips, javascript slide transition code, solidworks problem excel, javascript slide rollover code, utf problem excel, java slide puzzle code

About the Employer:
( 4 reviews ) Toronto, Canada

Project ID: #12164219

Awarded to:

citijayamala

Expert in Excel, Excel formulas, and all excel functions, macros, lookup concepts. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Can complete on time with More

$45 CAD in 1 day
(26 Reviews)
4.4

13 freelancers are bidding on average $32 for this job

zebracaro

I can do it for you quickly and exactly

$50 CAD in 2 days
(69 Reviews)
5.5
UyangaS

I have three years of working experience in data analysis, market and consumer research area. I conduct analysis on MS excel and SPSS. I was also responsible for designing Excel based MIS reporting system, monthly and More

$35 CAD in 1 day
(6 Reviews)
2.8
Topfreelancer4

Feel fee to contact me for excel work.Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the clients.Make payment only after the work do More

$30 CAD in 1 day
(5 Reviews)
2.9
$70 CAD in 1 day
(2 Reviews)
1.6
Ramez125

Hello I have more than 3 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards

$20 CAD in 0 days
(2 Reviews)
0.8
fcueno

Accurate, fast keying skills and sound knowledge of computer applications. Proven ability to collect and manage information efficiently and accurately. Excellent written and verbal communication skills and a strong des More

$30 CAD in 1 day
(1 Review)
0.6
$25 CAD in 1 day
(0 Reviews)
0.0
saurabhkalra79

I have understood the project details and I am glad that I can finish up the work in 1 day and submit the same. On Later stage, I am also happy to make any changes as per your requirements without additional charge. More

$19 CAD in 1 day
(0 Reviews)
0.0
Tiacid

I have good work experience (I worked as Customer Service and Admin in my last office) and use Ms Office a lot in my work, I served as support office in my office now

$25 CAD in 1 day
(0 Reviews)
0.0
$25 CAD in 1 day
(1 Review)
0.0
daringlion

I have agood exp in this field and i can do this easily. i just read this now and it dinds easy. kindly provide this job to me, i have a good feedback. you can check my profile. i wont disappoint u. Kindly trust me!!

$15 CAD in 1 day
(0 Reviews)
0.0
FatmaAbdalla

i am almost work in excel and power point daily in the last 10 years. what you asked for will take only an hour from me

$25 CAD in 1 day
(0 Reviews)
0.0
ash567a1bdf6f443

hey ...... I am ready to do it....... experience and qualified working experience on office related software

$10 CAD in 1 day
(1 Review)
0.0
evertsch

Hello, I am a systems analyst with more than 7 years of experience developing Web, mobile and desktop solutions, I will be more than happy to help u!

$30 CAD in 1 day
(0 Reviews)
0.0
rahulnagpall

Hey. Seems like a fairly easily task. Looking for good reviews. I only pick up those projects which I am extremely confident of.

$25 CAD in 1 day
(0 Reviews)
0.0