BEGIN:VCALENDAR
VERSION:2.0
METHOD:PUBLISH
CALSCALE:GREGORIAN
PRODID:-//WordPress - MECv7.26.0//EN
X-ORIGINAL-URL:https://www.pmadvance.com.my/
X-WR-CALNAME:PM Advance Sdn Bhd - Project Management Training Malaysia
X-WR-CALDESC:PM Advance
X-WR-TIMEZONE:Asia/Kuala_Lumpur
BEGIN:VTIMEZONE
TZID:Asia/Kuala_Lumpur
X-LIC-LOCATION:Asia/Kuala_Lumpur
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:+08
DTSTART:20260613T173947
END:STANDARD
END:VTIMEZONE
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-PUBLISHED-TTL:PT1H
X-MS-OLK-FORCEINSPECTOROPEN:TRUE
BEGIN:VEVENT
CLASS:PUBLIC
UID:MEC-3465ab6e0c21086020e382f09a482ced@pmadvance.com.my
DTSTART;TZID=Asia/Kuala_Lumpur:20251112T000000
DTEND;TZID=Asia/Kuala_Lumpur:20251113T000000
DTSTAMP:20251104T145007Z
RDATE;VALUE=PERIOD:20251111T160000Z/20251112T160000Z,20251208T160000Z/20251209T160000Z,20260112T160000Z/20260113T160000Z,20260223T160000Z/20260224T160000Z,20260420T160000Z/20260421T160000Z,20260622T160000Z/20260623T160000Z,20260817T160000Z/20260818T160000Z,20261019T160000Z/20261020T160000Z,20261214T160000Z/20261215T160000Z
CREATED:20251104
LAST-MODIFIED:20251210
PRIORITY:5
SEQUENCE:39
TRANSP:OPAQUE
SUMMARY:Microsoft Excel (Intermediate Level)
DESCRIPTION:\nLevel 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.\n\n\nWhy Take This Microsoft Excel Intermediate Course?\nThis 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:\n\nUse advanced formulas and data validation\nApply conditional formatting and dynamic charting\nManage large datasets efficiently with sorting, filtering, and database functions\nCreate professional reports and insightful visualizations\n\nThrough practical exercises and trainer-led demonstrations, you’ll not only learn theory but also apply skills immediately in your day-to-day work.\n\nWho Should Attend\nThis course is ideal for:\n\nProfessionals and executives who regularly work with data, reports, and spreadsheets\nTeam leaders, administrators, and analysts looking to improve accuracy and productivity\nUsers aiming to transition from basic to intermediate Excel skills\nAnyone who wants a structured, analytical approach to data management\n\nPrerequisite: Completion of Microsoft Excel Basic Training or familiarity with basic formulas, data entry, and simple charts.\n\n\nTraining Benefits\nParticipants of this Microsoft Excel Intermediate Course will enjoy:\n\n1-day interactive, hands-on training led by an experienced Excel trainer\nHRDC claimable course under the HRD Corp Scheme\nSkills to analyze and manage large datasets effectively\nKnowledge in applying advanced formulas, data validation, and conditional formatting\nAbility to create professional reports and dynamic visualizations\nComprehensive training materials and certificate of completion\nReal-world examples and guidance to immediately implement learning at work\n\nRegister Today to enhance your Excel skills and increase your productivity!\nCourse Content\nLesson 1: ADVANCED DATA MANAGEMENT\n\nSorting and Filtering by Multiple Criteria\nCustom Sorting and Advanced Filter Options\nData Transformation and Cleaning\n\nLesson 2: DATABASE FUNCTIONS FOR DATA ACCURACY \n\nApplying Subtotals and Custom Sorts\nMulti-Level Data Validation\nUsing Conditional Data Validation\n\nLesson 3: USING AND CUSTOMIZING TEMPLATES \n\nModifying Workbook Templates\nAccessing Online Templates\nCreating and Saving Custom Templates\n\nLesson 4: ADVANCED CHARTING AND VISUALIZATION \n\nUsing Combined Chart Types and Secondary Axes\nFormatting and Customizing Chart Elements\nApplying Sparklines for In-Cell Visualization\n\nLesson 5: ADVANCED FILTERING TECHNIQUES \n\nFiltering Data by Complex Criteria\nUsing Database Functions (DSUM, DAVERAGE, DCOUNT)\nExtracting Unique Values and Removing Duplicates\n\n\nLesson 6: SECURING DATA WITH WORKSHEET PROTECTION \n \n\n\nProtecting Worksheets and Workbooks with Passwords\nAllowing Selective Editing\nManaging Permissions for Workbook Sharing\n\n\n✅ Certificate of Completion will be awarded upon successful completion of the training.✅ Fully HRDC Claimable Course.\n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
URL:https://www.pmadvance.com.my/training/intermediate-microsoft-excel-training/
CATEGORIES:Microsoft Excel Training
ATTACH;FMTTYPE=image/jpeg:https://www.pmadvance.com.my/wp-content/uploads/2025/11/Introduction-to-Microsoft-Excel.jpg
END:VEVENT
END:VCALENDAR