Google Sheets from Beginner to Advanced
3.8 (76 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,857 students enrolled

Google Sheets from Beginner to Advanced

Manage your work and life with Google Sheets
3.8 (76 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,857 students enrolled
Created by Tony Hat
Last updated 10/2018
English
English [Auto]
Current price: $62.99 Original price: $104.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 2 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understanding of Google Ecosystem management
  • Build a solid understanding on the Google Sheets Basics
  • Create amazing visualisation with Google Charts
  • Link sheets to Internet and Web data to the Sheets
  • Creating dynamic reports with Pivot Tables
  • Manage Surveys by using Google Forms
  • Master the data by Lookup, IF, SUM & FILTER, GETPIVOTDATA and others..
  • Analyze Data with Google Queries
  • Automate your work by Macros and modify it by Scripting
Requirements
  • PC, Chromebook or other device to work with Google Sheets
  • A Google or Gmail account
Description

This course will lead you from Basic to Advanced level. You will be able to manage your data, task, analysis, reports, queries, and other activities easily. You will learn great tools as a Pivot Tables and Vlookup Functions. By mastering the Queries you can see how Google Sheets can be better than Excel. You will also learn how to work with Adds-on templates.

The course contains practical training assignments so you can develop your knowledge by practice. Links to the Data, Assignments & Results are available in Bonus Section #7.

**Include Google Sheets May 2018 Updates** 

Who this course is for:
  • Anyone who wants to improve the Google Sheets knowledge
  • Anyone who wants to enhance own life with this tool
Course content
Expand all 41 lectures 04:57:19
+ 3 Google Ecosystem
1 lecture 06:25
How to work with Google apps
06:25
+ 4 Google Sheets Beginners
18 lectures 02:22:14
  • Define spreadsheet title
  • Moving and Copying Data in the worksheet
  • Share spreadsheet
  • Inserting and Deleting Rows and Columns
  • Changing the Width and Height of Cells
  • Hiding and Unhiding Rows and Columns
Work with the versions
4.1.1 Create new spreadsheet
09:07
  • Add sheet
  • Delete sheet
  • Rename sheet
  • Duplicate sheet
  • Move sheet
  • Change sheet color
  • Hide sheet
  • Unhide sheet
4.1.2 Organize sheets
04:50
  • Copy and paste data
  • Create Header
  • Use Text wrapping
  • Format text and fill colors
  • Freeze rows and columns
  • Use borders
Preview 07:39
  • Set Number/Text (Order number to text)
  • Set Date formats
  • Set currency formats
  • Copy the formats
4.2.2 Working with data formats
11:41
  • Hide unimportant columns
  • Prepare lines for formulas
  • Use basic formulas (+)
  • Use simple cell reference
4.2.3 Basic formulas and cell references
06:39
  • Create new filter
  • Filter by values
  • Filter by conditions
  • Save filter
  • Use multiple filter view
4.2.4 Data filtering
09:33
  • Use the calculations SUM, AVERAGE, COUNT, MAX, MIN
  • AutoFill to Copy functions
  • Absolute versus relative reference (A$1$ v A1)
4.3.1 How to use basic formulas
13:09
  • Get functions Syntax and Samples
  • Write the formula (SUMPRODUCT)
  • 4.3.2.1 Show the colors and formula syntax
  • Get the formula help
  • Solve the issues
4.3.2 Managing the formulas
07:13
  • Merging and centering cells
  • Conditional formatting for numbers
  • Conditional formatting for dates 
  • Conditional formatting for numbers by using color scale
  • Conditional formatting by using Custom formula
  • Prioritize formats
4.4.1 Conditional formatting
14:51
  • Create filter
  • Filter by text (Orders)
  • Filter by Date (Schedule Ship Date is before 12/31/2017)
  • Filter by price (price is greater than $150)
  • Multiple filters (filter in two columns)
  • Create filter views
4.4.2 Filtering Data
09:49
  • Add image by inserting URL
  • Use “IMAGE” function
  • Add image from Drive
4.5.1 Inserting Images
07:34
  • Create flowchart / orgchart 
  • Format the Drawings
  • Downloading the drawings 
4.5.2 Gsheet Drawings
07:12
  • Define the Data for the chart
  • Insert chart
  • Customize the chart
4.6.1 Creating a Column Chart
07:58
  • Modify the series
  • Publishing the Charts
  • Modify the Chart Titles
4.6.2 Modify and Publish the Chart
05:27
  • Auto Create the charts
  • Modify the charts
4.6.3 Charts Auto creation
05:49
  • Explain Sparklines - showing trend
  • Create Line Sparkline chart - open the function
  • Create Column Sparkline chart
  • Modify the colors



    4.6.4 Sparklines charts
    03:20
    • Publishing one sheet
    • Stop publishing
    • Publish whole Spreadsheet
    • Viewing your Document in Print Preview
    • Changing the Margins, Scaling and Orientation
    • Adding Header and Footer Content
    • Printing a Specific Range of Cells
    4.7 Publishing and Printing Gsheet Worksheet
    05:45
    • Intro to Gsheet Templates
    • Opening an Existing Template from menu
    • Use the Add-ons templates to get professional styles
    4.8 Working with Sheet Templates
    04:38
    + 5 Google Sheets Intermediate
    10 lectures 01:11:01
    • Importing Data from Text Files (*.csv)
    • Importing Data from  Excel
    • Importing data from Google Drive (excel in Drive)
    • Getting data from web (IMPORTHTML
    Preview 08:32
    • Export the sheet to different formats
    • Publish the sheet: Link (keep linked} or embed (no linked)
    • Export Google sheet from Drive
    5.1.2 Export Data from GSheet
    04:44
    • Add-ons introduction
    • Power Tools
    • Split the names
    • Split by position (Country)
    • Duplicate the sheet, make changes and compare two sheets
    • Find Duplicated rows
    5.2.1 Splits, Duplicates, Comparisons by Add-ons
    09:22
    • Define the Forms
    • Review the Responses
    5.3 Using Gsheet Forms
    06:02
    • Gsheet Function: DSUM()
    • Gsheet Function: DCOUNT()
    • Gsheet Function: DAVERAGE()
    • Gsheet Function: SUBTOTAL()
    5.4 Gsheet Database Functions
    10:11

    Creating and practicing Validation Rules

    5.5 Gsheet Data Validation
    04:39
    • Take suggestion from Explore (Use more..)
    • Using suggested Pivots
    • Creating Pivot Table
    • Formatting Pivot Table Data
    • Filtering Pivot Table Data
    5.6.1 Create basic Pivot Table
    08:25
    • Grouping Pivot Table Data
    • Expand / Collapse the Data
    • Creating Pivot Charts
    • Pivot Calculated Fields
    5.6.2 Enhanced Pivot Features
    08:09
    • Using the Freeze Panes Tool
    • Consolidating Data from Multiple Worksheets
    5.7.1 Consolidating Data from multiple sheets
    05:31
    • Linking Worksheets by function IMPORTRANGE
    5.7.2 Consolidating Data from multiple Worksheets
    05:26
    + 6 Google Sheets Advanced
    8 lectures 01:07:42
    • Using IF() Function
    • Nesting Functions
    • Using COUNTIF() Function
    • Using SUMIF() Function
    6.1 Working with Conditional Functions
    08:14
    • Using LOOKUP() Function
    • Use absolute reference for data range
    • Transpose the data to sheet “b”
    • Using HLOOKUP() Function
    • Using IFERROR() Function
    • Use Conditional formatting to identify “Not found” results
    6.2.1 Lookup functions
    13:09
    • Using INDEX() and MATCH() Functions
    • Using GETPIVOTDATA
    6.2.2 Other Lookup Functions
    09:42
    • Using Gsheet's LEFT(), RIGHT() and MID() Functions
    • Using Gsheet's LEN() Function
    • Using Gsheet's SEARCH() Function
    • Using Gsheet's CONCATENATE() Function
    6.3 Working with Text Functions
    09:16
    • Protecting Data Range in a Worksheet
    • Protecting the whole Worksheet

    Preview 03:51
    • Using query for easier way to analyze data
    • Practicing various Queries
    6.5 Retrieving Data by Query Function
    09:36
    • Understanding Gsheet Macros
    • Creating a Macro with the Macro Recorder
    6.6 Automating Repetitive Tasks with Macros
    06:56
    • Modify the Macros
    6.7 Simple Scripting
    06:58
    + 7 Bonus section
    2 lectures 00:50
    Link to Curriculum and Spreadsheets
    00:33
    Bonus Lecture: 75% DISCOUNT to Google Data Studio Course
    00:17