Duration: 2 days / 15 hours
Time: 9am to 5.30pm
Course Code: CRS-N-0048952
TPGateway Course Code: TGS-2020502647


Funding available for this course :

SkillsFuture Credit PSEA UTAP
Broad based Funding



What Will Be Taught For This Excel Course?

This 2-day course empowers the participants with the skills and knowledge on how to combine the functionality of Power View, PowerPivot, Power Query, and Power Map into graphs, KPIs, reports, and other visualizations for use in their business.

Module 1. Quick Overview of Excel Power Tools

  • Introduction to PowerPivot, PowerQuery, PowerView, PowerMap

Module 2. Working with Power Pivot

  • Power Pivot Interface
  • Getting Data for Power Pivot
  • Working with Relationships
  • Configuring Calculated Columns and Calculated Fields
  • Creating PivotTables
  • Introducing DAX Functions
  • Build Measures with DAX Functions
  • Using KPIs
  • Working with Hierarchies
  • Labs

Module 3. Power Query

  • Power Query Interface
  • Importing Data
  • Appending Files in Folders
  • Data Transformation (UnPivoting, Pivoting, Grouping Data)
  • Labs

Module 4. Working with Power View

  • Power View Interface
  • Working with Tables
  • Understanding Aggregations
  • Utilizing Matrix
  • Working with Drill Through
  • Using Cards
  • Applying Filters & Highlights
  • Cross-Filtering
  • Creating Charts
  • Adding Tiles
  • Adding Slicers to Reports
  • Applying Themes
  • Labs

Module 5. Power Map

  • Power Map Interface
  • Using Bing Maps
  • Review Map Types and Presentation
  • Labs

Module 6. Build your Dashboard

  • Create your dashboard with Excel Power Tools
  • Know the Best Practices
  • Labs

Who Should Attend This Excel Course Training?

This course is intended for business analysts, business intelligence developers, and reporting professionals..


Participants must have a basic working knowledge of Excel.

  w/o GST w GST
Course Fee $900 $963


Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.

Please ensure that you have read our Terms and Conditions before submitting the enrolment form.

Please click on the course date to enrol.

  • CL: Classroom Learning
  • VILT: Virtual Instructor-Led Training
  • GTR: Guaranteed To Run
  • Sat: Saturday
  • Wkn: Weekend
Note: Courses are conducted via classroom unless stated otherwise beside the course dates.