GOOGLE SHEETS ESSENTIAL TRAINING

5

Lessons

4

Videos

All

Skill Level

1:11h

Duration

English

Language

Share This Class:

Overview

Google Sheets increased in popularity in the last years after adding many features year after year. This cloud-based spreadsheet application fights now on an equal footing the well known Microsoft Excel. Even if these two applications are similar, as always, there are and will always be strong points on both of the sides.

In the next hours we will focus on Google Sheets and, from time to time, we will make parallels with Microsoft Excel for a smooth transition for ones of you migrating outside of the Microsoft environment. 

During the GOOGLE SHEETS ESSENTIAL TRAINING you will learn as a beginner to work effectively and efficiently with the basic functions of Google Sheets. You learn to enter data, make tables, calculate data and then analyze this data.

Completing this course will help you:

Who is the course for?

Everyone interested in using a spreadsheet software is welcomed to this class. If you have previous experience, in similar software, there is a timestamp feature on the video allowing you to jump to the desired point on interest.

In reality, all you need is a computer connected to internet and time to run through the module (including the exercises). 

And don’t’ forget … keep it fun!

Play Video

Learning Path

Short introduction of the Google Sheets environment followed by basic operations like adding workbooks and worksheets, data (entry, change and deletion) and cell manipulation (select, copy, move, delete, fill handle).

Video 15 Min  + 5 Min read to complete

START NOW – Lesson 1

In this lesson we will start creating the first formulas and copy them across the table. We will then learn how to name ranges in Google Sheets to keep better track of them and create cleaner formulas. We will end this Lesson with an overview of the most used Google Sheets functions.

Video 15 Min  + 5 Min read to complete

START NOW – Lesson 2

You will see that sometimes when copying a formula from one cell to another, the result is not the expected one. In many cases, this is due to the faulty cell reference. We will learn about the absolute, relative and mixed cell reference types and when to use each of them.

Video 8 Min  + 5 Min read to complete

START NOW – Lesson 3

In other words, formatting. We will see how to format your data, cells and tables and then, how to automatically change the formatting based on your defined criteria. In this step, we are adding color to the mathematics.

Coming up soon

In many cases, at least one of your worksheets is a collection of data. It can be 10 lines but maybe hundreds, thousands… To make it easy to read we will create tables, block the header (table titles) so that when you scroll through the table you will always know what your data means and then will show you how to print the table and automatically include the table titles on every printed page. In the end of the lesson we will learn how to Adjust, add and delete rows and columns.

Coming up soon

Are You Ready To Start?

More Courses

You might also be interested in these courses

Course 2

Pivot Tables, Formulas and Functions

✔️ Sorting & filtering
✔️ Pivot Tables
✔️ Formulas
✔️ Functions
✔️ Tips & Tricks

Pivot Tables, Formulas and Functions



5 lessons - 4:11 hours
View Course

Course 3

Google Sheets Advanced Training

✔️ Functions (part 2)
✔️ Data Validation
✔️ (Pivot) Tables & Graphs
✔️ Macros (basic)
✔️ Collaboration best practices

Google Sheets Advanced Training



5 lessons - 4:11 hours
View Course