MS Excel (Basic to Advanced) & Power BI Data Visualization – Gayazuddin Sheik

Course Content

Module 1: MS Excel – Basic

• Introduction to Excel Interface

• Worksheets & Workbooks

• Data Entry, Formatting & Editing

• Basic Formulas & Functions (SUM, AVERAGE, COUNT)

• Sorting & Filtering Data

Module 2: MS Excel – Intermediate

• Conditional Formatting

• Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)

• Text, Date & Logical Functions

• Data Validation & What-If Analysis

• Pivot Tables & Pivot Charts

Module 3: MS Excel – Advanced

• Advanced Formulas & Nested Functions

• Dynamic Arrays & Advanced Lookup

• Power Query in Excel

• Macros & VBA Basics

• Dashboards in Excel

Module 4: Power BI – Getting Started

• Introduction to Power BI & Interface

• Importing Data from Multiple Sources

• Data Cleaning & Shaping with Power Query

• Data Modeling & Relationships

Module 5: Power BI – Visualization

• Creating Charts, Tables & Cards

• Using Filters, Slicers & Drill-Downs

• Custom Visuals & Marketplace

• Dashboard Design Best Practices

Module 6: Power BI – Advanced

• Introduction to DAX (Data Analysis Expressions)

• Calculated Columns & Measures

• Time Intelligence Functions

• Report Generation & Publishing to Power BI Service

• Collaboration & Sharing

Module 7: Real-Time Project

• End-to-End Dashboard Project (Excel + Power BI)

• Data Cleaning → Modeling → Visualization → Report

• Case Study: Sales/HR/Finance Dashboard

• Certification & Interview Preparation