This course is designed for those interested to learn how to access Google Sheets and start your first spreadsheet, how to use dozens of functions from SUM to VLOOKUP, INDEX/MATCH, NPV and ARRAYFORMULA, and build great spreadsheets with tools like data validation, conditional formatting and macros.
Read more.Instructor
Hi I'm Mark. I have had a great career as an accountant and financial analyst and these days I love making courses.
Only want this course? Buy this course for $199 $29 and keep lifetime access.
Click here
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.
10 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 |