Google Sheets Certification Training

About Google Sheets Certification Training

A warm welcome to the

Google Sheets

course by

Uplatz

.

Google Sheets

is the spreadsheet application software available within Google's cloud-based office suite. Google Sheets has been designed with the needs of agile organizations in mind. AI features mean you can tap into the right insights to make meaningful business decisions. A cloud-based architecture enables you to collaborate with anyone, anytime, anywhere. Compatibility with external systems, including Microsoft Office, removes the friction of working with multiple data sources. Based on Google’s infrastructure, Sheets provides the flexibility to create amazing spreadsheets while helping to keep your information secure. Google sheets is being used by more and more companies instead of Microsoft Excel. There are many advantages to using Google Sheets the main one being the ability to share a sheet with multiple users. It is free to use and works in a browser! So there is no need to install anything on your machine neither to buy any license. This Google Sheets training course by

Uplatz

will get you used to Google sheets and be able to create and manage it in practical situations even if you have never used spreadsheets before. The Google Sheets course will introduce you to the basics of creating spreadsheets using the free Google Sheets application. This course will teach you some of the essential features of Google Sheets and how they can be used to work together in an interactive and graphical way. You will be able to take a deep-dive into all the features and options available in Google Sheets. This Google Sheets training provides detailed demonstration on how to use functions, build pivot tables, charts, formatting, filtering, sorting, AI-based and dynamic functions, analyze data on the fly, and more in Google Sheets.

Course Topics at high-level

An Introduction to Google Sheets

Create a new Google Sheet

Name a Spreadsheet

Upload an Existing Excel Spreadsheet

Edit Cells

Use Auto-fill

Format Cells

Format Text and Numbers

Basic Formulas and Functions

Use the Sum function

Create and Copy Formula using Auto-fill

Sort and Filter data

Finding your way around Google Sheets

Opening Files

Move data from Excel Files to Google Sheets and vice-versa

What about saving files?

File Management

Adding/Deleting Worksheets

Renaming Worksheets Basic Formatting

Formatting Numbers

Dealing with Dates

Changing the Typeface

Adding more fonts

Adding Colors

Format Painter Formulas in Google Sheets

Basic Arithmetic

Operator Preference

Absolute References

Using Functions

Calculating between Worksheets Printing Google Sheets

Selecting a print area

Fitting everything onto a page

Creating a PDF

Printing all sheets Sharing a Google Sheet

Choosing people to share with

Restricting Editing

Preventing others from downloaded and printing

Google Sheets course curriculum

Introduction

Menu Options - File

Menu Options - Edit

Menu Options - View

Menu Options - Insert

Menu Options - Format

Menu Options - Data and more

Entering Data and Filtering

Functions - Numeric Function

Functions - Text Function

Functions - Data Functions

Charts and Conditional Formatting

Pivot Tables

Saving, Sharing, Collaboration

Course Objectives

Learn how to navigate around Google Sheets

Learn how to adjust the way data and information are displayed

Learn how to write formulas quickly and easily

Learn how to create powerful calculations

Learn how to visually represent your data with charts and graphs

Learn how to use data tools like sorting, subtotaling, and filtering

Learn Google sheets shortcuts, tips, tricks