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:
- Confidently navigate through Google Sheets
- Format you data for easy readability
- Understand the different cell reference types and know when to use each of them
- Apply the most used Google Sheets functions
- Start using Google Sheets for your spreadsheets projects (from Personal Budget to business applications)
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!
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
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
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
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
✔️ Pivot Tables
✔️ Formulas
✔️ Functions
✔️ Tips & Tricks
Course 3
Google Sheets Advanced Training
✔️ Data Validation
✔️ (Pivot) Tables & Graphs
✔️ Macros (basic)
✔️ Collaboration best practices