Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Vacation & Attendance Tracker Dashboard in Microsoft Excel
Chapter 1 - Introduction to the Course
Introduction (6:21)
Scope (9:03)
Download Vacation & Attendance Tracker Dashboard Excel Template
Download the Step by Step User Guide - eBook - PDF
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
Release Checklist (16:45)
Chapter 6: Frequently Asked Questions
Ask Your Questions (1:01)
Scope