PivotTable Training Outline:

1. PivotTable Fields

• Filters, Columns, Rows and Values

2. PivotTable Options

• How to name a PivotTable

• How to autofit or fix column width on update

3. PivotTable Field Settings

• How to apply format on “Values”

4. PivotTable Menu

PivotTable Analyze:

  a) Refresh

  b) Change Data Source

  c) Slicer

Design:

  a) Report Layout

  b) Subtotals

  c) GrandTotals

5. PivotTable from a Range/Table and Its Difference

6. Misc Tips

a) How to rename fields?

b) How to re-arrange records?

c) How to group records?

7. Q&A Session

Estimated Training Time & Charges : 

• For Beginner Participants: N/A

• For Intermediate Participants:  4–5 hours | RM 650 per person (1-to-1 session)

Group rate (more than 1 person): RM 500 per person

Power Query Training Outline:

1. Introduction to Power Query

• What is Power Query?

• Benefits of using Power Query

2. Loading Data

• Importing data from Excel files, CSV

3. Transforming Data

• Removing duplicates and errors

• Filtering and sorting data

• Splitting and merging columns

4. Shaping Data

• Unpivoting and pivoting columns

• Grouping data by categories

• Adding custom columns with formulas

5. Merging and Appending Queries

• Combining multiple tables into one

• Appending additional data to existing tables

6. Managing Queries

• Renaming and organizing queries

• Understanding query dependencies

7. Data Loading Options

• Loading data into Excel sheets

• Refreshing and scheduling queries

8. Best Practices

• Tips for handling large datasets

• Optimizing query performance

9. Q&A Session

Estimated Training Time & Charges: 

• For Beginner Participants: N/A

• For Intermediate Participants:  5–6 hours | RM 650 per person (1-to-1 session)

Group rate (more than 1 person): RM 500 per person