From the course: Excel: Modeling for Beginners
Join today to access over 25,300 courses taught by industry experts.
Workforce planning - Microsoft Excel Tutorial
From the course: Excel: Modeling for Beginners
Workforce planning
- [Instructor] Now, we're going to build a workforce planning model. In a workforce planning model, you have two types of data. You have the data about how many people are in your workforce, and then you have the data about the demands that are going to be required of your company. So for instance, if you had several personnel and then you did a survey, you could find out what is the average person being paid per year given a specific position in a specific department. For instance, let's say we surveyed our thousands of employees, and we found that customer support at the entry level was making on average about 54,000 a year. Okay, well, let us say then that you had several projects that you needed to plan for, and these projects could be really grouped into one of three buckets, simple, medium, and complex. So a simple project would look on average like this. So it would need zero HR people, zero finance people, might need one person at sales, but this would be at the management…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.