Google Sheets for Data Analysis and Workflow Automation

Focused View

Ishan Luthra

6:46:47

136 View

1. Onboarding with Googlesheets

1. Create a Gmail Account.mp4

02:54

2. Your First Googlesheet.mp4

02:00

3. The UI of Googlesheets.mp4

12:20

4. Your First Database in Googlesheets.mp4

14:51

5. Import Data in Googlesheets.mp4

07:18

2. Mathematical and Statistical Functions

1. COUNTIF, COUNTIFS, COUNTUNIQUE.mp4

14:55

2. FLOOR and CEILING.mp4

09:31

3. ROUND, ROUNDUP, ROUNDDOWN.mp4

11:23

4. ISEVEN and ISODD.mp4

05:01

5. SUM, SUMIF, SUMIFS.mp4

14:47

6. AVERAGE, AVERAGEIF, AVERAGEIFS.mp4

13:30

7. COUNT, COUNTA, MIN, MAX.mp4

10:49

8. RANK.mp4

06:11

3. Text Functions

1. LEN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TRIM.mp4

13:14

2. REPLACE and SUBSTITUTE.mp4

11:15

3. REGEXREPLACE, REGEXMATCH, REGEXEXTRACT.mp4

05:50

4. Logical Functions

1. AND and OR.mp4

10:40

2. IF and NESTED IF.mp4

09:17

3. IFS.mp4

04:13

4. SWITCH.mp4

05:40

5. IFERROR and IFNA.mp4

08:05

5. Filter Functions

1. FILTER.mp4

08:54

2. SORT.mp4

08:46

3. UNIQUE.mp4

09:38

6. Date and Time Functions

1. ISDATE, DATEDIF, DATE.mp4

10:55

2. DAY, MONTH, YEAR, DAYS, DAYS360.mp4

08:50

3. EDATE, EOMONTH, NOW, TODAY, HOUR, MINUTE, SECOND.mp4

10:48

4. WEEKDAY, WEEKNUM, TEXT.mp4

06:12

7. Other Important Functions in Google Sheets

1. CONCATENATE and ARRAYFORMULA.mp4

14:40

2. QUERY.mp4

05:13

3. IMPORTRANGE.mp4

04:57

4. VLOOKUP.mp4

10:49

8. PROJECT 1

1. Project 1 Analyze Sales Data.mp4

01:46

9. Data Validation and Conditional Formatting

1. Data Validation - Part 1.mp4

12:56

2. Data Validation - Part 2.mp4

06:42

3. Conditional Formatting.mp4

11:29

10. Data Sharing and Security

1. Data Sharing Options with Different User Rights.mp4

13:19

11. Bonus Package Google Forms

1. Create a Data Entry Form.mp4

14:00

2. Importance of Array Formula.mp4

09:51

3. Send automated emails using FormMule.mp4

14:07

12. PROJECT 2

1. Online Leave Approval Process - Part -1.mp4

13:34

2. Online Leave Approval Process - Part -2.mp4

14:58

3. Congratulations!!.mp4

00:39

Description

Learn to implement real-life projects in Google Sheet and also apply most of the functions in Excel too.

What You'll Learn?

Use different types of functions for Data Cleaning and Data Analysis
Prevent the user from adding Bad Data to your Google Sheets Database and Highlight Important Data based on pre-defined rules.
Use Data Security features to protect your work when working on Collaborative Projects
Complete a Project to Streamline and Automate the Workflow at your Company

Who is this for?

This course is meant for all such learners who use Google Sheets or Microsoft Excel at their Job and want to streamline and automate their workflow

More details

Description
"Google Sheets for Data Analysis & Workflow Automation" is a comprehensive course designed to equip learners with the skills to use a Google Sheet effectively for analysing data and automating the workflows. This course is ideal for individuals who are new to Google SpreadSheet or those who have some experience in sheets but want to enhance their skills to analyse data more effectively and streamline their workflows.
Throughout the course, learners will learn to perform a range of data analysis tasks using Google Sheets, such as cleaning and organizing data, using various functions to analyze the data and implement automation through Google Forms as a bonus package of this course.
Learners of this course will be able to work on two real life projects, one on Sales Data Analysis and another on implementing a completely Online Leave Application and Approval workflow by leveraging Google Sheets, Google Forms and Gmail Productivity features in Google Workspace (G Suite).

The functions covered in this course include:

Mathematical Functions: COUNTIF, COUNTIFS, COUNTUNIQUE, FLOOR, CEILING, ROUND, ROUNDUP, ROUNDDOWN, ISEVEN, ISODD, SUM, SUMIF &Â SUMIFS

Statistical Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT, COUNTA, MIN, MAX &Â RANK

Text Functions: LEN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TRIM, REPLACE, SUBSTITUTE, REGEXREPLACE, REGEXMATCH &Â REGEXTRACT

Logical Functions: AND, OR, IF, NESTED IF, IFS, SWITCH, IFERROR & IFNA

Filter Functions: FILTER, SORT & UNIQUE

Date &Â Time Functions: DATE, ISDATE, DATEDIF, DAY, MONTH, YEAR, DAYS, DAYS360, EDATE, EOMONTH, NOW, TODAY, HOUR, MINUTE, SECOND, WEEKDAY &Â WEEKNUM

Other Important Functions in G-Sheets: VLOOKUP, IMPORTRANGE, ARRAYFORMULA, QUERY &Â CONCATENATE

Most of these functions can also be used, equally well, in Microsoft Excel / Advanced Excel.

The course will also cover essential topics such as conditional formatting, data validation, collaboration, data sharing & security, allowing learners to gain a deeper understanding of how to use Google Sheets to streamline their work processes. They will also explore add-ons and other advanced features to enhance their productivity.

By the end of this course, learners will have gained a solid foundation in using a Google Sheet for data analysis and workflow automation. The learners will be able to use a wide variety of functions for Data Analysis. They will be able to use Google Sheets to streamline their workflows, saving them time and improving their productivity.
Who this course is for:
This course is meant for all such learners who use Google Sheets or Microsoft Excel at their Job and want to streamline and automate their workflow

User Reviews

Rating

average 0

Total votes0

Focused display

Ishan Luthra is a seasoned educator and data analyst with over 13 years of blended experience in teaching, training, and data analysis in Google Workspace. He holds a Masters Degree and has been actively involved in the education industry for over a decade. Ishan is a passionate trainer who loves sharing his knowledge and expertise in Google Workspace with his students. He has a strong track record of developing and implementing effective training programs that have helped many individuals and organizations achieve their goals. With his in-depth knowledge of data analysis in Google Workspace, Ishan has helped many businesses streamline their workflows and improve their productivity.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.