Home
Videos uploaded by user “Learn Google Spreadsheets”
Google Sheets VLOOKUP from another Spreadsheet with IMPORTRANGE Tutorial - Part 7
 
08:10
Video tutorial series about VLOOKUP function in Google Sheets and various ways it can be applied. In this video we'll cover how to use VLOOKUP & IMPORTRANGE functions to lookup data from another spreadsheet. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - Drop Down List, 2 Dependent Dropdown Lists
 
14:45
Learn how to make dependent dropdown data validation lists and have different dropdown values based on another cell.
Google Sheets - Combine Data From Multiple Sheets (Tabs) Tutorial
 
11:04
Learn how to Combine Data From Multiple Sheets (Tabs) in Google Sheets using arrays & QUERY Function and make an automatic master sheet with all the data combined into one tab. Google Sheets https://www.google.com/sheets/about/ Company Page http://www.chicagocomputerclasses.com/
IMPORTJSON Function - Google Sheets Tutorial - How to Import JSON feed to Spreadsheets
 
07:30
Learn how to import JSON data from API to Google Sheets using user defined IMPORTJSON function. Get the function script here https://www.chicagocomputerclasses.com/google-sheets-import-json-importjson-function/ Google Sheets https://www.google.com/sheets/about/ Company Page http://www.chicagocomputerclasses.com/
Google Sheets QUERY Function Tutorial - Advanced Contains with Matches & Regular Expression - Part 2
 
05:47
Video tutorial series about QUERY function in Google Sheets. In this tutorial we'll cover how to use QUERY function in Google Sheets to pull filtered results out of your main dataset using regular expression. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets IMPORTRANGE Function Tutorial - Learn How to Pull Data From Other SpreadSheets
 
14:54
This video demonstrates how to use IMPORTRANGE Function in Google Sheets. You can import data from other spreadsheets. Thsi is Google Sheets alternative to referring to data in other files in Excel. Sales Data https://docs.google.com/spreadsheets/d/1tSapEb63l53nZjG7suCKuZciTsafP7FA3pSG4aMAEgI/edit?usp=sharing IMPORTRANGE https://docs.google.com/spreadsheets/d/1K5J_M8gFBvpyuWHIo4-_jhlGciZjfcchLuBy6CNpIIk/edit?usp=sharing Google Sheets https://www.google.com/sheets/about/
Google Sheets - Dependent Dropdown List for Entire Column - Apps Scipt, Match Alternative - Part 2
 
24:14
Learn how to assign data validation using Apps Scripts and create dynamic dependent dropdown lists for the whole column for Google Sheets. Script: https://www.chicagocomputerclasses.com/google-sheets-apps-script-dynamic-dependent-dropdown-data-validation-lists/
Google Sheets - SUMIFS, SUM Functions Intro Tutorial
 
12:09
Video tutorial about SUM & SUMIFS functions in Google Sheets. You will learn how to apply conditional summing in Google Sheets. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets ARRAYFORMULA, Introductions to Arrays, ARRAY_CONSTRAIN, SORT Functions Tutorial
 
23:17
Learn how to use ARRAYFORMULA function in Google Sheets as well as arrays in Google Sheets. This tutorial will cover array syntax, ARRAYFORMULA, SORT & ARRAY_CONSTRAIN functions and other tips and tricks.
Google Sheets QUERY - SUM, AVERAGE, COUNT, GROUP BY Aggregate Functions Tutorial - Part 5
 
08:39
Video tutorial series about QUERY function in Google Sheets. In this tutorial we'll cover how to use QUERY function in Google Sheets to get aggregate data using SUM, AVG, COUNT functions and Group By Statement. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - INDEX & MATCH  - Part 1
 
16:12
Learn how to use INDEX and MATCH functions in Google Sheets. This tutorial covers fundamentals of Match function (exact type) & Index function.
Google Sheets - Dashboard Tutorial - Shared Filter Slicer for The Dashboard - Part 2
 
15:06
Learn how to create shared filer/slicer for your dashboard in Google Sheets.
Google Sheets QUERY Function Tutorial - SELECT, WHERE, LIKE, AND, OR, LIMIT statements - Part 1
 
19:30
Video tutorial series about QUERY function in Google Sheets. In this tutorial we'll cover how to use QUERY function in Google Sheets to pull filtered results out of your main dataset. We'll use SELECT, WHERE, LIKE, AND, OR and LIMIT statements to filter data by number value, text & text that contains a certain string in it. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Data Studio & Google Sheets Reports Tutorial - DataTable, GeoMap, Filters, Scorecard - Part 1
 
24:14
Pivot Table Video tutorial https://www.youtube.com/watch?v=T98RwlndSZk Video tutorial about using Google Data Studio with Google Sheets. You will learn how to analyze data and create reports using Google Sheets data in Data Studio. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets Apps Script Tutorial - Clear Contents - Part 4
 
05:49
Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent). In this tutorial we'll cover how to clear data and formating using Google Sheets scripts. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - Dashboard Tutorial - Part 1
 
20:48
Learn how to create dynamic dashboards in Google Sheets. This video tutorial will demosntrate examples of skills that will help you create functional and good looking dashboards.
Google Sheets - QUERY from Another Sheet, IMPORTRANGE, Use Multiple Tabs, Subquery Examples Tutorial
 
24:51
Part 8 - In this Google Sheets tutorial see examples & learn how to use QUERY function with data from other sheets or worksheets, get data from other files using IMPORTRANGE function, combine multiple tabs and use them within QUERY function, run subqueries in Query function, implement Col1, Col2 ...etc. syntax.
App Script Editor Tutorial - Google Sheets - Excel VBA Equivalent - Read & Write to Ranges & Cells
 
29:48
Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent). In this tutorial we'll cover how to work with script editor, main spreadsheet app structure, how to write to a cell or a range & how to read information from a cell using Google Sheets Scripts. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets QUERY Function, VLOOKUP with Multiple Matches Tutorial - Part 6
 
10:54
Video tutorial series about VLOOKUP function in Google Sheets and various ways it can be applied. In this video we'll cover how to get QUERY function to work like VLOOKUP exact match and also return multiple results in case of multiple matches. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets QUERY - Filter by Date Range using WHERE Statement Tutorial - Part 3
 
15:36
Video tutorial series about QUERY function in Google Sheets. In this tutorial we'll cover how to use QUERY function in Google Sheets to pull filtered results within a specific date range. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - RegEx REGEXEXTRACT, Functions Exctract, Replace, Match Tutorial - Part 1
 
15:33
Video tutorial series about Google Sheets RegEx functions, how to work with text suing REGEXEXTRACT, REGEXMATCH, REGEXREPLACE functions. You will learn all the basics of regular expression, how to extract text using REGEXEXTRACT, how to replace text using REGEXREPLACE, how to make logical tests and use it for conditional formatting using REGEXMATCH. Unfortunately these functions are not available in Microsoft Excel. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
IMPORTHTML, IMPORTXML Functions - Google Sheets Tutorial to Extract from Web Pages to Spreadsheets 2
 
17:09
Learn how to use IMPORTHTML, IMPORTXML Functions to extract information from websites to spreadsheets. Find more advanced XPATH video here https://www.youtube.com/watch?v=pwZ44kAeiOo Final Worksheets https://docs.google.com/spreadsheets/d/1D9oFE1VFfZouSPBw6O820VkVIi1L0qlnVtKnSOk_FE0/edit?usp=sharing Google Sheets https://www.google.com/sheets/about/ Company Page http://www.chicagocomputerclasses.com/
Google Sheets - Dependent Dropdown List for Entire Column - App Scipt, Run  On User Input - Part 1
 
19:33
Learn how to assign data validation using Apps Scripts and create dynamic dependent dropdown lists for the whole column for Google Sheets.
TEXTJOIN Function, Like VLOOKUP with Multiple Matches - Google Sheets Tutorial, IF, TEXTJOIN, Arrays
 
18:48
Learn how to use TEXTJOIN Function to return multiple matching results, which is something you wouldn't be able to do using VLOOKUP function. TEXTJOIN VLOOKUP replacement https://docs.google.com/spreadsheets/d/1UmMNJVgOWMa3QBDo9yeJyJQQ_FU5Bsxzzkm5nUO4P6U/edit?usp=sharing Google Sheets https://www.google.com/sheets/about/
Google Sheets Drop Down List - Data Validation Tutorial, Dynamic Lists from Ranges
 
10:28
Video tutorial about creating Drop Down List in Google Sheets using Data Validation. You will learn how to make drop down lists from ranges and make them dynamic. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - Dynamic Drop Down Based on Another Cell & Multiple Selections Updated Automatically
 
11:30
Learn how to create dynamic drop down based on another cell using Indirect and Match functions. You will get dependent multiple selection dropdowns that will update automatically as you keep adding new data.
Google Sheets - RegEx REGEXREPLACE, Functions Exctract, Replace, Match Tutorial - Part 3
 
05:45
Video tutorial series about Google Sheets RegEx functions, how to work with text suing REGEXEXTRACT, REGEXMATCH, REGEXREPLACE functions. You will learn all the basics of regular expression, how to extract text using REGEXEXTRACT, how to replace text using REGEXREPLACE, how to make logical tests and use it for conditional formatting using REGEXMATCH. Unfortunately these functions are not available in Microsoft Excel. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets QUERY Date Range using SQL Format Dates Tutorial - Part 4
 
09:41
Video tutorial series about QUERY function in Google Sheets. In this tutorial we'll cover how to use QUERY function in Google Sheets to pull filtered results within a specific date range using SQL date formatting and the date keyword. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - Filter Views & SUBTOTAL Function Tutorial
 
12:52
Learn how to use Filter Views & SUBTOTAL Function in Google Sheets.
Google Sheets - Freeze Rows and Columns Tutorial, How To Freeze Single or Multiple Rows or Columns
 
05:04
Video tutorial about freezing rows & columns in Google Sheets. You will learn how to freeze single or multiple columns in Google Sheets. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - Create Custom Functions (UDF) using Apps Script with AutoComplete Tutorial - Part 5
 
11:40
Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent). In this tutorial we'll cover how to create custom user defined functions using scripts in Google Sheets together with autocomplete functionality. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets Scripts Tutorial - Get & Set Cell Value in Other Sheets - Part 3
 
09:56
Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent). In this tutorial we'll cover how to write & read data from other non-active sheets. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - Macro Recorder Tutorial - How to Record an Apps Script
 
20:52
Learn how to record a script in Google Sheets using macro recorder. This tutorial covers recording macros in absolute or relative mode, modifying macro script in Apps Script editor, tips & tricks during recording.
Google Sheets IF & IFS Functions - Formulas with If, Then, Else, Else If Statements
 
21:43
Video tutorial about Logical Test/Expression, IF function & IFS function in Google Sheets. In this tutorial we'll cover how to use formulas with If, Then, Else, Else If statements using IF & IFS functions in Google Sheets. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - Query IN List Like SQL or Many ORs Using a Range Tutorial - Part 7
 
12:28
Learn how to create SQL like IN statement in QUERY function available in Google Sheets using join logic.
Google Sheets - Pivot Tables Tutorial - includes Grouping by Date using Year, Month Functions
 
35:56
Video tutorial Pivot Tables in Google Sheets. You will learn how to analyze data using Pivot Tables in Google Sheets using different functions, group years and months and more. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
GOOGLEMAPS Function - Google Sheets Tutorial - How to Get Distance & Time Live Data to Spreadsheets
 
08:21
Learn how to get travel distance & time live data to spreadsheets from Google Maps to Google Sheets using user defined GOOGLEMAPS function. Get the function script here https://www.chicagocomputerclasses.com/google-sheets-google-maps-function-distance-time/ Watch how this function was created https://www.youtube.com/watch?v=0kRKmrk_6bQ Google Sheets https://www.google.com/sheets/about/
Google Sheets VLOOKUP Function Tutorial - INDEX & MATCH, QUERY - Part 1
 
32:51
Video series about VLOOKUP function in Google Sheets and various ways it can be applied. Other functions covered in these series: INDEX & MATCH, QUERY, IFERROR. If you need to jump to certain point, see below: Merge Data Using VLOOKUP function: https://www.youtube.com/watch?v=B8118U0z0_k VLOOKUP is sorted (Approximate Match) https://www.youtube.com/watch?v=AwOM3yzN3so Organize Data Using VLOOKUP Function https://www.youtube.com/watch?v=8hAn0G-tLWc INDEX & MATCH Functions as VLOOKUP alternative https://www.youtube.com/watch?v=-nqLkqXnAvg Google Sheets https://www.google.com/sheets/about/
Google Sheets Apps Script - If, Then, Else If, Else JavaScript Statements Tutorial - Part 6
 
17:43
Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent). In this tutorial we'll cover how to use If, Then, Else If, Else statements in Google Sheets scripts. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - Apps Script New Authorization Steps 2017 Tutorial - Part 8
 
02:46
Quick video tutorial that covers how to do Apps Script Authorization Steps in Google Sheets since Google has made some changes to these steps in 2017. Google Sheets https://www.google.com/sheets/about/ Company Page http://www.chicagocomputerclasses.com/
Google Sheets Web App Example - Google Apps Script Web App Tutorial - Part 1
 
31:41
Learn how to create Web App with Google Apps Script and have it interact with Google Sheets using JavaScript & HTML. Support the Channel: https://www.patreon.com/chicagocomputerclasses #webapp #google #spreadsheet
Google Sheets - VLOOKUP to Return a Value From the Left using ARRAYFORMULA Tutorial - Part 8
 
05:21
Video tutorial series about VLOOKUP function in Google Sheets and various ways it can be applied. In this video we'll cover how to use VLOOKUP & ARRAYFORMULA functions to lookup data from a columnd and return values located to the left of that column. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets - Apps Script Fill Down Formula (Set a Fromula & Copy Down AutoFill) Tutorial - Part 9
 
11:52
Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent). In this tutorial we'll cover how to Fill Down a Formula (Set a Fromula & Copy Down with AutoFill) in Google Sheets using scripts. We also cover how to get last row in our data. Methods used: setFormula, getLastRow, copyTo, getRange. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Excel - Find Matching Values in Two Worksheets, Tables or Columns Tutorial - Part 1
 
14:44
In this video tutorial learn how to find matches in two worksheets in Microsoft Excel.
Google Sheets - RegEx REGEXEXTRACT, Functions Exctract, Replace, Match Tutorial - Part 2
 
12:05
Video tutorial series about Google Sheets RegEx functions, how to work with text suing REGEXEXTRACT, REGEXMATCH, REGEXREPLACE functions. You will learn all the basics of regular expression, how to extract text using REGEXEXTRACT, how to replace text using REGEXREPLACE, how to make logical tests and use it for conditional formatting using REGEXMATCH. Unfortunately these functions are not available in Microsoft Excel. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Sheets Apps Script - Read Range to a JavaScript Array & Write to a Range Tutorial - Part 7
 
10:21
Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent). In this tutorial we'll cover how to read a range to a JavaScript array & write an array to a range in Google Sheets using scripts. Google Sheets https://www.google.com/sheets/about/ Website: https://www.chicagocomputerclasses.com/
Google Forms with Google Sheets Spreadsheet, How to Link Them Together - Part 1
 
13:13
This tutorial will demonstrate how to create a basic form with Google Forms and link it to Google Sheets which you can later export to an Excel Spreadsheet. #googleforms
Google Sheets - Import Data from Another Sheet - Tutorial Part 1
 
17:43
In this video tutorial learn how to import data from another sheet (file, workbook) or multiple sheets in Google Sheets.
JavaScript Arrays & Methods - Part 1 - Google Sheets Apps Script Tutorial
 
15:13
Learn about JavaScript arrays & array methods. This tutorial covers common JavaScript array methods, using Apps Scirpt to write array to Google Sheets, moving Google Sheets data to a JavaScript array & more.
Google Sheets - Tutorial for Beginners - Part 1
 
30:56
This is entry level tutorial for Google Sheets, best for beginners with little to no prior experience with Google Sheets. We'll go over basic user interface, how to create a spreadsheet, add/remove worksheets, apply formatting, get basic totals & averages and create simple charts. #googlesheets #googledocs