About this course
Learn the fundamentals of Excel’s interface and basic data management for analysis.
Before We Begin
1 Parts
- 0:20 Hr
Before We Begin
20 Min
Chapter 1: Getting Started with Excel
2 Parts
- 1:30 Hr
Excel Interface and Navigation
45 Min
Data Entry and Formatting
45 Min
Chapter 2: Basic Calculations and Data Organization
2 Parts
- 1:45 Hr
Basic Formulas and Statistical Functions
60 Min
Sorting and Filtering Data
45 Min
Chapter 3: Data Cleaning and Preparation
2 Parts
- 1:45 Hr
Data Cleaning Techniques
60 Min
Importing External Data
45 Min
Chapter 4: Logical and Lookup Functions
2 Parts
- 2:00 Hr
Logical Functions
60 Min
Lookup Functions
60 Min
Chapter 5: Text Manipulation and Conditional Formatting
2 Parts
- 1:30 Hr
Text Functions
45 Min
Conditional Formatting
45 Min
Chapter 6: Data Validation and Workflow Optimization
2 Parts
- 1:30 Hr
Data Validation
45 Min
Workflow Optimization
45 Min
Chapter 7: Data Visualization
2 Parts
- 1:45 Hr
Chart Creation
60 Min
Dashboard Basics
45 Min
Chapter 8: PivotTable Analysis
2 Parts
- 2:00 Hr
PivotTable Basics
60 Min
Advanced PivotTable Techniques
60 Min
Chapter 9: PivotChart Visualizations
1 Parts
- 1:00 Hr
Creating PivotCharts
60 Min
Chapter 10: What-If Analysis
2 Parts
- 1:30 Hr
Goal Seek
45 Min
Scenario Manager
45 Min
Chapter 11: Advanced Power Query
2 Parts
- 1:45 Hr
Power Query Transformations
60 Min
Data Modeling
45 Min
Chapter 12: Forecasting and Statistical Analysis
2 Parts
- 1:45 Hr
Forecasting
60 Min
Statistical Analysis
45 Min
Chapter 13: Advanced Automation and Reporting
4 Parts
- 3:30 Hr
VBA Automation
60 Min
Professional Reporting
60 Min
Cloud Integration
45 Min
Power BI Export
45 Min
Capstone Projects
1 Parts
- 1:40 Hr
Employee Database with Validation
100 Min
No Reviews Yet
