Google Sheets: Complete Course to Master Google Spreadsheet

A Step by Step guide to Google Sheet by Industry Expert in Easy to follow style

Created by TELCOMA Global, Last Updated 27-Apr-2021, Language:English

What Will I Get ?

Create, edit, and share spreadsheets
Create Customizable CRM
Create Custom Business Analytics Dashboard
Explore Google Apps Script
Make Forms/Surveys and Collect/Analyze Data
Write Faster With Spreadsheets
Use various Add-ons
Implement Extra Resources To Manage Spreadsheets

Requirements

Google Account

Description

Welcome to Google Sheets: Complete Course to Master Google Spreadsheet With Google Sheets, you can create, edit, and collaborate wherever you are. This course will help you to get the most from Google Sheets.

Google Sheets is the most popular online spreadsheet software. Knowing Google Sheets will make your job easier.

Join in, As for learning Google sheet this course is the authority and equally important you will get a certification of completion that validates your skills.

Course Content

Basics of Google Sheets

15 Lectures 01:03:28
- Create and fill spreadsheet
  
  Preview
  
  00:06:47
- Format data
  
  Preview
  
  00:04:43
- Sharing and Protecting Sheets
  
  00:06:50
- Downloading Data & Work Offline
  
  00:03:42
- Formulas
  
  00:06:04
- alternate apps & create template apps
  
  00:04:27
- addons-blockspring
  
  00:03:42
- automatically add contacts
  
  00:03:37
- integrate twitter
  
  00:04:11
- count tweet length
  
  00:03:18
- introduction google sheets
  
  00:02:24
- using help tab
  
  00:03:33
- create HTML table
  
  00:02:28
- enter data & name data range
  
  00:03:27
- pull data from any other app
  
  00:04:15
Making Forms

4 Lectures 00:28:35
- Create & Customize Forms
  
  00:12:00
- Add & View Responses
  
  Preview
  
  00:02:41
- Share, Print and Add ons
  
  00:07:40
- Integrate Google Forms
  
  00:06:14
Create Customizable CRM

7 Lectures 00:43:23
- Move Data to Another Sheet
  
  Preview
  
  00:08:46
- Adding IDs
  
  00:03:38
- If Else Formula
  
  00:06:32
- Add New Link
  
  00:03:23
- Select Data to Scrape
  
  00:06:59
- X-path, Import XML
  
  00:08:50
- Conditional Formatting
  
  00:05:15
Write Faster With Spreadsheets

5 Lectures 00:30:51
- Editorial Calendar & Track Items
  
  Preview
  
  00:04:51
- Import Data from Websites & Feeds
  
  00:06:48
- Identify, Translate Text
  
  00:07:42
- Create Linked Text & Display Images
  
  00:05:01
- Publish Spreadsheets
  
  00:06:29
Create Custom Business Analytics Dashboard

4 Lectures 00:23:23
- Create Report
  
  00:05:44
- Run Report
  
  00:05:01
- Using Charts in Reports
  
  00:04:11
- Add Additional Metrics
  
  00:08:27
Using various Add-ons

8 Lectures 01:00:15
- Addons - Forms
  
  Preview
  
  00:07:48
- Addons- Gathering Data
  
  00:09:33
- Addons- Text Tools
  
  00:06:46
- Addons- Formatting
  
  00:09:35
- Addons - Numbers
  
  00:04:56
- Addons- Email Communications
  
  00:11:09
- Addons - Build your own
  
  00:07:18
- Addons - Appsheet
  
  00:03:10
Using various Add-ons 2

4 Lectures 00:24:43
- First Google App Script
  
  00:08:58
- Creating Values
  
  00:07:01
- Creating Header Names
  
  00:04:04
- Sending Multiple Mails
  
  00:04:40
Extra Resources To Manage Spreadsheets

1 Lectures 00:04:24
- Organize file folders and backup
  
  00:04:24

TELCOMA Global

Fanatical Services to the Telecom & IT Industry Since 2009

TELCOMA Global (An ISO 9001:2008 Certified Company) is a provider of IT and Telecommunication based solutions, including Network Solutions, System Integration services, Software Solutions, Consultancy and Education.

TELCOMA Global has been providing excellent services to the IT industry and our clients Since 2007

TELCOMA Global offers industry recognized trainings and global certifications with best in class course content delivered by the certified expert trainers. Earning your Certification gives you a well-respected Expert credential that validates your expertise and enhances your professional credibility.

With TELCOMA Global certification, you hold the power to move ahead in your career, increase your earning potential and add value to any organization.