A complete Excel mastery program designed to take you from beginner level to advanced data presentation and dashboard creation.

كورس Excel للمبتدئين من الصفر | تعلم اكسل عملي – Edvance Academy

تعلم Excel من الصفر خطوة بخطوة مع تطبيق عملي على بيانات حقيقية. كورس Excel مناسب للمبتدئين مع شهادة من Edvance Academy.

ابدأ الآن

Level 1: Excel Foundations – Build strong fundamentals.

In this lesson, you will learn how to navigate Microsoft Excel confidently.

We will explore:
– The Excel interface and ribbon
– Worksheets and workbooks
– Rows, columns, and cells
– Basic navigation shortcuts

By the end of this lesson, you will feel comfortable working inside Excel.

Level 2: Data Analysis – Work with real datasets and business scenarios.

Lesson 1

Understanding Data & Data Preparation

In this lesson, you will learn how to understand raw data and prepare it for analysis.

We will cover:
– Identifying data types
– Structuring tables correctly
– Removing duplicates
– Handling missing values
– Cleaning inconsistent data

By the end, you will be able to transform messy data into structured, analysis-ready datasets.

Lesson 2

Data Cleaning Techniques

• Text to Columns

• Remove Duplicates

• TRIM

• PROPER

• Find & Replace

• Data Validation

Lesson 3

Essential Data Functions

• SUM

• SUMIF

• SUMIFS

• COUNT

• COUNTIF

• COUNTIFS

• IF

• Nested IF

• Logical Operators

Lesson 4

Lookup & Advanced Formulas

• VLOOKUP

• HLOOKUP

• INDEX

• MATCH

• INDEX + MATCH Combination

Lesson 5

Pivot Tables & Data Summarization

• Creating Pivot Tables

• Grouping Data

• Calculated Fields

• Building Business Reports

Lesson 6

Mini Business Case Study

• Sales Dataset

• Analyse Performance

• Extract Insights

• Create Summary Report

Level 3: Present Your Data – Create dashboards and professional reports.

Lesson 1

In this lesson, you will understand how to present data clearly and professionally.

We will cover:
– Choosing the right chart for the right data
– Avoiding common visualization mistakes
– Understanding visual hierarchy
– Designing clean and readable reports

Good dashboards start with good design thinking.

Lesson 2

Professional Charts in Excel

• Column Charts

• Bar Charts

• Line Charts

• Combo Charts

• Dynamic Charts

• Formatting & Styling

Lesson 3

KPI Design & Performance Metrics

• What is a KPI?

• Designing performance indicators

• Conditional Formatting

• Traffic Light Indicators

• Performance vs Target Analysis

Lesson 4

Final Project – Business Dashboard

• Sales Performance Dashboard

• HR Dashboard

• Finance Dashboard

• Marketing Dashboard

Final Project

Final Business Dashboard Project

Students must build a complete interactive Excel dashboard using real business data.

The dashboard must include:
– At least 3 KPIs
– 2 Pivot Tables
– 2 Charts
– Interactive filter (Slicer or Drop-down)
– Clean professional design

Submission must include the Excel file.

This program is designed to prepare you for real job market demands across all industries.

✔ 38+ Recorded Video Lessons
✔ Real Business Case Studies
✔ Hands-on Practical Projects
✔ Final Dashboard Project
✔ Certificate of Completion