I have a headcount forecasting worksheet in workbook an ex-employee left behind that has some holes in it. I need a formula in
Headcount Forecast In Excel
Answers
Not sure of the scope of it, but you can attack this in a minimum of 2 ways. One using Countif/Sumif and the other using PivotTables. In my mind, what you are looking for is pretty straightforward, so in that case I suggest CountIf/SumIf. PivotTables can be quirky and if the data analysis doesn't involve a ton of 'whatif' meaning the grid will be static I suggest the simpler approach.
1
Whatever headcount forecasting spreadsheet you create in Excel, to be accurate, it should in some way take into account the metrics in this informative
"5 Must-Have Metrics to Create an
https://www.proformative.com/whitepapers/5-must-have-metrics-create-hr-value-center
It breaks it down into these five areas: Recruitment/Retention, Productivity/Goals, Employee Engagement, Compensation and Benefits.
Plus, this free "Excel Shortcuts Cheat Sheet"
https://www.proformative.com/whitepapers/excel-shortcuts-cheat-sheet
Enjoy!
Best... Sarah
David, I would be interested in this resource and so may other members of the Proformative community. Proformative does allow the posting of resources. Resources is a main site navigation tab. You could post the resource and then share the link in a response to Jerry to get the resource out to the community and "close the loop" with Jerry in addition to sharing your resource with the Proformative community.
David, I saw that you posted the resource, but I did not see the attachment.
2
Tim,
Try it again, hopefully it worked this time. Let me know if it helps at all.
https://www.proformative.com/resources/employee-raises-grid-month
Thx David
Jerry,
Just posted my headcount forecast model here. See if it works for you.
http://www.thesaascfo.com/how-to-create-headcount-forecasts/
Ben
Good day,
I am finishing HC Model creation for the Bank, (it has more than 20 Analysis Types & 8 Integrated DataBases) and it is interesting for me: why no one uses VBA Programming for Models Creation instead of using million of complicated/hard for viewing formulas?
thx.
1
Possibly because most Controllers/
Filed Under:
Budgeting & Forecasting