Ayesha Mustafa

Module 1: Advanced Excel (4 Hours)

Topic: Mastering Advanced Excel for Business Analysis

Session Outline
Advanced Excel Functions
XLOOKUP
INDEX & MATCH
FILTER
UNIQUE
SORT
TEXT Functions
IFERROR
Dynamic Arrays
Spill Ranges
SEQUENCE
RANDARRAY
Advanced Data Analysis
Pivot Tables
Pivot Charts
Slicers & Timelines
Calculated Fields
Data Validation & Conditional Formatting
Drop-down Lists
Custom Validation
Formula-based Formatting
Dashboard Development
KPI Cards
Interactive Charts
Dynamic Reports
Automation
Named Ranges
Excel Tables
Introduction to Macros
Build an Interactive Sales Dashboard

Module 2: Power Query (4 Hours)

Topic: Data Cleaning & Transformation with Power Query

Session Outline
Introduction
What is ETL?
Power Query Interface
Importing Data
Excel
CSV
PDF
Folder
Web
Data Cleaning
Remove Duplicates
Fill Down
Replace Values
Split Columns
Merge Columns
Change Data Types
Data Transformation
Pivot Columns
Unpivot Columns
Group By
Append Queries
Merge Queries
Creating Custom Columns
Conditional Columns
Custom M Formulas
Refresh & Automation

Module 3: Power BI (4 Hours)

Topic: Business Intelligence & Dashboard Design

Session Outline
Power BI Introduction
Desktop Interface
Data Model
Relationships
Data Modeling
Star Schema
Snowflake Schema
Fact vs Dimension Tables
DAX Fundamentals
SUM
CALCULATE
FILTER
ALL
DISTINCTCOUNT
IF
SWITCH
Time Intelligence
YTD
MTD
QTD
SAMEPERIODLASTYEAR
Visualizations
Cards
Tables
Matrix
Bar Charts
Line Charts
Treemap
Map
Gauge
KPI
Slicers
Interactive Dashboard
Drill Through
Tooltips
Bookmarks
Buttons
Page Navigation
Publishing
Power BI Service
Refresh
Sharing Dashboards

This structure is ideal for a 12-hour corporate training program, balancing theory (10%) with practical exercises (90%), ensuring participants understand the concepts thoroghully.

Call 056-6060872

Power BI Advanced Excel Course

Description

Location