~Get Your Files Here !

  1 - Introduction

   1 - Course and Data Table Introduction.mp4

   1 - Google Sheets Basics Intermediate.txt

  2 - Google Sheets Basics

   2 - Understanding Google Sheets Terminologies.mp4

   3 - Google Sheet Shortcuts.mp4

   4 - Filter and Filter Views.mp4

   5 - Filter with ColorText Conditions.mp4

   6 - Data Sorting.mp4

   7 - Data Validation.mp4

   8 - Data Cleanup Removing Duplicates and using UNIQUE Function.mp4

  3 - Google Sheets Intermediate

   10 - Advanced Conditional Formatting Example 1.mp4

   11 - Advanced Conditional Formatting Example 2.mp4

   12 - Pivot Table Introduction and Example 1.mp4

   13 - Advanced Pivot Table Introducing Pivot Filters and Slicer.mp4

   14 - Pivot Table Example 2.mp4

   15 - Introduction to Functions Playing around with Average and Sum Functions.mp4

   16 - SUMIF and SUMIFS Functions.mp4

   17 - Counting Functions COUNT COUNTACOUNTIF COUNTIFS.mp4

   18 - Date Functions TODAY & NOW.mp4

   19 - Concatenate Function.mp4

   9 - Conditional Formatting.mp4

  4 - Google Sheets Advanced

   20 - Understanding Macros Part 1.mp4

   21 - Understanding Macros Part 2.mp4

   22 - IMPORT Functions Starting with IMPORTDATA.mp4

   23 - IMPORTHTML Function.mp4

   24 - IMPORTRANGE The most important safety function.mp4

   25 - Understanding REF Error and how to resolve it.mp4

   26 - VLOOKUP Function within the Google Sheet.mp4

   27 - TRIM and VLOOKUP Nesting.mp4

   28 - VLOOKUP between Google Sheets Nesting with IMPORTRANGE.mp4

   29 - Clean VLOOKUP Taking one step ahead with VLOOKUP Function.mp4

   30 - VLOOKUP God Mode Unlocked English.vtt

   31 - Overcoming VLOOKUPs cons INDEXMATCH Functions within the Google Sheet.mp4

   32 - INDEXMATCH Functions between Google Sheets Nesting with IMPORTRANGE.mp4

   33 - Functionality problem with INDEX MATCH and ARRAYFORMULA Use Reverse VLOOKUP.mp4

   34 - Understanding the basic concepts of QUERY Most useful function.mp4

   35 - Understanding QUERY Clauses.mp4

   36 - Query between the Google Sheets.mp4

   37 - How to give cell reference in a QUERY Dynamic QUERY.mp4

  5 - Mastering Automation Putting it All Together

   38 - Google Sheet Wizard Problem Statement 1 Part 1.mp4

   39 - Google Sheet Wizard Problem Statement 1 Part 2.mp4

   40 - Google Sheet Wizard Problem Statement 1 Part 3.mp4

   41 - Google Sheet Wizard Problem Statement 1 Final Part 4.mp4

   42 - Google Sheet Wizard Problem Statement 2 Dependent Dropdowns in Google Sheets.mp4

   43 - Google Sheet Wizard Problem Statement 3 Playing with Checkboxes.mp4

  Bonus Resources.txt