Course Highlights
  • Introduction to google sheets and its features
  • Essential Function
  • Data Cleaning and Formatting
  • Text Manipulation and Conditional Formatting
  • Text Functions and Validation
  • Lookup & Date Functions
  • Special Functions
  • Data Summarization using Pivot Tables
  • Charts and Dashboard
Curriculum

7 Topics
Introduction To Google Sheets
The Role of Data in Daily Life
Google Sheet Vs Excel
Navigate the Google Sheet
Data Entry in Google Sheet
Practical Applications of Google Sheet & Examples
Quick Challenge

10 Topics
Introduction To Essential Functions
Basic Arithmetic Operators
Comparison Operators
Logical Operators
Text Concatenation Operator
Difference Between Functions and Formulas
Functions - Conditional Function P1
Aggregate Function P2
Conditional Aggregation Function P3
Quick Challenge

11 Topics
Introduction to Data Cleaning
Handling Missing Data
Splitting Text to Columns
Trimming Whitespace
Changing Case
Find and Replace
Formatting
Freeze Rows and Columns
Cell References
Quick Challenge
Removing Duplicates

5 Topics
Introduction to Text Manipulation and Conditional Formatting
LEFT MID and RIGHT Functions
CONCATENATE and TEXT JOIN Functions
Quick Challenge
Conditional Formatting

6 Topics
Introduction To Text Functions and Validation
LEN Function
FIND Function
Using FIND with LEFT MID and RIGHT Functions
Data Validation
Quick Challenge

6 Topics
Introduction to LOOKUP and DATE Functions
VLOOKUP Function
HLOOKUP Function
INDEX and MATCH Functions
DATE Functions
Quick Challenge

8 Topics
XLOOKUP Function
SUMPRODUCT Function
OFFSET Function
IMAGE Function
Editing Hyperlinks
Quick Challenge
Introduction to Special Functions
IFERROR Function

6 Topics
Introduction to Data Summarization using Pivot Tables
Creating Basic Pivot Tables
Customizing Pivot Tables
Advanced Pivot Table Techniques
Using the QUERY Function
Quick Challenge

5 Topics
Introduction to Charts and Dashboards
Importing Data with IMPORTRANGE
Creating Pivot Charts
Building a Dashboard
Quick Challenge

  Write a Review

Google Sheets Free Course : Beginner to Advance

Go to Free Course