(English) How to Build Dynamic Leave Approval, Tracker & Analytics with Google Form, Google Sheets & Google Data Studio

Sign Up Now at RM 29. Price will increase to RM 49 after (Sun) 01.08.2021 11pm

   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.

👉 Click here to sign up (RM29)

Payment is inclusive of
  • 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.

No Jam. No Parking. Bee Happy. Learn Online.

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


  20210716 How to Build Dynamic Leave Approval, Tracker & Analytics with Google Form, Google Sheets & Google Data Studio
Available in days
days after you enroll
  (Morning Session) Training Video - Part 1: Google Form (Hands on)
Available in days
days after you enroll
  (Morning Session) Training Video - Part 2: Google Data Studio (Easy version)
Available in days
days after you enroll
  (Morning Session) Training Video - Part 3: Final Digital Tools Showcase
Available in days
days after you enroll
  (Afternoon Session) Training Video - Part 4: Set up settings
Available in days
days after you enroll
  (Afternoon Session) Training Video - Part 5: Set up mark sheet
Available in days
days after you enroll
  (Afternoon Session) Training Video - Part 7: Summary
Available in days
days after you enroll

Frequently Asked Questions


Language Available ?
English Only
Payment
One Time Off, No Annual Fee, No Renewal Fee.
Payment Method
Credit Card or Online Bank In
Venue & Access
100% Online Learning, 24/7 Anytime, Anywhere.
Supported Devices:
Desktop, laptop, smart devices & smart phones (iOS and Andriod supported).
Am I Allowed to Post Questions to Trainer After Live Webinar ?
Yes
How many times can I view the video replay ?
Unlimited Replay of Training Content.
Are the Video & Training Materials downloadable ?
Yes. You will enjoy Unlimited Download of Video & Training Materials.
Do You Issue Certificate of Completion ?
Yes, upon completion, you can download the Certificate of Completion.
Will you update the training from time to time ?
This is not a guaranteed benefit when you sign up but we will try our best., You will receive UpToDate Training Content whenever the trainer feels necessary to do a follow up webinar.

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 ...

Get started now!