Microsoft Excel (Intermediate Level)
Level up your Excel skills in just 1 day with our practical, hands-on training. Learn advanced techniques to manage, analyze, and present data efficiently, and gain confidence to use Excel as a powerful tool for productivity and decision-making.
Why Take This Microsoft Excel Intermediate Course?
This 1-day Microsoft Excel Intermediate Course is designed for professionals who want to build on basic Excel knowledge and master advanced features. You’ll learn to:
- Use advanced formulas and data validation
- Apply conditional formatting and dynamic charting
- Manage large datasets efficiently with sorting, filtering, and database functions
- Create professional reports and insightful visualizations
Through practical exercises and trainer-led demonstrations, you’ll not only learn theory but also apply skills immediately in your day-to-day work.
Who Should Attend
This course is ideal for:
- Professionals and executives who regularly work with data, reports, and spreadsheets
- Team leaders, administrators, and analysts looking to improve accuracy and productivity
- Users aiming to transition from basic to intermediate Excel skills
- Anyone who wants a structured, analytical approach to data management
Prerequisite: Completion of Microsoft Excel Basic Training or familiarity with basic formulas, data entry, and simple charts.
Training Benefits
Participants of this Microsoft Excel Intermediate Course will enjoy:
- 1-day interactive, hands-on training led by an experienced Excel trainer
- HRDC claimable course under the HRD Corp Scheme
- Skills to analyze and manage large datasets effectively
- Knowledge in applying advanced formulas, data validation, and conditional formatting
- Ability to create professional reports and dynamic visualizations
- Comprehensive training materials and certificate of completion
- Real-world examples and guidance to immediately implement learning at work
Register Today to enhance your Excel skills and increase your productivity!
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.