(English) How to Build Dynamic Leave Approval, Tracker & Analytics with Google Form, Google Sheets & Google Data Studio
Training Duration : 5 Hours 10 Minutes
Watch Promo
For Credit Card Payment, click Orange Enroll Button Above this Sales Page. 👆👆👆
For Online Bank In, click this link 👉 https://www.learnabee.com/p/bank
For FAQ, click this link 👉 https://www.learnabee.com/p/faq
Everything you need to know about How to Build Dynamic Leave Approval, Tracker & Analytics with Google Form, Google Sheets & Google Data Studio
If you can't make it to our live webinar, no worries, we have replay & recording for you.
- Unlimited Download of Sample Raw Data (for practice)
- Unlimited Copying Template / Sample Dashboard (for practice & reference)
- Unlimited Replay
- Unlimited Download of Presentation Slides & Notes
- Certificate of Completion to manually claim your CPD/CPE points.
Webinar Outline:
| Introduction |
| - What is a dynamic leave tracker and analytics |
| - Benefits of using a dynamic leave tracker |
| Tools that were used to build leave tracker |
| - Google Form |
| - Google Sheet |
| - Google Data Studio |
| Part 1: Google Form (Hands on) |
| - Install Add Ons |
| - Fill in questions in form |
| - Set up logic table, test it up and (insert marking status) |
| - Review what they have learnt |
| - Hands on (Google form) |
| Part 2: Google Data Studio (Easy version) (If timing allows) |
| - Get your data ready |
| - Connect dataset |
| - Theme and layout |
| - Pie chart |
| - Table of results |
| - Share GDS dataset and Hands on (GDS) and Q&A |
| Final Products Showcase |
| Teach how to download PAID GDS advance version & advanced template |
| How to use template (Review) |
| - Change settings |
| - Set up google form |
| - Update mark sheet |
| Part 1: Set up settings |
| - Modified list (Holidays, Name, Department) |
| - Fixed list (Leave type) |
| - Black list (To change year) |
| Part 2: Set up mark sheet |
| - Set up Employee Name and Leave Code |
| - Vlookup for (Employee ID, Department and Leave Type) |
| - Set up Leave ID and test out |
| Part 3: Monthly Summary |
| - Create a monthly range |
| - Set up Employee ID, Employee Name and Leave Type column |
| - Working days, holidays and leave type for conditional formatting |
| - Conditional formatting (Working days) |
| - Conditional formatting (Holidays) |
| - Conditional formatting (Leave Type) |
| - Vlookup for mark sheet |
| - Number of leaves for each month (Sum product) |
| - Conditional formatting and Introduction of half day leave |
| - Total leaves |
| Part 4: Summary |
| - Columns set up |
| -Countifs |
| -Date range |
| Part 5: Google Data Studio (Advance version) |
| - Get your data ready |
| - Connect dataset |
| - Theme and layout |
| - Set title and monthly date |
| - Time series chart |
| - Stacked bar chart |
| - Table of results |
| - Pie chart |
| - Controls (Date/ Department/ Employee Name |
Your Instructor
Course Curriculum
Frequently Asked Questions
Sign Up Now ... See you "inside" the paid area soon !
We highly encourage you to pay via credit card for instant access to the content.
However, you have the option to pay via online bank in method, Click Here for Instruction to Pay Through Bank
Hi, My name is EvannaMiss8. I am a One Leg Kick , Happy go Lucky Organiser & Producer of Webinars & Online Training for Professionals, Directors & Management
If you are still blur blur about this webinar, no worries ya ... you may contact me directly using any of the below methods
Email: [email protected]
Whatsapp: +6012 203 8046
Facebook: https://www.facebook.com/learnabeeOfficial/
Bee Happy, Learn Online ...
Important Note: If you want to download the Certificate of Completion at the end of this course, please make sure the FULL NAME you key in is 100% Accurate ya ...