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:20231017T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231017T170000
DTSTAMP:20260620T195253
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:20260620T195253
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:20260620T195253
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:20260620T195253
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:20260620T195253
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:20260620T195253
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
END:VCALENDAR