Google Sheets – Making it Simple (Basics to Maestro)

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome

Lecture 2: Setting up Your Google Account and Google Sheets

Lecture 3: How to Access Course Files

Chapter 2: Module 1: Basics of Google Sheets

Lecture 1: History of Spreadsheet

Lecture 2: Important Shortcuts

Lecture 3: What is a Spreadsheet?

Lecture 4: Data Types

Lecture 5: Navigation in Google Sheets

Lecture 6: Introduction to Formulas

Lecture 7: Game of Referencing

Lecture 8: Practice: Momos Stand

Lecture 9: Practice: Momos Stand Solution

Chapter 3: Module 2: Data Management in Google Sheets

Lecture 1: Sort

Lecture 2: SortN

Lecture 3: Filter and Unique

Lecture 4: Practice: Sort and Filter Practice

Lecture 5: Practice: Sort and Filter Solution

Lecture 6: Text Cleaning Basic: Left- Right – Mid – Len – Find

Lecture 7: Text Cleaning Basic – Search and Replace

Lecture 8: Text Cleaning Basic: Text to Columns

Lecture 9: Text Cleaning Basic: Trim – Upper – Lower – Proper

Lecture 10: Text Cleaning Basic: Concat – Concatenate

Lecture 11: Practice: Text Cleaning Basic

Lecture 12: Practice: Text Cleaning Basic Solution

Lecture 13: Text Cleaning Advanced: Paste Special

Lecture 14: Text Cleaning Advanced: Join – Split – Transpose

Lecture 15: Conditional Formatting: Basic

Lecture 16: Conditional Formatting: Advanced

Lecture 17: Data Validation

Lecture 18: Named Ranges

Chapter 4: Module 3: Family of Lookups

Lecture 1: VLOOKUP Introduction

Lecture 2: VLOOKUP & HLOOKUP

Lecture 3: VLOOKUP – Intersheet

Lecture 4: Practice: VLOOKUP & HLOOKUP

Lecture 5: Practice: VLOOKUP & HLOOKUP Solution

Lecture 6: VLOOKUP with MATCH

Lecture 7: INDEX with MATCH Introduction

Lecture 8: INDEX with MATCH – MATCH

Lecture 9: XLOOKUP

Chapter 5: Module 4: Thinking Logically

Lecture 1: Introduction to IF

Lecture 2: Practice: Introduction to IF

Lecture 3: AND – OR Logic

Lecture 4: IF with AND – OR

Lecture 5: Nested IF Logic

Lecture 6: Practice: Nested IF

Lecture 7: IFS

Lecture 8: SUMIF – COUNTIF – AVGIF and more

Lecture 9: Practice Activity + IFERROR

Chapter 6: Magic with PIVOT Tables

Lecture 1: Introduction to PIVOT Tables

Lecture 2: PIVOT Table Analysis

Lecture 3: Practice: PIVOT Table

Lecture 4: Additional Analysis

Chapter 7: Visualize Your Data using Charts and Graphs

Lecture 1: Introduction to Charts

Lecture 2: Creating Charts

Lecture 3: Practice: Charts Solution

Chapter 8: Importrange and Query in Google Sheets

Lecture 1: IMPORTRANGE

Lecture 2: Crash Course in SQL

Lecture 3: QUERY Introduction

Lecture 4: QUERY with IMPORTRANGE

Chapter 9: Module 8: Fun with Google Sheets

Lecture 1: Google Translate

Lecture 2: My Function (User Defined Functions)

Lecture 3: Connecting with POWER BI