Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Google Sheets for Data Analysis and Workflow Automation

Name: Google Sheets for Data Analysis and Workflow Automation
Rating: 4.5 (125 reviews)

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

Created byIshan Luthra

Last updated 3/2023

English

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

Course content

12 sections • 43 lectures • 6h 46m total length

Create a Gmail Account2:54
Your First Googlesheet2:00
The UI of Googlesheets12:20
Learn the Google Sheets user interface, including columns, rows, cells and cell references, the ribbon formatting tools, and managing sheets—adding, renaming, duplicating, hiding, coloring, and sharing.
Your First Database in Googlesheets14:51
Import Data in Googlesheets7:18

ISDATE, DATEDIF, DATE10:55
Verify date values with isdate, convert text to date with the date function, and compute date differences with date diff in Google Sheets.
DAY, MONTH, YEAR, DAYS, DAYS3608:50
Explore extracting day, month, and year from dates with day, month, and year functions, and compare date differences using days, date diff, and days360 in Google Sheets.
EDATE, EOMONTH, NOW, TODAY, HOUR, MINUTE, SECOND10:48
Explore edate and eomonth to calculate dates relative to a given date, and now and today to obtain current date and time. Extract hour, minute, and second components.
WEEKDAY, WEEKNUM, TEXT6:12

Data Validation - Part 112:56
Learn to enforce data quality in Google Sheets with data validation and conditional formatting, including date validation, dropdown lists for items, and email validation to prevent inconsistent records.
Data Validation - Part 26:42
Apply data validation in Google Sheets to enforce binary yes/no fields with checkboxes, validate dispatch numbers starting with exp, and require quantities to be at least ten.
Conditional Formatting11:29
Explore how conditional formatting in Google Sheets highlights key data points using rules for empty cells, text contains, dates, and custom formulas to expose trends and streamline workflows.

Requirements

No prior knowledge is required. Join this course to become a pro at using Google Sheets and Revolutionize the Workflow at your Job

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

Google Sheets for Data Analysis and Workflow Automation

What you'll learn

Explore related topics

Course content

Onboarding with Googlesheets5 lectures • 39min

Mathematical and Statistical Functions8 lectures • 1hr 26min

Text Functions3 lectures • 30min

Logical Functions5 lectures • 38min

Filter Functions3 lectures • 27min

Date and Time Functions4 lectures • 37min

Other Important Functions in Google Sheets4 lectures • 36min

PROJECT 11 lecture • 2min

Data Validation and Conditional Formatting3 lectures • 31min

Data Sharing and Security1 lecture • 13min

Requirements

Description

Who this course is for: