Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Excel Beginner

Excel Calendars & Schedules: Dynamic Monthly Calendar, Shift Rota & Gantt with Formulas

Build the schedules teams actually print and share: a monthly calendar that redraws from one date, weekends, closed days and today in colour, ISO weeks, working days and paydays, a 4-on-4-off rota from one pattern, hours and overtime, a daily Gantt with progress bars, a milestone status board and a yearly planner with a chart, in 8 hands-on labs.

8 lessons 8 labs 2.6 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Build the monthly calendar Northgate's hub team prints for the notice board: type any date and the whole grid redraws for that month.
  • Colour Northgate's December calendar: weekends, the hub's closed days from a list, and the as-of date, each with one formula rule, and count the closed days that fall in the month.
  • Build Northgate's 2026 month table: last day, working days without weekends and closed days, the ISO week each month starts in, and the payday (last working day).
  • Generate two weeks of Northgate's 24/7 rota for four crews from one 8-day pattern, check the coverage and find Crew D's first night shift.
  • Turn a week of shift codes into hours per person, overtime above the weekly limit, the number of people over the limit and the overtime cost.
  • Build a working-day Gantt for Northgate's racking upgrade: end dates with WORKDAY, a bar for every task, a darker part for the work already done and the project's overall % complete.
  • Turn Northgate's milestone list into a status board: days left, a status word for every milestone and the next milestone that is coming up.
  • Summarise Northgate's 2026 event log by month and type, find the busiest month and the months without an audit, and chart the year.

About this course

Stop redrawing calendars by hand each month. In this course you build planning sheets that update themselves when you change a date. A monthly calendar grid starts on the right Monday using WEEKDAY and SEQUENCE, and formula rules shade weekends, closed days and today. You add ISO week numbers and count working days with NETWORKDAYS and WORKDAY against a closed-day list. A four-on, four-off shift rota repeats its pattern with MOD and INDEX, and weekly hours and overtime are counted per shift code. A daily Gantt chart shows end dates and progress, milestones display days remaining and overdue or due-soon status, and a yearly planner charts events per month. For office managers, team leads, schedulers and project coordinators.

Curriculum

Course content

8 lessons · 8 labs · 2.6 h · final exam

  1. A Dynamic Monthly Calendar: First Monday with WEEKDAY & a SEQUENCE GridLab18 min4 checked tasks
    Unlocked when you buy the course
  2. Highlighting Weekends, Closed Days & the As-of Date with Formula RulesLab18 min4 checked tasks
    Unlocked when you buy the course
  3. Week Numbers & Working Days: ISOWEEKNUM, NETWORKDAYS & WORKDAY with a Closed-Day ListLab20 min4 checked tasks
    Unlocked when you buy the course
  4. A 4-on-4-off Shift Rota: Repeating Patterns with MOD & INDEXLab20 min4 checked tasks
    Unlocked when you buy the course
  5. Weekly Hours & Overtime from a Shift Rota: COUNTIF per Shift Code & MAX(0, …)Lab18 min4 checked tasks
    Unlocked when you buy the course
  6. A Daily Gantt with Progress: WORKDAY End Dates & Two Formula RulesLab22 min4 checked tasks
    Unlocked when you buy the course
  7. Milestones: Days Remaining, Overdue / Due Soon Status & the Next MilestoneLab18 min4 checked tasks
    Unlocked when you buy the course
  8. Yearly Planner Summary: Events per Month with COUNTIFS & a Stacked Column ChartLab20 min4 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Excel courses →
$9.99one-time payment
Buy course