Focused Excel Training on
Essential Topics
Focused Excel Training on
Essential Topics
Unlock the true power of Excel with specialized training tailored to specific topics like PivotTables, Power Query, and more. In this course, participants will gain in-depth knowledge of these tools to excel in their roles and tasks. Sessions are designed to be concise yet comprehensive, ensuring optimal learning without overwhelming participants.
If the course duration exceeds 3 hours, we can arrange multiple sessions (3 hours per session) to ensure that participants fully grasp each concept at a comfortable pace. Each participant will receive practice files during the training and personalized guidance to ensure mastery of the topics. As a bonus, sessions are recorded, and participants will get a download link to revisit and reinforce their learning whenever needed.
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 1,000 per person (1-to-1 session)
Group rate (more than 1 person): RM 900 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 1,400 per person (1-to-1 session)
Group rate (more than 1 person): RM 1,250 per person