Google Sheets
Introduction
Google Sheets is a cloud-based spreadsheet tool that lets you create, edit and collaborate in real time.
You can perform calculations, organize data and visualize it using formulas, charts and filters.
Course Description
Course Captain - Irshad Banu - irshad@desicrew.in
Course Duration - 3 Hours
Course Curriculum
- Google Sheet InterfacePreview
- a. How to open Google Sheet
- b. Basics: Interface, rows, columns, cells
- Google Sheet Functions
- a. SUM Function
- b. AVERAGE Function
- c. COUNT Function
- d. IF Function
- f. VLOOKUP Function
- Data Validation & Drop-Downs
- a. Video about Data Validation & Drop-Downs
- Conditional Formatting
- a. Video about Conditional Formatting
- Filter & Sort for large data
- a. Video about Sort the Data
- b. Video about Filter the Data
- Pivot Tables & Charts
- a. Video about Pivot Table
- b. Video about Charts
- Sharing, Permissions and Real-time Collaboration
- a. Video about Sharing and Permission
- Tips for using Sheets in Quality Tracking
Course includes:
-
Level
101
-
Duration 02:44:00
-
Lessons
22
-
Certifications
Yes
-
Enrolled
0
-
Available seats
0
