Google Sheets Making it Simple (Basics to Maestro)

Google Sheets – Making it Simple (Basics to Maestro), available at $44.99, with 62 lectures.

You will learn about 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 This course is ideal for individuals who are This course is designed for individuals of all ages wanting to learn or already working on Google Sheets. It is particularly useful for This course is designed for individuals of all ages wanting to learn or already working on Google Sheets.

Enroll now: Google Sheets – Making it Simple (Basics to Maestro)

Summary

Title: Google Sheets – Making it Simple (Basics to Maestro)

Price: $44.99

Number of Lectures: 62

Number of Published Lectures: 62

Number of Curriculum Items: 62

Number of Published Curriculum Objects: 62

Original Price: ?799

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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

What you will learn:

Getting Started with Google Sheets
Discover the interface, navigation, and basic functions of Google Sheets.

Working with Formulas and Functions
Learn how to use formulas and functions to perform calculations and manipulate data.

Data Visualization Techniques
Explore various ways to visualize and present data with charts and graphs.

Advanced Google Sheets Features
Unlock advanced features and techniques to streamline your workflow and enhance productivity.

Collaboration and Sharing
Learn how to collaborate and share spreadsheets with others, making collaboration seamless and efficient.

YOUR INSTRUCTOR

RAUNAK SINGH

A 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

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

Instructors

Raunak Singh
Senior Instructor

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 0 votes

5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!