MM0023 - 04/05/20 - Automating Work Scheduling With Excel

Scheduling shifts is a great example of a task that could take some time, but could be automated with Excel VBA - let's give it a try!

Topics

  •  | Chris' Extreme Haircut
  •  | Jazfin - Homework Review
  •  | Iain L - Homework Review
  •  | Briefing For VBA Task
  •  | How To Do A Screen Recording
  •  | Create A Safe Space For Practice
  •  | TODAY
  •  | Get All Dates In A Year
  •  | TEXT
  •  | WEEKDAY
  •  | List All The Sundays In A Year
  •  | MOD
  •  | VALUE
  •  | RIGHT
  •  | Full vs. Partial Absolute Referencing
  •  | IF
  •  | Conditional Formatting Example
1 Lesson