Google Sheets for Data Analysis and Workflow Automation

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

4.70 (106 reviews)
Udemy
platform
English
language
Google
category
instructor
5,324
students
7 hours
content
Mar 2023
last update
$74.99
regular price

What you will 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

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.

Content

Onboarding with Googlesheets

Create a Gmail Account
Your First Googlesheet
The UI of Googlesheets
Your First Database in Googlesheets
Import Data in Googlesheets

Mathematical and Statistical Functions

COUNTIF, COUNTIFS, COUNTUNIQUE
FLOOR and CEILING
ROUND, ROUNDUP, ROUNDDOWN
ISEVEN and ISODD
SUM, SUMIF, SUMIFS
AVERAGE, AVERAGEIF, AVERAGEIFS
COUNT, COUNTA, MIN, MAX
RANK

Text Functions

LEN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TRIM
REPLACE and SUBSTITUTE
REGEXREPLACE, REGEXMATCH, REGEXEXTRACT

Logical Functions

AND and OR
IF and NESTED IF
IFS
SWITCH
IFERROR and IFNA

Filter Functions

FILTER
SORT
UNIQUE

Date and Time Functions

ISDATE, DATEDIF, DATE
DAY, MONTH, YEAR, DAYS, DAYS360
EDATE, EOMONTH, NOW, TODAY, HOUR, MINUTE, SECOND
WEEKDAY, WEEKNUM, TEXT

Other Important Functions in Google Sheets

CONCATENATE and ARRAYFORMULA
QUERY
IMPORTRANGE
VLOOKUP

PROJECT 1

Project 1: Analyze Sales Data

Data Validation and Conditional Formatting

Data Validation - Part 1
Data Validation - Part 2
Conditional Formatting

Data Sharing and Security

Data Sharing Options with Different User Rights

Bonus Package : Google Forms

Create a Data Entry Form
Importance of Array Formula
Send automated emails using FormMule

PROJECT 2

Online Leave Approval Process - Part -1
Online Leave Approval Process - Part -2
Congratulations!!

Screenshots

Google Sheets for Data Analysis and Workflow Automation - Screenshot_01Google Sheets for Data Analysis and Workflow Automation - Screenshot_02Google Sheets for Data Analysis and Workflow Automation - Screenshot_03Google Sheets for Data Analysis and Workflow Automation - Screenshot_04

Reviews

Mateo
January 7, 2024
It's very useful this course, the creator goes slow and I like it because i don't know anything about Sheets and that help me a lot. If you are at the beginner level like me, this course is for you
Yahaya
March 28, 2023
Woo, this is another wonderful course, I never knew google sheets can do this job. Thank you very much.
Baljeet
March 28, 2023
This course is really different from other courses on google sheets. It covers a wide variety of functions, google forms as a bonus section, automation in real life scenario and 2 projects with real life application. This course helped me apply an online approval system which is fully automated. Wonderful course!!
Pawan
March 28, 2023
Excellent course, nicely explained functions. The project work is very helpful to get hands on with the Googlesheets.
Syed
March 28, 2023
One of the standout features of the course is its focus on practical, applicable skills. Unlike many courses that are heavy on theory and light on real-world applications, this course provided hands-on training that I know will be invaluable in my personal and professional life. The skills I learned will undoubtedly help me to be more productive, efficient, and effective in a variety of settings. I must mention how beautifully each and every aspect of the course was explained. I highly recommend this course to anyone looking to gain new skills or brush up on existing ones.
Vidyanand
March 24, 2023
Really nice course. The structure of this course is very different from other courses on Google sheets. The Projects in this course really got me hands on with variety of functions and I could even automate few basic operations in my workflow. Thanks for this course.

Coupons

DateDiscountStatus
3/26/2023100% OFF
expired
3/28/2023100% OFF
expired
3/31/202330% OFF
expired
6/13/2023100% OFF
expired
6/14/202350% OFF
expired
7/2/2023100% OFF
expired
7/2/202350% OFF
expired
9/3/2023100% OFF
expired
9/4/2023100% OFF
expired

Charts

Price

Google Sheets for Data Analysis and Workflow Automation - Price chart

Rating

Google Sheets for Data Analysis and Workflow Automation - Ratings chart

Enrollment distribution

Google Sheets for Data Analysis and Workflow Automation - Distribution chart
4996270
udemy ID
11/26/2022
course created date
3/25/2023
course indexed date
Bot
course submited by