Master Data Analysis: Excel CaseLab with Real-World Datasets

Categories: Microsoft Excel
Wishlist Share

About Course

Welcome to the Microsoft Excel CaseLab: Data Analyst programme. Led by trainer Wan Nurul Atiqah, this practical, case-based course is designed to equip you with the essential skills to prepare, transform, and analyze real-world datasets.

Through 13 comprehensive video lessons (~3 hours of content), you will dive deep into the actual daily tasks of a Data Analyst. We focus heavily on hands-on application. From core data cleaning techniques and advanced lookup functions to pivot-driven analysis. By the end of this course, you will be able to effortlessly produce structured reports, extract actionable insights, and ensure accuracy and efficiency in your professional data workflows.

Show More

What Will You Learn?

  • Data Preparation & Cleaning: Master text functions, date formatting, and dataset scanning to ensure your raw data is structured and ready for analysis.
  • Advanced Formulas & Logic: Utilize essential mathematical operations, logical statements (IF, OR, Nested IF, Iferror), and powerful lookup functions (VLOOKUP, XLOOKUP) to connect and synthesize complex data.
  • Data Visualization & Reporting: Build dynamic Pivot Tables and Pivot Charts, culminating in clear, narrative reporting designed for business stakeholders.

Course Content

Excel CaseLab: Data Analyst Real Case

  • Download The Dataset
  • Scanning Dataset
    14:55
  • Text Functions
    13:11
  • Date & Numbering
    13:17
  • Xlookup Functions
    19:43
  • Vlookup Functions
    05:37
  • Iferror Functions
    02:32
  • IF & OR Functions
    09:03
  • Mathematical Operations
    03:00
  • Nested IF
    06:01
  • Pivot Table
    19:00
  • Pivot Table (Part 2)
    19:30
  • Pivot Chart
    08:28
  • Narrative Reporting
    28:56