Introduction to Excel
▶- What is Excel?
- Excel Interface (Ribbon, Workbook, Worksheet)
- Rows, Columns & Cells
- Basic Navigation
Basic Operations
▶- Opening, Saving, and Closing Workbooks
- Data Entry and Editing
- AutoFill & Flash Fill
- Cell Formatting (Font, Color, Border)
Formulas & Functions
▶- Basic Formulas (SUM, AVERAGE, MIN, MAX)
- Cell Referencing (Relative & Absolute)
- Text Functions (LEFT, RIGHT, LEN)
- Logical Functions (IF, AND, OR)
Data Management
▶- Sorting & Filtering
- Data Validation & Dropdowns
- Removing Duplicates
- Find & Replace
Charts & Visualization
▶- Creating Charts (Bar, Pie, Line)
- Chart Customization
- Sparklines
- Combo Charts
Tables & PivotTables
▶- Creating & Formatting Tables
- Using Structured References
- Creating PivotTables
- Pivot Charts and Slicers
Advanced Excel Tools
▶- Conditional Formatting
- What-If Analysis
- Goal Seek & Data Tables
- Macros (Basic)
Printing & Protection
▶- Page Setup and Print Area
- Headers and Footers
- Sheet Protection
- Workbook Protection