■ Excel Full Course (Beginner to Advanced)
1. Basics of Excel
• Introduction to Excel interface
• Workbook vs Worksheet
• Rows, Columns, Cells
• Data entry & editing
• Formatting (fonts, borders, colors, alignment)
• Basic shortcuts
2. Essential Functions
• SUM, AVERAGE, MIN, MAX, COUNT
• IF, AND, OR, NOT
• Text functions: LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE, TEXTJOIN
• Date & Time functions: TODAY, NOW, DATEDIF, EOMONTH
3. Data Management
• Sorting & Filtering
• Data Validation (drop-down lists, restrictions)
• Remove Duplicates
• Find & Replace
• Named Ranges
4. Charts & Visualization
• Column, Bar, Line, Pie charts
• Conditional Formatting
• Sparklines
• Combo Charts
• Formatting charts professionally
5. Advanced Formulas
• VLOOKUP, HLOOKUP
• INDEX + MATCH
• XLOOKUP (newer versions)
• OFFSET, INDIRECT
• Nested IFs
• Array formulas & Dynamic Arrays (UNIQUE, FILTER, SORT)
6. Data Analysis Tools
• PivotTables & PivotCharts
• Grouping & Slicers
• Power Query (Get & Transform)
• What-If Analysis (Goal Seek, Data Tables, Scenario Manager)
• Descriptive Statistics (Analysis ToolPak)
7. Advanced Excel Features
• Conditional Formatting with formulas
• Hyperlinks & Dynamic Ranges
• Protecting sheets & workbooks
• Custom Number Formatting
• Subtotals & Outlines
8. Automation with Macros & VBA
• Recording Macros
• Introduction to VBA Editor
• Writing simple VBA scripts
• Automating repetitive tasks
• Creating User Forms
9. Excel for Data Analysis
• Data Cleaning techniques
• Lookup + Text functions for data wrangling
• PivotTable-based dashboards
• Forecasting & Trend Analysis
• Connecting Excel with external data (CSV, SQL)
10. Excel for Business & Career
• Dashboard creation (with KPIs, charts, slicers)
• Financial Modeling basics
• Inventory & Sales Tracking Templates
• Resume-friendly Excel Projects