Autoplay
Autocomplete
Previous Lesson
Complete and Continue
(English) How to Build Dynamic Leave Approval, Tracker & Analytics with Google Form, Google Sheets & Google Data Studio
20210716 How to Build Dynamic Leave Approval, Tracker & Analytics with Google Form, Google Sheets & Google Data Studio
Preview of How to Build Dynamic Leave Approval, Tracker & Analytics with Google Form, Google Sheets & Google Data Studio (3:33)
Session #01 (111:21)
Session #02 (196:13)
Training Material & Notes
Download PPT Slides (12-pages)
Sample Google Form
Sample Yearly Leave Tracker (Templates)
Sample: Employee Leave Report (Easy)
Sample Dataset for GDS
Sample: Employee Leave Report (Advance)
(Morning Session) Training Video - Part 1: Google Form (Hands on)
Video 01: Install Add Ons (2:18)
Video 02: Google Form (5:36)
Video 03: Add On (6:49)
(Morning Session) Training Video - Part 2: Google Data Studio (Easy version)
Video 04: GDS connect (2:41)
Video 05: GDS done (7:29)
(Morning Session) Training Video - Part 3: Final Digital Tools Showcase
Video 06: Final Digital Tools Showcase (15:34)
(Afternoon Session) Training Video - Part 4: Set up settings
Video 07: Modified list (11:55)
Video 08: Fixed and blacklist (6:12)
(Afternoon Session) Training Video - Part 5: Set up mark sheet
Video 09: Name and leavecode (4:35)
Video 10: Vlookup (10:56)
Video 11: Marksheet (8:47)
(Afternoon Session) Training Video - Part 6: Monthly Summary
Video 12: Monthly Date (12:11)
Video 13: Employee Name (5:44)
Video 14: Table of CF (5:30)
Video 15: CF working days (6:01)
Video 16: CF holidays (5:53)
Video 17: CF leave type (6:13)
Video 18: Vlookup (5:06)
Video 19: Sum product (15:10)
Video 20: Monthly summary (10:32)
(Afternoon Session) Training Video - Part 7: Summary
Video 21: Summary setup (11:19)
Video 22: Countifs (11:20)
Video 23: Finale (1:22)
(Afternoon Session) Training Video - Part 8: Google Data Studio (Advance version)
Video 24: GDS (2:46)
Video 25: Title (1:41)
Video 26: Time series (4:38)
Video 27: Stacked column (3:08)
Video 28: Table of summary (4:41)
Video 29: Pie chart (2:15)
Video 30: Finale (4:13)
Video 28: Table of summary
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock