Silver Plan – Complete Curriculum
Excel + Power BI for Data Analytics
Module 1: Excel Basics to Intermediate
Master formulas, functions & automation
🔹 Excel Fundamentals
- Excel Interface & Navigation
- Rows, Columns, Cells & Ranges
- Data Types (Text, Number, Date)
- Formatting & Conditional Formatting
🔹 Core Excel Functions
- SUM, AVERAGE, COUNT
- IF, AND, OR
- VLOOKUP, HLOOKUP
- XLOOKUP & INDEX-MATCH
- TEXT, DATE & TIME Functions
🔹 Data Handling & Analysis
- Sorting & Filtering
- Data Validation
- Remove Duplicates
- Pivot Tables & Pivot Charts
🔹 Excel Automation
- Basic Macros overview
- Excel shortcuts & productivity hacks
Module 2: Power BI Fundamentals
Create stunning data visualizations
🔹 Power BI Introduction
- Power BI Desktop overview
- Power BI vs Excel
- Data analytics workflow
🔹 Data Importing
- Excel, CSV, Folder data
- Basic data modeling concepts
🔹 Visualization Essentials
- Tables, Cards, Charts
- Bar, Line, Pie, Donut charts
- Slicers & Filters
- Drill-down & interactions
🔹 Report Design
- Color themes & layouts
- Professional dashboard structure
- User-friendly reporting
Module 3: Data Cleaning & Dashboards
Professional-grade data transformation
🔹 Power Query (Data Cleaning)
- Remove errors & blanks
- Split / merge columns
- Change data types
- Transform messy data
🔹 Data Preparation
- Column profiling
- Standardizing data
- Preparing data for analysis
🔹 Dashboard Building
- Business-focused dashboards
- KPI cards
- Trend & performance analysis
Module 4: Practical Real-World Projects
Build your portfolio with confidence
📊 Project Examples:
- Sales Performance Dashboard
- Customer Analysis Report
- Expense & Profit Tracker
- Simple Business MIS Dashboard
🔹 Project Learning
- Requirement understanding
- Data cleaning
- Visualization selection
- Final dashboard presentation
Module 5: Portfolio & Career Readiness
- Portfolio building guidance
- How to present dashboards
- Analyst mindset & best practices
- Entry-level analytics roadmap