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 our Google Sheets - Complete Beginner to Advanced Training Course is for you!
What will I learn from this course?
Our Google Sheets - Complete Beginner to Advanced Training Course will teach you everything you need to know about building practical and elegant spreadsheets.
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.
What is the course structure?
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!
We cover everything there is to know in Google Sheets for you to be able to build amazing spreadsheets. Check out the full list of topics we cover on this course:
How to use these beginner level functions:
MAX and MIN
How to work with data:
Selecting and moving
Copying and pasting
Cutting and pasting
How to use the basic components of a spreadsheet:
Cells, rows and columns
Formatting tips and tricks to create great looking spreadsheets:
Font size and type
Bold, italics and strikethrough
Text and background colours
Vertical and horizontal Align
Text wrap and rotation
Borders, gridlines and alternating colours
How to insert content such as images
How to import data
How to export data through:
How to use these powerful intermediate level functions:
DATE, DAY, DAYS, EDATE, NOW, TODAY
CELL, ISBLANK, ISERR, ISERROR
IF, AND, OR, IFERROR, Nested IF functions, IFS
VLOOKUP, HLOOKUP, INDEX/MATCH
COUNT, COUNTIF, COUNTIFS, COUNTBLANK
ROUND, ROUNDDOWN, ROUNDUP
SUM, SUMIF, SUMIFS
AVERAGE, AVERAGEIF, AVERAGEIFS, AVERAGE.WEIGHTED
LEFT, RIGHT, LEN
TRIM, SUBSTITUTE, REPLACE
CONCATENATE, CONCAT, AMPERSAND
How to use these amazing data tools:
How to create charts and graphs such as:
Bar or column charts
How to create and use pivot tables and pivot charts
How to add protection to worksheets and ranges of cells
How to use these powerful advanced level functions:
Interest Rate Functions:
How to create and manage fixed and dynamic Named Ranges
How to combine the functions you have learned and Named Ranges to extract and manipulate large amounts of data easily
How to create and manage basic macros
So what are you waiting for? Sign up today and go from a complete beginner to an advanced user in Google Sheets.
See you on the course!