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.

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.

  • Entering Data

  • Formatting a table

  • Adding deleting renaming sheets

  • Undo Redo

  • Saving the file

  • Saving a copy

Learning the basics
Formulas

  • Writing basic formulas

  • Sum, Average, Max, Min, Round.

  • Learning Text Functions

  • Learning Sum if

  • Learning Vlook-up

  • Learning google functions

Data Analysis​

  • Filtering Data and analysing

  • Creating chart

  • Creating pivot tables

  • Making Forms

  • Using conditional formatting

Project: Time Tracking
 

  • 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