Curriculum
- 3 Sections
- 48 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Beginners Class18
- 1.1Introduction to Data Analysis With Ms Excel3 Minutes
- 1.21.1 Introduction to Excel22 Minutes
- 1.31.2 Excel-Formatting Copy32 Minutes
- 1.41.3 Conditional Formatting-115 Minutes
- 1.51.4 Conditional Formatting-27 Minutes
- 1.61.5 Formulas Function -130 Minutes
- 1.71.6 Formulas function-2(Result Analysis)16 Minutes
- 1.81.7 Formulas and Function 337 Minutes
- 1.91.8 Data validation Drop down13 Minutes
- 1.101.9 Header and Footer14 Minutes
- 1.111.10 Protecting Sheet10 Minutes
- 1.121.11 How to Unlock Protected Sheet17 Minutes
- 1.131.12 Automated Calculator14 Minutes
- 1.141.13 Consolidation14 Minutes
- 1.151.14 Charts39 Minutes
- 1.161.15 Progress Bar Chart17 Minutes
- 1.171.16 Print Setup25 Minutes
- 1.18Course Review1 Minute
- Advance Class19
- 2.1Advance Class Intro1 Minute
- 2.22.17 Sorting9 Minutes
- 2.32.18 Basic Filter20 Minutes
- 2.42.19 Advance Filter17 Minutes
- 2.52.20 Logical Function(AND)10 Minutes
- 2.62.21 Logical Function(Text)21 Minutes
- 2.72.22 Advance Data Validation (Dropdown list)32 Minutes
- 2.82.23 H-Lookup8 Minutes
- 2.92.24 V-Lookup5 Minutes
- 2.102.25 DataBase System19 Minutes
- 2.112.26 Data Cleaning15 Minutes
- 2.122.27 Pivot Table – 124 Minutes
- 2.132.28 Pivot Table 211 Minutes
- 2.142.29 Pivot Table 39 Minutes
- 2.152.30 Power Query 122 Minutes
- 2.162.31 Power Query 24 Minutes
- 2.172.32 Sales Dashboard33 Minutes
- 2.18Capstone Project – Worked Project47 Minutes
- 2.19Course Review1 Minute
- Application Class11
- 3.1Application Class Intro2 Minutes
- 3.23.35 Automated Data Entry Form7 Minutes
- 3.33.36 Attendance Register(Clock In & Clock Out)7 Minutes
- 3.43.37 Salary Sheet with Excel7 Minutes
- 3.63.38 Simple & Compound Interest23 Minutes
- 3.73.39 Loan Payment3 Minutes
- 3.83.40 Drop Down List (3)8 Minutes
- 3.93.41 Loan Management System(Data Base)31 Minutes
- 3.103.42 Loan Management System(Payment Page)12 Minutes
- 3.113.43 Loan Management System (Home Page)11 Minutes
- 3.12Last Course Review and more2 Minutes
1.1 Introduction to Excel
Next