Google Sheet Functions Formulas and Advanced Concepts-part1
Hello guys. In this series of videos we will learn different functions in google sheets from very simple to most advanced concepts.
Link to practice sheet
https://docs.google.com/spreadsheets/...
we will learn 30 most commonly used google sheet functions with examples.
SUM()
MIN()
MAX()
AVERAGE()
SUMIF()
SUMIFS()
COUNT()
COUNTIF()
COUNTIFS()
CONCATENATE()
JOIN()
TEXTJOIN()
LEN()
TRIM()
SPLIT()
LOWER()
UNIQUE()
TODAY()
YEAR()
MONTH()
DAY()
DATE()
DATEDIF()
OR()
NOT()
AND()
IF()
VLOOKUP()
FILTER()
QUERY()
Also we will learn advanced Google sheet concepts like
Conditional Formatting
PIVOT table
CHARTS in GOOGLE SHEET
Creating a DASHBOARD in google SHEET
I will provide sample examples for google sheet functions to check your understanding
My name is Dr. Ram Charan Baishya. Dr. RCB. I work as a guest faculty in the Computer science and engineering department in Tezpur University. Also I run a software startup named YROS software.