Scope

Vacation & Attendance Tracker Dashboard in Microsoft Excel

Chapter 1 - Introduction to the Course

Chapter 2 - Inputs

Vacation Types (8:51)
Weekends (5:39)
Holidays (4:38)
Employees Data (6:10)
Vacation Data (11:43)

Chapter 3 - Team Dashboard

Getting Started (2:32)
User Inputs (4:03)
Employee List (9:38)
Dates of Month (9:39)
Display Data in Calendar - Named Ranges (6:12)
Display Data in Calendar - Formula (22:39)
Conditional Formatting (7:49)
Conditional Formatting - Vacation Types (5:57)
How to Copy and Paste Data (3:16)
Monthly Summary - Headers (5:00)
Monthly Summary - Monthly Totals (9:13)
Monthly Summary - Work Days (3:28)
10-Point Formatting Checklist - Part 1 (14:33)
10-Point Formatting Checklist - Part 2 (16:18)

Chapter 4 - Employee Report

Employee Report - Getting Started (1:34)
Employee Report - User Inputs (4:40)
Employee Report - Calendar Months and Dates (5:39)
Employee Report - Start and End Dates (5:51)
Employee Report - Calendar Data - Formula (20:19)
Employee Report - Conditional Formatting (6:58)
Monthly Summary (6:39)
Annual Summary (2:20)
10-Point Formatting Checklist (14:51)

Chapter 5 - Release Checklist

Chapter 6: Frequently Asked Questions