Curriculum
- 12 Sections
- 126 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 Class12
- 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.53.38 gantt_chart15 Minutes
- 3.63.39 Simple & Compound Interest22 Minutes
- 3.73.40 Loan Payment9 Minutes
- 3.83.41 drop down list22 Minutes
- 3.93.42 Loan Management System(Data Base)31 Minutes
- 3.103.43 Loan Management System(Payment Page)11 Minutes
- 3.113.44 Loan Management System (Home Page)11 Minutes
- 3.12Last Course Review and more1 Minute
- Module 1: Introduction to Data Analysis & Excel Fundamentals13
- 4.11.1 introduction to data_analysis24 Minutes
- 4.21.2 Introduction to Microsoft Excel โ Excel interface and navigation essentials23 Minutes
- 4.31.3 Data Types in MS Excel9 Minutes
- 4.41.4 Data Entry in Ms Excel9 Minutes
- 4.51.5 Formatting I10 Minutes
- 4.61.6 Formatting II9 Minutes
- 4.71.7 Formatting III โ Conditional Formatting I9 Minutes
- 4.81.8 Formatting III โ Conditional Formatting II8 Minutes
- 4.91.9 Structured Datasets3 Minutes
- 4.101.10 Unstructured Datasets4 Minutes
- 4.111.11 Protecting a Sheet9 Minutes
- 4.121.12 Protecting a Document4 Minutes
- 4.131.13 Printing an Excel Document11 Minutes
- Module 2: Essential Excel Functions for Analysis15
- 5.12.1 Number Functions I18 Minutes
- 5.22.2 Number Functions II17 Minutes
- 5.32.3 Consolidation9 Minutes
- 5.42.4 Logical Funtions I โ IF, SUMIF, COUNTIF16 Minutes
- 5.52.5 Logical Funtions II โ IFS, SUMIFS, COUNTIFS, MAXIFS, AND, OR19 Minutes
- 5.62.6 TEXT Functions15 Minutes
- 5.72.7 Time and Date Functions I9 Minutes
- 5.82.8 Time and Date Functions II13 Minutes
- 5.92.9 Time Intelligence Functions18 Minutes
- 5.102.10 Lookup Functions โ HLOOKUP, VLOOKUP XLOOKUP10 Minutes
- 5.112.11 Lookup Functions โ INDEX AND MATCH8 Minutes
- 5.122.12 Lookup Functions โ WILDCARDS6 Minutes
- 5.132.13 Error Handling Functions7 Minutes
- 5.142.14 Lookup Functions โ Multiple VLOOKUP6 Minutes
- 5.152.15 Other Data Analysis Functions13 Minutes
- Module 3: Data Cleaning & Preparation (ETL in Excel)10
- 6.13.1 Removing Duplicates
- 6.23.2 Removing Blank Rows
- 6.33.3 Removing Blank Columns
- 6.43.4 Text to Columns
- 6.53.5 Find and Replace
- 6.63.6 Data Validation I
- 6.73.7 Data Validation โ Custom Formula
- 6.83.8 Searcheable Dropdown List
- 6.93.9 Handling Missing and Inconsistent Records
- 6.103.10 Introduction to Power Query
- Module 4: Exploratory Data Analysis (EDA)6
- Module 5: Advanced Excel Tools for Data Analysis15
- 8.15.1 Power Query โ Data Cleaning
- 8.25.2 Power Query โ Transformation
- 8.35.3 Power Query โ Transpose
- 8.45.4 Power Query โ Unpivot
- 8.55.5 Data Scraping with Power Query
- 8.65.6 Multiple Files Combination โ Append
- 8.75.7 Multiple Files Combination โ Merge
- 8.85.8 Group and Aggregate
- 8.95.9 M Language in Power Query
- 8.105.10 Data Normalization I
- 8.115.11 Data Normalization II
- 8.125.12 Data Modeling
- 8.135.13 What IF Analysis โ Scenario Manager
- 8.145.14 What IF Analysis โ Goal Seek and Solver
- 8.155.15 What IF Analysis โ Data Table
- Module 6: Data Visualization & Dashboards9
- 9.16.1 Introduction to Visualizations
- 9.26.2 Visualization โ Pie Charts and Donought Chart
- 9.36.3 Visualization โ Column Chart and Bar Chart
- 9.46.4 Visualization โ Funnel Chart
- 9.56.5 Visualization โ Waterfall Chart
- 9.66.6 Visualization โ Line Chart
- 9.76.7 Visualization โ Cards
- 9.86.8 Interactive Dashboard
- 9.96.9 Executive Summary
- Module 7: Excel Automation with Macros & AI5
- Module 8: Real-World Business Applications3
- Module 9: Capstone Project1