An Employee Manager would not be complete without a Scheduling Component.
This week, as part of the Employee Manager Part 7 series, I am super excited to bring you just that.
In this weeks training video I show you how to create an amazing Employee Scheduler without VBA (We only use vba to switch months) This weeks training includes:
In this weeks Part 7 of the Excel Employee Manager I show you how to:
☑️ Create An Amazing Employee Scheduling feature
☑️ Use SUMPRODUCT, INDEX-MATCH, WEEKDAY & ISERROR formulas
☑️ Create Custom Pop-uP Comments with Variable Data
☑️ Dynamic Named Ranges using OFFSET & COUNTA Formulas
☑️ Dynamic & Custom Field Types
☑️ Hide Data Using Conditional Formatting
☑️ Add Employee Leave, Training, Holidays & Weekends to the Schedule
☑️ Switch Months Using Just a few Lines of VBA