Course Detail(IT034C : Leveraging Microsoft PowerPivot (2016) (Live Webinar))

IT034C : Leveraging Microsoft PowerPivot (2016) (Live Webinar)

7.00 CPE Hours (Others)
Classroom

Please be informed that as per Ministry of Health’s (MOH) guidelines on tighter measures that was announced on 24th March 2020, we will be changing the format of the session in Jul & Aug 2020 into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account.


Notice
 
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
 
You may opt to bring along your laptop if you wish to use Excel 2013.

Programme Objective
 
Power Pivot is an Add-Ins in Microsoft Excel used to add data into Excel workbook and store it as an embedded Power Pivot database inside Excel file. You can then use this database in Excel PivotTable reports or in Power View reports. Power Pivot Add-Ins is available in Office Professional 2016, Excel 2016 standalone and Office 365 Pro Plus.
 
With Power Pivot, you can import millions of records from multiple data sources into a single Excel workbook, create calculated columns using Data Analysis Expressions (DAX) functions, create Data Model, create Key Performance Indicator (KPIs) to track performance against targets and create calculated measures that aggregate data from different rows on a PivotTable.
 
The use of Power Pivot, PivotTable reports and Power View reports enable you to perform powerful data analysis, create interactive reports and make timely business decisions.

Programme Outline

 

  • Exploring the Power Pivot Ribbon
  • Importing Data from Excel
  • Importing Data from Text Files
  • Understanding Power Pivot Data Model
  • Creating Relationships in Diagram View
  • Introducing Calculated Columns
  • Using DAX to Create Calculated Columns
  • Creating PivotTable and PivotChart in Power Pivot Window
  • Creating Calculated Measures
  • Adding Slicer and Timeline to Power Pivot Reports
  • Applying Visualizations on Power Pivot Reports
  • Building a Power View Reports

Training Methodology
 
Lecture style, with hands-on exercises
 
Closing Date for Registration

1 week before programme or until full enrolment

Intended For

This one day workshop is an introductory course for Power Pivot. The course is for those who proficient in building PivotTable report and have a need to create dynamic report with large volumes of data. Participants must have an adequate knowledge in Microsoft Excel and extensive working experience with PivotTable and PivotChart in order to benefit from the course. This course is not for beginners with basic level of Excel knowledge and those who seldom use Excel program.

Competency Mapping

Others = 7.00 Hours

Schedule & Fees

Date & Time

08 Jul 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 347.75   $ 278.20
For Non-Members: $ 417.30   $ 333.84
Discounts till 31 Aug 2020

Programme Facilitator(s)

Valene Ang

Venue

Online Classroom in or outside of
Singapore

Date & Time

30 Nov 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 347.75
For Non-Members: $ 417.30

Programme Facilitator(s)

Valene Ang

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

27 Aug 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Valene Ang

Date & Time

05 Apr 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Valene Ang

Date & Time

21 Dec 2018 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Valene Ang

Testimonial

Funding

No funding Available!

Programme Facilitator(s)


Valene Ang

Valene Ang is a Microsoft Certified Trainer (MCT) and ACTA Certified trainer. She has 20 years training experience in Information Technology field. She had conducted many Microsoft Office seminars and workshops in Singapore and Malaysia. Her spreadsheet training focuses on providing practical solutions to problems in data analysis and reporting.

 
Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outline and courseware, assisting corporate client in business data analysis and providing dynamic report solutions.

Please be informed that as per Ministry of Health’s (MOH) guidelines on tighter measures that was announced on 24th March 2020, we will be changing the format of the session in Jul & Aug 2020 into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account.


Notice
 
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
 
You may opt to bring along your laptop if you wish to use Excel 2013.

Programme Objective
 
Power Pivot is an Add-Ins in Microsoft Excel used to add data into Excel workbook and store it as an embedded Power Pivot database inside Excel file. You can then use this database in Excel PivotTable reports or in Power View reports. Power Pivot Add-Ins is available in Office Professional 2016, Excel 2016 standalone and Office 365 Pro Plus.
 
With Power Pivot, you can import millions of records from multiple data sources into a single Excel workbook, create calculated columns using Data Analysis Expressions (DAX) functions, create Data Model, create Key Performance Indicator (KPIs) to track performance against targets and create calculated measures that aggregate data from different rows on a PivotTable.
 
The use of Power Pivot, PivotTable reports and Power View reports enable you to perform powerful data analysis, create interactive reports and make timely business decisions.

Programme Outline

 

  • Exploring the Power Pivot Ribbon
  • Importing Data from Excel
  • Importing Data from Text Files
  • Understanding Power Pivot Data Model
  • Creating Relationships in Diagram View
  • Introducing Calculated Columns
  • Using DAX to Create Calculated Columns
  • Creating PivotTable and PivotChart in Power Pivot Window
  • Creating Calculated Measures
  • Adding Slicer and Timeline to Power Pivot Reports
  • Applying Visualizations on Power Pivot Reports
  • Building a Power View Reports

Training Methodology
 
Lecture style, with hands-on exercises
 
Closing Date for Registration

1 week before programme or until full enrolment

Intended For

This one day workshop is an introductory course for Power Pivot. The course is for those who proficient in building PivotTable report and have a need to create dynamic report with large volumes of data. Participants must have an adequate knowledge in Microsoft Excel and extensive working experience with PivotTable and PivotChart in order to benefit from the course. This course is not for beginners with basic level of Excel knowledge and those who seldom use Excel program.

Competency Mapping

Others = 7.00 Hours

Programme Facilitator(s)

Valene Ang

Valene Ang is a Microsoft Certified Trainer (MCT) and ACTA Certified trainer. She has 20 years training experience in Information Technology field. She had conducted many Microsoft Office seminars and workshops in Singapore and Malaysia. Her spreadsheet training focuses on providing practical solutions to problems in data analysis and reporting.

 
Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outline and courseware, assisting corporate client in business data analysis and providing dynamic report solutions.


Upcoming Schedule

Date & Time

08 Jul 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 347.75   $ 278.20
For Non-Members: $ 417.30   $ 333.84
Discounts till 31 Aug 2020

Programme Facilitator(s)

Valene Ang

Venue

Online Classroom in or outside of
Singapore