Microsoft Excel: Data Model & Power Pivot Basics

Wishlist Share

About Course

Analyse data from several related tables in one PivotTable – without giant VLOOKUP formulas. Learn what Excel’s Data Model is, how to add tables to it, how to create relationships between tables, and how to use Power Pivot to write simple DAX measures.

Tutwoo is an independent learning provider. This course is general awareness training written from published official guidance. It does not replace training required for your specific job, and it is not an accredited qualification.

© 2026 Tutwoo UK Limited. This course was created in-house by Tutwoo and is our original work. It is for your own learning only: please do not copy, share, record or resell it.

What Will You Learn?

  • Explain what the Excel Data Model is and why it helps
  • Add tables to the Data Model and create relationships
  • Build a PivotTable that uses fields from several related tables
  • Write simple DAX measures in Power Pivot

Course Content

Course Lessons

  • What the Data Model is
  • Adding tables and creating relationships
  • Power Pivot and simple DAX measures

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕