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.
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.
Exploring the Power Pivot RibbonImporting Data from ExcelImporting Data from Text FilesUnderstanding Power Pivot Data ModelCreating Relationships in Diagram ViewIntroducing Calculated Columns Using DAX to Create Calculated ColumnsCreating PivotTable and PivotChart in Power Pivot WindowCreating Calculated MeasuresAdding Slicer and Timeline to Power Pivot ReportsApplying Visualizations on Power Pivot ReportsBuilding a Power View ReportsTraining Methodology Lecture style, with hands-on exercises Closing Date for Registration1 week before programme or until full enrolment
Training Methodology Lecture style, with hands-on exercises Closing Date for Registration1 week before programme or until full enrolment
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.
Others = 7.00 Hours
08 Jul 2020 (9:00 AM - 5:00 PM)
For Members: $ 347.75 $ 278.20 For Non-Members: $ 417.30 $ 333.84 Discounts till 31 Aug 2020
30 Nov 2020 (9:00 AM - 5:00 PM)
For Members: $ 347.75 For Non-Members: $ 417.30
27 Aug 2019 (9:00 AM - 5:00 PM)
Registration is closed
05 Apr 2019 (9:00 AM - 5:00 PM)
21 Dec 2018 (9:00 AM - 5:00 PM)
Valene AngValene 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.
Online Classroom in or outside ofSingapore
You are about to leave ISCA eServices Portal and the registration link will be opened in a new tab. Do you wish to continue?
This course has been added successfully
Declaration to be provided by CPE
You have already enrolled IT034C : Leveraging Microsoft PowerPivot (2016) (Live Webinar) Individual to another session. Do you want to remove from the cart?
This Course is Intended for CA Singapore Users..
If you have an account with us, please sign-in first. If you do not have an account with us, create one now for free.
Do you wish to apply for SFC funding? (Singapore Citizenship Only)
