Data Analytics & Visualization with Google Sheet

This content is protected, please login and enroll course to view this content!

Prev 4.41 Customer Data Entry Form

Next 4.43 Sales Transaction Template

Leave A Reply Cancel reply

Beginners Class (Introduction) 18
- Lecture1.1
  
  1.0 Introduction (Access to Lesson Materials) 07 min
- Lecture1.2
  
  1.1 Introduction 14 min
- Lecture1.3
  
  1.2 Freeze Pane 06 min
- Lecture1.4
  
  1.3 Formatting 16 min
- Lecture1.5
  
  1.4 Borders 05 min
- Lecture1.6
  
  1.5 Conditional Formatting 09 min
- Lecture1.7
  
  1.6 Data Validation & Drop Down 17 min
- Lecture1.8
  
  1.7 Duplicate, Find & Replace 06 min
- Lecture1.9
  
  1.8 Formulas & Function 1 15 min
- Lecture1.10
  
  1.9 Formulas & function 2 13 min
- Lecture1.11
  
  1.10 Formulas & function 3 08 min
- Lecture1.12
  
  1.11 Consolidation 05 min
- Lecture1.13
  
  1.12 SUMIF 06 min
- Lecture1.14
  
  1.13 Charts 20 min
- Lecture1.15
  
  1.14 Charts 2 14 min
- Lecture1.16
  
  1.15 Protecting Sheet 13 min
- Lecture1.17
  
  1.16 Sharing 09 min
- Quiz1.1
  
  Quiz 1 0 question
Intermediate Class 14
- Lecture2.1
  
  2.17 Sorting 11 min
- Lecture2.2
  
  2.18 Filter 12 min
- Lecture2.3
  
  2.19 Advance Filter I 19 min
- Lecture2.4
  
  2.20 Advance Filter II 18 min
- Lecture2.5
  
  2.21 SUMIFS 07 min
- Lecture2.6
  
  2.22 COUNTIFS 04 min
- Lecture2.7
  
  2.23 AVERAGEIFS 07 min
- Lecture2.8
  
  2.24 DATEDIF (Date Functions) 06 min
- Lecture2.9
  
  2.25 HLOOKUP 05 min
- Lecture2.10
  
  2.26 VLOOKUP 03 min
- Lecture2.11
  
  2.27 Dependent Drop Down List 14 min
- Lecture2.12
  
  2.28 XLOOKUP 16 min
- Lecture2.13
  
  2.29 Client Records (Database) 10 min
- Lecture2.14
  
  2.30 Vstack & Hstack 06 min
Advance Class 7
- Lecture3.1
  
  3.31 Data Cleaning 1 16 min
- Lecture3.2
  
  3.32 Data Cleaning 2 15 min
- Lecture3.3
  
  3.33 Unpivot 11 min
- Lecture3.4
  
  3.34 Pivot Table 1 16 min
- Lecture3.5
  
  3.35 Pivot Table 2 08 min
- Lecture3.6
  
  3.36 Pivot Table 3 13 min
- Lecture3.7
  
  3.37 Sales Dashboard 22 min
Application Class 7
- Lecture4.1
  
  4.38 Personal Budget Template 1 14 min
- Lecture4.2
  
  4.39 Personal Budget Template 2 13 min
- Lecture4.3
  
  4.40 Employment Status 16 min
- Lecture4.4
  
  4.41 Customer Data Entry Form 16 min
- Lecture4.5
  
  4.42 Linking (Form – Sheet) 14 min
- Lecture4.6
  
  4.43 Sales Transaction Template 36 min
- Lecture4.7
  
  4.44 Team Collaboration 16 min

Leave A Reply Cancel reply

Beginners Class (Introduction) 18

Intermediate Class 14

Advance Class 7

Application Class 7