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 at Upskill Technologies.
Excel Dashboard training to create stunning dashboards using simple tips and tricks.
Learn how to create stunning charts for business.
Google sheet training at Upskill Technologies.
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