Curriculum
- 9 Sections
- 77 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Module 1: Introduction to Data Analysis & Excel Fundamentals13
- 1.11.1 introduction to data_analysis24 Minutes
- 1.21.2 Introduction to Microsoft Excel โ Excel interface and navigation essentials23 Minutes
- 1.31.3 Data Types in MS Excel9 Minutes
- 1.41.4 Data Entry in Ms Excel9 Minutes
- 1.51.5 Formatting I10 Minutes
- 1.61.6 Formatting II9 Minutes
- 1.71.7 Formatting III โ Conditional Formatting I9 Minutes
- 1.81.8 Formatting III โ Conditional Formatting II8 Minutes
- 1.91.9 Structured Datasets3 Minutes
- 1.101.10 Unstructured Datasets4 Minutes
- 1.111.11 Protecting a Sheet9 Minutes
- 1.121.12 Protecting a Document4 Minutes
- 1.131.13 Printing an Excel Document11 Minutes
- Module 2: Essential Excel Functions for Analysis15
- 2.12.1 Number Functions I18 Minutes
- 2.22.2 Number Functions II17 Minutes
- 2.32.3 Consolidation9 Minutes
- 2.42.4 Logical Funtions I โ IF, SUMIF, COUNTIF16 Minutes
- 2.52.5 Logical Funtions II โ IFS, SUMIFS, COUNTIFS, MAXIFS, AND, OR19 Minutes
- 2.62.6 TEXT Functions15 Minutes
- 2.72.7 Time and Date Functions I9 Minutes
- 2.82.8 Time and Date Functions II13 Minutes
- 2.92.9 Time Intelligence Functions18 Minutes
- 2.102.10 Lookup Functions โ HLOOKUP, VLOOKUP XLOOKUP10 Minutes
- 2.112.11 Lookup Functions โ INDEX AND MATCH8 Minutes
- 2.122.12 Lookup Functions โ WILDCARDS6 Minutes
- 2.132.13 Error Handling Functions7 Minutes
- 2.142.14 Lookup Functions โ Multiple VLOOKUP6 Minutes
- 2.152.15 Other Data Analysis Functions13 Minutes
- Module 3: Data Cleaning & Preparation (ETL in Excel)10
- 3.13.1 Removing Duplicates5 Minutes
- 3.23.2 Removing Blank Rows8 Minutes
- 3.33.3 Removing Blank Columns7 Minutes
- 3.43.4 Text to Columns5 Minutes
- 3.53.5 Find and Replace3 Minutes
- 3.63.6 Data Validation I16 Minutes
- 3.73.7 Data Validation โ Custom Formula19 Minutes
- 3.83.8 Searcheable Dropdown List9 Minutes
- 3.93.9 Handling Missing and Inconsistent Records9 Minutes
- 3.103.10 Introduction to Power Query24 Minutes
- Module 4: Exploratory Data Analysis (EDA)6
- Module 5: Advanced Excel Tools for Data Analysis15
- 5.15.1 Power Query โ Data Cleaning7 Minutes
- 5.25.2 Power Query โ Transformation6 Minutes
- 5.35.3 Power Query โ Transpose1 Minute
- 5.45.4 Power Query โ Unpivot3 Minutes
- 5.55.5 Data Scraping with Power Query7 Minutes
- 5.65.6 Multiple Files Combination โ Append13 Minutes
- 5.75.7 Multiple Files Combination โ Merge7 Minutes
- 5.85.8 Group and Aggregate3 Minutes
- 5.95.9 M Language in Power Query5 Minutes
- 5.105.10 Data Normalization I6 Minutes
- 5.115.11 Data Normalization II
- 5.125.12 Data Modeling
- 5.135.13 What IF Analysis โ Scenario Manager
- 5.145.14 What IF Analysis โ Goal Seek and Solver
- 5.155.15 What IF Analysis โ Data Table
- Module 6: Data Visualization & Dashboards9
- 6.16.1 Introduction to Visualizations10 Minutes
- 6.26.2 Visualization โ Pie Charts and Donought Chart14 Minutes
- 6.36.3 Visualization โ Column Chart and Bar Chart6 Minutes
- 6.46.4 Visualization โ Funnel Chart5 Minutes
- 6.56.5 Visualization โ Waterfall Chart4 Minutes
- 6.66.6 Visualization โ Line Chart8 Minutes
- 6.76.7 Visualization โ Cards14 Minutes
- 6.86.8 Interactive Dashboard25 Minutes
- 6.96.9 Executive Summary
- Module 7: Excel Automation with Macros & AI5
- Module 8: Real-World Business Applications3
- Module 9: Capstone Project1