Explore

Google Sheets: Complete Beginner to Advanced Training Course

8 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

Go from being a Google Sheets beginner to an advanced user with our complete and up-to-date training course!

Description

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:

BEGINNER LEVEL:

How to use these beginner level functions:
- SUM
- COUNT
- AVERAGE
- MAX and MIN
How to work with data:
- Selecting and moving
- Copying and pasting
- Cutting and pasting
- Deleting
- Paste special
- Auto-Fill
How to use the basic components of a spreadsheet:
- Cells, rows and columns
- Worksheets (tabs)
- Freezing panes
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
- Formatting numbers
- Borders, gridlines and alternating colours
- How to insert content such as images
- How to import data
How to export data through:
- Printing
- Sharing
- Emailing
- Downloading

INTERMEDIATE LEVEL:

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
- SUBTOTAL
- AVERAGE, AVERAGEIF, AVERAGEIFS, AVERAGE.WEIGHTED
- RANK
- LEFT, RIGHT, LEN
- TRIM, SUBSTITUTE, REPLACE
- CONCATENATE, CONCAT, AMPERSAND
How to use these amazing data tools:
- Sort
- Filter
- Filter Views
- Conditional Formatting
- Data Validation
How to create charts and graphs such as:
- Pie charts
- Line charts
- Bar or column charts
- Combination charts
How to create and use pivot tables and pivot charts
How to add protection to worksheets and ranges of cells

ADVANCED LEVEL:

How to use these powerful advanced level functions:
- Array functions:
  - Curly Brackets
  - ARRAYFORMULA
  - ARRAY_CONSTRAIN
  - MMULT
  - TRANSPOSE
  - SUMPRODUCT
  - FILTER
  - SORT
- Database Functions:
  - DSUM
  - DAVERAGE
  - DCOUNT
  - DCOUNTA
- Interest Rate Functions:
  - EFFECT
  - NOMINAL
  - INTRATE
  - RATE
- Value Functions:
  - FV
  - NPV
  - PV
- Investment Functions:
  - IRR
  - NPER
  - PMT
  - YIELD
- Google Functions:
  - GOOGLEFINANCE
  - GOOGLETRANSLATE
  - QUERY: with SELECT, AND, ORDER BY and LIMIT
  - SPARKLINE
- Web Functions:
  - IMPORTHTML
  - IMPORTRANGE
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!

Requirements

Requirements
Access to Google Sheets

Recommended for you

Python Complete Masterclass for Beginners

Learn Python including Excel/Database/Test/Network Automation, Data Analysis, Web Development, REST APIs, GraphQL & more ✔ Probably the most PRACTICAL Python 3 course on Udemy...

Save Course

QuickBooks Pro 2017 Training: Manage Small Business Finances

The Easiest, Most Convenient and Surefire Way to Master QuickBooks Pro 2017 Get Confident in Using QuickBooks Pro to Efficiently Manage Your Accounts...

Save Course