About This Course

Do you want to learn everything there is to know about Google Sheets in one complete course?

Do you want a course that will let you learn the basics of how spreadsheets work before building up to intermediate and advanced topics such as macros, arrays and complex functions?

Do you want access to spreadsheets that you can use to practise the exercises as you go through each lesson?

If so, then The Google Sheets Masterclass course is for you! This course will teach you everything you need to know about building practical and elegant spreadsheets.

This course is divided up into beginner, intermediate and advanced sections. Depending on your skill level, you can do the entire course or skip ahead to the lessons you want to learn. It’s totally up to you!

Over more than eight hours, you will start at the beginner level where you will learn how to access Google Sheets and get your first spreadsheet started, before learning about: cells, rows, columns and tabs; formatting data; basic formulas and functions; and much more.

You will then move onto the intermediate section of the course where you will learn about: sorting and filtering data, including filter views; data validation; charts; and dozens of intermediate level functions such as VLOOKUP, INDEX/MATCH, SUMIF, RANK, TRIM and CONCATENATE.

Then, you will finish with the advanced section of the course where you will discover all about: arrays, named ranges; basic macros; and advanced level functions such as MMULT, SUMPRODUCT, NPV and QUERY.

We cover everything there is to know in Google Sheets for you to be able to build amazing spreadsheets. 

Requirements:

  • Access to Google Sheets

Who this course is for:

  • Anyone who wants to learn beginner, intermediate and advanced Google Sheets topics

Our Promise to You

By the end of this course, you will have learned everything there is to know about Google Sheets.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about the Google Sheets.

Course Curriculum

Section 1 - Beginner Level
Course Introduction 00:00:00
Beginner Level Overview 00:00:00
Beginner Practise Spreadsheet Instructions 00:00:00
Make a Copy 00:00:00
Section 2 - First Steps And Tour
Opening A Google Account 00:00:00
Opening Google Sheets 00:00:00
Open, Name And Save First Spreadsheet 00:00:00
Main Menu Tour 00:00:00
Version History and Sharing Tour 00:00:00
Menu Ribbon Tour 00:00:00
Rows, Columns And Worksheets Tour 00:00:00
Formula Bar Tour 00:00:00
In Cells 00:00:00
In Rows And Columns 00:00:00
Section 3 - Copying, Pasting, Cutting And Deleting Data
Copying And Pasting Data 00:00:00
Cutting And Pasting Data 00:00:00
Deleting Data 00:00:00
Paste Special 00:00:00
Auto-Fill 00:00:00
Section 4 - Managing Spreadsheets
Cells, Rows And Columns 00:00:00
Worksheets (Tabs) 00:00:00
Freezing Panes 00:00:00
Section 5 - Formatting
Font Size And Type 00:00:00
Bold, Italics And Strikethrough 00:00:00
Text And Background Colour 00:00:00
Vertical And Horizontal Align 00:00:00
Text Wrap And Rotation 00:00:00
Formatting Numbers 00:00:00
Borders, Gridlines And Alternating Colours 00:00:00
Section 6 - Basic Formulas And Functions
Formulas Vs Functions 00:00:00
SUM 00:00:00
COUNT 00:00:00
AVERAGE 00:00:00
MAX and MIN 00:00:00
Forcing Text 00:00:00
Section 7 - Inserting Images, Notes And Comments
Inserting Images 00:00:00
Inserting Notes And Comments 00:00:00
Section 8 - Importing And Exporting
Importing Excel Files 00:00:00
Printing 00:00:00
Sharing 00:00:00
Publishing, Emailing And Downloading 00:00:00
Section 9 - Intermediate Level
Intermediate Level Overview 00:00:00
Intermediate Practise Spreadsheet Instructions 00:00:00
Make A Copy 00:00:00
Section 10 - Intermediate Functions
Date – DATE, DAY, DAYS, EDATE, NOW, TODAY 00:00:00
Info – CELL, ISBLANK, ISERR, ISERROR 00:00:00
Logical 1 – IF, AND, OR 00:00:00
Logical 2 – IFERROR 00:00:00
Logical 3 – Nested IF 00:00:00
Logical 4 – IFS 00:00:00
Absolute Cell References 00:00:00
Lookup 1 – VLOOKUP, HLOOKUP 00:00:00
Lookup 2 – INDEX/MATCH 00:00:00
Lookup 3 – INDEX/MATCH vs VLOOKUP 00:00:00
Maths 1 – COUNT, COUNTIF, COUNTIFS, COUNTBLANK 00:00:00
Maths 2 – ROUND, ROUNDDOWN, ROUNDUP 00:00:00
Maths 3 – SUM, SUMIF, SUMIFS 00:00:00
Maths 4 – SUBTOTAL 00:00:00
Statistical 1 – AVERAGE, AVERAGEIF, AVERAGEIFS, AVERAGE.WEIGHTED 00:00:00
Statistical 2 – RANK 00:00:00
Text 1 – LEFT, RIGHT, LEN 00:00:00
Text 2 – TRIM, SUBSTITUTE, REPLACE 00:00:00
Text 3 – CONCATENATE, CONCAT, AMPERSAND 00:00:00
Multi-Tab Formulas And Functions 00:00:00
Section 11 - Working With Data
Sorting Data 00:00:00
Filtering Data 00:00:00
Filter Views 00:00:00
Conditional Formatting 00:00:00
Data Validation 00:00:00
Section 12 - Charts
Line, Bar And Combination Charts 00:00:00
Pie Charts 00:00:00
Section 13 - Pivot Tables And Charts
Pivot Tables 00:00:00
GETPIVOTDATA 00:00:00
Pivot Charts 00:00:00
Section 14 - Protection
Protecting Sheets And Ranges 00:00:00
Section 15 - Advanced Level
Advanced Level Overview 00:00:00
Advanced Practise Spreadsheet Instructions 00:00:00
Make A Copy 00:00:00
Section 16 - Array Functions
What Is An Array? 00:00:00
Curly Brackets 00:00:00
ARRAYFORMULA 00:00:00
ARRAY_CONSTRAIN 00:00:00
MMULT 00:00:00
TRANSPOSE 00:00:00
SUMPRODUCT 00:00:00
FILTER 00:00:00
SORT 00:00:00
Section 17 - Database Functions
DSUM, DAVERAGE, DCOUNT, DCOUNTA 00:00:00
Section 18 - Financial Functions
EFFECT, NOMINAL, INTRATE, RATE 00:00:00
FV, NPV, PV 00:00:00
IRR, NPER, PMT, YIELD 00:00:00
Section 19 - Google Functions
GOOGLEFINANCE, GOOGLETRANSLATE 00:00:00
QUERY With SELECT, AND, ORDER BY, LIMIT 00:00:00
SPARKLINE 00:00:00
Section 20 - Web Functions
IMPORTHTML 00:00:00
IMPORTRANGE 00:00:00
Section 21 - Combining Functions
Combining Curly Brackets, ARRAYFORMULA, SORT, FILTER And ARRAY_CONSTRAIN 00:00:00
Section 22 - Named Ranges
Fixed Named Ranges 00:00:00
Dynamic Named Ranges 00:00:00
QUERY With Names Ranges 00:00:00
Section 23 - Macros
Basic Macros 00:00:00
top
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel