| 1 - Course and Data Table Introduction English.vtt | 2.7 KB | ||
| 1 - Course and Data Table Introduction.mp4 | 29.8 MB | ||
| 1 - Google Sheets Advanced.txt | 102.4 B | ||
| 1 - Google Sheets Basics Intermediate.txt | 102.4 B | ||
| 10 - Advanced Conditional Formatting Example 1 English.vtt | 2.1 KB | ||
| 10 - Advanced Conditional Formatting Example 1.mp4 | 31 MB | ||
| 11 - Advanced Conditional Formatting Example 2 English.vtt | 2.3 KB | ||
| 11 - Advanced Conditional Formatting Example 2.mp4 | 37.1 MB | ||
| 12 - Pivot Table Introduction and Example 1 English.vtt | 4.4 KB | ||
| 12 - Pivot Table Introduction and Example 1.mp4 | 48.1 MB | ||
| 13 - Advanced Pivot Table Introducing Pivot Filters and Slicer English.vtt | 4.1 KB | ||
| 13 - Advanced Pivot Table Introducing Pivot Filters and Slicer.mp4 | 51.7 MB | ||
| 14 - Pivot Table Example 2 English.vtt | 1.9 KB | ||
| 14 - Pivot Table Example 2.mp4 | 30.6 MB | ||
| 15 - Introduction to Functions English.vtt | 4.1 KB | ||
| 15 - Introduction to Functions Playing around with Average and Sum Functions.mp4 | 51 MB | ||
| 16 - SUMIF and SUMIFS Functions English.vtt | 5.4 KB | ||
| 16 - SUMIF and SUMIFS Functions.mp4 | 70.2 MB | ||
| 17 - Counting Functions COUNT COUNTACOUNTIF COUNTIFS English.vtt | 3.6 KB | ||
| 17 - Counting Functions COUNT COUNTACOUNTIF COUNTIFS.mp4 | 52.2 MB | ||
| 18 - Date Functions TODAY & NOW English.vtt | 1.2 KB | ||
| 18 - Date Functions TODAY & NOW.mp4 | 15.5 MB | ||
| 19 - Concatenate Function English.vtt | 3.9 KB | ||
| 19 - Concatenate Function.mp4 | 53.4 MB | ||
| 2 - Understanding Google Sheets Terminologies English.vtt | 14.5 KB | ||
| 2 - Understanding Google Sheets Terminologies.mp4 | 156.4 MB | ||
| 20 - Understanding Macros Part 1 English.vtt | 4.6 KB | ||
| 20 - Understanding Macros Part 1.mp4 | 56.7 MB | ||
| 21 - Understanding Macros Part 2 English.vtt | 2.1 KB | ||
| 21 - Understanding Macros Part 2.mp4 | 32.3 MB | ||
| 22 - IMPORT Functions English.vtt | 2.2 KB | ||
| 22 - IMPORT Functions Starting with IMPORTDATA.mp4 | 12.5 MB | ||
| 23 - IMPORTHTML Function English.vtt | 4.6 KB | ||
| 23 - IMPORTHTML Function.mp4 | 42.5 MB | ||
| 24 - IMPORTRANGE English.vtt | 5.1 KB | ||
| 24 - IMPORTRANGE The most important safety function.mp4 | 42.7 MB | ||
| 25 - Understanding REF Error and how to resolve it English.vtt | 1.2 KB | ||
| 25 - Understanding REF Error and how to resolve it.mp4 | 9.2 MB | ||
| 26 - VLOOKUP Function within the Google Sheet English.vtt | 4.3 KB | ||
| 26 - VLOOKUP Function within the Google Sheet.mp4 | 30.5 MB | ||
| 27 - TRIM and VLOOKUP Nesting English.vtt | 3.5 KB | ||
| 27 - TRIM and VLOOKUP Nesting.mp4 | 23.7 MB | ||
| 28 - VLOOKUP between Google Sheets Nesting with IMPORTRANGE English.vtt | 5 KB | ||
| 28 - VLOOKUP between Google Sheets Nesting with IMPORTRANGE.mp4 | 37.6 MB | ||
| 29 - Clean VLOOKUP Taking one step ahead with VLOOKUP Function English.vtt | 3.9 KB | ||
| 29 - Clean VLOOKUP Taking one step ahead with VLOOKUP Function.mp4 | 26.2 MB | ||
| 3 - Google Sheet Shortcuts English.vtt | 4 KB | ||
| 3 - Google Sheet Shortcuts.mp4 | 53.9 MB | ||
| 30 - VLOOKUP God Mode Unlocked ARRAYFORMULAVLOOKUP.mp4 | 27.1 MB | ||
| 30 - VLOOKUP God Mode Unlocked English.vtt | 4 KB | ||
| 31 - Overcoming VLOOKUPs cons English.vtt | 4.1 KB | ||
| 31 - Overcoming VLOOKUPs cons INDEXMATCH Functions within the Google Sheet.mp4 | 30.2 MB | ||
| 32 - INDEXMATCH Functions between Google Sheets Nesting with IMPORTRANGE English.vtt | 4.3 KB | ||
| 32 - INDEXMATCH Functions between Google Sheets Nesting with IMPORTRANGE.mp4 | 33.6 MB | ||
| 33 - Functionality problem with INDEX MATCH and ARRAYFORMULA Use Reverse VLOOKUP English.vtt | 3.9 KB | ||
| 33 - Functionality problem with INDEX MATCH and ARRAYFORMULA Use Reverse VLOOKUP.mp4 | 29 MB | ||
| 34 - Understanding the basic concepts of QUERY Most useful function English.vtt | 5.3 KB | ||
| 34 - Understanding the basic concepts of QUERY Most useful function.mp4 | 36.5 MB | ||
| 35 - Understanding QUERY Clauses English.vtt | 5.2 KB | ||
| 35 - Understanding QUERY Clauses.mp4 | 34.6 MB | ||
| 36 - Query between the Google Sheets English.vtt | 3.7 KB | ||
| 36 - Query between the Google Sheets.mp4 | 27.4 MB | ||
| 37 - How to give cell reference in a QUERY Dynamic QUERY English.vtt | 3.7 KB | ||
| 37 - How to give cell reference in a QUERY Dynamic QUERY.mp4 | 27.2 MB | ||
| 38 - Google Sheet Wizard Problem Statement 1 Part 1 English.vtt | 10.1 KB | ||
| 38 - Google Sheet Wizard Problem Statement 1 Part 1.mp4 | 66.4 MB | ||
| 39 - Google Sheet Wizard Problem Statement 1 Part 2 English.vtt | 11 KB | ||
| 39 - Google Sheet Wizard Problem Statement 1 Part 2.mp4 | 89.4 MB | ||
| 4 - Filter and Filter Views English.vtt | 2.7 KB | ||
| 4 - Filter and Filter Views.mp4 | 31 MB | ||
| 40 - Google Sheet Wizard Problem Statement 1 Part 3 English.vtt | 13.8 KB | ||
| 40 - Google Sheet Wizard Problem Statement 1 Part 3.mp4 | 101.5 MB | ||
| 41 - Google Sheet Wizard Problem Statement 1 Final Part 4 English.vtt | 6.9 KB | ||
| 41 - Google Sheet Wizard Problem Statement 1 Final Part 4.mp4 | 45.7 MB | ||
| 42 - Google Sheet Wizard Problem Statement 2 Dependent Dropdowns in Google Sheets English.vtt | 11.1 KB | ||
| 42 - Google Sheet Wizard Problem Statement 2 Dependent Dropdowns in Google Sheets.mp4 | 66.6 MB | ||
| 43 - Google Sheet Wizard Problem Statement 3 Playing with Checkboxes English.vtt | 7.6 KB | ||
| 43 - Google Sheet Wizard Problem Statement 3 Playing with Checkboxes.mp4 | 42.8 MB | ||
| 5 - Filter with ColorText Conditions English.vtt | 2.2 KB | ||
| 5 - Filter with ColorText Conditions.mp4 | 27.1 MB | ||
| 6 - Data Sorting English.vtt | 1 KB | ||
| 6 - Data Sorting.mp4 | 12.4 MB | ||
| 7 - Data Validation English.vtt | 1.9 KB | ||
| 7 - Data Validation.mp4 | 22.7 MB | ||
| 8 - Data Cleanup English.vtt | 1.7 KB | ||
| 8 - Data Cleanup Removing Duplicates and using UNIQUE Function.mp4 | 21.3 MB | ||
| 9 - Conditional Formatting English.vtt | 1.4 KB | ||
| 9 - Conditional Formatting.mp4 | 18.3 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 90 total files | |||
Becoming A Google Sheet Wizard
https://DevCourseWeb.com
Published 6/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.74 GB | Duration: 3h 1m
Learn why It's better than Microsoft EXCEL and become an Expert in 3 Hours
What you'll learn
Basics of Google Sheets
Intermediate level of Google Sheets
Advanced level of Google Sheets
Clubbing everything together - Advance level automation (Reason why you never needed to learn scripting)
Requirements
No google sheets or excel knowledge needed you will learn everything from the basics to the high level automation on the go.
Description
The two most analytical softwares where a person learns to get a feel about data is "Microsoft Excel" and "Google Sheets". These two might be complex but they help you start learning about how you can play with and visualize data in a BETTER form.Time to sit into my rocket ship for the next 3 hrs and I will open up that anaytical space for you.You will get to learn : -1) Introduction - This section contain information about the Course and Data Table which we will use throughout the course.2) Google Sheets Basics - This will be for the beginners who have never touched Google Sheets this will give you information about the basic terminologies and data management.3) Google Sheets Intermediate - In this section you will learn how to use conditional formatting, pivot tables and the BEST intermediate level functions.4) Google Sheets Advanced - This section covers some high level functions which will be used in google sheet automation.5) Mastering Automation - This section will be the final level you need to achieve before setting your foot into the data world and will help you in summing up everything you have learned with the help of 3 Problem Statements.
Overview
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.8 GB | freecoursewb | 2 months | 1 | 4 | |
| 905 MB | freecoursewb | 3 months | 4 | 4 | |
| 2.1 GB | freecoursewb | 8 months | 3 | 19 | |
| 512.1 MB | freecoursewb | 1 year | 8 | 0 | |
| 3.7 GB | freecoursewb | 1 year | 15 | 1 |
All Comments