image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

Welcome to this course,
Google Sheets Complete Course: Free Online Spreadsheet Excel
This course will give you you everything you need to know about Google Spreadsheets.
From 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.
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 pro
Solve real-life spreadsheet challenges with ease
Learn hacks and hidden Google Sheets features that even the Experts don't know
Create interactive & visually effective dashboards in Sheets
Secrets to properly use tricky features like Conditional formatting
Master Pivot tables, charts and sparklines to create impressive Google spreadsheets
Analyze data sets with ease using complex functions & formulas
Connect multiple Google Sheets together using a single formula
Learn formulas that work in both Google sheets & Excel!
Feel completely comfortable in a spreadsheet environment
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.
So I will see you inside this course, Google Sheets Complete Course: Free Online Spreadsheet Excel.
Enroll now!
Who this course is for:
Absolute beginners who want a structured, engaging, fun and practical Google Sheets course.
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.

What you'll learn

Complete Google Sheet guide from starting to pro

Solve real-life spreadsheet challenges with ease

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

Create interactive & visually effective dashboards in Sheets

Secrets to properly use tricky features like Conditional formatting

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

Analyze data sets with ease using complex functions & formulas

Connect multiple Google Sheets together using a single formula

Learn formulas that work in both Google sheets & Excel!

Feel completely comfortable in a spreadsheet environment

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction to Google Sheets
4
1.1-Google Sheets Complete Course: Free Online Spreadsheet Excel (Promo)
1.2-Why Google Sheets ?
1.3-Requirements of Google Sheets
1.4-Basics of Google Sheets
2-Basics of Functions & Formula
3
2.1-Auto Fill Formula
2.2-Smart Fill Formula
2.3-BODMAS Formula
3-Advanced Maths Functions
4
3.1-Sum & Average Functions
3.2-Count Functions
3.3-Max & Min Function
3.4-Largest & Smaller Function
4-Using Wild Card in Math Function
3
4.1-Using Wild Card a
4.2-Using Wild Card b
4.3-Using Wild Card c
5-Logical Functions - IF()
2
5.1-Logical Operations
5.2-Conditions with Operations
6-IF Related Functions
2
6.1-IF Related Functions 1
6.2-IF Related Functions 2
7-IF Related Functions Task
1
7.1-IF Related Functions Task
8-Upper Lower Proper Function
2
8.1-Upper Lower Proper Function
8.2-Trim Function
9-Left Right Find Nesting
2
9.1-Left Right Function
9.2-Find Function
10-Nesting Methodology
3
10.1-Left Methodology Part 1
10.2-Left Methodology Part 2
10.3-Mid Function
11-Concatenate Function
1
11.1-Concatenate Function
12-Replace & Substitue Function
3
12.1-Replace Function
12.2-Substitue Function
12.3-Split Function
13-Filters Function in Google Sheets
3
13.1-Filter Function
13.2-Slicer & Sort Function
13.3-Conditional Formatting
14-Named Ranges & Links
2
14.1-Named Ranges
14.2-Linking in Sheet
15-Data Validation, Pivot & Chart Presentation
3
15.1-Data Validation in Sheet
15.2-Pivot Table in Sheet
15.3-Chart Presentation in Sheet
16-Hlook & Vlook Function
3
16.1-Vlook Function
16.2-Hlook Function
16.3-Date & Time in Sheets
17-Other Functions in Google Sheet
3
17.1-PMT Function
17.2-PPMT & IPMT
17.3-Present Value
18-Sharing & Protection in Sheet
4
18.1-Sharing Google Sheet
18.2-Google Sheet Protection
18.3-Watch Free Courses
18.4-Bonus