Q&A Forum
Headcount Forecast In Excel
Jerry Goldberg
(Principal at Strategic Capital Corp) | Jul 28, 2013
I have a headcount forecasting worksheet in workbook an ex-employee left behind that has some holes in it. I need a formula in
Get Free Membership
Business Exchange
Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.
Learn moreContribute to Community
If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.
Answers
Company: ITW
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.
Company: Proformative
Whatever headcount forecasting spreadsheet you create in Excel, to be accurate, it should in some way take into account the metrics in this informativewhite paper :
"5 Must-Have Metrics to Create anHR Value Center"
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
Company: Private
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.
Company: Private
David, I saw that you posted the resource, but I did not see the attachment.
Company: ITW
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
Company: Strategic Capital Corp
Thx David
Company: Cartegraph
Jerry,
Just posted my headcount forecast model here. See if it works for you.
http://www.thesaascfo.com/how-to-create-headcount-forecasts/
Ben
Company: OTP Bank
LinkedIn Profile
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.
Company: SBAConsulting.com
LinkedIn Profile
Possibly because most Controllers/CFO 's are not programmers... and they don't have a VBA programmer at their disposal and quite possibly don't want to incur the expense....