Excel Advanced

Work with real datasets and business scenarios.

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

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

ابدأ الآن

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

• Analyze Performance

• Extract Insights

• Create Summary Report