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