Microsoft Excel (Advanced Level)
The Microsoft Excel Intermediate Training is a 1-day practical program designed to strengthen participants’ skills in managing, analyzing, and presenting data using Excel’s more advanced tools and techniques.
This course focuses on building upon the foundational knowledge from the Basic level, introducing participants to powerful features such as advanced formulas, data validation, conditional formatting, and chart customization. Participants will also learn how to manage large datasets, use database functions, and apply filtering and sorting techniques to extract meaningful insights efficiently.
Through a series of guided hands-on exercises, participants will develop the ability to organize data dynamically, create professional reports, and apply structured methods for data management. The course emphasizes practical applications that can be directly implemented in daily business tasks.
PM Advance’s training philosophy emphasizes real-world application and industry relevance, combining theoretical understanding with practical exercises and trainer-led demonstrations. This approach ensures participants gain not only knowledge but also the confidence to use Excel as a strategic tool for productivity and decision-making.
Entry Requirements / Who Should Attend
This course is designed for participants who have completed the Microsoft Excel Basic Training or already possess fundamental Excel knowledge such as data entry, basic formulas, and simple chart creation.
This program is ideal for:
- Professionals and executives who work with data, reports, and spreadsheets on a regular basis.
- Team leaders, administrators, and analysts seeking to improve data accuracy and productivity.
- Users who want to enhance their ability to manage large datasets using advanced features.
- Anyone looking to progress from basic Excel skills to a more efficient, structured, and analytical approach to data management.
Training Benefits
- 1 Day of interactive, hands-on training conducted by an experienced Excel trainer.
- HRDC Claimable Course under the HRD Corp Claimable Courses Scheme.
- Learn advanced tools and features to manage and analyze large datasets effectively.
- Gain practical knowledge in using formulas, data validation, and conditional formatting.
- Master sorting, filtering, and database functions for accurate data organization.
- Develop professional and dynamic data visualizations through enhanced charting techniques.
- Receive comprehensive training materials and certificate of completion from PM Advance Sdn. Bhd.
- Benefit from real-world examples and post-training guidance to apply your learning immediately at work.
Course Content
Lesson 1: ADVANCED DATA MANAGEMENT
- Sorting and Filtering by Multiple Criteria
- Custom Sorting and Advanced Filter Options
- Data Transformation and Cleaning
Lesson 2: DATABASE FUNCTIONS FOR DATA ACCURACY
- Applying Subtotals and Custom Sorts
- Multi-Level Data Validation
- Using Conditional Data Validation
Lesson 3: USING AND CUSTOMIZING TEMPLATES
- Modifying Workbook Templates
- Accessing Online Templates
- Creating and Saving Custom Templates
Lesson 4: ADVANCED CHARTING AND VISUALIZATION
- Using Combined Chart Types and Secondary Axes
- Formatting and Customizing Chart Elements
- Applying Sparklines for In-Cell Visualization
Lesson 5: ADVANCED FILTERING TECHNIQUES
- Filtering Data by Complex Criteria
- Using Database Functions (DSUM, DAVERAGE, DCOUNT)
- Extracting Unique Values and Removing Duplicates
- Protecting Worksheets and Workbooks with Passwords
- Allowing Selective Editing
- Managing Permissions for Workbook Sharing
✅ Certificate of Completion will be awarded upon successful completion of the training.
✅ Fully HRDC Claimable Course.