Add Employee Scheduling With Ease In This Week’s Employee Manager Part 7

Randy Austin

Randy Austin

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

Download Your FREE Workbooks From either of the following links:
Using Your Email Here: http://bit.ly/EmplMgrPt7_Wb
With Facebook Messenger Here: http://bit.ly/EmplMgrPt7_FbDl

Got Excel Question? Let us help you with that, Join thousands of the worlds best Excel Experts in Facebook’s fastest growing @Excel For Freelancers Group right here: http://bit.ly/groupexcel

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing on YouTube here: http://bit.ly/ExcelForFreelancers_FreeTraining

I hope you love these videos, for More Free videos, personalized training and amazing tricks for freelancers, please find and follow us here:
Twitter: https://twitter.com/RandyNAustin
LinkedIn: https://www.linkedin.com/in/excelforfreelancers/
Facebook: https://www.facebook.com/ExcelForFreelancers/

Share this post