Video Tutorial:
An Excel version was added. That will be included in the purchase, and to use it, you must have Office 365 and be in the ‘insiders’ program since it uses Dynamic Arrays.
The tool is very easy to use and can be used across multiple years. The flow starts with a data entry tab where the user can enter data into each row every time a given training item is completed or not completed for each employee. The database uses dropdown lists that are populated based on the user’s entry of each employee and training item on the validation tab.
On the data entry tab, the fields are: Employee Name, Training Plan, Completed (yes/no), and Date. Based on those entries, all subsequent reports and tracking are automated. Two main report summaries show the number of items completed per employee and a separate summary that shows the date each employee has completed a given item.
The file can support up to 20 unique training items / requirement items and up to 499 employees at one time.
There are a few other reports that will show lists of all completed and incomplete items by employees, as well as a consolidated summary of the count of items completed, incomplete, and pending per employee, as well as a visualization that shows incomplete items per employee. Use each sheet for 1 year at a time and keep a master template that has all the base information already filled in (employee names/training items) and then make a copy of that for each year. You can store the link to each year in the master template. Slots were made available for this.
There are complete instructions within the file as well.
Similar Products
Other customers were also interested in...
Digital Hiring (Talent) Marketplace – 5 Year Fin...
Financial Model providing an advanced 5-year financial plan for an online, two-sided hiring platform... Read more
Recruitment Agency Financial Model Excel Template
Shop Recruitment Agency Financial Model Template. Fortunately, you can solve Cash Flow shortfalls wi... Read more
Human Resources Company – Dynamic 10 Year Financ...
Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Human... Read more
Staffing Agency Financial Model
This excel financial projection model is for forecast of revenue, expenses and cash flows for a staf... Read more
Top 16 Google Sheet Templates
This is a bundle of all the most useful and efficient google sheet templates I have built over the y... Read more
Equipment Rental Cash Flow Model
Highly dynamic financial model that is specific to renting equipment out. High attention paid to the... Read more
Industry Based Financial Models (Variety Bundle)
There are currently 52 unique financial models included in this bundle. Nearly all of that include a... Read more
Consulting Firm Startup Financial Model
A 5-year financial model for starting your own consultancy firm. Includes 3-statement model integrat... Read more
Consulting Firm Financial Model – Dynamic 10 Yea...
Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Consu... Read more
Due Diligence Tools and Methods
A suite of best practices to perform financial and commercial due diligence. Use it if you are consi... Read more
You must log in to submit a review.