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
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
~Get Your Files Here !/1 - Introduction/1 - Course and Data Table Introduction English.vtt
2.7 KB
~Get Your Files Here !/1 - Introduction/1 - Course and Data Table Introduction.mp4
29.8 MB
~Get Your Files Here !/1 - Introduction/1 - Google Sheets Advanced.txt
94 B
~Get Your Files Here !/1 - Introduction/1 - Google Sheets Basics Intermediate.txt
94 B
~Get Your Files Here !/2 - Google Sheets Basics/2 - Understanding Google Sheets Terminologies English.vtt
14.5 KB
~Get Your Files Here !/2 - Google Sheets Basics/2 - Understanding Google Sheets Terminologies.mp4
156.4 MB
~Get Your Files Here !/2 - Google Sheets Basics/3 - Google Sheet Shortcuts English.vtt
4 KB
~Get Your Files Here !/2 - Google Sheets Basics/3 - Google Sheet Shortcuts.mp4
53.9 MB
~Get Your Files Here !/2 - Google Sheets Basics/4 - Filter and Filter Views English.vtt
2.7 KB
~Get Your Files Here !/2 - Google Sheets Basics/4 - Filter and Filter Views.mp4
31 MB
~Get Your Files Here !/2 - Google Sheets Basics/5 - Filter with ColorText Conditions English.vtt
2.2 KB
~Get Your Files Here !/2 - Google Sheets Basics/5 - Filter with ColorText Conditions.mp4
27.1 MB
~Get Your Files Here !/2 - Google Sheets Basics/6 - Data Sorting English.vtt
1 KB
~Get Your Files Here !/2 - Google Sheets Basics/6 - Data Sorting.mp4
12.4 MB
~Get Your Files Here !/2 - Google Sheets Basics/7 - Data Validation English.vtt
1.9 KB
~Get Your Files Here !/2 - Google Sheets Basics/7 - Data Validation.mp4
22.7 MB
~Get Your Files Here !/2 - Google Sheets Basics/8 - Data Cleanup English.vtt
1.7 KB
~Get Your Files Here !/2 - Google Sheets Basics/8 - Data Cleanup Removing Duplicates and using UNIQUE Function.mp4
21.3 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/10 - Advanced Conditional Formatting Example 1 English.vtt
2.1 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/10 - Advanced Conditional Formatting Example 1.mp4
31 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/11 - Advanced Conditional Formatting Example 2 English.vtt
2.3 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/11 - Advanced Conditional Formatting Example 2.mp4
37.1 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/12 - Pivot Table Introduction and Example 1 English.vtt
4.4 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/12 - Pivot Table Introduction and Example 1.mp4
48.1 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/13 - Advanced Pivot Table Introducing Pivot Filters and Slicer English.vtt
4.1 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/13 - Advanced Pivot Table Introducing Pivot Filters and Slicer.mp4
51.7 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/14 - Pivot Table Example 2 English.vtt
1.9 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/14 - Pivot Table Example 2.mp4
30.6 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/15 - Introduction to Functions English.vtt
4.1 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/15 - Introduction to Functions Playing around with Average and Sum Functions.mp4
51 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/16 - SUMIF and SUMIFS Functions English.vtt
5.4 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/16 - SUMIF and SUMIFS Functions.mp4
70.2 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/17 - Counting Functions COUNT COUNTACOUNTIF COUNTIFS English.vtt
3.6 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/17 - Counting Functions COUNT COUNTACOUNTIF COUNTIFS.mp4
52.2 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/18 - Date Functions TODAY & NOW English.vtt
1.2 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/18 - Date Functions TODAY & NOW.mp4
15.5 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/19 - Concatenate Function English.vtt
3.9 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/19 - Concatenate Function.mp4
53.4 MB
~Get Your Files Here !/3 - Google Sheets Intermediate/9 - Conditional Formatting English.vtt
1.4 KB
~Get Your Files Here !/3 - Google Sheets Intermediate/9 - Conditional Formatting.mp4
18.3 MB
~Get Your Files Here !/4 - Google Sheets Advanced/20 - Understanding Macros Part 1 English.vtt
4.6 KB
~Get Your Files Here !/4 - Google Sheets Advanced/20 - Understanding Macros Part 1.mp4
56.7 MB
~Get Your Files Here !/4 - Google Sheets Advanced/21 - Understanding Macros Part 2 English.vtt
2.1 KB
~Get Your Files Here !/4 - Google Sheets Advanced/21 - Understanding Macros Part 2.mp4
32.3 MB
~Get Your Files Here !/4 - Google Sheets Advanced/22 - IMPORT Functions English.vtt
2.2 KB
~Get Your Files Here !/4 - Google Sheets Advanced/22 - IMPORT Functions Starting with IMPORTDATA.mp4
12.5 MB
~Get Your Files Here !/4 - Google Sheets Advanced/23 - IMPORTHTML Function English.vtt
4.6 KB
~Get Your Files Here !/4 - Google Sheets Advanced/23 - IMPORTHTML Function.mp4
42.5 MB
~Get Your Files Here !/4 - Google Sheets Advanced/24 - IMPORTRANGE English.vtt
5.1 KB
~Get Your Files Here !/4 - Google Sheets Advanced/24 - IMPORTRANGE The most important safety function.mp4
42.7 MB
~Get Your Files Here !/4 - Google Sheets Advanced/25 - Understanding REF Error and how to resolve it English.vtt
1.2 KB
~Get Your Files Here !/4 - Google Sheets Advanced/25 - Understanding REF Error and how to resolve it.mp4
9.2 MB
~Get Your Files Here !/4 - Google Sheets Advanced/26 - VLOOKUP Function within the Google Sheet English.vtt
4.3 KB
~Get Your Files Here !/4 - Google Sheets Advanced/26 - VLOOKUP Function within the Google Sheet.mp4
30.5 MB
~Get Your Files Here !/4 - Google Sheets Advanced/27 - TRIM and VLOOKUP Nesting English.vtt
3.5 KB
~Get Your Files Here !/4 - Google Sheets Advanced/27 - TRIM and VLOOKUP Nesting.mp4
23.7 MB
~Get Your Files Here !/4 - Google Sheets Advanced/28 - VLOOKUP between Google Sheets Nesting with IMPORTRANGE English.vtt
5 KB
~Get Your Files Here !/4 - Google Sheets Advanced/28 - VLOOKUP between Google Sheets Nesting with IMPORTRANGE.mp4
37.6 MB
~Get Your Files Here !/4 - Google Sheets Advanced/29 - Clean VLOOKUP Taking one step ahead with VLOOKUP Function English.vtt
3.9 KB
~Get Your Files Here !/4 - Google Sheets Advanced/29 - Clean VLOOKUP Taking one step ahead with VLOOKUP Function.mp4
26.2 MB
~Get Your Files Here !/4 - Google Sheets Advanced/30 - VLOOKUP God Mode Unlocked ARRAYFORMULAVLOOKUP.mp4
27.1 MB
~Get Your Files Here !/4 - Google Sheets Advanced/30 - VLOOKUP God Mode Unlocked English.vtt
4 KB
~Get Your Files Here !/4 - Google Sheets Advanced/31 - Overcoming VLOOKUPs cons English.vtt
4.1 KB
~Get Your Files Here !/4 - Google Sheets Advanced/31 - Overcoming VLOOKUPs cons INDEXMATCH Functions within the Google Sheet.mp4
30.2 MB
~Get Your Files Here !/4 - Google Sheets Advanced/32 - INDEXMATCH Functions between Google Sheets Nesting with IMPORTRANGE English.vtt
4.3 KB
~Get Your Files Here !/4 - Google Sheets Advanced/32 - INDEXMATCH Functions between Google Sheets Nesting with IMPORTRANGE.mp4
33.6 MB
~Get Your Files Here !/4 - Google Sheets Advanced/33 - Functionality problem with INDEX MATCH and ARRAYFORMULA Use Reverse VLOOKUP English.vtt
3.9 KB
~Get Your Files Here !/4 - Google Sheets Advanced/33 - Functionality problem with INDEX MATCH and ARRAYFORMULA Use Reverse VLOOKUP.mp4
29 MB
~Get Your Files Here !/4 - Google Sheets Advanced/34 - Understanding the basic concepts of QUERY Most useful function English.vtt
5.3 KB
~Get Your Files Here !/4 - Google Sheets Advanced/34 - Understanding the basic concepts of QUERY Most useful function.mp4
36.5 MB
~Get Your Files Here !/4 - Google Sheets Advanced/35 - Understanding QUERY Clauses English.vtt
5.2 KB
~Get Your Files Here !/4 - Google Sheets Advanced/35 - Understanding QUERY Clauses.mp4
34.6 MB
~Get Your Files Here !/4 - Google Sheets Advanced/36 - Query between the Google Sheets English.vtt
3.7 KB
~Get Your Files Here !/4 - Google Sheets Advanced/36 - Query between the Google Sheets.mp4
27.4 MB
~Get Your Files Here !/4 - Google Sheets Advanced/37 - How to give cell reference in a QUERY Dynamic QUERY English.vtt
3.7 KB
~Get Your Files Here !/4 - Google Sheets Advanced/37 - How to give cell reference in a QUERY Dynamic QUERY.mp4
27.2 MB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/38 - Google Sheet Wizard Problem Statement 1 Part 1 English.vtt
10.1 KB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/38 - Google Sheet Wizard Problem Statement 1 Part 1.mp4
66.4 MB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/39 - Google Sheet Wizard Problem Statement 1 Part 2 English.vtt
11 KB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/39 - Google Sheet Wizard Problem Statement 1 Part 2.mp4
89.4 MB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/40 - Google Sheet Wizard Problem Statement 1 Part 3 English.vtt
13.8 KB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/40 - Google Sheet Wizard Problem Statement 1 Part 3.mp4
101.5 MB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/41 - Google Sheet Wizard Problem Statement 1 Final Part 4 English.vtt
6.9 KB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/41 - Google Sheet Wizard Problem Statement 1 Final Part 4.mp4
45.7 MB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/42 - Google Sheet Wizard Problem Statement 2 Dependent Dropdowns in Google Sheets English.vtt
11.1 KB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/42 - Google Sheet Wizard Problem Statement 2 Dependent Dropdowns in Google Sheets.mp4
66.6 MB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/43 - Google Sheet Wizard Problem Statement 3 Playing with Checkboxes English.vtt
7.6 KB
~Get Your Files Here !/5 - Mastering Automation Putting it All Together/43 - Google Sheet Wizard Problem Statement 3 Playing with Checkboxes.mp4
42.8 MB
~Get Your Files Here !/Bonus Resources.txt
386 B
Alternative Torrents for 'Udemy Becoming Google Sheet Wizard'.