| 1 |
Data Analytics Foundations & Excel Best Practices |
- Data analytics lifecycle
- Business analytics workflow
- Excel architecture & workbook design
- Naming conventions
- Productivity shortcuts
- Version control basics
|
1 |
3 |
4 |
- Understand analytics lifecycle
- Build structured Excel files
- Improve productivity
|
| 2 |
Formula Logic & Conditional Functions |
- IF, IFS, AND, OR logic
- Nested formulas
- Error handling (IFERROR)
- Dynamic formulas
- Formula auditing tools
|
1 |
6 |
7 |
- Build logical models
- Debug formulas efficiently
|
| 3 |
Data Summarization & Dynamic Arrays |
- SUMIFS, COUNTIFS, AVERAGEIFS
- AGGREGATE & SUBTOTAL
- Dynamic arrays (UNIQUE, FILTER, SORT)
- Spill ranges
- Advanced array calculations
|
1 |
6 |
7 |
- Summarize data dynamically
- Create self-updating models
|
| 4 |
Data Cleaning & Preparation |
- TRIM, CLEAN, LEFT, RIGHT, MID
- Conditional cleaning logic
- ASCII cleaning
- Duplicate handling
- Standardization methods
|
1 |
6 |
7 |
- Prepare raw datasets
- Apply cleaning workflows
|
| 5 |
Date, Time & Data Validation |
- Date intelligence functions
- Time calculations
- Business calendars
- Data validation rules
- Dropdown logic
|
0 |
5 |
5 |
- Build date-driven reports
- Prevent data entry errors
|
| 6 |
Lookup Mastery & Data Extraction |
- VLOOKUP, HLOOKUP
- INDEX + MATCH
- XLOOKUP
- Multi-condition lookups
- Array lookups
|
1 |
7 |
8 |
- Retrieve and merge data
- Choose best lookup methods
|
| 7 |
Pivot Tables, Power Pivot & Data Models |
- Pivot table analysis
- Grouping & segmentation
- Calculated fields
- Relationships in Power Pivot
- Data models
|
1 |
7 |
8 |
- Analyze large datasets
- Build relational models
|
| 8 |
Power Query & Data Connectors |
- Data import
- Query editor transformations
- Merge & append
- Data connectors
- Automation
|
1 |
7 |
8 |
- Build ETL pipelines
- Connect multiple sources
|
| 9 |
Reporting & Dashboard Design |
- Reporting principles
- KPI design
- Dashboard layouts
- Executive summaries
|
0 |
5 |
5 |
- Create dashboards
- Communicate insights
|
| 10 |
Analytical Excel |
- Data tab
- Data Analysis Toolkit
|
1 |
2 |
3 |
- |
| 11 |
AI Fundamentals for Data Analysts |
- AI for analysts
- Generative AI overview
- AI workflows
- Prompt basics
- AI limitations
|
0 |
3 |
3 |
- Understand AI in analytics
- Use AI responsibly
|
| 12 |
ChatGPT for Excel & Analytics |
- Formula generation
- Data cleaning prompts
- SQL generation
- Insight summarization
- AI report writing
|
1 |
5 |
6 |
- Use ChatGPT in analytics
- Speed up workflows
|
| 13 |
Industry AI Tools for Analysts |
- Quadratic AI
- Excel Copilot
- Power BI AI
- Claude / Perplexity
|
0 |
5 |
5 |
|
| 14 |
AI Automation & Analyst Workflows |
- AI dashboards
- KPI insights
- Automated reporting
- Forecasting suggestions
|
0 |
5 |
5 |
|
| 15 |
Business Case Studies |
- Sales analytics
- Forecasting
- Marketing ROI
- Profitability analysis
|
0 |
5 |
5 |
- Solve real business problems
|
| 16 |
Capstone Projects |
- Automated dashboard
- AI reporting
- Final case study
|
0 |
4 |
4 |
- Build end-to-end solutions
|
| Total Duration |
9 |
81 |
90 |
- |
