Excel
WEEK 1: Excel Basics for Data Analysis
Session 1: Getting Comfortable with Excel
- Excel in the world of Data Analytics
- Interface, Navigation, Shortcuts
- Workbook/Worksheet management
- Intro to Excel Table structure
Session 2: Working with Data
- Data Types: Numbers, Text, Dates
- Formatting tricks for clean layouts
- Sorting, Filtering, Removing duplicates
- Data Entry Tips, Flash Fill & Text to Columns
Session 3: Core Formulas & Functions
- Math Functions: SUM, AVERAGE, COUNT, ROUND
- Logical: IF, IFS, AND, OR, IFERROR
- Text: LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN
WEEK 2: Data Cleaning & Lookups
Session 4: Practical Data Cleaning Techniques
- TRIM, CLEAN, SUBSTITUTE
- Handling missing & inconsistent data
- Data Validation (Drop-downs, Rules)
- Conditional Formatting for data spotting
Session 5: Lookup & Matching Skills
- VLOOKUP, HLOOKUP, XLOOKUP (365)
- INDEX + MATCH combo
- Dynamic Named Ranges
Session 6: Data Structuring with Pivot Tables
- Creating and formatting PivotTables
- Grouping, Filtering, Custom Sorting
- Adding Calculated Fields
- PivotCharts Basics
WEEK 3: Visualizations + AI Tools
Session 7: Data Visualization in Excel
- Creating Bar, Line, Column, Pie charts
- Combo Charts, Dual Axis Charts
- Best practices in chart formatting
- Dashboards with interactivity (slicers, buttons)
Session 8: Intro to Excel Copilot (Microsoft 365)
- What is Excel Copilot?
- Asking Natural Language Queries (e.g., “Summarize this data”)
- Letting Copilot suggest formulas, charts, pivots
- AI-generated data summaries
Session 9: ChatGPT in Excel (Add-in / Edge Sidebar)
- Installing the ChatGPT Add-in or using Edge Sidebar
- Asking Excel-related queries inside ChatGPT
- Using ChatGPT for:
- Formula building help
- Code/logic explanations
- Suggestions for dashboards & automation ideas
WEEK 4: AI-Enhanced Reporting
Session 10: What-If Analysis & Auto Insights
- Goal Seek & Scenario Manager
- Quick Forecast Sheet (365 only)
- Copilot for what-if summaries and scenario suggestions
- Dynamic drop-down dashboards