BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.16.4//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:20230620T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230621T170000
DTSTAMP:20260621T025326
CREATED:20230103T080922Z
LAST-MODIFIED:20230602T030628Z
UID:7123-1687251600-1687366800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Graphic Design Course
DESCRIPTION:The graphic design course will first start with the Adobe Photoshop aspect. In this session\, you will learn the basic uses of the software and will slowly introduce the more advanced features that the software has After this session\, you will be able to enhance the images of your posters\, flyers\, online banners and others. In other words\, you will be able to leave and edit your own images to your own liking. \nMoving on\, our training will commence with Adobe Illustrator aspect. Our Illustrator training will introduce the powerful pen tool\, which is able to transform existing shapes\, add colour to existing drawn objects\, apply layer effects to artwork\, and many more. This training will benefit where your will be able to design your own logo and create templates for social media posters/ flyers and others. In short\, the set of tools provided by illustrator will provide everything you need to produce extraordinary graphics for print\, the web and others. \nGraphic Design Course – Available Dates\n\nJanuary: 17 & 18\nFebruary: 14 & 15\nApril: 18 & 19\nJune: 20 & 21 (Face-to-Face Training)\nAugust: 22 & 23\nOctober: 24 & 25\nDecember: 19 & 20\n\nGraphic Design Course Learning Outcomes\n\nDevelop display ad campaigns\nPromote your company by managing brand colours\nCreate online banners in various sizes and formats\nDesign print materials like business cards\, flyers\, etc.\nLearn industry-insider graphic design terms\nCommunicate better with ad agencies and design teams\n\nCourse Outline\nADOBE PHOTOSHOP \n\nDigital Advertising Principles of design\nDesign Elements\nIntroduction to Adobe Photoshop\nEraser Tool – separate object and background\nLayer effects\nImage manipulation\nColour correction\nTypography\nCreating Posters for FB and IG\nCreating Banners for FB\nPreparing Photoshop files for animated poster\n\nADOBE ILLUSTRATOR \n\nIntroduction to Adobe Illustrator\nDrawing with shape\nTracing with Pen tool\nLayer Effects\nApply gradients\, warp effects\, blends\, and other styles to shapes in Illustrator\nTypography techniques\nCreating Posters for web and print\nCreating Logos\nPreparing Illustrator files for animated poster\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-graphic-design-course-june-2023/
LOCATION:Selangor
CATEGORIES:Multimedia
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/01/Graphic-Design-June.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230621T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230622T170000
DTSTAMP:20260621T025326
CREATED:20230103T080314Z
LAST-MODIFIED:20230106T081159Z
UID:7120-1687338000-1687453200@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-june-2023/
LOCATION:Selangor
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/01/Excel-Training_2122June2023.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230705T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230706T170000
DTSTAMP:20260621T025326
CREATED:20230711T062655Z
LAST-MODIFIED:20230711T064032Z
UID:9009-1688544000-1688662800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Data Analytics and Visualization in Excel
DESCRIPTION:Transform Your Data into Insights with Excel\nUnlock the full potential of your data with our comprehensive Data Analytics and Visualization in Excel course. Whether you’re a beginner or an experienced user\, this course will teach you the skills you need to turn raw data into actionable insights. \nWith step-by-step instructions and hands-on exercises\, you’ll learn how to import\, clean\, and analyze data in Excel. You’ll also learn how to create interactive dashboards\, powerful visualizations\, and custom functions that can help you make informed decisions. \n  \nWho Should Join This Data Analytics and Visualization in Excel?\nA Data Analytics and Visualization in Excel course can benefit you in many ways. It can boost your career\, improve your problem-solving and decision-making skills\, make you more efficient in using Excel\, increase your data literacy\, and give you hands-on experience with real-world scenarios. This course is suitable for anyone looking to advance their career\, start a new one\, or learn a new skill. \n  \nHRD Corp Claimable Course\nThis course is not just eligible for HRD Corp claims\, it’s a must-have opportunity for those looking to invest in their personal and professional growth. By taking advantage of the organization’s human resource development program and getting reimbursed for the cost of the course\, you’ll not only be boosting your skillset and increasing your knowledge\, but you’ll also be maximizing the benefits offered by your employer. Don’t miss out on this incredible opportunity to enhance your career and secure your future success. Make the investment in yourself today and claim your spot in this valuable course. \n  \nCourse Outline\nGETTING DATA INTO MICROSOFT EXCEL\n– Import data from various platforms into Microsoft Excel for further analysis \nDATA CLEANING AND MANIPULATION\n– Use functions for combining and splitting text\n– Clean data\, change case\, and remove unwanted characters\n– Understand the importance of well-organized data for analysis \nWORKING WITH NUMBERS AND DATES\n– Convert data types from text to numbers\, dates to text\, and both numbers and text to dates\n– Utilize functions for generating dates\, calculating days between two dates\, and more \nDEFINED NAMES FOR BETTER DATA MANAGEMENT\n– Referencing and naming cells\, creating named ranges\, and automating processes.\n– Improve efficiency and accuracy by using defined names in calculations \nAUTOMATING DATA MANIPULATION WITH TABLES\n– Use SMART TABLES to create\, format\, and manage tables\n– Format\, select\, sort\, and filter data\n– Improve the organization and analysis of data with structured referencing \nLOGICAL AND LOOKUP FUNCTIONS\n– Evaluate data using nested IF functions\n– Perform logical operations with IF\n– Categorize data with VLOOKUP and XLOOKUP\n– Match data with advanced functions such as INDEX and MATCH \nDATA TRANSFORMATION WITH POWER QUERY\n– Use the Query Editor Engine to extract\, transform\, and load data\n– Combine multiple datasets for more comprehensive analysis. \nDATA VISUALIZATION\n– Visualize data with conditional formatting\, sparklines\, number formats\, and more\n– Utilize standard charts such as line charts\, pie charts\, and scatter charts\, as well as specialized charts such as hierarchy\, waterfall\, funnel\, geospatial\, and gauge charts \nCREATING INTERACTIVE DASHBOARDS\n– Summarize data with Pivot Tables\n– Customize\, group\, sort\, and filter pivot data\n– Create interactive dashboards with pivot charts\, slicers\, and timelines \nDATA VISUALIZATION WITH POWER BI\n– Quickly visualize data with the help of Power BI. \n  \nFor more information about our Data Analytics and Visualization In Excel\, 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-data-analytics-and-visualization-in-excel/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Data Analytics & Visualization In Excel,Public training/course
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/07/HRDCorpClaimableCourse_Data_Analytics__Visualization_In_Excel_Physical_7_JUL.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230712T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230713T170000
DTSTAMP:20260621T025327
CREATED:20230711T064447Z
LAST-MODIFIED:20230711T064447Z
UID:9014-1689148800-1689267600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Mastering Interactive Dashboard Reporting with Power BI
DESCRIPTION:Master the art of interactive dashboard reporting with Power BI. Learn from industry experts how to transform raw data into visually stunning and actionable dashboards that drive informed decision-making. Explore data sources\, clean and transform data\, create captivating visualizations\, and leverage advanced features like interactivity\, storytelling\, and DAX formulas. Ideal for data analysts\, BI professionals\, and decision-makers. \n  \nWhy You Should Enroll in this Power BI Course?\n– Unlock the power of data visualization with Power BI and create impactful dashboards. \n– Gain hands-on experience and practical skills to transform raw data into visually stunning reports. \n– Learn advanced techniques like interactivity\, storytelling\, and DAX formulas for deeper analysis. \n– Enhance your decision-making abilities with actionable insights from interactive dashboards. \n– Ideal for data analysts\, BI professionals\, and decision-makers seeking to leverage Power BI’s capabilities. \n– Stay ahead in the competitive landscape by mastering interactive dashboard reporting. \n– Enroll now to become a Power BI dashboard reporting specialist and elevate your data analysis skills. \n  \nHRD Corp Claimable Course\nThis course is not just eligible for HRD Corp claims\, it’s a must-have opportunity for those looking to invest in their personal and professional growth. By taking advantage of the organization’s human resource development program and getting reimbursed for the cost of the course\, you’ll not only be boosting your skillset and increasing your knowledge\, but you’ll also be maximizing the benefits offered by your employer. Don’t miss out on this incredible opportunity to enhance your career and secure your future success. Make the investment in yourself today and claim your spot in this valuable course. \n  \nCourse Outline\nINTRODUCTION TO SELF-SERVICE BI SOLUTIONS \n– Introduction to business intelligence \n– Introduction to data analysis \n– Introduction to data visualization \n– Microsoft tools for self-service BI \n  \nINTRODUCING POWER BI \n– This module introduces Power BI. \n– Power BI \n– The Power BI service \n  \nPOWER BI DATA \n– This module describes Power BI data sources. \n– Excel files\, CSV & Text files as a Power BI data source \n– Using databases as a Power BI data source \n  \nSHAPING AND COMBINING DATA \n– This module describes how to shape and combine data. \n– Power BI desktop queries \n– Shaping data \n– Combining data \n  \nMODELLING DATA \n– This module describes how to model data in Power BI. \n– Relationships \n– DAX queries \n– Calculations and measures \n  \nINTERACTIVE DATA VISUALIZATIONS \n– This module describes Power BI visualizations. \n– Creating Power BI reports \n– Managing a Power BI solution \n  \nFor more information about our Mastering Interactive Dashboard Reporting with Power BI\, 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-mastering-interactive-dashboard-reporting-with-power-bi/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Mastering Interactive Dashboard Reporting with Power BI,Public training/course
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/07/HRDCorpClaimableCourse_Mastering_Interactive_Dashboard_Reporting_With_Power_BI_Physical_7_JUL.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230725T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230726T170000
DTSTAMP:20260621T025327
CREATED:20230104T012808Z
LAST-MODIFIED:20230728T065537Z
UID:7130-1690272000-1690390800@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.\n\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\n  \nCourse Outline\nDATA MANAGEMENT\n• Sorting\n• Sorting Multiple Columns\n• Finding Data\n• Replacing Data\n• Finding and Replacing Cell Format\n• Practice – Data Management \nWORKING WITH DATABASES\n• Creating Subtotals in a List\n• Removing Subtotals from a List\n• Sorting Data by Multiple Levels\n• Using Custom Sort\n• Using Data Validation\n• Validating Data using a List\n• Creating a Custom Error Message\n• Removing Data Validation \nUSING TEMPLATES\n• Copying Worksheets\n• Hiding Columns and Rows\n• Unhiding Columns and Rows\n• Saving a Workbook as a Template\n• Using a Template\n• Editing a Template\n• Inserting a New Worksheet\n• Hiding/Unhiding a Worksheet\n• Deleting a Template\n• Finding Online Templates \nCREATING CHARTS\n• Inserting a column chart\n• Inserting a line chart\n• Inserting a bar chart\n• Inserting a pie chart\n• Resizing a chart\n• Deleting a chart\n• Adding a Chart Title\n• Changing the Chart Background\n• Changing a column\, bar\, line\, or pie slice colours\n• Changing the chart type\n• Adding a Data Table\n• Changing the Chart Layout\n• Copying and moving charts\n• Creating a 3-D Chart\n• Adjusting 3-D View\n• Inserting Sparklines\n• Practice – Creating Charts \nREVISING CHARTING FEATURES\n• Formatting an Axis\n• Changing the Axis Scaling\n• Formatting the Data Series\n• Adding Data from Different Worksheets\n• Using a Secondary Axis\n• Changing Data Series Chart Types\n• Changing Source Data Range \nWORKING WITH ADVANCED FILTERS\n• Creating a Criteria Range\n• Using a Criteria Range\n• Showing All Records\n• Using an Advanced and Condition\n• Using an Advanced or Condition\n• Copying Filtered Records\n• Using Database Functions \nUSING CONDITIONAL AND CUSTOM FORMATS\n• Applying Conditional Formats\n• Changing a Conditional Format\n• Adding a Conditional Format\n• Creating a Custom Conditional Format\n• Using Data Bars\n• Deleting a Conditional Format\n• Creating a Custom Number Format\nUSING WORKSHEET PROTECTION\n• Unlocking Cells in a Worksheet\n• Protecting a Worksheet\n• Unprotecting a Worksheet\n• Creating Allow-Editing Ranges\n• Deleting Allow-Editing Ranges\n• Protecting Workbook Windows\n• Unprotecting Workbook Windows\n• Assigning a Password\n• Opening a Password-protected File\n• Removing a Password \nUSING AUDITING TOOLS AND RANGE NAMES\n• Jumping to a Named Range\n• Assigning Names\n• Using Range Names in Formulas\n• Creating Range Names from Headings\n• Applying Range Names\n• Deleting Range Names\n• Using Range Names in 3-D Formulas\n• Displaying/Removing Dependent Arrows\n• Displaying/Removing Precedent Arrows\n• Showing Formulas \nEXPORTING AND IMPORTING DATA\n• Importing Data from Text Files\n• Changing External Data Range Properties\n• Removing the Query Definition\n• Creating a Hyperlink\n• Editing a Hyperlink \nUSING ADVANCED FUNCTIONS\n• Using the VLOOKUP Function\n• Using the HLOOKUP Function\n• Using the IF Function\n• Using Nested IF Functions\n• Using the ISERROR Function\n• Using an AND Condition with IF\n• Using an OR Condition with IF\n• Using the ROUND Function\n• Using COUNTIF Function\n• Using RANK Function\n• Using Financial Functions\n• Using Text Functions \nCREATING/REVISING PIVOT TABLES\n• Creating a PivotTable Report\n• Adding PivotTable Report Fields\n• Selecting a Page Field Item\n• Refreshing a PivotTable Report\n• Changing the Summary Function\n• Adding New Fields to a PivotTable Report\n• Moving PivotTable Report Fields\n• Hiding/Unhiding PivotTable Report Items\n• Deleting PivotTable Report Fields\n• Creating a Page Field Report\n• Formatting a PivotTable Report\n• Creating a PivotChart Report\n• Grouping Data Manually \nUSING SCENARIOS\n• Creating a Scenario\n• Displaying a Scenario\n• Editing a Scenario\n• Creating a Scenario Summary Report\n• Working with Data Tables\n• Placing Formulas in Data Tables\n• Creating a One-Variable Table\n• Creating a Two-Variable Table \nTRACKING AND MERGING WORKBOOKS\n• Saving a Shared Workbook\n• Viewing Users Sharing a Workbook\n• Viewing Shared Workbook Changes\n• Changing the Update Frequency\n• Highlighting Changes\n• Managing Conflicting Changes\n• Resolving Conflicting Changes\n• Setting Change History Options\n• Adding a History Worksheet\n• Reviewing Tracked Changes\n• Merging Shared Workbook Files \nRECORDING MACROS\n• Recording a Macro\n• Saving a Macro-Enabled Workbook\n• Running a Macro\n• Assigning a Shortcut Key\n• Using a Shortcut Key\n• Deleting a Macro\n• Adding a Macro to Quick Access Toolbar\n• Deleting a Macro Button from QAT \n  \nFor more information about our Microsoft Excel Training\, 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-july-2023/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel,Public training/course
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/01/HRDCorpClaimableCourse_Microsoft_Excel_Intermediate__Advanced_Level_Physical_7_JULY.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230725T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230726T170000
DTSTAMP:20260621T025327
CREATED:20230104T013635Z
LAST-MODIFIED:20230711T070936Z
UID:7133-1690275600-1690390800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Video Editing Course
DESCRIPTION:The video editing course will begin with Adobe After Effects. This session will provide you with the skills to create\, edit and compound digital video with desired effects\, for the purposes of post-production\, presentation\, instructional\, and visual messaging content. Examples of what you will learn are motion graphics\, text animation\, and others. In short\, our After Effects course will provide ways to enhance the features of video to make it more exciting and engaging. \nNext\, our video editing course will continue with the Adobe Premiere Pro aspect. This session will provide the essential editing skills to boost your video editing skills. Examples of the lessons that you will learn are such as how to completely edit a video such as adjusting the volume of the video to the desired level\, video formatting\, dynamic trimming\, and many more. In a nutshell\, by attending our Premiere Pro session\, you will be able to graphic design\, and easily manage and edit videos. \n  \nVideo Editing Course Learning Outcomes?\n\nDevelop display ad campaigns\nPromote your company using FB pocket TVC\nCreate marketing videos in various sizes and formats\nLearn industry insider video production terms\nCommunicate better with ad agencies and design teams\n\n  \nCourse Outline\nADOBE AFTER EFFECT \n– Introduction FB pocket TVC \n– Introduction to After effects \n– Work Photoshop/illustrator with aftereffects \n– Motion Graphics \n– Text Animation \n– Create FB pocket TVC \n  \nADOBE PREMIERE \n– Video productions \n– Camera works \n– Introduction to Adobe premiere \n– Video Transition \n– Video Cutting Techniques \n– Titles \n– Video motion and effects \n– Audio \n– Video formats \n– Video editing and publishing \n  \nFor more information about our Video Editing course\, 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-video-editing-course-july-2023/
LOCATION:Selangor
CATEGORIES:Multimedia,Public training/course
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/01/HRDCorpClaimableCourse_Video_Editing_7_JULY.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230726T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230727T170000
DTSTAMP:20260621T025327
CREATED:20230104T011651Z
LAST-MODIFIED:20230711T065315Z
UID:7127-1690362000-1690477200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Digital Marketing Masterclass
DESCRIPTION:Digital Marketing Masterclass training allows the participants to learn and master effective online marketing strategies\, ranging from learning to plan\, set up\, monitor and optimize a marketing campaign that leads to achieving the marketing goals. In this Digital Marketing Masterclass\, the participants will also get a chance to learn the proven framework and formula for managing their social media and Google ads campaigns. These modules are custom designed\, to help participants to equip the skill and ability to see improvement in their marketing campaign. This Digital Marketing Masterclass training is more than a theory\, the trainer will cover case studies\, best practices\, and the do’s and don’ts to make it practical\, easy to understand\, and easy to apply. \n  \nWhat will you learn in this Digital Marketing Masterclass Training?\n\nUnderstand the principles of digital marketing and the tools. Leverage them to grow your presence\, positioning and revenue online.\nUtilize the latest Facebook Ads campaign strategies to improve your marketing results and performance.\nLearn how to run Google Ads\, using other Google online tools to create an effective campaign for both B2C and B2B industries.\nLearn how to create engaging copies\, images or videos for social media and Search Engine campaigns.\nHow to build authority\, brand\, and positioning as the go-to expert on social media with content marketing.\n\n  \nCourse Outline\nPRINCIPLES OF DIGITAL MARKETING\n• Overview of an effective digital marketing strategy\n• Understand the pillars of digital marketing\n• Identifying customer online behavioral journey\n• Online competitor research and analysis\n• Concept and important terms for digital marketing\n• Malaysian behavioral trend online \nFACEBOOK & INSTAGRAM MARKETING\n• Social Media Ads campaign structure Overview\n• Meta Ads Account Manager & Business Manager Overview\n• Facebook & Instagram Campaign setup best practices\n• Custom audience and Lookalike audience overview and strategy\n• Copywriting for Ads\n• Campaign monitoring and optimization\n• Facebook / Instagram ads policy and guidelines overview\n• Ads analysis and measuring your campaign\n• Facebook pixel and event measurement overview \nWEBSITE AND LANDING PAGE OPTIMIZATION\n• How to build a beginner-friendly site easily\n• Differences between a website and a landing page\n• Website ideas and structure setup\n• Website optimization best practices\n• Tools and tips for building a modern website without experience\n• Website pro tips and strategies that will help you save costs and\ngenerate leads\n• Lead generation forms integration and setup for maximum conversion \nCONTENT MARKETING\n• Introduction to content marketing and its application.\n• Learn different types of content to build brand\, positioning and authority.\n• Content research\, ideation\, and planning strategy\n• Set up and manage your content calendar effectively.\n• How TO measure your content marketing goals\n• Short video – Reels video creation tutorial \nGOOGLE ADS MARKETING\n• Understand Google Ads campaign structure.\n• Learn different types of Google Ads objectives for your campaign goals.\n• Keyword research analysis and preparation.\n• Google ads campaign setup walkthrough and best practices.\n• Monitor and optimizing your Google Ads campaign.\n• How to measure your Google ads campaign. \nSEARCH ENGINE OPTIMIZATION\n• How to optimize your website for better ranking on Google.\n• Understanding technical SEO.\n• Keyword research and optimization for better ranking.\n• Off-page SEO methods and strategies.\n• Auditing your website before implementing SEO.\n• Understand how Search Engine works in most cases.\n• Getting in touch with Google’s latest update on the algorithm.\n• Recommended tools to help measure your site performance and\nprogress.\n• Measuring your SEO effort with Google Analytics and Google Analytics \nAI FOR MARKETING PERFORMANCE\, PRODUCTIVITY & CREATIVITY\n• Learn different AI tools for marketing tasks & activities\n• Understand the limit and boundaries of AI tools\n• Using AI for Social Media & Search Engine\n• AI prompt for digital marketing \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/july-2023/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Digital Marketing,Public training/course
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/01/HRDCorpClaimableCourse_Digital_Marketing_Masterclass_Physical_7_JUL.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230815T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230815T170000
DTSTAMP:20260621T025327
CREATED:20230728T070232Z
LAST-MODIFIED:20230728T070232Z
UID:9242-1692086400-1692118800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - ChatGPT Mastery: Enhancing Marketing Communications & Productivity
DESCRIPTION:In today’s fast-paced and digitally driven world\, organizations are seeking innovative solutions to streamline workflows and enhance productivity. This comprehensive course introduces participants to ChatGPT\, a state-of-the-art language model developed by OpenAI\, and explores its effective utilization within organizational settings.\n\nDesigned for professionals and teams across industries\, this course equips participants with the necessary knowledge and practical skills to leverage ChatGPT for a wide range of applications in their work environments.\n\nWhat will you learn in ChatGPT Mastery Training?\n\nUnderstand the fundamentals of ChatGPT and its capabilities\nLearn how to use ChatGPT to enhance productivity and efficiency in daily tasks\nExplore practical applications of ChatGPT in different organisational contexts\nDevelop strategies for effectively integrating ChatGPT into existing workflows\nGain insights on best practices\, potential challenges\, and ethical considerations when using ChatGPT\n\n  \nCourse Outline\nINTRODUCTION TO CHATGPT-3\n• Introduction to artificial intelligence and natural language processing\n• Overview of GPT-3 and its capabilities in text generation and human-computer interactions\n• Exploring the benefits of using ChatGPT-3 in organizational contexts\n• How ChatGPT-3 learns and adapts to generate human-like responses\n• Key concepts and the underlying technology behind ChatGPT-3\n• Limitations and ethical considerations of using ChatGPT-3 \nIMPLEMENTING CHATGPT-3 IN ORGANIZATIONAL WORKFLOWS\n• Introduction to Prompt Engineering\n• Using ChatGPT to create a full marketing campaign\n• Creating a comprehensive content calendar for your marketing campaign using ChatGPT\n• Defining and optimizing your target audience and buyer persona\n• Utilizing ChatGPT for audience research and analysis\n• Developing optimized social media posts with ChatGPT\n• Writing an optimized blog post in seconds with ChatGPT\n• Creating an email sequence with ChatGPT\n• Crafting sales page copy with ChatGPT\n• Generating Facebook ads and Google ads with ChatGPT\n• Analysing reviews and optimizing products and services with ChatGPT\n• Leveraging ChatGPT for tailored content\, seizing trending opportunities\, and crafting compelling advertisements\, newsletters\, and dynamic media campaigns in marketing\n• Optimizing AI-generated content\, captivating audiences\, and boosting brand impact through prompt engineering in ChatGPT marketing\n• Unleashing the power of ChatGPT from OpenAI for cutting-edge marketing strategies and impactful results \nMANAGING AND EVALUATING CHATGPT-3\n• Guidelines for integrating ChatGPT-3 into existing systems and workflow\n• Best practices for data preparation and fine-tuning models for specific organizational needs\n• Addressing potential biases and ethical concerns in the use of ChatGPT-3\n• Strategies for continuous improvement and feedback loops to enhance ChatGPT-3’s performance\n• Practical Exercises and Case Studies\n• Hands-on activities to engage participants in using ChatGPT-3\n• Group discussions and knowledge sharing to exchange insights and lessons learned \n  \nFor more information about our ChatGPT Mastery training\, 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-chatgpt-mastery-enhancing-marketing-communications-productivity/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:ChatGPT,Digital Marketing
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/07/HRDCorpClaimableCourse-ChatGPT-Mastery-Enhancing-Marketing-Communications-Productivity-AUG.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230816T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230817T170000
DTSTAMP:20260621T025327
CREATED:20230728T071244Z
LAST-MODIFIED:20230728T071244Z
UID:9246-1692172800-1692291600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Social Media Marketing
DESCRIPTION:Digital marketing skills are critical not only for digital marketing professionals but for anyone working in a business that has an online presence. This includes entrepreneurs\, marketing managers\, marketing specialists\, and small business owners.\n\nThis intensive 2-day Social Media Marketing and Branding workshop provides a realistic hands-on setting for beginners to embark on a Social Media Marketing and branding journey. Peppered with case studies and practical both local and international\, role-playing scenarios\, and hands-on activities\, participants will learn how to create\, grow\, and measure Social Media Marketing campaigns and manage their brand. Participants will also learn practical methods of how to harness the power of DM as the core driver of marketing strategy; how to apply successful marketing campaigns\, measure outcomes and plan a marketing strategy.\n\n\nWhat will you learn in Social Media Marketing Training?\n• Create and brand personal/organization presence in social media\,\n• Attract the right target audience and quality fans\n• Convert the traffics and fans to become leads/customer\n• Understand how latest social media marketing trends works\n• Create a social media marketing plan for your business\n• Deepen your knowledge of the evolving social media trends and brand developments\n• Expose to the best practices for branding and marketing\n• Increase your return on investment as part of marketing efforts\n• Optimise your existing social media marketing activities with the right tool \n  \nCourse Outline\nUNDERSTANDING DIGITAL MEDIA MARKETING\n• Fundamentals of Digital Marketing\n• Components of Digital Marketing\n• Current trends and Opportunities in the field of Digital Marketing\n• The Social Media Audit\n• SOSTAC® Marketing and RACE® Model \n  \nCONTENT MARKETING\n• Content Marketing Essentials\n• Copywriting Techniques\n• Generating content ideas\n• Types of content writing\n• Content Format and repurposing\n• Video Marketing\n• Tools and Techniques for content marketing\n• Strategy & the Social Journey\n• Vision & Goals Setting\n• Choosing your channels – Developing Buyer’s Journey and Customer Persona \n  \nSOCIAL MEDIA MARKETING CONCEPTUALIZATION\n• How online media differs from other traditional media opportunities\n• Audience behaviour online: penetration rates\, trends\, challenges\n• Selecting the right channels\, formats and placements for your campaign\n• Key considerations to consider when briefing and developing ad creative\n• How to overcome the key challenges of online advertising and maximize ROAS \n  \nFACEBOOK AND INSTAGRAM MARKETING\n• Facebook Content Marketing Best Practices\n• Setting a Facebook Content Strategy\n• Moderation and Reputation Management\n• Best Practices for using Facebook\n• Instagram and its role in your Marketing efforts\n• Instagram and how to make sure of it effective\n• Facebook & Instagram Advertising\n• Introduction to Meta Business Manager \n  \nLINKEDIN AND TIK TOK MARKETING\n• Personal & Corporate LinkedIn Pages\n• Advertising On LinkedIn and ad formats\n• Tik Tok basics – setting up profile for business\n• How to increase engagement on Tik Tok\n• Trending Challenges and Music usage\n• Hashtag Marketing & Influencer marketing\n• Creating and editing Tik Tok Video\n• Tik Tok Ads Manager \n  \nANALYTICS AND DATA INTERPRETATION\n• Facebook Insights\n• Return of Ads Spent (ROAS) Calculations\n• Competitor Analysis\n• Refining Social Media Strategies from Analytics \n  \nLOYALTY MARKETING\n• What Is Loyalty Marketing?\n• Identifying your loyal customers\n• Benefits of Loyalty Marketing – a continuous effort\n• Develop and Implement Your Own Loyalty Strategy \n  \nFor more information about our Social Media Marketing training\, 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-social-media-marketing/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Digital Marketing
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/07/HRDCorpClaimableCourse-Social-Media-Marketing-AUG.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230821T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230822T170000
DTSTAMP:20260621T025327
CREATED:20230728T072732Z
LAST-MODIFIED:20230728T072732Z
UID:9249-1692604800-1692723600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Data Import\, Cleanse & Automation with Power Query
DESCRIPTION:Power Query can connect to wide range of data sources. Databases such as SQL Server\, Oracle\, Text files\, Big data and Hardtop data sources\, online searches and Data feeds\, Cloud storage\, Facebook\, SharePoint and many other types of data storage. Power Query extracts the data from sources\, and does transformations such as splitting columns\, data conversions\, lookups\, merge\, append\, data cleansing and many other data transformations AUTOMATICALLY without the use of VBA.\n\nPower Query is simply the best transformation and data manipulation tool for Excel and easier to use\, understand and master than other tools. Upon successful completion of this course\, the delegate should be proficient with Power Query and have the necessary skills to implement and automate the process of pulling in data\, perform data transformation and data cleansing.\n\nWhat will you learn in Power Query Training?\n•Import / connect to external data from multiple sources\n• Automate the data transformation & data cleansing processes\n• Combine data from multiple sources into a single source\n• Merging data without the need of formulas such as VLOOKUP\, INDEX & MATCH\n• Perform calculation to aggregate data \n  \nCourse Outline\nINTRODUCTION TO POWER QUERY\nThis module explains what a power query is and how you can download and install the power query on your computer. Learn how data files are imported / connected whether it’s a text files\, CSV file\, database\, or any other source. Once the connection is built\, refreshing the connection will automatically load the latest changes. \nAPPENDING DATA FROM MULTIPLE SOURCES / FORMATS\nIn this module\, you will append data together into one source from multiple file formats\, multiple sources and even an entire folder for the purpose of analysis. If the source is an Excel file\, learn to pull data from multiple workbooks\, multiple sheets\, and multiple tables. \nMERGING TABLES\nThis module shows how easy to merge data without using formulas such as VLOOKUP\, INDEX & MATCH. Perform more advanced merges using Inner\, Outer\, Full\, and Anti Joins. Learn to automate reconciliations and throw out exceptional items. \nPOWER QUERY FORMULAS\nThis module shows how to perform calculations such as SUM\, AVERAGE & COUNT just like a pivot table. More complicated data transformation can be done using “M” language for Power Query. \nTRANSFORMING DATA\nIn Power Query\, you will be able to transform selected columns into attribute value pairs where columns become rows for data analysis which is required for Pivot Tables. Data that is structured incorrectly can be transformed easily. \n  \nCLEANING DIRTY DATA\nThe complete removal of dirty data from a source is virtually impossible. Power Query has some tools which can be used to clean some common problems such as missing data\, data formatted incorrectly or date problems. \n  \nFor more information about our Power Query training\, 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-data-import-cleanse-automation-with-power-query/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Power Query
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/07/HRDCorpClaimableCourse-Data-Import-Cleanse-Automation-With-Power-Query-AUG.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230821T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230822T170000
DTSTAMP:20260621T025327
CREATED:20230728T073653Z
LAST-MODIFIED:20230728T073653Z
UID:9252-1692604800-1692723600@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.\n\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\n  \nCourse Outline\nDATA MANAGEMENT\n• Sorting\n• Sorting Multiple Columns\n• Finding Data\n• Replacing Data\n• Finding and Replacing Cell Format\n• Practice – Data Management \nWORKING WITH DATABASES\n• Creating Subtotals in a List\n• Removing Subtotals from a List\n• Sorting Data by Multiple Levels\n• Using Custom Sort\n• Using Data Validation\n• Validating Data using a List\n• Creating a Custom Error Message\n• Removing Data Validation \nUSING TEMPLATES\n• Copying Worksheets\n• Hiding Columns and Rows\n• Unhiding Columns and Rows\n• Saving a Workbook as a Template\n• Using a Template\n• Editing a Template\n• Inserting a New Worksheet\n• Hiding/Unhiding a Worksheet\n• Deleting a Template\n• Finding Online Templates \nCREATING CHARTS\n• Inserting a column chart\n• Inserting a line chart\n• Inserting a bar chart\n• Inserting a pie chart\n• Resizing a chart\n• Deleting a chart\n• Adding a Chart Title\n• Changing the Chart Background\n• Changing a column\, bar\, line\, or pie slice colours\n• Changing the chart type\n• Adding a Data Table\n• Changing the Chart Layout\n• Copying and moving charts\n• Creating a 3-D Chart\n• Adjusting 3-D View\n• Inserting Sparklines\n• Practice – Creating Charts \nREVISING CHARTING FEATURES\n• Formatting an Axis\n• Changing the Axis Scaling\n• Formatting the Data Series\n• Adding Data from Different Worksheets\n• Using a Secondary Axis\n• Changing Data Series Chart Types\n• Changing Source Data Range \nWORKING WITH ADVANCED FILTERS\n• Creating a Criteria Range\n• Using a Criteria Range\n• Showing All Records\n• Using an Advanced and Condition\n• Using an Advanced or Condition\n• Copying Filtered Records\n• Using Database Functions \nUSING CONDITIONAL AND CUSTOM FORMATS\n• Applying Conditional Formats\n• Changing a Conditional Format\n• Adding a Conditional Format\n• Creating a Custom Conditional Format\n• Using Data Bars\n• Deleting a Conditional Format\n• Creating a Custom Number Format\nUSING WORKSHEET PROTECTION\n• Unlocking Cells in a Worksheet\n• Protecting a Worksheet\n• Unprotecting a Worksheet\n• Creating Allow-Editing Ranges\n• Deleting Allow-Editing Ranges\n• Protecting Workbook Windows\n• Unprotecting Workbook Windows\n• Assigning a Password\n• Opening a Password-protected File\n• Removing a Password \nUSING AUDITING TOOLS AND RANGE NAMES\n• Jumping to a Named Range\n• Assigning Names\n• Using Range Names in Formulas\n• Creating Range Names from Headings\n• Applying Range Names\n• Deleting Range Names\n• Using Range Names in 3-D Formulas\n• Displaying/Removing Dependent Arrows\n• Displaying/Removing Precedent Arrows\n• Showing Formulas \nEXPORTING AND IMPORTING DATA\n• Importing Data from Text Files\n• Changing External Data Range Properties\n• Removing the Query Definition\n• Creating a Hyperlink\n• Editing a Hyperlink \nUSING ADVANCED FUNCTIONS\n• Using the VLOOKUP Function\n• Using the HLOOKUP Function\n• Using the IF Function\n• Using Nested IF Functions\n• Using the ISERROR Function\n• Using an AND Condition with IF\n• Using an OR Condition with IF\n• Using the ROUND Function\n• Using COUNTIF Function\n• Using RANK Function\n• Using Financial Functions\n• Using Text Functions \nCREATING/REVISING PIVOT TABLES\n• Creating a PivotTable Report\n• Adding PivotTable Report Fields\n• Selecting a Page Field Item\n• Refreshing a PivotTable Report\n• Changing the Summary Function\n• Adding New Fields to a PivotTable Report\n• Moving PivotTable Report Fields\n• Hiding/Unhiding PivotTable Report Items\n• Deleting PivotTable Report Fields\n• Creating a Page Field Report\n• Formatting a PivotTable Report\n• Creating a PivotChart Report\n• Grouping Data Manually \nUSING SCENARIOS\n• Creating a Scenario\n• Displaying a Scenario\n• Editing a Scenario\n• Creating a Scenario Summary Report\n• Working with Data Tables\n• Placing Formulas in Data Tables\n• Creating a One-Variable Table\n• Creating a Two-Variable Table \nTRACKING AND MERGING WORKBOOKS\n• Saving a Shared Workbook\n• Viewing Users Sharing a Workbook\n• Viewing Shared Workbook Changes\n• Changing the Update Frequency\n• Highlighting Changes\n• Managing Conflicting Changes\n• Resolving Conflicting Changes\n• Setting Change History Options\n• Adding a History Worksheet\n• Reviewing Tracked Changes\n• Merging Shared Workbook Files \nRECORDING MACROS\n• Recording a Macro\n• Saving a Macro-Enabled Workbook\n• Running a Macro\n• Assigning a Shortcut Key\n• Using a Shortcut Key\n• Deleting a Macro\n• Adding a Macro to Quick Access Toolbar\n• Deleting a Macro Button from QAT \n  \nFor more information about our Microsoft Excel Training\, 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/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/07/HRDCorpClaimableCourse-Microsoft-Excel-Intermediate-Advanced-Level-AUG.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230822T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230823T170000
DTSTAMP:20260621T025327
CREATED:20230728T074610Z
LAST-MODIFIED:20230728T074610Z
UID:9256-1692691200-1692810000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Data Analytics & Visualization In Excel
DESCRIPTION:Transform Your Data into Insights with Excel\nUnlock the full potential of your data with our comprehensive Data Analytics and Visualization in Excel course. Whether you’re a beginner or an experienced user\, this course will teach you the skills you need to turn raw data into actionable insights. \nWith step-by-step instructions and hands-on exercises\, you’ll learn how to import\, clean\, and analyze data in Excel. You’ll also learn how to create interactive dashboards\, powerful visualizations\, and custom functions that can help you make informed decisions. \n  \nWho Should Join This Data Analytics and Visualization in Excel?\nA Data Analytics and Visualization in Excel course can benefit you in many ways. It can boost your career\, improve your problem-solving and decision-making skills\, make you more efficient in using Excel\, increase your data literacy\, and give you hands-on experience with real-world scenarios. This course is suitable for anyone looking to advance their career\, start a new one\, or learn a new skill. \n  \nHRD Corp Claimable Course\nThis course is not just eligible for HRD Corp claims\, it’s a must-have opportunity for those looking to invest in their personal and professional growth. By taking advantage of the organization’s human resource development program and getting reimbursed for the cost of the course\, you’ll not only be boosting your skillset and increasing your knowledge\, but you’ll also be maximizing the benefits offered by your employer. Don’t miss out on this incredible opportunity to enhance your career and secure your future success. Make the investment in yourself today and claim your spot in this valuable course. \n  \nCourse Outline\nGETTING DATA INTO MICROSOFT EXCEL\n– Import data from various platforms into Microsoft Excel for further analysis \nDATA CLEANING AND MANIPULATION\n– Use functions for combining and splitting text\n– Clean data\, change case\, and remove unwanted characters\n– Understand the importance of well-organized data for analysis \nWORKING WITH NUMBERS AND DATES\n– Convert data types from text to numbers\, dates to text\, and both numbers and text to dates\n– Utilize functions for generating dates\, calculating days between two dates\, and more \nDEFINED NAMES FOR BETTER DATA MANAGEMENT\n– Referencing and naming cells\, creating named ranges\, and automating processes.\n– Improve efficiency and accuracy by using defined names in calculations \nAUTOMATING DATA MANIPULATION WITH TABLES\n– Use SMART TABLES to create\, format\, and manage tables\n– Format\, select\, sort\, and filter data\n– Improve the organization and analysis of data with structured referencing \nLOGICAL AND LOOKUP FUNCTIONS\n– Evaluate data using nested IF functions\n– Perform logical operations with IF\n– Categorize data with VLOOKUP and XLOOKUP\n– Match data with advanced functions such as INDEX and MATCH \nDATA TRANSFORMATION WITH POWER QUERY\n– Use the Query Editor Engine to extract\, transform\, and load data\n– Combine multiple datasets for more comprehensive analysis. \nDATA VISUALIZATION\n– Visualize data with conditional formatting\, sparklines\, number formats\, and more\n– Utilize standard charts such as line charts\, pie charts\, and scatter charts\, as well as specialized charts such as hierarchy\, waterfall\, funnel\, geospatial\, and gauge charts \nCREATING INTERACTIVE DASHBOARDS\n– Summarize data with Pivot Tables\n– Customize\, group\, sort\, and filter pivot data\n– Create interactive dashboards with pivot charts\, slicers\, and timelines \nDATA VISUALIZATION WITH POWER BI\n– Quickly visualize data with the help of Power BI. \n  \nFor more information about our Data Analytics and Visualization In Excel\, 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-data-analytics-visualization-in-excel/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Data Analytics & Visualization In Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/07/HRDCorpClaimableCourse-Data-Analytics-Visualization-In-Excel-Physical-AUG.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230822T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230823T170000
DTSTAMP:20260621T025327
CREATED:20230728T075704Z
LAST-MODIFIED:20230728T075704Z
UID:9259-1692691200-1692810000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Graphic Design
DESCRIPTION:The graphic design course will first start with the Adobe Photoshop aspect. In this session\, you will learn the basic uses of the software and will slowly introduce the more advanced features that the software has After this session\, you will be able to enhance the images of your posters\, flyers\, online banners and others. In other words\, you will be able to leave and edit your own images to your own liking. \nMoving on\, our training will commence with Adobe Illustrator aspect. Our Illustrator training will introduce the powerful pen tool\, which is able to transform existing shapes\, add colour to existing drawn objects\, apply layer effects to artwork\, and many more. This training will benefit where your will be able to design your own logo and create templates for social media posters/ flyers and others. In short\, the set of tools provided by illustrator will provide everything you need to produce extraordinary graphics for print\, the web and others. \n  \nHRD Corp Claimable Course\nThis course is not just eligible for HRD Corp claims\, it’s a must-have opportunity for those looking to invest in their personal and professional growth. By taking advantage of the organization’s human resource development program and getting reimbursed for the cost of the course\, you’ll not only be boosting your skillset and increasing your knowledge\, but you’ll also be maximizing the benefits offered by your employer. Don’t miss out on this incredible opportunity to enhance your career and secure your future success. Make the investment in yourself today and claim your spot in this valuable course. \n  \nCourse Outline\nADOBE PHOTOSHOP\n• Graphic Design Principles\n• Introduction to Adobe Photoshop\n• Layer styles and how to combine image\n• Object selection and masking\n• Image composition\n• Transform and distort\n• Colour correction (Camera Raw Filter)\n• Typography\n• Blend Modes and Adjustment\n• Shapes and gradient\n• Blur and Filter\n• Prepare a poster for social media \nADOBE ILLUSTRATOR\n• Introduction to Adobe Illustrator\n• Drawing with shape using the Shape Builder Tool\n• Tracing with Pen Tool and Curvature Tool\n• Layer Effects\n• Create colour palette using the Blend Tool\n• Apply gradients\, warp effects\, blends\, and other styles to shapes in Illustrator\n• Typography techniques\n• Convert raster images to vector\n• Prepare Illustrator files for handover\n• Creating Logos \n  \nFor more information about our Data Analytics and Visualization In Excel\, 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-graphic-design/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Multimedia
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/07/HRDCorpClaimableCourse-Graphic-Design-Intermediate-Level-AUG.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230822T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230823T170000
DTSTAMP:20260621T025327
CREATED:20230728T081635Z
LAST-MODIFIED:20230728T081635Z
UID:9262-1692691200-1692810000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Digital Marketing Masterclass
DESCRIPTION:Digital Marketing Masterclass training allows the participants to learn and master effective online marketing strategies\, ranging from learning to plan\, set up\, monitor and optimize a marketing campaign that leads to achieving the marketing goals. In this Digital Marketing Masterclass\, the participants will also get a chance to learn the proven framework and formula for managing their social media and Google ads campaigns. These modules are custom designed\, to help participants to equip the skill and ability to see improvement in their marketing campaign. This Digital Marketing Masterclass training is more than a theory\, the trainer will cover case studies\, best practices\, and the do’s and don’ts to make it practical\, easy to understand\, and easy to apply. \n  \nWhat will you learn in this Digital Marketing Masterclass Training?\n\nUnderstand the principles of digital marketing and the tools. Leverage them to grow your presence\, positioning and revenue online.\nUtilize the latest Facebook Ads campaign strategies to improve your marketing results and performance.\nLearn how to run Google Ads\, using other Google online tools to create an effective campaign for both B2C and B2B industries.\nLearn how to create engaging copies\, images or videos for social media and Search Engine campaigns.\nHow to build authority\, brand\, and positioning as the go-to expert on social media with content marketing.\n\n  \nCourse Outline\nPRINCIPLES OF DIGITAL MARKETING\n• Overview of an effective digital marketing strategy\n• Understand the pillars of digital marketing\n• Identifying customer online behavioral journey\n• Online competitor research and analysis\n• Concept and important terms for digital marketing\n• Malaysian behavioral trend online \nFACEBOOK & INSTAGRAM MARKETING\n• Social Media Ads campaign structure Overview\n• Meta Ads Account Manager & Business Manager Overview\n• Facebook & Instagram Campaign setup best practices\n• Custom audience and Lookalike audience overview and strategy\n• Copywriting for Ads\n• Campaign monitoring and optimization\n• Facebook / Instagram ads policy and guidelines overview\n• Ads analysis and measuring your campaign\n• Facebook pixel and event measurement overview \nWEBSITE AND LANDING PAGE OPTIMIZATION\n• How to build a beginner-friendly site easily\n• Differences between a website and a landing page\n• Website ideas and structure setup\n• Website optimization best practices\n• Tools and tips for building a modern website without experience\n• Website pro tips and strategies that will help you save costs and\ngenerate leads\n• Lead generation forms integration and setup for maximum conversion \nCONTENT MARKETING\n• Introduction to content marketing and its application.\n• Learn different types of content to build brand\, positioning and authority.\n• Content research\, ideation\, and planning strategy\n• Set up and manage your content calendar effectively.\n• How TO measure your content marketing goals\n• Short video – Reels video creation tutorial \nGOOGLE ADS MARKETING\n• Understand Google Ads campaign structure.\n• Learn different types of Google Ads objectives for your campaign goals.\n• Keyword research analysis and preparation.\n• Google ads campaign setup walkthrough and best practices.\n• Monitor and optimizing your Google Ads campaign.\n• How to measure your Google ads campaign. \nSEARCH ENGINE OPTIMIZATION\n• How to optimize your website for better ranking on Google.\n• Understanding technical SEO.\n• Keyword research and optimization for better ranking.\n• Off-page SEO methods and strategies.\n• Auditing your website before implementing SEO.\n• Understand how Search Engine works in most cases.\n• Getting in touch with Google’s latest update on the algorithm.\n• Recommended tools to help measure your site performance and\nprogress.\n• Measuring your SEO effort with Google Analytics and Google Analytics \nAI FOR MARKETING PERFORMANCE\, PRODUCTIVITY & CREATIVITY\n• Learn different AI tools for marketing tasks & activities\n• Understand the limit and boundaries of AI tools\n• Using AI for Social Media & Search Engine\n• AI prompt for digital marketing \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-digital-marketing-masterclass/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Digital Marketing
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/07/HRDCorpClaimableCourse-Digital-Marketing-Masterclass-AUG.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230907T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230907T170000
DTSTAMP:20260621T025327
CREATED:20230830T031759Z
LAST-MODIFIED:20230830T034349Z
UID:9532-1694077200-1694106000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Basic Level
DESCRIPTION:The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she will understand and be able to accomplish basic operations associated with developing\, formatting\, and using a spreadsheet. \n  \nWhat will you learn in this  Microsoft Excel Basic Level Training?\n• The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer.\n• He or she will understand and be able to accomplish basic operations associated with developing\, formatting\, and using a spreadsheet.\n• Additionally\, trainees will be able to accomplish standard mathematical operations using basic formulas and functions.\n• The trainee will be able to demonstrate competence in using some of the features of Excel such as filtering\, managing data and creating charts. \n  \nCourse Outline\nOFFICE WORKSPACE BASICS \n• Basic Window Elements\n• Exploring Office Backstage\n• Working with the Ribbon\n• Customizing the Quick Access Toolbar\n• Working with Key Tips\n• Using the Status Bar \nINTRODUCTION TO EXCEL \n• What is Excel?\n• Getting to Know the Excel Window\n• Moving the Cell Selector\n• Opening a Workbook\n• Navigating a Workbook\n• Selecting Cells\n• Creating Workbooks\n• Saving a Workbook\n• Closing a Workbook \nENTERING AND EDITING DATA \n• Entering Text\, Numbers\, and Dates\n• Editing Data\n• Using AutoComplete and AutoFill\n• Copying Data\n• Moving and Clearing Data\n• Using Undo and Redo\n• Finding and Replacing Data \n  \nFORMATTING DATA \n• Introduction to Formatting\n• Applying Number Formats\n• Applying Font Formats\n• Changing Cell Alignment\n• Applying Cell Styles\n• Copying Formats\n• Clearing Formats\n• Finding and Replacing Formats \nFORMATTING WORKSHEETS \n• Inserting and Deleting Rows and Columns\n• Inserting and Deleting Cells\n• Adjusting Column and Row Sizes\n• Hiding Worksheet Components\n• Inserting and Deleting Worksheets\n• Copying and Moving Worksheets\n• Customizing Sheet Tabs\n• Adding a Worksheet Background \nKICK START WITH BASIC FORMULAS AND FUNCTIONS \n• What are Formulas and Functions?\n• Entering Formulas\n• Entering Functions\n• Using the Insert Function Tools\n• Using AutoSum\n• Copying and Moving Formulas \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-basic-level/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/08/Individual-Course-Posting.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230913T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230914T170000
DTSTAMP:20260621T025327
CREATED:20230830T034241Z
LAST-MODIFIED:20230830T034501Z
UID:9536-1694595600-1694710800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Intermediate & Advanced Level
DESCRIPTION:In this course\, the participants will be introduced to the more intermediate features of Microsoft Excel. The participant will learn how to generate reports from Excel data. The course also shows the participant how to highlight important data using conditional formats\, prevent date entry errors using Data Validation. At the end of the course\, the participant will be able to demonstrate the ability to manage data efficiently with Microsoft Excel. Moving on\, the participants will be introduced to the more advanced features of Microsoft Excel. This course provides the participant to use the spreadsheet application to produce what are deemed to be advanced spreadsheet outputs. The participant shall be able to operate effectively at more than intermediate level of competence and be able to sort\, query and link data. The participant shall be able to use functions such as those associated with logical\, statistical\, or mathematical operations. Furthermore\, the participant will be able to use available analysis and audit tools and to run and record simple macros. \n  \nWhat will you learn in this  Microsoft Excel Intermediate & Advanced Level Training?\n• Apply proper formula and function\n• Troubleshooting errors\n• Link and Embed Data from other sources\n• Applying Conditional Formatting and Validation Rules\n• Build upon the essential Microsoft Office Excel knowledge and skills\n• Learn to create advanced workbooks and worksheets\, including\nadvanced formulas\, tables\, and data analyzing tools \n  \nCourse Outline\nDATA MANAGEMENT\n• Sorting\n• Sorting Multiple Columns\n• Finding Data\n• Replacing Data\n• Finding and Replacing Cell Format\n• Practice – Data Management \nWORKING WITH DATABASES \n• Creating Subtotals in a List\n• Removing Subtotals from a List\n• Sorting Data by Multiple Levels\n• Using Custom Sort\n• Using Data Validation\n• Validating Data using a List\n• Creating a Custom Error Message\n• Removing Data Validation \nUSING TEMPLATES\n• Copying Worksheets\n• Hiding Columns and Rows\n• Unhiding Columns and Rows\n• Saving a Workbook as a Template\n• Using a Template\n• Editing a Template\n• Inserting a New Worksheet\n• Hiding/Unhiding a Worksheet\n• Deleting a Template\n• Finding Online Templates \nCREATING CHARTS\n• Inserting a column chart\n• Inserting a line chart\n• Inserting a bar chart\n• Inserting a pie chart\n• Resizing a chart\n• Deleting a chart\n• Adding a Chart Title\n• Changing the Chart Background\n• Changing a column\, bar\, line\, or pie slice colours\n• Changing the chart type\n• Adding a Data Table\n• Changing the Chart Layout\n• Copying and moving charts\n• Creating a 3-D Chart\n• Adjusting 3-D View\n• Inserting Sparklines\n• Practice – Creating Charts \nREVISING CHARTING FEATURES \n• Formatting an Axis\n• Changing the Axis Scaling\n• Formatting the Data Series\n• Adding Data from Different Worksheets\n• Using a Secondary Axis\n• Changing Data Series Chart Types\n• Changing Source Data Range \nWORKING WITH ADVANCED FILTERS \n• Creating a Criteria Range\n• Using a Criteria Range\n• Showing All Records\n• Using an Advanced and Condition\n• Using an Advanced or Condition\n• Copying Filtered Records\n• Using Database Functions \nUSING CONDITIONAL AND CUSTOM FORMATS \n• Applying Conditional Formats\n• Changing a Conditional Format\n• Adding a Conditional Format\n• Creating a Custom Conditional Format\n• Using Data Bars\n• Deleting a Conditional Format\n• Creating a Custom Number Format \nUSING WORKSHEET PROTECTION \n• Unlocking Cells in a Worksheet\n• Protecting a Worksheet\n• Unprotecting a Worksheet\n• Creating Allow-Editing Ranges\n• Deleting Allow-Editing Ranges\n• Protecting Workbook Windows\n• Unprotecting Workbook Windows\n• Assigning a Password\n• Opening a Password-protected File\n• Removing a Password \nUSING AUDITING TOOLS AND RANGE NAMES \n• Jumping to a Named Range\n• Assigning Names\n• Using Range Names in Formulas\n• Creating Range Names from Headings\n• Applying Range Names\n• Deleting Range Names\n• Using Range Names in 3-D Formulas\n• Displaying/Removing Dependent Arrows\n• Displaying/Removing Precedent Arrows\n• Showing Formulas \nEXPORTING AND IMPORTING DATA \n• Importing Data from Text Files\n• Changing External Data Range Properties\n• Removing the Query Definition\n• Creating a Hyperlink\n• Editing a Hyperlink \nUSING ADVANCED FUNCTIONS \n• Using the VLOOKUP Function\n• Using the HLOOKUP Function\n• Using the IF Function\n• Using Nested IF Functions\n• Using the ISERROR Function\n• Using an AND Condition with IF\n• Using an OR Condition with IF\n• Using the ROUND Function\n• Using COUNTIF Function\n• Using RANK Function\n• Using Financial Functions\n• Using Text Functions \nCREATING/REVISING PIVOT TABLES \n• Creating a PivotTable Report\n• Adding PivotTable Report Fields\n• Selecting a Page Field Item\n• Refreshing a PivotTable Report\n• Changing the Summary Function\n• Adding New Fields to a PivotTable Report\n• Moving PivotTable Report Fields\n• Hiding/Unhiding PivotTable Report Items\n• Deleting PivotTable Report Fields\n• Creating a Page Field Report\n• Formatting a PivotTable Report\n• Creating a PivotChart Report\n• Grouping Data Manually \nUSING SCENARIOS\n• Creating a Scenario\n• Displaying a Scenario\n• Editing a Scenario\n• Creating a Scenario Summary Report\n• Working with Data Tables\n• Placing Formulas in Data Tables\n• Creating a One-Variable Table\n• Creating a Two-Variable Table \nTRACKING AND MERGING WORKBOOKS \n• Saving a Shared Workbook\n• Viewing Users Sharing a Workbook\n• Viewing Shared Workbook Changes\n• Changing the Update Frequency\n• Highlighting Changes\n• Managing Conflicting Changes\n• Resolving Conflicting Changes\n• Setting Change History Options\n• Adding a History Worksheet\n• Reviewing Tracked Changes\n• Merging Shared Workbook Files \nRECORDING MACROS \n• Recording a Macro\n• Saving a Macro-Enabled Workbook\n• Running a Macro\n• Assigning a Shortcut Key\n• Using a Shortcut Key\n• Deleting a Macro\n• Adding a Macro to Quick Access Toolbar\n• Deleting a Macro Button from QAT
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-intermediate-advanced-level/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/08/Individual-Course-Posting-1.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230913T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230914T170000
DTSTAMP:20260621T025327
CREATED:20230830T063613Z
LAST-MODIFIED:20230830T063613Z
UID:9540-1694595600-1694710800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Mastering Interactive Dashboard Reporting with Power BI
DESCRIPTION:This two-day training provides participants with the knowledge and skills to analyze data with Power BI. The simplicity of the training methodology will enable you to use Power BI immediately. In this module\, participants will be introduced to the key concepts in business intelligence\, data analysis\, and data visualization. In addition\, they will learn the rationale for self-service BI\, considerations for using self-service BI\, and how Microsoft products can be used to implement a self-service BI solution \nWhat will you learn in this Mastering Interactive Dashboard Reporting with Power BI Training?\n• Describe key features of a self-service BI solution\n• Describe Power BI and its data sources model\, shape and combine data\n• Describe Power BI data visualizations \nCourse Outline\nINTRODUCTION TO SELF-SERVICE BI SOLUTIONS \n• Introduction to business intelligence\n• Introduction to data analysis\n• Introduction to data visualization\n• Microsoft tools for self-service BI \nINTRODUCING POWER BI\n• This module introduces Power BI.\n• Power BI\n• The Power BI service \nPOWER BI DATA\n• This module describes Power BI data sources.\n• Excel files\, CSV & Text files as a Power BI data source\n• Using databases as a Power BI data source \nSHAPING AND COMBINING DATA\n• This module describes how to shape and combine data.\n• Power BI desktop queries\n• Shaping data\n• Combining data \nMODELLING DATA\n• This module describes how to model data in Power BI.\n• Relationships\n• DAX queries\n• Calculations and measures \nINTERACTIVE DATA VISUALIZATIONS\n• This module describes Power BI visualizations.\n• Creating Power BI reports\n• Managing a Power BI solution
URL:https://www.excelacademy.my/event/hrd-corp-claimable-mastering-interactive-dashboard-reporting-with-power-bi-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Mastering Interactive Dashboard Reporting with Power BI
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/08/Individual-Course-Posting-2.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230919T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230920T170000
DTSTAMP:20260621T025327
CREATED:20230830T064843Z
LAST-MODIFIED:20230830T064843Z
UID:9545-1695114000-1695229200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Search Engine Optimization (SEO) and Search Engine Marketing (SEM)
DESCRIPTION:Learn how to rank faster and more effectively on Google. Get everything you need to know about search engine optimization\, master them and implement them on your website\, to start seeing consistent traffic coming to your site. Though SEO is not a rocket science\, most people find it difficult to implement because of various terminologies used\, updates and other misconceptions. This workshop serves as a purpose to help students who have no time to do their own research\, or a total beginner who’s not sure of where to start\, this course is for you. Students will be given case studies\, tools\, resources with several examples on how to implement effective SEO strategies with a clear step-by-step guide\, in the simplest and most effective manner. SEO is a must-know section for every business owner and marketer because it can help you drive consistent traffic 24/7\, generate qualified leads and save tons of your advertising cost. \n  \nWhat will you learn in this Search Engine Optimization (SEO) and Search Engine Marketing (SEM) Training?\n• How to optimize your website for better search ranking\n• Leveraging SEO and Google Paid Ads to enhance your site’s traffic and leads\n• Learn to build SEO strategies for your company\, using tools and setup best practices\n• How to generate traffic consistently with SEO best practices setup\n• Learn how to setup your first Google Ads campaign\n• Learn how to analyze and measure your ads performance\n• Understand different ways to optimize your ads campaign \nCourse Outline\nFUNDAMENTAL OF SEO\n• What is SEO and how does it work?\n• Organic search vs paid search\n• Relationship between SEO and website optimization\n• Debunking SEO myth\n• 3 Core pillars of SEO\n• Measuring your SEO performance \nKEYWORD RESEARCH\n• Understanding keywords for SEO\n• Types of keywords and how to use them for your advantage\n• Understanding long-tailed vs short-tailed keywords\n• How to conduct keyword research\n• How to use Google keyword planner to conduct keyword research\n• Other recommended tools for keyword research\n• How to identify and prioritize your keywords \nCONTENT STRATEGIES FOR SEO \n• Understanding On-page SEO\n• List of On-Page SEO setup.\n• Ways to optimize your meta title and meta description\n• Understand URL structure impact on SEO\n• Using headings (H1-H6) for SEO\n• Optimizing images with keywords\n• Internal and external linking\n• Content writes up for SEO \nOFF-PAGE SEO STRATEGIES \n• Off-page SEO explained\n• List of Off-page SEO checklist\n• Understand link-building\n• Building backlinks strategies\n• How to identify competitor’s backlink\n• Best practices when it comes to link building \nTECHNICAL SEO \n• Strategies to improve your website performance\n• List of technical SEO setup\n• Understand Google Search Console\n• Understand Google Analytics\n• Identify duplicate content and how to fix it\n• Optimizing Google business profile \nFUNDAMENTAL OF GOOGLE ADS \n• Why Google Ads and how does it work\n• Understand Google Ads campaign structure\n• Learn about different types of Google Ads objectives\n• Understand how your ads will be triggered\n• Understand keywords match type\n• Understand types of ads extension and the purpose \n  \nGOOGLE ADS OPTIMIZATION STRATEGIES\n• Conduct keywords research using free tools\n• Ad group and keywords setup\n• How to write powerful copy for your Google Ads\n• Bidding strategies\n• How to optimize your campaign with search term\n• How to optimize your campaign with negative search\n• Measure your Google Ads campaign performance
URL:https://www.excelacademy.my/event/hrd-corp-claimable-search-engine-optimization-seo-and-search-engine-marketing-sem/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Digital Marketing
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/08/Individual-Course-Posting-3.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230919T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230920T170000
DTSTAMP:20260621T025327
CREATED:20230901T011252Z
LAST-MODIFIED:20230901T011252Z
UID:9580-1695114000-1695229200@www.excelacademy.my
SUMMARY:HRD Corp Claimable – Video Editing
DESCRIPTION:Excel Academy’s video editing course will begin with the Adobe After Effects part. Our After Effects training course will provide you with the skills to create\, edit and compound digital video with desired effects\, for the purposes of post-production\, presentation\, instructional and visual messaging content. Examples of what you will learn are motion graphics\, text animation and others. In short\, our After Effects course will provide ways to enhance the features of video to make it more exciting and interesting. Next\, our video editing course will carry on with the Adobe Premiere Pro aspect. Our Premiere Pro course provides the essential editing skills to enhance the want of creative power as well as freedom. Examples of the lessons that you will learn are such as how to completely edit a video such as adjusting the volume of the video to the desired level\, video formatting\, dynamic trimming and many more. In a nutshell by attending our Premiere Pro session\, you will be able to graphic design and easily manage and edit videos. \nWhat will you learn in this Video Editing Training?\n• Develop display ad campaigns\n• Promote your company using FB pocket TVC\n• Create marketing video in various sizes and formats\n• Learn industry insider video production terms\n• Communicate better with ad agencies and design teams \nCourse Outline\nADOBE AFTER EFFECTS:\nIntroduction to FB Pocket TVC and After Effects \n• Overview of the FB Pocket TVC project and its requirements\n• Introduction to the After Effects interface and workspace \nWorking with Photoshop/Illustrator in After Effects \n• Importing and integrating Photoshop and Illustrator files into After\nEffects\n• Using Photoshop and Illustrator assets in After Effects compositions\nMotion Graphics Fundamentals \n• Understanding keyframe animation and motion paths\n• Exploring various animation techniques and easing options\n• Working with shape layers\, masks\, and effects to create dynamic motion graphics \nText Animation Techniques \n• Manipulating and animating text layers\n• Exploring text presets and animation presets\n• Creating custom text animations using keyframes and effects \nCreating A FB Pocket TVC From Scratch \n• Step-by-step process of creating a FB Pocket TVC project\n• Implementing motion graphics\, text animations\, and visual effects\n• Fine-tuning the timing and synchronization of the elements\n• Rendering the final video for distribution and sharing \nADOBE PREMIERE PRO: \nVideo Production Basics\n• Understanding the fundamentals of video production process\n• Pre-production planning\, shooting\, and post-production workflow \nCamera Work and Techniques \n• Exploring different camera techniques for capturing compelling\nfootage\n• Understanding framing\, composition\, and camera movement\nIntroduction to Adobe Premiere Pro \n• Familiarizing with the Premiere Pro interface and workspace\n• Importing and organizing media assets for video editing \nVideo Transition Effects \n• Adding and customizing various transition effects between video\nclips\n• Exploring different types of transitions and their creative applications\nVideo Cutting Techniques and Tips \n• Mastering the art of precise video cutting and trimming\n• Understanding the importance of pacing and rhythm in video editing \nTitles and Text Overlays\n• Creating and customizing text titles and lower thirds\n• Incorporating text overlays to enhance storytelling \nVideo Motion and Effects \n• Applying motion and animation to video clips\n• Utilizing visual effects and filters to enhance footage \nAudio Editing and Mixing\n• Understanding audio editing techniques and tools in Premiere Pro\n• Adjusting audio levels\, adding sound effects\, and working with music tracks \nVideo Formats and Exporting Options \n• Familiarizing with different video formats and their specific uses\n• Exporting video projects with appropriate settings for various platforms \nVideo Editing and Publishing Workflows \n• Streamlining the video editing process through efficient workflows\n• Optimizing settings for different platforms and sharing options
URL:https://www.excelacademy.my/event/hrd-corp-claimable-video-editing/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Video Editing
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/09/Individual-Course-Posting-10.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20230926T090000
DTEND;TZID=Asia/Kuala_Lumpur:20230927T170000
DTSTAMP:20260621T025327
CREATED:20230830T070223Z
LAST-MODIFIED:20230830T070223Z
UID:9548-1695718800-1695834000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Digital Marketing Masterclass
DESCRIPTION:The programme will allow participants to learn and master effective online marketing strategies from knowing how to plan\, set up\, monitor\, and optimize it\, to achieve their marketing goals effectively. Participants will learn how to use a proven framework and formula to manage their social media and Google ads campaign\, whether they’re in the B2C or B2B industry. These modules are custom designed\, to help participants to equip the skill and ability to see improvement in their marketing campaign. In this class\, we’ll not just talk about the concept\, but also cover the case studies\, best practices\, the dos\, and don’ts\, to make it practical\, easy to understand and easy to apply. \nWhat will you learn in this Digital Marketing Masterclass Training?\n• Understand the principles of digital marketing\, the tools\, and how you can leverage it to grow your presence\, positioning and revenue online.\n• Leveraging the latest Facebook Ads campaign strategies to improve your marketing results and performance.\n• Learning how to run Google Ads\, using other Google online tools to create an effective campaign for both B2C and B2B industry.\n• How to create engaging copies\, images\, or videos for both social media and Search Engine campaign.\n• How to build authority\, brand\, and positioning as the go-to-expert on social media with content marketing. \nCourse Outline\nPRINCIPLES OF DIGITAL MARKETING\n• Overview of an effective digital marketing strategy\n• Understand the pillars of digital marketing\n• Identifying customer online behavioral journey\n• Online competitor research and analysis\n• Concept and important terms for digital marketing\n• Malaysian behavioral trend online \nFACEBOOK & INSTAGRAM MARKETING\n• Social Media Ads campaign structure Overview\n• Meta Ads Account Manager & Business Manager Overview\n• Facebook & Instagram Campaign setup best practices\n• Custom audience and Lookalike audience overview and strategy\n• Copywriting for Ads\n• Campaign monitoring and optimization\n• Facebook / Instagram ads policy and guidelines overview\n• Ads analysis and measuring your campaign\n• Facebook pixel and event measurement overview \nWEBSITE AND LANDING PAGE OPTIMIZATION\n• How to build a beginner-friendly site easily\n• Differences between a website and a landing page\n• Website ideas and structure setup\n• Website optimization best practices\n• Tools and tips for building a modern website without experience\n• Website pro tips and strategies that will help you save costs and generate leads\n• Lead generation forms integration and setup for maximum\nconversion \nCONTENT MARKETING\n• Introduction to content marketing and its application.\n• Learn different types of content to build brand\, positioning and authority.\n• Content research\, ideation\, and planning strategy\n• Set up and manage your content calendar effectively.\n• How TO measure your content marketing goals\n• Short video – Reels video creation tutorial \nGOOGLE ADS MARKETING\n• Understand Google Ads campaign structure\n• Learn different types of Google Ads objectives for your campaign goals\n• Keyword research analysis and preparation\n• Google ads campaign set up walkthrough and best practices\n• Monitor and optimize your Google Ads campaign\n• How to measure your Google ads campaign \nEMAIL MARKETING\n• Email Marketing\n• Email Write Up Best Practices\n• Reduce Spam Filters\, Increase Delivery Rate & Open Rate\n• Email Marketing Automation \nAI FOR MARKETING PERFORMANCE\, PRODUCTIVITY & CREATIVITY\n• Learn different AI tools for marketing tasks & activities\n• Understand the limit and boundaries of AI tools\n• Using AI for Social Media & Search Engine\n• AI prompt for digital marketing
URL:https://www.excelacademy.my/event/hrd-corp-claimable-digital-marketing-masterclass-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Digital Marketing
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/08/Individual-Course-Posting-4.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231017T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231017T170000
DTSTAMP:20260621T025327
CREATED:20230830T071911Z
LAST-MODIFIED:20230927T061236Z
UID:9551-1697533200-1697562000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Chatgpt Mastery: Enhancing Marketing Communication & Productivity
DESCRIPTION:In today’s fast-paced and digitally driven world\, organizations are seeking innovative solutions to streamline workflows and enhance productivity. This comprehensive course introduces participants to ChatGPT\, a state-of-the-art language model developed by OpenAI\, and explores its effective utilization within organizational settings. Designed for professionals and teams across industries\, this course equips participants with the necessary knowledge and practical skills to leverage ChatGPT for a wide range of applications in their work environments. \nWhat will you learn in this Chatgpt Mastery: Enhancing Marketing Communication & Productivity Training?\n• Understand the fundamentals of ChatGPT and its capabilities\n• Learn how to use ChatGPT to enhance productivity and efficiency in daily tasks\n• Explore practical applications of ChatGPT in different organizational contexts\n• Develop strategies for effectively integrating ChatGPT into existing workflows\n• Gain insights on best practices\, potential challenges\, and ethical considerations when using ChatGPT \nCourse Outline\nINTRODUCTION TO CHAT GPT-3\n• Introduction to artificial intelligence and natural language processing\n• Overview of GPT-3 and its capabilities in text generation and human- computer\ninteractions\n• Exploring the benefits of using Chat GPT-3 in organizational contexts\n• How Chat GPT-3 learns and adapts to generate human-like responses\n• Key concepts and underlying technology behind Chat GPT-3\n• Limitations and ethical considerations of using Chat GPT-3 \nPROMPT ENGINEERING\n• Prompt Engineering: What & Why?\n• The Core Elements Of A Good Prompt\n• Zero-\, One- & Few-Shot Prompting\n• Providing Cues & Hints To ChatGPT\n• Separating Instructions From Content\n• Ask-Before-Answer Prompting\n• Contextual Prompting\n• Emotional Prompting\n• Laddering Prompting\n• Using ChatGPT For Prompting\n• Find Out Which Information Is Missing\n• Self-evaluative Prompting\n• ChatGPT-powered Problem Splitting\n• Reversing Roles\n• More Prompts & Finding Prompt Inspirations \nIMPLEMENTING CHAT GPT-3 IN ORGANIZATIONAL WORKFLOWS\n• Usage of ChatGPT in Marketing and Sales\n• Using ChatGPT to create a full marketing campaign\n• Creating a comprehensive content calendar for your marketing campaign using ChatGPT\n• Defining and optimizing your target audience and buyer persona\n• Utilizing ChatGPT for audience research and analysis\n• Developing optimized social media posts with ChatGPT\n• Writing an optimized blog post in seconds with ChatGPT\n• Creating an email sequence with ChatGPT\n• Crafting sales page copy with ChatGPT\n• Generating Facebook ads and Google ads with ChatGPT\n• Customer sentiment analysis for sales and marketing\n• Leveraging ChatGPT for tailored content\, seizing trending opportunities\, and crafting compelling advertisements\, newsletters\, and dynamic media campaigns in marketing\n• Optimizing AI-generated content\, captivating audiences\, and boosting brand impact through prompt engineering in ChatGPT marketing\n• Unleashing the power of ChatGPT from OpenAI for cutting-edge marketing strategies and impactful results \nUsage of ChatGPT in Human Resource\, Customer Service and Office Tasks\n• Analyzing reviews and optimizing products and services with ChatGPT\n• Utilizing ChatGPT for candidate screening and assessment in the hiring process\n• Implementing virtual HR assistants to answer employee queries and provide HR-related\ninformation\n• Using ChatGPT for employee onboarding and training support\n• Designing conversational interfaces for customer support using ChatGPT.\n• Creating automated chatbots for handling FAQs and basic customer\ninquiries.\n• Enhancing customer engagement and satisfaction through\npersonalized responses.\n• Implementing ChatGPT for scheduling meetings and managing\ncalendars.\n• Using ChatGPT to automate routine office tasks\, such as data entry\nand report generation.\n• Leveraging ChatGPT for organizing and prioritizing emails. \nMANAGING AND EVALUATING CHAT GPT-3\n• Guidelines for integrating Chat GPT-3 into existing systems and\nworkflows.\n• Best practices for data preparation and fine-tuning models for specific\norganizational needs\n• Addressing potential biases and ethical concerns in the use of Chat\nGPT-3\n• Strategies for continuous improvement and feedback loops to\nenhance Chat GPT-3’s performance\n• Practical Exercises and Case Studies\n• Hands-on activities to engage participants in using Chat GPT-3\n• Group discussions and knowledge sharing to exchange insights and\nlessons learne
URL:https://www.excelacademy.my/event/hrd-corp-claimable-chatgpt-mastery-enhancing-marketing-communication-productivity/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:ChatGPT
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/08/51.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231018T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231019T170000
DTSTAMP:20260621T025327
CREATED:20230830T073418Z
LAST-MODIFIED:20230927T061335Z
UID:9554-1697619600-1697734800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Social Media Marketing
DESCRIPTION:Digital marketing skills are critical not only for digital marketing professionals but for anyone working in a business that has an online presence. This includes entrepreneurs\, marketing managers\, marketing specialists\, and small business owners. This intensive 2-day Social Media Marketing and Branding workshop provides a realistic hands-on setting for beginners to embark on a Social Media Marketing and branding journey. Peppered with case studies and practical both local and international\, role-playing scenarios\, and hands-on activities\, participants will learn how to create\, grow\, and measure Social Media Marketing campaigns and manage their brand. Participants will also learn practical methods of how to harness the power of DM as the core driver of marketing strategy; how to apply successful marketing campaigns\, measure outcomes and plan a marketing strategy. \nWhat will you learn in this  Social Media Marketing Training?\n• Create and brand personal/organization presence in social media\,\n• Attract the right target audience and quality fans\n• Convert the traffics and fans to become leads/customer\n• Understand how latest social media marketing trends works\n• Create a social media marketing plan for your business\n• Deepen your knowledge of the evolving social media trends and brand developments\n• Expose to the best practices for branding and marketing\n• Increase your return on investment as part of marketing efforts\n• Optimize your existing social media marketing activities with the right tool \nCourse Outline\nUNDERSTANDING DIGITAL MEDIA MARKETING \n• Fundamentals of Digital Marketing\n• Components of Digital Marketing\n• Current trends and Opportunities in the field of Digital Marketing\n• The Social Media Audit\n• SOSTAC® Marketing and RACE® Model \nCONTENT MARKETING \n• Content Marketing Essentials\n• Copywriting Techniques\n• Generating content ideas\n• Types of content writing\n• Content Format and repurposing\n• Video Marketing\n• Tools and Techniques for content marketing\n• Strategy & the Social Journey\n• Vision & Goals Setting\n• Choosing your channels – Developing Buyer’s Journey and Customer\nPersona \nSOCIAL MEDIA MARKETING CONCEPTUALIZATION\n• How online media differs from other traditional media opportunities\n• Audience behaviour online: penetration rates\, trends\, challenges\n• Selecting the right channels\, formats\, and placements for your campaign\n• Key considerations to consider when briefing and developing ad\ncreative\n• How to overcome the key challenges of online advertising and\nmaximize ROAS \nFACEBOOK AND INSTAGRAM MARKETING \n• Facebook Content Marketing Best Practices\n• Setting a Facebook Content Strategy\n• Moderation and Reputation Management\n• Best Practices for using Facebook\n• Instagram and its role in your Marketing efforts\n• Instagram and how to make sure of it effective\n• Facebook & Instagram Advertising\n• Introduction to Meta Business Manager \nLINKEDIN AND TIK TOK MARKETING \n• Personal & Corporate LinkedIn Pages\n• Advertising On LinkedIn and ad formats\n• Tik Tok basics – setting up profile for business\n• How to increase engagement on Tik Tok\n• Trending Challenges and Music usage\n• Hashtag Marketing & Influencer marketing\n• Creating and editing Tik Tok Video\n• Tik Tok Ads Manager \nANALYTICS AND DATA INTERPRETATION\n• Facebook Insights\n• Return of Ads Spent (ROAS) Calculations\n• Competitor Analysis\n• Refining Social Media Strategies from Analytics \nLOYALTY MARKETING \n• What Is Loyalty Marketing?\n• Identifying your loyal customers\n• Benefits of Loyalty Marketing – a continuous effort\n• Develop and Implement Your Own Loyalty Strategy
URL:https://www.excelacademy.my/event/hrd-corp-claimable-social-media-marketing-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Social Media Marketing
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/08/52.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231018T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231019T170000
DTSTAMP:20260621T025327
CREATED:20230830T074501Z
LAST-MODIFIED:20230927T061525Z
UID:9557-1697619600-1697734800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Data\, Import\, Cleanse & Automation with Power Query
DESCRIPTION:Power Query can connect to a wide range of data sources. Databases such as SQL Server\, Oracle\, Text files\, Big data and Hardtop data sources\, online searches and Data feeds\, Cloud storage\, Facebook\, SharePoint and many other types of data storage. Power Query extracts the data from sources\, and does transformations such as splitting columns\, data conversions\, lookups\, merge\, append\, data cleansing and many other data transformations AUTOMATICALLY without the use of VBA. Power Query introduced a new expression language called “M” for data transformations. Power Query is simply the best transformation and data manipulation tool for Excel and easier to use\, understand and master than other tools. Upon successful completion of this course\, the delegate should be proficient with Power Query and have the necessary skills to implement and automate the process of pulling in data\, perform data transformation and data cleansing. \nWhat will you learn in this Data\, Import\, Cleanse & Automation with Power Query Training?\n• Import / connect to external data from multiple sources\n• Automate the data transformation & data cleansing processes\n• Combine data from multiple sources into a single source\n• Merging data without the need of formulas such as VLOOKUP\, INDEX & MATCH\n• Perform calculation to aggregate data \nCourse Outline\nINTRODUCTION TO POWER QUERY\nThis module explains what a power query is and how you can download and\ninstall the power query on your computer. Learn how data files are imported\n/ connected whether it’s a text files\, CSV file\, database\, or any other source. Once the connection\nis built\, refreshing the connection will automatically load the latest changes. \nAPPENDING DATA FROM MULTIPLE SOURCES / FORMATS\nIn this module\, you will append data together into one source from multiple file formats\, multiple\nsources and even an entire folder for the purpose of analysis. If the source is an Excel file\,\nlearn to pull data from multiple workbooks\, multiple sheets\, and multiple tables. \nMERGING TABLES\nThis module shows how easy to merge data without using formulas such as VLOOKUP\, INDEX & MATCH.\nPerform more advanced merges using Inner\, Outer\, Full\, and Anti Joins. Learn to automate\nreconciliations and throw out exceptional items. \nPOWER QUERY FORMULAS\nThis module shows how to perform calculations such as SUM\, AVERAGE & COUNT just like a pivot table.\nMore complicated data transformation can be done using “M” language for Power Query. \nTRANSFORMING DATA\nIn Power Query\, you will be able to transform selected columns into attribute value pairs where\ncolumns become rows for data analysis which is required for Pivot Tables. Data that is structured\nincorrectly can be transformed easily. \nCLEANING DIRTY DATA\nThe complete removal of dirty data from a source is virtually impossible. Power Query has some\ntools which can be used to clean some common\nproblems such as missing data\, data formatted incorrectly or date problems.
URL:https://www.excelacademy.my/event/hrd-corp-claimable-data-import-cleanse-automation-with-power-query-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Power Query
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/08/53.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231024T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231025T170000
DTSTAMP:20260621T025327
CREATED:20230830T084724Z
LAST-MODIFIED:20230927T061723Z
UID:9560-1698138000-1698253200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Data Analytics & Visualizations in Excel
DESCRIPTION:As data becomes the modern currency\, the ability to analyze data quickly and accurately has become of paramount importance. Therefore\, data analytics and visualization are two of the most sought-after skills for high paying jobs with strong future growth prospects. This course will help you develop your analytical and visualization skills so that you not only improve your current work performance but also expand your future job prospects. For those in business and data analysis who want to master advanced Excel and beginner Power BI\, that will add an asset to your employability portfolio. Upon completing this specialization\, you will be able to bring data to life using advanced Excel functions\, creative visualizations\, and powerful automation features. These courses will equip you with a comprehensive set of tools for transforming\, linking\, and analyzing data. You will master a broad range of charts and create stunning interactive dashboards. Finally\, you will explore a new dimension in Excel with PowerPivot\, Get and Transform\, and DAX. Harnessing the power of an underlying database engine\, we will remove the 1\,048\,576-row limitation\, completely automate data transformation\, create data models to effectively link data\, and open the gateway to Power Business Intelligence. \nWhat will you learn in this Data Analytics & Visualizations in Excel in Excel Training?\n• Understand the different types of data in Excel and use appropriate functions to work with them.\n• Use logical and lookup functions to transform\, link and categorize data.\n• Use Excel tools and functions to clean and prepare data for analysis.\n• Use Named Ranges and Tables to automate your analysis \nCourse Outline\nGETTING DATA INTO MICROSOFT EXCEL\n• Import data from various platforms into Microsoft Excel for further\nanalysis \nDATA CLEANING AND MANIPULATION\n• Use functions for combining and splitting text\n• Clean data\, change case\, and remove unwanted characters\n• Understand the importance of well-organized data for analysis \nWORKING WITH NUMBERS AND DATES\n• Convert data types from text to numbers\, dates to text\, and both numbers and text to\ndates\n• Utilize functions for generating dates\, calculating days between two dates\, and more \nDEFINED NAMES FOR BETTER DATA MANAGEMENT\n• Referencing and naming cells\, creating named ranges\, and automating processes\n• Improve efficiency and accuracy by using defined names in\ncalculations \nAUTOMATING DATA MANIPULATION WITH TABLES\n• Use SMART TABLES to create\, format\, and manage tables\n• Format\, select\, sort\, and filter data\n• Improve the organization and analysis of data with structured\nreferencing \nLOGICAL AND LOOKUP FUNCTIONS\n• Evaluate data using nested IF functions\n• Perform logical operations with IF\n• Categorize data with VLOOKUP and XLOOKUP\n• Match data with advanced functions such as INDEX and MATCH \nDATA TRANSFORMATION WITH POWER QUERY\n• Use the Query Editor Engine to extract\, transform\, and load data\n• Combine multiple datasets for more comprehensive analysis. \nDATA VISUALIZATION\n• Visualize data with conditional formatting\, sparklines\, number formats\,\nand more\n• Utilize standard charts such as line charts\, pie charts\, and scatter\ncharts\, as well as specialized charts such as hierarchy\, waterfall\, funnel\, geospatial\, and gauge\ncharts \nCREATING INTERACTIVE DASHBOARDS\n• Summarize data with Pivot Tables\n• Customize\, group\, sort\, and filter pivot data\n• Create interactive dashboards with pivot charts\, slicers\, and timelines \nDATA VISUALIZATION WITH POWER BI\n• Quickly visualize data with the help of Power
URL:https://www.excelacademy.my/event/hrd-corp-claimable-data-analytics-visualizations-in-excel/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Data Analytics & Visualization In Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/08/55.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231025T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231026T170000
DTSTAMP:20260621T025327
CREATED:20230901T012123Z
LAST-MODIFIED:20230927T061930Z
UID:9583-1698224400-1698339600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Digital Marketing Masterclass
DESCRIPTION:The programme will allow participants to learn and master effective online marketing strategies from knowing how to plan\, set up\, monitor\, and optimize it\, to achieve their marketing goals effectively. Participants will learn how to use a proven framework and formula to manage their social media and Google ads campaign\, whether they’re in the B2C or B2B industry. These modules are custom designed\, to help participants to equip the skill and ability to see improvement in their marketing campaign. In this class\, we’ll not just talk about the concept\, but also cover the case studies\, best practices\, the dos\, and don’ts\, to make it practical\, easy to understand and easy to apply. \nWhat will you learn in this Digital Marketing Masterclass Training?\n• Understand the principles of digital marketing\, the tools\, and how you can leverage it to grow your presence\, positioning and revenue online.\n• Leveraging the latest Facebook Ads campaign strategies to improve your marketing results and performance.\n• Learning how to run Google Ads\, using other Google online tools to create an effective campaign for both B2C and B2B industry.\n• How to create engaging copies\, images\, or videos for both social media and Search Engine campaign.\n• How to build authority\, brand\, and positioning as the go-to-expert on social media with content marketing. \nCourse Outline\nPRINCIPLES OF DIGITAL MARKETING\n• Overview of an effective digital marketing strategy\n• Understand the pillars of digital marketing\n• Identifying customer online behavioral journey\n• Online competitor research and analysis\n• Concept and important terms for digital marketing\n• Malaysian behavioral trend online \nFACEBOOK & INSTAGRAM MARKETING\n• Social Media Ads campaign structure Overview\n• Meta Ads Account Manager & Business Manager Overview\n• Facebook & Instagram Campaign setup best practices\n• Custom audience and Lookalike audience overview and strategy\n• Copywriting for Ads\n• Campaign monitoring and optimization\n• Facebook / Instagram ads policy and guidelines overview\n• Ads analysis and measuring your campaign\n• Facebook pixel and event measurement overview \nWEBSITE AND LANDING PAGE OPTIMIZATION\n• How to build a beginner-friendly site easily\n• Differences between a website and a landing page\n• Website ideas and structure setup\n• Website optimization best practices\n• Tools and tips for building a modern website without experience\n• Website pro tips and strategies that will help you save costs and generate leads\n• Lead generation forms integration and setup for maximum\nconversion \nCONTENT MARKETING\n• Introduction to content marketing and its application.\n• Learn different types of content to build brand\, positioning and authority.\n• Content research\, ideation\, and planning strategy\n• Set up and manage your content calendar effectively.\n• How TO measure your content marketing goals\n• Short video – Reels video creation tutorial \nGOOGLE ADS MARKETING\n• Understand Google Ads campaign structure\n• Learn different types of Google Ads objectives for your campaign goals\n• Keyword research analysis and preparation\n• Google ads campaign set up walkthrough and best practices\n• Monitor and optimize your Google Ads campaign\n• How to measure your Google ads campaign \nEMAIL MARKETING\n• Email Marketing\n• Email Write Up Best Practices\n• Reduce Spam Filters\, Increase Delivery Rate & Open Rate Email Marketing Automation \nAI FOR MARKETING PERFORMANCE\, PRODUCTIVITY & CREATIVITY\n• Learn different AI tools for marketing tasks & activities\n• Understand the limit and boundaries of AI tools\n• Using AI for Social Media & Search Engine\n•
URL:https://www.excelacademy.my/event/hrd-corp-claimable-digital-marketing-masterclass-3/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Digital Marketing
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/09/56.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231025T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231026T170000
DTSTAMP:20260621T025327
CREATED:20230901T012848Z
LAST-MODIFIED:20230927T062128Z
UID:9586-1698224400-1698339600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Intermediated and Advanced Level
DESCRIPTION:In this course\, the participants will be introduced to the more intermediate features of Microsoft Excel. The participant will learn how to generate reports from Excel data. The course also shows the participant how to highlight important data using conditional formats\, prevent date entry errors using Data Validation. At the end of the course\, the participant will be able to demonstrate the ability to manage data efficiently with Microsoft Excel. Moving on\, the participants will be introduced to the more advanced features of Microsoft Excel. This course provides the participant to use the spreadsheet application to produce what are deemed to be advanced spreadsheet outputs. The participant shall be able to operate effectively at more than intermediate level of competence and be able to sort\, query and link data. The participant shall be able to use functions such as those associated with logical\, statistical\, or mathematical operations. Furthermore\, the participant will be able to use available analysis and audit tools and to run and record simple macros. \nWhat will you learn in this Microsoft Excel Intermediated and Advanced Level Training?\n• Apply proper formula and function\n• Troubleshooting errors\n• Link and Embed Data from other sources\n• Applying Conditional Formatting and Validation Rules\n• Build upon the essential Microsoft Office Excel knowledge and skills\n• Learn to create advanced workbooks and worksheets\, including advanced formulas\, tables\, and data analyzing tools \nCourse Outline\nDATA MANAGEMENT\n• Sorting\n• Sorting Multiple Columns\n• Finding Data\n• Replacing Data\n• Finding and Replacing Cell Format\n• Practice – Data Management \nWORKING WITH DATABASES \n• Creating Subtotals in a List\n• Removing Subtotals from a List\n• Sorting Data by Multiple Levels\n• Using Custom Sort\n• Using Data Validation\n• Validating Data using a List\n• Creating a Custom Error Message\n• Removing Data Validation \nUSING TEMPLATES\n• Copying Worksheets\n• Hiding Columns and Rows\n• Unhiding Columns and Rows\n• Saving a Workbook as a Template\n• Using a Template\n• Editing a Template\n• Inserting a New Worksheet\n• Hiding/Unhiding a Worksheet\n• Deleting a Template\n• Finding Online Templates \nCREATING CHARTS\n• Inserting a column chart\n• Inserting a line chart\n• Inserting a bar chart\n• Inserting a pie chart\n• Resizing a chart\n• Deleting a chart\n• Adding a Chart Title\n• Changing the Chart Background\n• Changing a column\, bar\, line\, or pie slice colours\n• Changing the chart type\n• Adding a Data Table\n• Changing the Chart Layout\n• Copying and moving charts\n• Creating a 3-D Chart\n• Adjusting 3-D View\n• Inserting Sparklines\n• Practice – Creating Charts \nREVISING CHARTING FEATURES\n• Formatting an Axis\n• Changing the Axis Scaling\n• Formatting the Data Series\n• Adding Data from Different Worksheets\n• Using a Secondary Axis\n• Changing Data Series Chart Types\n• Changing Source Data Range \nWORKING WITH ADVANCED FILTERS \n• Creating a Criteria Range\n• Using a Criteria Range\n• Showing All Records\n• Using an Advanced and Condition\n• Using an Advanced or Condition\n• Copying Filtered Records\n• Using Database Functions \nUSING CONDITIONAL AND CUSTOM FORMATS \n• Applying Conditional Formats\n• Changing a Conditional Format\n• Adding a Conditional Format\n• Creating a Custom Conditional Format\n• Using Data Bars\n• Deleting a Conditional Format\n• Creating a Custom Number Format \nUSING WORKSHEET PROTECTION \n• Unlocking Cells in a Worksheet\n• Protecting a Worksheet\n• Unprotecting a Worksheet\n• Creating Allow-Editing Ranges\n• Deleting Allow-Editing Ranges\n• Protecting Workbook Windows\n• Unprotecting Workbook Windows\n• Assigning a Password\n• Opening a Password-protected File\n• Removing a Password \nUSING AUDITING TOOLS AND RANGE NAMES \n• Jumping to a Named Range\n• Assigning Names\n• Using Range Names in Formulas\n• Creating Range Names from Headings\n• Applying Range Names\n• Deleting Range Names\n• Using Range Names in 3-D Formulas\n• Displaying/Removing Dependent Arrows\n• Displaying/Removing Precedent Arrows\n• Showing Formulas\nEXPORTING AND IMPORTING DATA \n• Importing Data from Text Files\n• Changing External Data Range Properties\n• Removing the Query Definition\n• Creating a Hyperlink\n• Editing a Hyperlink \nUSING ADVANCED FUNCTIONS \n• Using the VLOOKUP Function\n• Using the HLOOKUP Function\n• Using the IF Function\n• Using Nested IF Functions\n• Using the ISERROR Function\n• Using an AND Condition with IF\n• Using an OR Condition with IF\n• Using the ROUND Function\n• Using COUNTIF Function\n• Using RANK Function\n• Using Financial Functions\n• Using Text Functions \nCREATING/REVISING PIVOT TABLES \n• Creating a PivotTable Report\n• Adding PivotTable Report Fields\n• Selecting a Page Field Item\n• Refreshing a PivotTable Report\n• Changing the Summary Function\n• Adding New Fields to a PivotTable Report\n• Moving PivotTable Report Fields\n• Hiding/Unhiding PivotTable Report Items\n• Deleting PivotTable Report Fields\n• Creating a Page Field Report\n• Formatting a PivotTable Report\n• Creating a PivotChart Report\n• Grouping Data Manually \nUSING SCENARIOS\n• Creating a Scenario\n• Displaying a Scenario\n• Editing a Scenario\n• Creating a Scenario Summary Report\n• Working with Data Tables\n• Placing Formulas in Data Tables\n• Creating a One-Variable Table\n• Creating a Two-Variable Table \nTRACKING AND MERGING WORKBOOKS \n• Saving a Shared Workbook\n• Viewing Users Sharing a Workbook\n• Viewing Shared Workbook Changes\n• Changing the Update Frequency\n• Highlighting Changes\n• Managing Conflicting Changes\n• Resolving Conflicting Changes\n• Setting Change History Options\n• Adding a History Worksheet\n• Reviewing Tracked Changes\n• Merging Shared Workbook Files \nRECORDING MACROS \n• Recording a Macro\n• Saving a Macro-Enabled Workbook\n• Running a Macro\n• Assigning a Shortcut Key\n• Using a Shortcut Key\n• Deleting a Macro\n• Adding a Macro to Quick Access Toolbar\n• Deleting a Macro Button from QAT
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-intermediated-and-advanced-level/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/09/54.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231107T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231107T170000
DTSTAMP:20260621T025327
CREATED:20230927T064510Z
LAST-MODIFIED:20230927T064510Z
UID:9879-1699347600-1699376400@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Basic Level
DESCRIPTION:The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she will understand and be able to accomplish basic operations associated with developing\, formatting\, and using a spreadsheet. \nWhat will you learn in this Microsoft Excel Basic Level Training?\n• The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer.\n• He or she will understand and be able to accomplish basic operations associated with developing\, formatting\, and using a spreadsheet.\n• Additionally\, trainees will be able to accomplish standard mathematical operations using basic formulas and functions.\n• The trainee will be able to demonstrate competence in using some of the features of Excel such as filtering\, managing data and creating charts. \nCourse Outline\nOFFICE WORKSPACE BASICS\n• Basic Window Elements\n• Exploring Office Backstage\n• Working with the Ribbon\n• Customizing the Quick Access Toolbar\n• Working with Key Tips\n• Using the Status Bar \nINTRODUCTION TO EXCEL\n• What is Excel?\n• Getting to Know the Excel Window\n• Moving the Cell Selector\n• Opening a Workbook\n• Navigating a Workbook\n• Selecting Cells\n• Creating Workbooks\n• Saving a Workbook\n• Closing a Workbook \nENTERING AND EDITING DATA\n• Entering Text\, Numbers\, and Dates\n• Editing Data\n• Using AutoComplete and AutoFill\n• Copying Data\n• Moving and Clearing Data\n• Using Undo and Redo\n• Finding and Replacing Data \nFORMATTING DATA\n• Introduction to Formatting\n• Applying Number Formats\n• Applying Font Formats\n• Changing Cell Alignment\n• Applying Cell Styles\n• Copying Formats\n• Clearing Formats\n• Finding and Replacing Formats \nFORMATTING WORKSHEETS\n• Inserting and Deleting Rows and Columns\n• Inserting and Deleting Cells\n• Adjusting Column and Row Sizes\n• Hiding Worksheet Components\n• Inserting and Deleting Worksheets\n• Copying and Moving Worksheets\n• Customizing Sheet Tabs\n• Adding a Worksheet Background \nKICK START WITH BASIC FORMULAS AND FUNCTIONS\n• What are Formulas and Functions?\n• Entering Formulas\n• Entering Functions\n• Using the Insert Function Tools\n• Using AutoSum\n• Copying and Moving Formulas \nADDING CHARTS AND GRAPHICS\n• Creating a Chart\n• Enhancing a Chart\n• Modifying Chart\n• Data Changing Chart\n• Types Drawing\n• Shapes Inserting\n• Pictures Creating\n• SmartArt \nVIEWING AND PRINTING WORKBOOKS\n• Changing View Options\n• Splitting and Freezing a Worksheet\n• Sorting and Filtering Data\n• Customizing the Page Layout\n• Adding Headers and Footers\n• Modifying Page Breaks\n• Previewing and Printing the Worksheet
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-basic-level-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/09/57.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231122T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231123T170000
DTSTAMP:20260621T025327
CREATED:20231102T072900Z
LAST-MODIFIED:20231102T072953Z
UID:10290-1700643600-1700758800@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Intermediate and Advanced Level
DESCRIPTION:In this course\, the participants will be introduced to the more intermediate features of Microsoft Excel. The participant will learn how to generate reports from Excel data. The course also shows the participant how to highlight important data using conditional formats\, prevent date entry errors using Data Validation. At the end of the course\, the participant will be able to demonstrate the ability to manage data efficiently with Microsoft Excel. \nWhat will you learn in this Microsoft Excel Intermediate and Advanced Level?\n• Apply proper formula and function\n• Troubleshooting errors\n• Link and Embed Data from other sources\n• Applying Conditional Formatting and Validation Rules\n• Build upon the essential Microsoft Office Excel knowledge and skills\n• Learn to create advanced workbooks and worksheets\, including\nadvanced formulas\, tables\, and data analyzing tools \nCourse Outline\nDATA MANAGEMENT\n• Sorting\n• Sorting Multiple Columns\n• Finding Data\n• Replacing Data\n• Finding and Replacing Cell Format\n• Practice – Data Management \nWORKING WITH DATABASES \n• Creating Subtotals in a List\n• Removing Subtotals from a List\n• Sorting Data by Multiple Levels\n• Using Custom Sort\n• Using Data Validation\n• Validating Data using a List\n• Creating a Custom Error Message\n• Removing Data Validation \nUSING TEMPLATES\n• Copying Worksheets\n• Hiding Columns and Rows\n• Unhiding Columns and Rows\n• Saving a Workbook as a Template\n• Using a Template\n• Editing a Template\n• Inserting a New Worksheet\n• Hiding/Unhiding a Worksheet\n• Deleting a Template\n• Finding Online Templates \nCREATING CHARTS\n• Inserting a column chart\n• Inserting a line chart\n• Inserting a bar chart\n• Inserting a pie chart\n• Resizing a chart\n• Deleting a chart\n• Adding a Chart Title\n• Changing the Chart Background\n• Changing a column\, bar\, line\, or pie slice colours\n• Changing the chart type\n• Adding a Data Table\n• Changing the Chart Layout\n• Copying and moving charts\n• Creating a 3-D Chart\n• Adjusting 3-D View\n• Inserting Sparklines\n• Practice – Creating Charts \nREVISING CHARTING FEATURES\n• Formatting an Axis\n• Changing the Axis Scaling\n• Formatting the Data Series\n• Adding Data from Different Worksheets\n• Using a Secondary Axis\n• Changing Data Series Chart Types\n• Changing Source Data Range \nWORKING WITH ADVANCED FILTERS \n• Creating a Criteria Range\n• Using a Criteria Range\n• Showing All Records\n• Using an Advanced and Condition\n• Using an Advanced or Condition\n• Copying Filtered Records\n• Using Database Functions \nUSING CONDITIONAL AND CUSTOM FORMATS \n• Applying Conditional Formats\n• Changing a Conditional Format\n• Adding a Conditional Format\n• Creating a Custom Conditional Format\n• Using Data Bars\n• Deleting a Conditional Format\n• Creating a Custom Number Format \nUSING WORKSHEET PROTECTION \n• Unlocking Cells in a Worksheet\n• Protecting a Worksheet\n• Unprotecting a Worksheet\n• Creating Allow-Editing Ranges\n• Deleting Allow-Editing Ranges\n• Protecting Workbook Windows\n• Unprotecting Workbook Windows\n• Assigning a Password\n• Opening a Password-protected File\n• Removing a Password \nUSING AUDITING TOOLS AND RANGE NAMES \n• Jumping to a Named Range\n• Assigning Names\n• Using Range Names in Formulas\n• Creating Range Names from Headings\n• Applying Range Names\n• Deleting Range Names\n• Using Range Names in 3-D Formulas\n• Displaying/Removing Dependent Arrows\n• Displaying/Removing Precedent Arrows\n• Showing Formulas\nEXPORTING AND IMPORTING DATA \n• Importing Data from Text Files\n• Changing External Data Range Properties\n• Removing the Query Definition\n• Creating a Hyperlink\n• Editing a Hyperlink
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-intermediate-and-advanced-level/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/11/HRDCorpClaimableCourse-Microsoft-Excel-Intermediate-Advanced-Level-NOV.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231122T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231124T170000
DTSTAMP:20260621T025327
CREATED:20230927T070618Z
LAST-MODIFIED:20231102T071548Z
UID:9885-1700643600-1700845200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Certified Digital Marketing Professional
DESCRIPTION:The programme will allow participants to learn and master effective online marketing strategies from knowing how to plan\, set up\, monitor\, and optimize it\, to achieve their marketing goals effectively. Participants will learn how to use a proven framework and formula to manage their social media and Google ads campaign\, whether they’re in the B2C or B2B industry.\nThese modules are custom designed\, to help participants to equip the skill and ability to see improvement in their marketing campaign. In this class\, we’ll not just talk about the concept\, but also cover the case studies\, best practices\, the dos\, and don’ts\, to make it practical\, easy to understand and easy to apply. \nWhat will you learn in this Certified Digital Marketing Professional Training?\n• Understand the principles of digital marketing\, the tools\, and how you can leverage it to grow your presence\, positioning and revenue online.\n• Leveraging the latest Facebook Ads campaign strategies to improve your marketing results and performance.\n• Learning how to run Google Ads\, using other Google online tools to create an effective campaign for both B2C and B2B industry.\n• How to create engaging copies\, images\, or videos for both social media and Search Engine campaign.\n• How to build authority\, brand\, and positioning as the go-to-expert on social media with content marketing. \nCourse Outline\nPRINCIPLES OF DIGITAL MARKETING\n• Overview of an effective digital marketing strategy\n• Understand the pillars of digital marketing\n• Identifying customer online behavioral journey\n• Online competitor research and analysis\n• Concept and important terms for digital marketing\n• Malaysian behavioral trend online \nFACEBOOK & INSTAGRAM MARKETING\n• Social Media Ads campaign structure Overview\n• Meta Ads Account Manager & Business Manager Overview\n• Facebook & Instagram Campaign setup best practices\n• Custom audience and Lookalike audience overview and strategy\n• Copywriting for Ads\n• Campaign monitoring and optimization\n• Facebook / Instagram ads policy and guidelines overview\n• Ads analysis and measuring your campaign\n• Facebook pixel and event measurement overview \nWEBSITE AND LANDING PAGE OPTIMIZATION\n• How to build a beginner-friendly site easily\n• Differences between a website and a landing page\n• Website ideas and structure setup\n• Website optimization best practices\n• Tools and tips for building a modern website without experience\n• Website pro tips and strategies that will help you save costs and generate leads\n• Lead generation forms integration and setup for maximum conversion \nCONTENT MARKETING\n• Introduction to content marketing and its application.\n• Learn different types of content to build brand\, positioning and authority.\n• Content research\, ideation\, and planning strategy\n• Set up and manage your content calendar effectively.\n• How TO measure your content marketing goals\n• Short video – Reels video creation tutorial \nGOOGLE ADS MARKETING\n• Understand Google Ads campaign structure\n• Learn different types of Google Ads objectives for your campaign goals\n• Keyword research analysis and preparation\n• Google ads campaign set up walkthrough and best practices\n• Monitor and optimize your Google Ads campaign\n• How to measure your Google ads campaign \nEMAIL MARKETING\n• Email Marketing\n• Email Write Up Best Practices\n• Reduce Spam Filters\, Increase Delivery Rate & Open Rate\n• Email Marketing Automation \nAI FOR MARKETING PERFORMANCE\, PRODUCTIVITY & CREATIVITY\n• Learn different AI tools for marketing tasks & activities\n• Understand the limit and boundaries of AI tools\n• Using AI for Social Media & Search Engine\n• AI prompt for digital marketing
URL:https://www.excelacademy.my/event/hrd-corp-claimable-certified-digital-marketing-professional/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Digital Marketing
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/09/HRDCorpClaimableCourse-Certified-Digital-Marketing-Professional-NOV.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231128T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231129T170000
DTSTAMP:20260621T025327
CREATED:20230927T071527Z
LAST-MODIFIED:20230927T071527Z
UID:9888-1701162000-1701277200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Search Engine Optimization and Search Engine Marketing
DESCRIPTION:Learn how to rank faster and more effectively on Google. Get everything you need to know about search engine optimization\, master them and implement them on your website\, to start seeing consistent traffic coming to your site. Though SEO is not a rocket science\, most people find it difficult to implement because of various terminologies used\, updates and other misconceptions. This workshop serves as a purpose to help students who have no time to do their own research\, or a total beginner who’s not sure of where to start\, this course is for you. Students will be given case studies\, tools\, resources with several examples on how to implement effective SEO strategies with a clear step-by-step guide\, in the simplest and most effective manner. SEO is a must-know section for every business owner and marketer because it can help you drive consistent traffic 24/7\, generate qualified leads and save tons of your advertising cost. \nWhat will you learn in this Search Engine Optimization and Search Engine Marketing  Training?\n• How to optimize your website for better search ranking\n• Leveraging SEO and Google Paid Ads to enhance your site’s traffic and leads\n• Learn to build SEO strategies for your company\, using tools and setup best practices\n• How to generate traffic consistently with SEO best practices setup\n• Learn how to setup your first Google Ads campaign\n• Learn how to analyze and measure your ads performance\n• Understand different ways to optimize your ads campaign \nCourse Outline\nFUNDAMENTAL OF SEO\n• What is SEO and how does it work?\n• Organic search vs paid search\n• Relationship between SEO and website optimization\n• Debunking SEO myth\n• 3 Core pillars of SEO\n• Measuring your SEO performance \nKEYWORD RESEARCH\n• Understanding keywords for SEO\n• Types of keywords and how to use them for your advantage\n• Understanding long-tailed vs short-tailed keywords\n• How to conduct keyword research\n• How to use Google keyword planner to conduct keyword research\n• Other recommended tools for keyword research\n• How to identify and prioritize your keywords \nCONTENT STRATEGIES FOR SEO\n• Understanding On-page SEO\n• List of On-Page SEO setup.\n• Ways to optimize your meta title and meta description\n• Understand URL structure impact on SEO\n• Using headings (H1-H6) for SEO\n• Optimizing images with keywords\n• Internal and external linking\n• Content writes up for SEO \nOFF-PAGE SEO STRATEGIES\n• Off-page SEO explained\n• List of Off-page SEO checklist\n• Understand link-building\n• Building backlinks strategies\n• How to identify competitor’s backlink\n• Best practices when it comes to link building \nTECHNICAL SEO\n• Strategies to improve your website performance\n• List of technical SEO setup\n• Understand Google Search Console\n• Understand Google Analytics\n• Identify duplicate content and how to fix it\n• Optimizing Google business profile \nFUNDAMENTAL OF GOOGLE ADS\n• Why Google Ads and how does it work\n• Understand Google Ads campaign structure\n• Learn about different types of Google Ads objectives\n• Understand how your ads will be triggered\n• Understand keywords match type\n• Understand types of ads extension and the purpose \nGOOGLE ADS OPTIMIZATION STRATEGIES\n• Conduct keywords research using free tools\n• Ad group and keywords setup\n• How to write powerful copy for your Google Ads\n• Bidding strategies\n• How to optimize your campaign with search term\n• How to optimize your campaign with negative search\n• Measure your Google Ads campaign performance
URL:https://www.excelacademy.my/event/hrd-corp-claimable-search-engine-optimization-and-search-engine-marketing/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Search Engine Optimization and Search Engine Marketing
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2023/09/62.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR