Google Spreadsheet Training

Google Spreadsheet is a free online spreadsheet program provided by Google. All you need to access Google sheet is a google account and a browser. Learn how to quickly create a google spreadsheet, store numbers and information, format and design a report and also collaborate with others in real time.

google sheet training
google sheet training

Google sheet training at Upskill Technologies.

press to zoom
Dashboard Samples
Dashboard Samples

Excel Dashboard training to create stunning dashboards using simple tips and tricks.

press to zoom
Upskill Waterfall Chart
Upskill Waterfall Chart

Learn how to create stunning charts for business.

press to zoom
google sheet training
google sheet training

Google sheet training at Upskill Technologies.

press to zoom
1/5
Intoduction to Google Drive
  • Get a Google Account

  • Introduction to Google Drive

  • Installing Google Drive on PC

  • Accessing drive on browser

  • Creating documents online

  • Creating folders

  • Saving and accessing shared docs.

Learning the basics
  • Entering Data

  • Formatting a table

  • Adding deleting renaming sheets

  • Undo Redo

  • Saving the file

  • Saving a copy

Formulas
  • Writing basic formulas

  • Sum, Average, Max, Min, Round.

  • Learning Text Functions

  • Learning Sum if

  • Learning Vlook-up

  • Learning google functions

Data Analysis
Project: Time Tracking
 
  • Filtering Data and analysing

  • Creating chart

  • Creating pivot tables

  • Making Forms

  • Using conditional formatting

  • Gather and arrange details of developer

  • Design template to enter a new project

  • Design template for time tracking by project and developer

  • Using formulas create a consolidated summary.

Keywords:Google Docs training India, Google spreadsheet training, Corporate Training on google docs