The Basic + OLAP Pivot Table

Carriera Academy Sdn BhdTel:        03-38850531 / 017-7679688 (Steph )Email:trainings@carriera.com.my

Carriera Academy Sdn Bhd

HRDCORP CLAIMABLE COURSES (SBL-KHAS) INTRODUCTIONThis is a 1-day advanced course in the basic and new functionalities of the Excel Pivot Table.This course structure allows a deeper dive into the new Pivot Table capabilities and brings about a different approach in data preparation where relational files and multiple data sources are concerned. You will be introduced to flat and relational files, best practices, the Data Model, the OLAP and other key OLAP functions of the Pivot Table.These new capabilities improve performance and reduce users’ time when preparing data for further analysis work or reports from a single or multiple data sources. OBJECTIVEThis is an advanced course which covers all important functionalities of the Table, conventional Pivot Table and OLAP Pivot Table. Upon completion of this course, you will be able to create, manage and operate the Pivot Table on flat files and across files in relational databases.You will also acquire a working understanding of the Excel Data Model and the difference between conventional Pivot Table functions from the OLAP Pivot Table. PRE-REQUISITES· Stable Internet Connection· Webcam and Earphones· If you have two computer monitors, please use them· Required software (either one): Excel 2016 Professional Plus, Excel 2019, Excel 2021, Microsoft 365.· Ensure Power Query and Power Pivot is working in your installed versions of your Excel.· Power Pivot info: <a href="https://support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b" title="https://support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">https://support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b</a>· Power Query info: <a href="https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16" title="https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16</a>· Tutorial video: <a href="https://youtu.be/8tWi4nSUyWA" title="https://youtu.be/8tWi4nSUyWA" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">https://youtu.be/8tWi4nSUyWA</a> *This is a hands-on follow-along workshop, packed with exercises. All participants must each have a Computer/Laptop. COURSE CONTENTModule 1: The Excel Table· What is a flat file?· Overview of the Excel Table· Creating the Table· Filtering &amp; sorting the Table· The Table Ribbon· Naming &amp; resizing the Table· Table styles· Inserting slicers· Inserting formulas in the Table· Best practices on maintaining good data Module 2: Introduction to the Pivot Table· Creating the Pivot Table· Populating Rows, Values, Columns &amp; Filters· Formatting values in the Pivot Table· Pivot Table subtotals &amp; grand totals· Pivot Table Report Layout &amp; Styles· Components in Pivot Table Options· Renaming the Pivot Table· Drilling down into data Module 3: Filtering &amp; Sorting· Date filters, Label filters &amp; Value filters· Sorting items in Pivot Table in an ascending or descending order· Slicers &amp; Timeline· Filter Connections Module 4: Calculated Fields &amp; Items· How to insert a Calculated Field· Calculated Field behavior Module 5: Pivot Charts· What is a Pivot Chart?· Creating a Pivot Chart· Pivot Chart rules and design· Managing the underlying data, adding layers and altering structure· Dynamic Charts Module 6: Retrieving &amp; summarizing data from the Pivot Table· Introduction to the GETPIVOTDATA Function· Using GETPIVOTDATA with the Data Validation List Module 7: Managing Changes in Your Source Data· Dynamic Named Ranges· Dealing with zeroes Module 8: Business Intelligence overview· What is BI· The OLAP &amp; relational databases· The Data Model· Creating a Data Model with Power Pivot Module 9: The OLAP Pivot Table· CUBEVALUE &amp; CUBEMEMBER functions· Pivot Table relationshipsPivot Table Sets WHEN &amp; WHERE23 September 2026 (Wed); 9.00am to 5.00pmRemote Online Training (Zoom) WHO SHOULD ATTENDHR Managers, Project Managers, Revenue Managers, Finance Managers and Administrative Personnel who are in the basic to intermediate group who regularly handle a medium-to-high volume data from single or multiple sources TRAINING INVESTMENTRM 800 per participant (inclusive of Service Tax, Online Course Materials, E-Certificate of Attendance) 🔥Group Promo: Save 15%Register min. 3 pax for RM 680 per pax (Normal Rate: RM 800)HRD Corp Claimable (SBL-Khas) REGISTER HERE: <a href="https://carriera.com.my/register.html?training=34138c00-6a77-4e3b-95e0-58f595a4b23c" title="https://carriera.com.my/register.html?training=34138c00-6a77-4e3b-95e0-58f595a4b23c" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">HERE</a> DOWNLOAD BROCHURE HERE: <a href="https://carriera.com.my/training.html" title="https://carriera.com.my/training.html" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">HERE</a>

The Basic + OLAP Pivot Table

More events from Carriera Academy Sdn Bhd

Discover more events from Carriera Academy Sdn Bhd, from Business to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

The Basic + OLAP Pivot Table

More events from Carriera Academy Sdn Bhd

Discover more events from Carriera Academy Sdn Bhd, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.