Hiring Forecast Report

[pinkified]

Hi, I'm having a big headache trying to make my excel report look sleek (in terms of visuals/charts) when reporting to my senior management. I'm a noob when it comes to excel would really appreciate any advice/help!

I basically need to incorporate the following within 1 chart/ table that is easy to read. My management wants detailed hiring activity charted out:

- Individual dept headcounts beginning of year
- Individual dept headcount by year end
- Forecasted/Budgeted hiring month by month (which month I think there will be bums on seats)
- Actual hiring/ New joiners in that month

 

[vletm]

As Tip: Upload a Sample File to get a quicker response
with wanted sample layout.

 

[Hui]

There are a number of posts on How to Create Dashboards and Presentation styles here

Start at: http://chandoo.org/wp/welcome/

Also use the Search Box at the Top Right of every page at Chandoo.org
You may find existing samples of HR Dashboards

 

[pinkified]

Here is a sample of my current report. Thanks in advance!! Any help appreciated.

 

[vletm]

Terms ... terms ...
I found at least one term 'hiring month' ...
I basically need to incorporate the following within 1 chart/ table that is easy to read.
My management wants detailed hiring activity charted out:
- Individual dept headcounts beginning of year
- Individual dept headcount by year end
- Forecasted/Budgeted hiring month by month (which month I think there will be bums on seats)
- Actual hiring/ New joiners in that month
Maybe something more information needs or
could You name those values from that sample file?