BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Excel Academy Malaysia - HRD Corp Approved Training Provider
X-ORIGINAL-URL:https://www.excelacademy.my
X-WR-CALDESC:Events for Excel Academy Malaysia - HRD Corp Approved Training Provider
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Kuala_Lumpur
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:+08
DTSTART:20220101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230419T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230420T170000
DTSTAMP:20260424T192043
CREATED:20230103T071314Z
LAST-MODIFIED:20230103T070543Z
UID:7097-1681894800-1682010000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Training (Intermediate & Advanced Level)
DESCRIPTION:Microsoft Excel Training is suitable for someone who has the basics of Microsoft Excel\, this course will help bring you to the next level for greater efficiency and productivity.\n\nIn this Microsoft Excel Training\, you will learn the most important advanced Excel features\, functions\, tools\, tricks\, and reporting techniques. You will be able to perform your daily and periodic excel-related tasks professionally and become the Excel Star in your departments and offices. Besides\, the participants will also learn how to map and manage huge data\, as well as how to extract key information in a short amount of time.\nWhat will you learn in Microsoft Excel Training?\n\nManage database effectively\nApply proper formula and function\nTroubleshooting errors\nLink and Embed Data from other sources.\nApplying Conditional Formatting and Validation Rules\nBuild upon the essential Microsoft Office Excel knowledge and skills.\nLearn to create advanced workbooks and worksheets\, including advanced formulas\, tables\, and data-analyzing tools.\n\nCourse Outline\nModule 1: Calculating with Formulas \n\nHow formulas work\nUsing “$” in formulas\nSUM function\nMAX and MIN function\nAVERAGE and AVERAGE function\nCOUNT and COUNTA function\nCOUNTIF & SUMIF function\n\nModule 2: Conditional Formatting \n\nHow to use conditional formatting\nUsing conditional formatting presets\nManaging and prioritizing rules\nUsing top bottom rules\nCustomizing data bars\nUsing formulas in conditional formatting\n\nModule 3: Sparklines \n\nInserting sparklines\nFormatting sparklines\n\nModule 4: Charts \n\nCreating a chart\nUsing Excel’s recommended charts\nFormatting charts\nChanging chart data\nFiltering chart data\nCreating a dual-axis line chart\nSaving a chart template\n\nModule 5: Logical Functions \n\nFunction: IF\, AND\, OR\nNested IF & AND Function\nNested IF & OR Function\n\nModule 6: Pivot Tables \n\nCreating A Pivot Table\nChanging the Layout of the Pivot Table\nUsing Filters and Report Filters\nGrouping Data in Pivot table\nCalculation in Pivot Table\nUsing Slicers\n\nModule 7: Data Validation \n\nSetting Data Validation Rules\nMessage & Error Alert\nINDIRECT Function with Data Validation\n\nModule 8: Working with Data from Multiple Worksheets & Workbooks \n\nConsolidating Data from Multiple Sources\nConsolidating With Formulas\nLinking Cells with other Sheets & Workbooks\nRepairing Broken Links\n\nModule 9: Text Function \n\nREPLACE\, SUBSTITUTE\, LEN & TRIM\n\nModule 10: Passwords & Security \n\nAdding Open & Modify Password\nProtecting cells with password\nProtecting Worksheets\nHiding Formula\n\nFor more information about our Digital Marketing Masterclass\, contact us at 1700-81-5520 or email us at training@excelacademy.my. To keep updated with our training you can follow us on Facebook\, https://www.facebook.com/excelacademyofexecutiveeducation  \nCheck out other courses\, https://www.excelacademy.my/hrdcorp-claimablecourse/
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-training-intermediate-advanced-level-april-2023/
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/01/Excel-Training_1920April2023.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR