Tutorialspoint

Google Sheets Certification Training

Comprehensive training on Google Sheets. Store, manage & analyze your data, use functions, build lookup, pivots, charts.

  Uplatz

   IT & Software, IT Certification, Google Sheets

   Published on 11/2021

0

Description

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

Who this course is for:

  • Data Analysts and Consultants
  • Project Managers
  • Newbies aspiring to learn Google Sheets
  • Beginners aspiring to become Data Analysts
  • Data Management Professionals
  • Business and Financial Analysts
  • Project Support Personnel
  • Students aspiring for a career in Management Consulting or IT Operations
  • Students who want to build quick and easy-to-share online spreadsheets


What Will I Get ?

  • End-to-end knowledge of Google Sheets

  • Understand fully the Menu options - File, Edit, View, Insert, Format, Data, more

  • Entering Data and Editing

  • Format and Customize Data

  • Filtering, Sorting, Conditional Formatting

  • Functions - Numeric, Text, Date

  • Pivot Tables, VLookup, HLookup

  • Charts and Graphs

  • Advanced Functions such as Google Translate

  • Introduction to Script Editor

  • Saving, Sharing, Collaboration in Google Sheets

  • Get fully familiarized in a spreadsheet environment

  • Tips and Tricks

Requirements

  • Enthusiasm and determination to make your mark on the world!







0
Course Rating
0%
0%
0%
0%
0%

    Feedbacks (0)

  • No Feedbacks Yet..!
Google Sheets Certification Training
This Course Includes :

2.5 hours

14 Lectures

Lifetime Access

30-Days Money Back Guarantee