Google Sheets - Making It Simple (Basics To Maestro)

Master Google Sheets and boost your productivity

What you'll learn

Master the fundamentals of Google Sheets

Create powerful formulas and calculations

Get to know some heavyweight topics: Vlookup, Xlookup, Pivot Tables.

Data Visualization with professional-looking charts and graphs

Collaborate and share spreadsheets with others using Importrange and Query Functions

Increase your speed by learning shortcuts

Add Data Validations, Named Ranges, Cell references and much more

Requirements

You will learn everything you need to know

Description

Description:Learn how to effectively use Google Sheets, from basic functions to advanced features. This course will simplify and demystify Google Sheets, helping you become a master at data manipulation and analysis.Key Highlights:Master the fundamentals of Google SheetsCreate powerful formulas and calculationsGet to know some heavyweight topics: Vlookup, Xlookup, Pivot Tables.Data Visualization with professional-looking charts and graphsCollaborate and share spreadsheets with others using Importrange and Query FunctionsWhat you will learn:Getting Started with Google SheetsDiscover the interface, navigation, and basic functions of Google Sheets.Working with Formulas and FunctionsLearn how to use formulas and functions to perform calculations and manipulate data.Data Visualization TechniquesExplore various ways to visualize and present data with charts and graphs.Advanced Google Sheets FeaturesUnlock advanced features and techniques to streamline your workflow and enhance productivity.Collaboration and SharingLearn how to collaborate and share spreadsheets with others, making collaboration seamless and efficient.YOUR INSTRUCTORRAUNAK SINGHA subject-matter expert in a range of data analytics and visualization tools, including Google Sheets, Power BI, Tableau, Advanced Excel, Power Query, SQL, SPSS, SQL, GCP, Python and Predictive Modelling. Known for dynamic and engaging training methods that empower participants to harness the full potential of these tools for data-driven decision-making.Have facilitated 10k+ learners across professionals and students at all levels, from beginners to advanced users.MY JOB IS TO MAKE IT AS SIMPLE AS POSSIBLE FOR YOU

Overview

Section 1: Introduction

Lecture 1 Welcome

Lecture 2 Setting up Your Google Account and Google Sheets

Lecture 3 How to Access Course Files

Section 2: Module 1: Basics of Google Sheets

Lecture 4 History of Spreadsheet

Lecture 5 Important Shortcuts

Lecture 6 What is a Spreadsheet?

Lecture 7 Data Types

Lecture 8 Navigation in Google Sheets

Lecture 9 Introduction to Formulas

Lecture 10 Game of Referencing

Lecture 11 Practice: Momos Stand

Lecture 12 Practice: Momos Stand Solution

Section 3: Module 2: Data Management in Google Sheets

Lecture 13 Sort

Lecture 14 SortN

Lecture 15 Filter and Unique

Lecture 16 Practice: Sort and Filter Practice

Lecture 17 Practice: Sort and Filter Solution

Lecture 18 Text Cleaning Basic: Left- Right - Mid - Len - Find

Lecture 19 Text Cleaning Basic - Search and Replace

Lecture 20 Text Cleaning Basic: Text to Columns

Lecture 21 Text Cleaning Basic: Trim - Upper - Lower - Proper

Lecture 22 Text Cleaning Basic: Concat - Concatenate

Lecture 23 Practice: Text Cleaning Basic

Lecture 24 Practice: Text Cleaning Basic Solution

Lecture 25 Text Cleaning Advanced: Paste Special

Lecture 26 Text Cleaning Advanced: Join - Split - Transpose

Lecture 27 Conditional Formatting: Basic

Lecture 28 Conditional Formatting: Advanced

Lecture 29 Data Validation

Lecture 30 Named Ranges

Section 4: Module 3: Family of Lookups

Lecture 31 VLOOKUP Introduction

Lecture 32 VLOOKUP & HLOOKUP

Lecture 33 VLOOKUP - Intersheet

Lecture 34 Practice: VLOOKUP & HLOOKUP

Lecture 35 Practice: VLOOKUP & HLOOKUP Solution

Lecture 36 VLOOKUP with MATCH

Lecture 37 INDEX with MATCH Introduction

Lecture 38 INDEX with MATCH - MATCH

Lecture 39 XLOOKUP

Section 5: Module 4: Thinking Logically

Lecture 40 Introduction to IF

Lecture 41 Practice: Introduction to IF

Lecture 42 AND - OR Logic

Lecture 43 IF with AND - OR

Lecture 44 Nested IF Logic

Lecture 45 Practice: Nested IF

Lecture 46 IFS

Lecture 47 SUMIF - COUNTIF - AVGIF and more

Lecture 48 Practice Activity + IFERROR

Section 6: Magic with PIVOT Tables

Lecture 49 Introduction to PIVOT Tables

Lecture 50 PIVOT Table Analysis

Lecture 51 Practice: PIVOT Table

Lecture 52 Additional Analysis

Section 7: Visualize Your Data using Charts and Graphs

Lecture 53 Introduction to Charts

Lecture 54 Creating Charts

Lecture 55 Practice: Charts Solution

Section 8: Importrange and Query in Google Sheets

Lecture 56 IMPORTRANGE

Lecture 57 Crash Course in SQL

Lecture 58 QUERY Introduction

Lecture 59 QUERY with IMPORTRANGE

Section 9: Module 8: Fun with Google Sheets

Lecture 60 Google Translate

Lecture 61 My Function (User Defined Functions)

Lecture 62 Connecting with POWER BI

This course is designed for individuals of all ages wanting to learn or already working on Google Sheets.