Published 11/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.36 GB | Duration: 4h 40m

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