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