Google Sheet Essential Training

Topic 1: Spreadsheet Basics

• Introduction
• Pre work: Creating a Google drive account
• Pre work: Creating a copy of my spreadsheet templates!
• Spreadsheet basics
• Toolbar walkthrough
• Data types in Spreadsheets
• Navigating Spreadsheets with shortcuts
• Simple formatting tricks – beautify your Spreadsheets

Topic 2 Introduction to functions

• Get familiar with SUM, COUNT, AVERAGE, COUNTA, MIN, MAX
• Activity

Topic 3: Conditional Functions

• IF Statement
• AND / OR statements
• IF’s and nesting IF
• Conditional formatting
• Conditional arithmetic functions (eg: SUMIF)

Topic 4: Pivot Tables, Sorting & Filtering

• Introduction to raw data and the new section format
• Pivot tables
• Sorting and filtering

Topic 5: Charts & graphs

• Creating charts and graphs in Google Sheets

Topic 6: Data Validation & introduction to Dynamic Models

• Data validation
• Creating basic dynamic model
• Data validation and intermediate modelling

Topic 7: Errors, IF Error and Creating named ranges

• Errors that we need to know and how to fix them
• IFERROR formula
• Named ranges

Topic 8: VLOOKUP, Lookup and Index Match

• Vlookup
• Hlookup
• Index Match

Topic 9: Text functions

• Adding words together and changing their case
• Extracting first and last names from a cell
• Left function
• Right function
• Len function
• Trim function

Topic 10: Date & time functions

• Edate, EOMonth
• Interactive calendar

Topic 11: Rounding and Randomizing

• Randomizing using RAND and RANDBETWEEN
• ROUND, ROUNDUP and ROUNDDOWN

Prerequisite:

HRDF Funding

Please refer to this video https://youtu.be/Kzpd-V1F9Xs

1-     HRD Corp Grant Helper

How to submit grant applications for HRD Corp Claimable Courses

2-     Employers are required to apply for the grant at least one week before training commences.

Employers must submit their applications with supporting documents, including invoices/quotations, trainer profiles, training schedule and course content.

3-     First, Login to Employer’s e-TRIS account -https://etris.hrdcorp.gov.my

Second, Click Application

4-     Click Grant on the left side under Applications

5-     Click Apply Grant on the left side under Applications

6-     Click Apply

7-     Choose a Scheme Code and select HRD Corp Claimable Courses: Skim Bantuan Latihan Khas. Then, click Apply

8-     Scheme Code represents all types of training that suit the requirements provided by HRD Corp. Below are the list of schemes offered by HRD Corp:

9-     Select your Immediate Officer and click Next

10-  Select a Training Provider, then click Next

11-  Please select a training programme from the list, then key in all the required details and click Next

Select your desired training programme.

Give an explanation on why the participant is required to attend the training. E.g., related to their tasks/ career development, etc.

Explain the background and objective of this training.

Select a relevant focus area. For Employer-Specific Courses, select ‘Not Applicable’.

12-  If the training programme is a micro-credential programme, you are required to complete these 3 fields. Save and click Next

Insert MiCAS Application number

13-  Based on the nine (9) pillars listed below, HRD Corp Focus Area Courses are closely tied to support government initiatives towards nation building. As such, courses offered through the HRD Corp Focus Areas are designed to provide the workforce with skills required for current and future demands. Details of the focus areas are as follows:

14-  Please select a Course Title and Type of Training

15-  Select the correct type of training according to the actual type of training, or as mentioned in the training brochure:

16-  Please key in the Training Location and click Next

17-  Please select the Level of Certification and click Next

18-  Please follow the instructions and key in trainee details

19-  Click Add Batch, then click Save

20-  Click Add Trainee Details

21-  Please key in all the required details, then click Add

22-  Click Add if there are more participants. Once done, click Save

23-  Click Next

24-  Please key in the course fees and allowance details, then click Save

25-  Estimated cost includes the course fees/external trainer fees, allowances, and consumable training materials. Please comply with the HRD Corp Allowable Cost Matrix.

26-  Select Upfront Payment to Training Provider and key in the percentage from 0% to 30%. Then, click Save and Next

27-  Complete the declaration form and select a desired officer

28-  Add all the required documents, then click Add Attachment. Then, click Save and Submit Application

29-  Once the New Grant Application is successfully submitted, the Grant Officer will evaluate the application accordingly. The application may be queried if additional information is required.

The application status will be updated via the employer’s dashboard, email, and the e-TRiS inbox.

• Data Analyst
• Administrative Assistant
• Office Manager
• Project Manager
• Accountant
• Financial Analyst
• Marketing Coordinator
• Sales Representative
• Human Resources Coordinator
• Research Assistant
• Business Development Manager
• Product Manager
• Operations Manager
• Educator
• Small Business Owner

Dr. Aanand: Dr. Aanand is a Full Stack Data Scientist who once had a torrid love affair with Physics. He has consulted and published in the area of Public Health, Electricity Markets, Telecom, BFSI, Advertising & Communication Strategies and Digital & Social Media Technologies. He has worked on assignments with international agencies such as International Monetary Fund, World Bank, Royal Netherland Embassy etc. besides MNCs like Tata Consultancy Services, Kie Square Consulting and several government organizations of national importance.

He regularly conducts general training programs in Python (Pandas, NumPy, SciPy, Matplotlib, Bokeh), R (dplyr, rstanarm, knitR, ggplot2), Data Visualization (Tableau, D3.js) and Machine Learnng (Reinforced Learning, Scikit Learn) and specialized training programs on Structural Equation Modeling and SAP Hana.

He holds a doctorate in Operations Research from Indian Institute of Management Ahmedabad and a post graduate in Physics from University of Mumbai. He has advanced training in mathematical programming including optimization, advanced multivariate data analysis, and simulation techniques. When he is not teaching or consulting he can be found meditating or heading for an adventurous trek.

Amir Othman: Amir Othman is a software engineer by profession. Being educated in Bauhaus Universität Weimar and Hochschule Ulm, he brings experiences from different facades of the world.

With expertise in web technology, natural language processing and machine learning, he is a freelance data scientist. Some of his works include two international news aggregator

www.kronologimalaysia.com and www.diezeitachse.de

He also holds an impressive port folio for data visualizations, primarily focusing on web based techniques.

After the realization set in that, I do not want to make it as an electronic engineer, I took the decision to go and try something new out of pure curiosity and thirst for new adventure. It didn't come quite handy but I have changed my major three times. It's not a surprise that I studied artificial intelligence and found myself all over again. I have a strong passion for machine learning and data science, fueled by the drive to learn and the endurance for growth beyond the ordinary.