Course Modules
Module 1: Introduction to Excel.
- Excel Interface & Workbook Basics
- Ribbons, Tabs, and Worksheets
- Saving, Exporting & File Formats
Module 2: Formatting & Styles.
- Text, Number & Date Formatting
- Conditional Formatting
- Cell Styles and Themes
Module 3: Formulas & Functions.
- Basic Formulas: SUM, AVERAGE, COUNT
- Logical Functions: IF, Nested IF
- Text Functions: LEFT, RIGHT, MID, CONCAT
Module 4: Lookup & Reference Functions
- VLOOKUP & HLOOKUP
- INDEX & MATCH
Module 5: Data Handling & Validation
- Sorting & Filtering Data
- Data Validation & Drop-downs
- Remove Duplicates & Clean Data
Module 6: Charts & Graphs
- Column, Line, Pie, Combo Charts
- Chart Formatting & Customization
Module 7: Pivot Tables & Analysis.
- Creating Pivot Tables
- Grouping & Filtering Data
- Summarizing Large Datasets
Module 8: Excel Shortcuts & Tips
- Keyboard Shortcuts
- Time-saving Techniques
- Automation Tips