Duration: 2 days / 16 hours
Time: 9am to 6pm
Course Code: CRS-Q-0042051-ICT

Funding available for this course:

Enhanced Training Support for SMEs NICF-SF SkillsFuture Credit SkillsFuture Mid-Career Enhanced Subsidy

 

What Will Be Taught For This Excel Power Tools Training Course?

Explore data visualization with Excel PowerPivot,PowerQuery and PowerView. This 2-days course empowers the participants with the skills and knowledge on how to combine the functionality of the power tools and Power Map to translate data into graphs, KPIs, reports, and other visualizations for use in their business.

 

Statement of Attainment (SOA) from SSG

Participants will receive the SOA from SSG upon completion of training and assessment.

Module 1. Quick Overview of Excel Power Tools

Module 2. Working with Power Pivot

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

Module 3. Power Query

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

Module 4. Power View

  • Power View Interface
  • Working with Tables
  • Understanding Aggregations
  • Utilizing Matrix
  • Working with Drill Through
  • Using Cards
  • Applying Filters & Highlights
  • Cross-Filtering

Module 5.Power Map

  • Power Map Interface
  • Working with Power Map

Module 6. Present and Communicate with Dashboard

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

Assessment is conducted at the end of the course. Participants must complete and be assessed as competent (Passed) for the award of SOA from SSG.

Assessment Format & Duration (only applicable for learner taking SF grant)

Assessment Mode Duration
Practical Performance Summative 60 mins
Written Assessment Summative 30 mins
Total 90 mins

Who Should Attend This Excel Power Tools Training?

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

Pre-requisite

Participants must have a good working knowledge of Excel (example Table, PivotTable).

 

  w/o GST w GST
Course Fee $900 $963
Singapore Citizen & PR aged ≥ 21 years    
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
   

 

  w/o GST w GST
Course Fee $900 $963
Singapore Citizen & PR aged ≥ 21 years    
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
   

 

  w/o GST w GST
Course Fee $900 $963
Singapore Citizen & PR aged ≥ 21 years    
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
   

 


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.