Google Sheets A To Z: Best Online Excel Spreadsheet Editor

Create and collaborate on online spreadsheets in real-time and from any device using Google Sheets by Google Workspace

What you'll learn

Complete Google Sheet guide from starting to pro

Create interactive & visually effective dashboards in Sheets

Learn hacks and hidden Google Sheets features that even the Experts don't know

Solve real-life spreadsheet challenges with ease

Master Pivot tables, charts and sparklines to create impressive Google spreadsheets

Secrets to properly use tricky features like Conditional formatting

Connect multiple Google Sheets together using a single formula

Analyze data sets with ease using complex functions & formulas

Feel completely comfortable in a spreadsheet environment

Learn formulas that work in both Google sheets & Excel!

Requirements

No prior spreadsheet knowledge is needed.

Willingness to learn. Let's do this!

Description

Welcome to this course, Google Sheets A to Z: Best Free Online Spreadsheet EditorThis course will give you you everything you need to know about Google Spreadsheets.Google Sheets is better than Microsoft excel & Mac numbers because of many benefits taught inside this course.What we will learn :-Complete Google Sheet guide from starting to proSolve real-life spreadsheet challenges with easeLearn hacks and hidden Google Sheets features that even the Experts don't knowCreate interactive & visually effective dashboards in SheetsSecrets to properly use tricky features like Conditional formattingMaster Pivot tables, charts and sparklines to create impressive Google spreadsheetsAnalyze data sets with ease using complex functions & formulasConnect multiple Google Sheets together using a single formulaLearn formulas that work in both Google sheets & Excel!Feel completely comfortable in a spreadsheet environmentFrom the fundamentals, to the most advanced features, after taking this class you will be able to use Spreadsheets like a MASTER. Pretty soon, you'll be using Spreadsheets better than most people can use Excel… and be able to take advantage of the super useful features that only Google Spreadsheets has to offer.So I will see you inside this course, Google Sheets A to Z: Best Free Online Spreadsheet Editor.This class is guaranteed to teach you Google Spreadsheets. Once enrolled, you will have access to this course for the rest of your life. You will always be able to come back to this class to review material or to learn new material. Try this course for yourself and see how quickly and easily you too can learn to use Google Spreadsheets.Enroll now !

Overview

Section 1: Google Sheets A to Z: Best Online Excel Spreadsheet Editor

Lecture 1 Google Sheets A to Z: Best Online Excel Spreadsheet Editor (Promo)

Lecture 2 1 Basics of Google Sheets

Lecture 3 2 BODMAS & Basic Functions

Lecture 4 3 Advanced Maths Functions

Lecture 5 4 Using Wild Card Functions

Lecture 6 5 Logical Functions (IF)

Lecture 7 6 IF Related Functions

Lecture 8 7 IF Related Functions Task

Lecture 9 8 Upper Lower Proper Function

Lecture 10 9 Left Right Find Function

Lecture 11 10 Left & Right more examples

Lecture 12 11 Concatenate Function

Lecture 13 12 Replace & Substitue Function

Lecture 14 13 Split Function one Column

Lecture 15 14 Filters Function in Google Sheets

Lecture 16 15 Named Ranges & Links

Lecture 17 16 Data Validation & Charts

Lecture 18 17 Hlook & Vlook Function

Lecture 19 18 Other Functions

Lecture 20 19 PMT, PPMT, IPMT & PV

Lecture 21 20 Sharing & Protection in Sheet

Business professionals looking to expand their skills.,Students who want to make sure they have the right level of knowledge to succeed at their next job.,Spreadsheet users who want to discover & showcase new tips and tricks at work.,Absolute beginners who want a structured, engaging, fun and practical Google Sheets course.