Project Description


Welkin Course Code: PP16

Course Features

Power Pivot is an extension to Excel where you use it to perform more powerful data analysis and create sophisticated data models. It can go through large amounts of data from various sources but still produce analysis quickly and share insights easily. This course will go through from the basics of installing Power Pivot to more advanced topics of Power Pivot usage. The course covers:
  • Preparing and installing Power Pivot
  • Managing data in Power Pivot
  • Creating and managing relationships
  • Using data sheet view
  • Building Pivot Tables
  • Tips and tricks for Pivot Table and Power Pivot
Completing this course will allow you to be more productive and effective in processing data and information with Microsoft Excel.
  • Easy-to-follow, step-by-step hands-on learning approach
  • Qualified and experienced instructors
  • Weekday evening and weekend classes available

Learn from the Experts

Get Your Skills Certified

Certify your Excel skills with Microsoft Office Specialist Excel certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.
Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills in Microsoft Excel with the CEF reimbursable course Data Analysis with Microsoft Excel.

Course Fee


Course Duration

6 Hours

Course Prerequisites

Course participants should have a basic knowledge of Microsoft Excel.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement.

Schedule & Online Enrolment
Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

PowerPivot for Microsoft Excel
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
PP16-21111KCantonese / PC / MongKok08/1108/11MON0930-1230;1400-17006 hours / 2 sessions20211108


Understanding Power Pivot will allow you to create more complex data model through a collection of of tables with relationships. It is interchangeable with Excel, but allows for more sophisticated data modelling by working in the Power Pivot window. This 6-hour course is designed for those who have some background knowledge in Excel but would like to use more advanced add-ins of Excel to enhance work productivity and effectiveness.

  • Power Pivot: Powerful data analysis and data modeling in Excel
    • What to do in Power Pivot or in Excel
    • How the data is stored
  • Start Power Pivot in Microsoft Excel 2016 add-in
    • Open the Power Pivot window
    • Troubleshooting: Power Pivot ribbon disappears
  • Get data using the Power Pivot add-in
    • Tips for choosing data sources
    • Refresh relational data
    • Add worksheet data to a Data Model using a linked table
    • Copy and paste rows into a Data Model in Power Pivot
  • Create a relationship between tables in Excel
    • Notes about relationships
    • Example: Relating time intelligence data to airline flight data
    • “Relationships between tables may be needed”
  • Create relationships in Diagram View in Power Pivot
    • Find a related column
    • Change the active relationship
    • Arrange tables in the Diagram view
  • Calculations in Power Pivot
    • Types of Calculations in Power Pivot
    • Power Pivot Formulas use Data Analysis Expressions (DAX)
  1. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in