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-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:20231213T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231214T170000
DTSTAMP:20260620T171213
CREATED:20230927T065350Z
LAST-MODIFIED:20231102T071356Z
UID:9882-1702458000-1702573200@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. \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\nIn 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\nhow Microsoft products can be used to implement a self-service BI solution\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-3/
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/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/09/HRDCorpClaimableCourse-Mastering-Interactive-Dashboard-Reporting-with-Power-BI-DEC.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231213T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231214T170000
DTSTAMP:20260620T171213
CREATED:20231102T074811Z
LAST-MODIFIED:20231102T074811Z
UID:10295-1702458000-1702573200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Social Media Marketing
DESCRIPTION: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\ntool \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-3/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Social Media Marketing
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/11/HRDCorpClaimableCourse-Social-Media-Marketing-DEC.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231213T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231214T170000
DTSTAMP:20260620T171213
CREATED:20231102T080127Z
LAST-MODIFIED:20231102T080127Z
UID:10298-1702458000-1702573200@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 \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 
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-intermediate-and-advanced-level-2/
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-DEC.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231214T080000
DTEND;TZID=Asia/Kuala_Lumpur:20231214T170000
DTSTAMP:20260620T171213
CREATED:20231214T082800Z
LAST-MODIFIED:20231214T082800Z
UID:10618-1702540800-1702573200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Digital Marketing Masterclass
DESCRIPTION:The program will allow participants to learn and master effective digital marketing strategies from knowing how to plan\, setup\, monitor and optimizing it\, to achieve their marketing goals effectively.\nParticipants will learn how to use a proven framework and formula to manage their social media and websites to rank higher on Google\, 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 case studies\, best practices\, the do’s and the don’t\, to make it practical\, easy to understand and easy to apply. \nWhat will you learn in this Digital Marketing Masterclass? \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 \nModule 1: Principles of Digital Marketing\n• Overview of an effective digital marketing strategy\n• Understand the pillars of digital marketing\n• Identifying customer online behavioural journey\n• Online competitor research and analysis\n• Concept and important terms for digital marketing\n• Malaysian behavioural trend online \nModule 2: Social Media (Facebook & Instagram) Marketing\n• Facebook Ads campaign structure Overview\n• Facebook Account Manager & Business Manager Overview\n• Campaign setup best practises\n• Custom audience and Lookalike audience overview and strategy\n• Copywriting for Ads\n• Campaign monitoring and optimization\n• Facebook ads policy and guidelines overview\n• Ads analysis and measuring your Campaign \nModule 3: Content 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• Setup and manage your content calendar effectively.\n• How to measure your content marketing goals.\n• Posting method\, hashtags\, process\, and workflow for Social Media content.\n• Short video – Reels and TikTok video creation tutorial \nModule 4: Landing Page and Website Optimization\n• Principles of a good landing page.\n• Difference and its use case for landing page and website.\n• Strategies to improve your website for conversion.\n• WordPress overview and free website theme builder.\n• Structure and design of a good websites and landing page.\n• Using landing pages as a funnel to generate more leads\, signs-up and registration. \nModule 5: Search Engine Optimization\n• Understand how search engines work.\n• How to audit your website before implementing SEO.\n• Improve your website speed and performance.\n• How to conduct keyword research and optimization.\n• Simple ways to optimize your website content for better SEO.\n• Google business profile optimization.\n• Tools to analyse your website performance.
URL:https://www.excelacademy.my/event/hrd-corp-claimable-digital-marketing-masterclass-6/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/12/HRDCorpClaimableCourse_Digital_Marketing_Masterclass_Feb2024-1.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231215T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231215T170000
DTSTAMP:20260620T171213
CREATED:20231102T081459Z
LAST-MODIFIED:20231102T081459Z
UID:10301-1702630800-1702659600@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\ndemonstrate 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\,\nformatting\, and using a spreadsheet.\n• Additionally\, trainees will be able to accomplish standard mathematical operations using\nbasic formulas and functions.\n• The trainee will be able to demonstrate competence in using some of the features of Excel such\nas 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-3/
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-Basic-Level-DEC.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231219T080000
DTEND;TZID=Asia/Kuala_Lumpur:20231220T170000
DTSTAMP:20260620T171213
CREATED:20231102T083726Z
LAST-MODIFIED:20231102T083726Z
UID:10307-1702972800-1703091600@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. \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\nfunctions to work with them.\n• Use logical and lookup functions to transform\, link and categorize\ndata.\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 BI.
URL:https://www.excelacademy.my/event/hrd-corp-claimable-data-analytics-visualizations-in-excel-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Data Analytics & Visualization In Excel
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/11/HRDCorpClaimableCourse-Data-Analytics-Visualization-In-Excel-Physical-DEC.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231219T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231219T170000
DTSTAMP:20260620T171213
CREATED:20231102T082634Z
LAST-MODIFIED:20231102T082634Z
UID:10304-1702976400-1703005200@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\ncontexts\n• Develop strategies for effectively integrating ChatGPT into existing\nworkflows\n• Gain insights on best practices\, potential challenges\, and ethical\nconsiderations 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 \nUsage 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\ncompelling advertisements\, newsletters\, and dynamic media campaigns in marketing\n• Optimizing AI-generated content\, captivating audiences\, and boosting brand impact through\nprompt engineering in ChatGPT\nmarketing\n• Unleashing the power of ChatGPT from OpenAI for cutting-edge\nmarketing 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 learned \n 
URL:https://www.excelacademy.my/event/hrd-corp-claimable-chatgpt-mastery-enhancing-marketing-communication-productivity-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:ChatGPT
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/11/HRDCorpClaimableCourse-ChatGPT-Mastery-Enhancing-Marketing-Communications-Productivity-DEC.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231220T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231221T170000
DTSTAMP:20260620T171213
CREATED:20230927T072739Z
LAST-MODIFIED:20230927T072739Z
UID:9891-1703062800-1703178000@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?\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-digital-marketing-masterclass-4/
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/Individual-Course-Posting-17.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR