• Post category:StudyBullet-13
  • Reading time:6 mins read


Learn through real-life projects

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 Google Sheets effectively for analysing data and automatic the workflows. This course is ideal for individuals who are new to Google Sheets or those who have some experience but want to enhance their skills to 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.


Get Instant Notification of New Courses on our Telegram channel.


The course will cover essential topics such as conditional formatting, data validation, and collaboration, 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 Google Sheets 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.

English
language

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