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:20260613T163229
END:STANDARD
END:VTIMEZONE
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-PUBLISHED-TTL:PT1H
X-MS-OLK-FORCEINSPECTOROPEN:TRUE
BEGIN:VEVENT
CLASS:PUBLIC
UID:MEC-4feb2371a1843d099b28dd419dbab1ef@pmadvance.com.my
DTSTART;TZID=Asia/Kuala_Lumpur:20191119T000000
DTEND;TZID=Asia/Kuala_Lumpur:20191123T000000
DTSTAMP:20251104T145028Z
RDATE;VALUE=PERIOD:20191118T160000Z/20191122T160000Z,20251209T160000Z/20251210T160000Z,20260113T160000Z/20260114T160000Z,20260224T160000Z/20260225T160000Z,20260421T160000Z/20260422T160000Z,20260623T160000Z/20260624T160000Z,20260818T160000Z/20260819T160000Z,20261020T160000Z/20261021T160000Z,20261215T160000Z/20261216T160000Z
CREATED:20251104
LAST-MODIFIED:20251210
PRIORITY:5
SEQUENCE:24
TRANSP:OPAQUE
SUMMARY:Microsoft Excel (Advanced Level)
DESCRIPTION:\nTake your Excel expertise to the next level with our advanced, hands-on training. This 1-day Microsoft Excel Advanced Course helps professionals master complex tools and automation techniques for smarter, faster data management and reporting.\nOverview\n \n\nThe Microsoft Excel Advanced Course is a 1-day practical program designed to enhance participants’ ability to manage, analyze, and present complex data using Excel’s most powerful features. Building on the Intermediate level, this course dives deeper into advanced formulas, data modeling, automation tools, and visualization techniques that drive data-driven decision-making.\nAdditionally, participants will learn how to manage large datasets efficiently, use database functions, and create professional dashboards for impactful presentations. By the end of the training, attendees will have the confidence to design dynamic reports and automate repetitive tasks using Excel’s advanced capabilities.\nMoreover, PM Advance’s training approach combines real-world examples with practical exercises and trainer-led demonstrations. This ensures that every participant gains not just technical knowledge, but also the ability to apply Excel as a strategic productivity tool in their workplace.\nWho Should Attend\nThis program is designed for professionals who already possess solid Excel skills or have completed the Microsoft Excel Intermediate Course.\nIt is ideal for:\n\nExecutives and professionals who regularly analyze data and create reports\nTeam leaders, administrators, and analysts seeking greater data accuracy and efficiency\nUsers looking to automate repetitive tasks and simplify complex data processes\nAnyone aiming to progress from intermediate to advanced Excel proficiency\n\n\n\nTraining Benefits\nParticipants in the Microsoft Excel Advanced Course will gain:\n\n1-day interactive, hands-on training led by a certified Excel trainer\nHRDC claimable course under the HRD Corp Scheme\nAdvanced knowledge of data automation and complex functions\nSkills to manage and analyze large datasets effectively\nConfidence to use PivotTables, Power Query, and advanced charts for reporting\nTechniques to secure workbooks and manage permissions\nComprehensive course materials and a certificate of completion\nReal-world examples and post-training support to apply skills immediately\n\nEnroll Now and unlock the full potential of Microsoft Excel in your daily work!\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\n\n\n\n\n\n
URL:https://www.pmadvance.com.my/training/advanced-microsoft-excel-training/
CATEGORIES:Microsoft Excel Training
ATTACH;FMTTYPE=image/jpeg:https://www.pmadvance.com.my/wp-content/uploads/2025/11/Delete-These-Windows-Files-and-Folders-to-Free-Up-Disk-Space.jpg
END:VEVENT
END:VCALENDAR