Excel Data Analysis Course

To equip learners with the practical knowledge and analytical skills to collect, clean, analyze, visualize, and present data using Microsoft Excel.

Module 1: Introduction to Excel for Data Analysis

• Overview of Excel interface

• Workbook vs Worksheet

• Data types and formatting

• Basic operations and functions

• Data entry techniques

• Saving, printing, and sharing

📊 Module 2: Data Handling and Management

• Importing data from different sources (CSV, web, text, databases)

• Data cleaning techniques:

  • Remove duplicates

  • Text to Columns

  • Find & Replace

  • Data validation

• Sorting and filtering

• Using named ranges

🧮 Module 3: Formulas and Functions

• Logical Functions: IF, AND, OR, IFERROR

• Text Functions: LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN, TEXT, TRIM

• Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH

• Date & Time Functions

• Math & Statistical Functions: SUMIF, COUNTIF, AVERAGEIF, RANK, ROUND

📐 Module 4: Data Visualization

• Creating charts: Column, Line, Bar, Pie, Area, Combo

• Advanced charting:

  • Pivot Charts

  • Histogram

  • Sparklines

• Customizing charts: Titles, Axis, Legends, Data labels

• Conditional formatting

• Data bars, Color scales, Icon sets