Data Analysis Intermediate

Intermediate Excel Course

0 (0 Reviews)
Super Admin

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 Functions
    Enroll to access this unit
  • Lesson 5.2: Logical Functions
    Enroll to access this unit
  • Lesson 5.3: Text Functions
    Enroll to access this unit
  • Lesson 5.4: Date & Time Functions
    Enroll to access this unit

  • Lesson 6.1: Removing Errors in Data
    Enroll to access this unit
  • Lesson 6.2: Cleaning Text Data
    Enroll to access this unit
  • Lesson 6.3: Data Formatting Tools
    Enroll to access this unit

  • Lesson 7.1: VLOOKUP (Core Skill)
    Enroll to access this unit
  • Lesson 7.2: HLOOKUP
    Enroll 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 Data
    Enroll to access this unit
  • Lesson 8.3: Visual Indicators
    Enroll to access this unit
  • Lesson 8.1: Basics of Conditional Formatting
    Enroll to access this unit

  • Lesson 9.1: Introduction to Data Validation
    Enroll to access this unit
  • Lesson 9.2: Creating Dropdown Lists
    Enroll to access this unit
  • Lesson 9.3: Restricting Input
    Enroll to access this unit
  • Lesson 9.4: Custom Validation Rules
    Enroll to access this unit

  • Lesson 10.1: Introduction to Charts
    Enroll to access this unit
  • Lesson 10.2: Common Chart Types
    Enroll to access this unit
  • Lesson 10.3: Chart Customization
    Enroll to access this unit

Course Community

0 active threads

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!