Excel المتقدم | Advanced Excel 

✅  Module 1: Excel Foundations for Data Analysis

( أساسيات Excel وتحضير البيانات للتحليل)

• Introduction - Excel Intro to Data Analysi

• List Design Basics

• Inserting Tables for Analysis

• Filtering Data in Tables

• Using the Total Row

• Conditional Formatting

• IF Function

• SUMIF and AVERAGEIF

• SUMIFS

• Inserting Recommended Charts

• Adjusting Charts

• Sparklines

• Inserting Pivot Tables

• Displaying Data as Count

• Filtering Pivot Tables

• Inserting Pivot Charts

• Conclusion - Intro to Data Analysis

🎯 الهدف: تأسيس قوي + فهم شكل الداتا الصح + أول تعامل مع Pivot & Charts.

✅ Module 2: Power Query for Data Cleaning & Transformation

Power Query – Data Cleaning, Transformation & Automation

In this module, students will learn how to work with raw data before it reaches the analysis stage. The focus will be on importing data from different sources and transforming it into clean, structured, and analysis-ready datasets. Learners will build automated transformation steps instead of relying on manual editing.

This module covers practical, real-world skills such as:

• Importing data from multiple sources (Excel, CSV, Folder, Web)

• Cleaning messy data (removing duplicates, errors, and null values)

• Splitting and merging columns

• Changing and managing data types

• Applying text, date, and numeric transformations

• Merging and appending queries

• Creating dynamic, refreshable queries

• Loading clean data into Excel Tables and the Data Model for use in Pivot Tables, Power Pivot, and Power BI

🎯 By the end of this module, students will be able to take any unstructured dataset and transform it into a professional, analysis-ready model suitable for reporting and dashboards.

✅ Module 3: Pivot Tables for Data Analysis & Reporting

• (Pivot Tables من البداية للاحتراف)

• Introduction - Excel Pivot Tabl

• What are Pivot Tables

• Preparing Data for Analysis

• Pivot Table Components

• Building Pivot Tables to Show Different Values

• Adding Fields to Pivot Tables

• Using Built-In Filters

• Filtering Data with Slicers

• Displaying New Values from Data Sources

• Inserting Pivot Charts

🎯 الهدف: إتقان Pivot Table كأداة تحليل أساسية.

✅ Module 4: Lookup & Advanced Pivot Techniques

(الربط بين الجداول + Pivot متقدم)

• XLOOK - Vlookup - INDEX - Match - Hlookup

• Joining Data Sets with XLOOKUP

• Introduction to Advanced Pivot Tables

• Inserting Pivot Tables from Tables

• Calculated Fields

• Using the Timeline Tool

• Report Filter Pages

• Pivot Table Layouts

• Creating Pivot Table Designs

🎯 الهدف: تحويل المتدرب من مستخدم Pivot عادي لمحلل بيانات.

✅ Module 5: Power Pivot & Data Model (DAX Basics)

(الـ Data Model والانتقال لمستوى احترافي)

• Adding Power Pivot Tabs to the Ribbon

• Adding Tables to Power Pivot Data Model

• Creating Table Relationships

• Creating Columns with DAX Expressions

• Displaying New Source Data in Power Pivot Tables

• Data Mining with Flash Fill

• Conclusion - Excel Pivot Tables

🎯 الهدف: إدخال مفهوم الـ Data Model وتهيئة قوية لـ Power BI لاحقًا.

✅ Module 6: Excel Power User – Functions & Advanced Analysis

(دوال احترافية + تحليل متقدم)

• Introduction - Excel Power User

• IF Function Basics

• IF Functions with Calculations

• Nesting AND with IF

• Naming Ranges and COUNTIF

• SUMIF and AVERAGEIF

• SUMIFS

• XLOOKUP

• Populating Forms with XLOOKUP

• Displaying Pivot Table Fields with COUNT Function

• Calculated Fields

• Slicers

• Using the Timeline

• Inserting Report Filter Pages

• Flash Fill for Text Functions

🎯 الهدف: تمكين المتدرب من أدوات التحليل المتقدم اليومية.

✅ Module 7: Advanced Excel, Automation & Dashboards

(مستوى متقدم جدًا + أتمتة)

• Array Formula Basics

• Looking Up Multiple Values with XLOOKUP

• Array Functions ( Sort - Transpose - Unique - ... )

• Advanced Conditional Formatting

• Combo Charts

• Developer Tab

• Relative Reference

• Cleaning Data 

• Excel Power User

• 🎯 الهدف: نقل المتدرب لمستوى Power User حقيقي.