MS Excel Grand Course Curriculam

1.  Introduction to Excel, Interface, Ribbon, Sheets, Navigation
2.  Workbook vs Worksheet, File Formats (.xlsx, .xlsb, .csv)
3.  Data Entry, Autofill, Flash Fill, Fill Handle
4.  Formatting Basics (Fonts, Colors, Borders, Alignment)
5.  Number Formatting (Currency, %, Custom Formats)
6.  Shortcuts Every Analyst Must Know
7.  Freeze Panes, Split, Zoom, Page Layout
8.  Data Validation & Drop-Downs
9.  Named Ranges & Dynamic Named Ranges
10.  Case Study: Create a Student Attendance Tracker

1. Arithmetic Operators & Basic Functions (SUM, AVERAGE, MIN, MAX)
2. Logical Functions (IF, AND, OR, NOT, IFS, SWITCH)
3. Error Handling (IFERROR, IFNA)
4. Text Functions (LEFT, RIGHT, MID, LEN, TRIM, PROPER)
5. Advanced Text (SEARCH, FIND, SUBSTITUTE, CONCAT, TEXTJOIN)
6. Date & Time (TODAY, NOW, DATEDIF, NETWORKDAYS, EOMONTH)
7. Lookup Basics (VLOOKUP, HLOOKUP)
8. INDEX + MATCH Combo (Smarter Lookups)
9. XLOOKUP & XMATCH (Modern way)
10. Dynamic Arrays (FILTER, SORT, UNIQUE, RANDARRAY, SEQUENCE)

11. Nested IFS & Decision Making
12. LET & LAMBDA (Create Your Own Functions)
13. Case Study: Salary Slip Generator using Formulas
14. Case Study: Attendance & Leave Management using Formulas
15. Quick Project: Expense Manager with Dynamic Formulas

1. Sorting (Basic, Custom, Multi-level)
2. Filtering (AutoFilter, Advanced Filter)
3. Remove Duplicates, Flash Fill, Text-to-Columns
4. Tables (Structured References, Slicers, Total Rows)
5. Grouping & Outlining Data
6. Subtotals & Aggregations
7. Case Study: Sales Data Cleaning Project
8. Mini Project: Student Database Management

1. Introduction to Charts (Column, Line, Pie, Bar)
2. Combo Charts & Secondary Axis
3. Advanced Charts (Waterfall, Sunburst, Treemap)
4. Histograms, Pareto & Box Plot
5. Sparklines & Mini Graphs
6. Thermometer & Gauge Charts
7. Interactive Charts with Drop-downs & Slicers
8. Dynamic Charts with Named Ranges
9. Conditional Formatting with Icon Sets & Heatmaps
10. Case Study: Sales Trend Visualization Dashboard

1. Pivot Table Basics — Create, Format, Drill Down
2. Grouping & Summarizing Data
3. Pivot Charts with Slicers
4. Calculated Fields & Items in Pivot
5. KPIs, Hierarchies & Relationships in Pivot
6. Case Study: E-commerce Pivot Dashboard

1. Power Query Basics (Get & Transform Data)
2. Importing Data from Multiple Sources
3. Data Cleaning with Power Query
4. Merging & Appending Queries
5. Power Pivot Basics — Data Model & Star Schema
6. Relationships in Power Pivot
7. DAX Basics (CALCULATE, FILTER, ALL, RELATED)
8. Time Intelligence in DAX (YTD, QTD, SAMEPERIODLASTYEAR)
9. Case Study: Finance Analysis with Power Query + DAX

1. Macro Basics — Record & Run
2. VBA Intro - First Code in Excel
3. Automating Reports with VBA
4. Office Scripts (Excel on Web Automation)
5. Excel Copilot (AI Features in Excel 365)
6. Excel + Python Integration (Basic Data Science in Excel)
7. Case Study: Automated Report Generation

1. What-If Analysis (Goal Seek, Scenario Manager, Data Tables)
2. Loan Amortization & EMI Calculation
3. Budgeting, Forecasting & Variance Analysis
4. Sensitivity Analysis & Monte Carlo Simulation
5. Case Study: Startup Finance Model

1. IPL 2025 Dashboard Project (Players, Teams, Orange/Purple Cap)
2. HR Attrition & Attendance Dashboard
3. E-commerce Sales Profitability Dashboard
4. Resume & Portfolio Building with Excel Projects
5. Interview Q&A + Mock Assignments