This course teaches you how to clean, model, and analyze data using Power Query, Power Pivot, and DAX in Excel. Through practical, hands-on lessons, you’ll learn to import data from multiple sources, transform messy datasets, build scalable data models, and perform advanced calculations. By the end, you’ll be able to create dynamic reports, work efficiently with complex data, and apply real-world analytical skills, plus earn a certificate to showcase your expertise.

Course curriculum

Requirements

Basic Excel skills (formulas, tables)

Analytical mindset and willingness to learn

Laptop/PC with Excel installed

Outcomes

Understand the basics of PivotTables, Power Query, and Power Pivot

Import data from multiple sources into Excel

Clean, transform, and standardize data using Power Query

Build data models using relationships in Power Pivot

Write basic DAX formulas for calculations

Create reports using multiple tables and a connected data model

Instructor
7565 Students
9 Courses
151 Reviews
$331 year of access
by Mustafe Xareed
Get this course
Sheerxirfad

Somalia's leading online learning platform. Study ACCA, accounting, business and technology in Somali and English on any phone, and earn a verified certificate.

Address

  • US: 5830 E 2nd St, Casper WY
  • KE: General Wairungi St, Eastleigh, 00610
  • Phone: +252610920007
  • Email: [email protected]

We Accept

Payment method 1
Payment method 2
Payment method 3
Payment method 4

© Copyright 2026 Sheerxirfad, All rights reserved. Powered by Ilays Solutions