Intermediate Excel Course
Equip learners with practical Excel skills to handle real-world data, apply powerful functions, clean datasets, and create insightful reports and dashboards efficiently.
Modules
6
Lessons
21
Rating
0 / 5
Assignments
1
Course Curriculum
-
Lesson 5.1: Introduction to FunctionsEnroll to access this unit
-
Lesson 5.2: Logical FunctionsEnroll to access this unit
-
Lesson 5.3: Text FunctionsEnroll to access this unit
-
Lesson 5.4: Date & Time FunctionsEnroll to access this unit
-
Lesson 6.1: Removing Errors in DataEnroll to access this unit
-
Lesson 6.2: Cleaning Text DataEnroll to access this unit
-
Lesson 6.3: Data Formatting ToolsEnroll to access this unit
-
Lesson 7.1: VLOOKUP (Core Skill)Enroll to access this unit
-
Lesson 7.2: HLOOKUPEnroll to access this unit
-
Lesson 7.3: XLOOKUP (Modern Excel)Enroll to access this unit
-
Lesson 7.4: INDEX + MATCH (Advanced Technique)Enroll to access this unit
-
Lesson 8.2: Highlighting DataEnroll to access this unit
-
Lesson 8.3: Visual IndicatorsEnroll to access this unit
-
Lesson 8.1: Basics of Conditional FormattingEnroll to access this unit
-
Lesson 9.1: Introduction to Data ValidationEnroll to access this unit
-
Lesson 9.2: Creating Dropdown ListsEnroll to access this unit
-
Lesson 9.3: Restricting InputEnroll to access this unit
-
Lesson 9.4: Custom Validation RulesEnroll to access this unit
-
Lesson 10.1: Introduction to ChartsEnroll to access this unit
-
Lesson 10.2: Common Chart TypesEnroll to access this unit
-
Lesson 10.3: Chart CustomizationEnroll to access this unit
Course Community
The community forum is exclusive to enrolled students. Join us to collaborate and learn!
Ask the Community
Student Feedback
0
Average Rating
Reviewing is available for enrolled students.
Verified Reviews
No reviews yet. Be the first to rate this course!