BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.16.5.1//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:20230101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20241217T090000
DTEND;TZID=Asia/Kuala_Lumpur:20241218T170000
DTSTAMP:20240718T075107Z
CREATED:20240718T030810Z
LAST-MODIFIED:20240718T075107Z
UID:13357-1734426000-1734541200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Intermediate and Advanced Level
DESCRIPTION:Download the Course Brochure Link  \nThis comprehensive course provides a deep dive into advanced data management and analysis techniques within the Excel environment. Participants will learn how to manipulate and organize data effectively\, work with databases\, utilize templates\, create and revise charts\, use advanced filters\, protect worksheets\, utilize auditing tools\, import and export data\, use advanced functions\, and work with pivotal data and scenarios. The course is designed to equip participants with the skills necessary for efficient data handling and analysis in a professional setting. \nWhat will you learn in this Microsoft Excel Intermediate and Advanced Level?\n• Develop proficiency in sorting\, filtering\, and managing data for better organization and retrieval.\n• Learn advanced database management methods for accurate and reliable data analysis.\n• Master the use of templates for smoother and more organized worksheet management.\n• Acquire skills to create and customize charts effectively for clear data representation.\n• Learn to protect worksheets and workbooks for enhanced data security and integrity.\n• Develop skills in managing complex data relationships and tracking using auditing tools and range names.\n• Acquire the ability to seamlessly import and export data between different platforms and applications.\n• Become proficient in using various advanced functions for complex data analysis and manipulation.\n• Develop expertise in creating and managing pivot tables for comprehensive data analysis.\n• Learn effective techniques for tracking and merging workbooks for improved collaboration and version control.\n• Acquire skills in applying custom formats and recording macros for efficient and automated data formatting and manipulation. \nCourse Outline\nModule 1: Data Management\n• Sorting Data\n• Sorting Data in Multiple Columns\n• Finding Specific Data\n• Replacing Data Values\n• Modifying Cell Formats \nModule 2: Working with Databases\n• Creating and Removing Subtotals in Lists\n• Sorting Data in Multiple Levels\n• Custom Sorting\n• Validating and Removing Data\n• Customizing Error Messages \nModule 3: Using Template\n• Managing Worksheets\n• Adjusting Workbook Templates\n• Handling Worksheets (Hide\, Unhide\, Delete)\n• Accessing Online Templates \nModule 4: Creating Chart\n• Inserting and Formatting Different Chart Types\n• Customizing Chart Elements (Title\, Background\, Data Table)\n• Managing Chart Types and Layouts\n• Working with 3-D Charts and Sparklines \nModule 5: Revising Charting Features\n• Formatting Axis and Data Series\n• Including Data from Different Worksheets\n• Using Secondary Axis and Changing Data Series Types \nModule 6: Working with Advanced Filters\n• Formatting Axis and Data Series\n• Including Data from Different Worksheets\n• Using Secondary Axis and Changing Data Series Types \nModule 7: Using Worksheet Protection\n• Protecting and Unprotecting Worksheets and Workbook Windows\n• Managing Allow-Editing Ranges and Passwords \nModule 8: Using Auditing Tools and Range Names\n• Applying and Removing Range Names\n• Displaying Relationships between Cells (Dependent/Precedent Arrows)\n• Showing Formulas \nModule 9: Exporting and Importing Data\n• Managing External Data Properties and Hyperlinks \nModule 10: Using Advanced Function\n• Utilizing Various Functions (VLOOKUP\, HLOOKUP\, IF\, ISERROR\, AND\, OR\, ROUND\, COUNTIF\, RANK)\n• Exploring Financial and Text Functions \nModule 11: Creating/Revising Pivot Tables\n• Constructing and Customizing PivotTable Reports and PivotCharts\n• Working with Data Grouping and Summary Functions \nModule 12: Using Scenarios\n• Creating\, Editing\, and Displaying Scenarios\n• Generating Scenario Summary Reports\n• Handling Data Tables and Variable Tables \nModule 13: Tracking and Merging Workbook\n• Managing Shared Workbooks and Tracked Changes\n• Handling Conflicting Changes and History Worksheets \nModule 14: Using Conditional and Custom Formats\n• Applying and Customizing Conditional Formats\n• Working with Data Bars and Custom Number Formats \nModule 15: Recording Macros\n• Recording\, Running\, and Deleting Macros\n• Customizing Shortcut Keys and Quick Access Toolbar (QAT)
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-intermediate-and-advanced-level-13/
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/2024/07/HRDCorpClaimableCourse_Microsoft_Excel_IntermediateAdvanced_Level_Dec2024.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20241218T080000
DTEND;TZID=Asia/Kuala_Lumpur:20241218T170000
DTSTAMP:20240718T075646Z
CREATED:20240718T054341Z
LAST-MODIFIED:20240718T075646Z
UID:13371-1734508800-1734541200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Basic Level
DESCRIPTION:Download the Course Brochure Link  \nThis course serves as a comprehensive introduction to the fundamental aspects of office workspace management and Excel proficiency. Participants will be equipped with the necessary skills to navigate the Office suite effectively\, focusing on Excel’s core functionalities. From mastering data entry and formatting techniques to harnessing the power of formulas\, functions\, and visualizations\, this course aims to provide a solid foundation for efficient data management and analysis within the Excel environment. Participants will learn practical strategies for optimizing workflows and enhancing productivity through effective data handling and presentation \nWhat will you learn in this Microsoft Excel Basic Level?\n• Develop the ability to efficiently navigate and customize the Office workspace for improved productivity.\n• Acquire a solid understanding of Excel’s essential features\, enabling effective data entry\, editing\, and formatting.\n• Learn techniques for swift and accurate data manipulation\, leading to streamlined data management processes.\n• Develop proficiency in using basic formulas and functions to automate calculations and data analysis tasks.\n• Learn to create and enhance charts and graphics for clear and impactful data representation.\n• Acquire skills for managing and presenting workbooks effectively\, facilitating easy data interpretation and communication \nCourse Outline\nModule 1: Office Workspace Basics\n• Understanding the Basics of the Office Workspace\n• Exploring the Office Backstage\n• Mastering the Ribbon\n• Customizing the Quick Access Toolbar\n• Navigating Efficiently with Key Tips\n• Utilizing the Status Bar for Productivity \nModule 2: Introduction to Excel\n• Understanding the Basics of the Office Workspace\n• Exploring the Office Backstage\n• Mastering the Ribbon\n• Customizing the Quick Access Toolbar\n• Navigating Efficiently with Key Tips\n• Utilizing the Status Bar for Productivity \nModule 3: Entering and Editing Data\n• Understanding the Basics of the Office Workspace\n• Exploring the Office Backstage\n• Mastering the Ribbon\n• Customizing the Quick Access Toolbar\n• Navigating Efficiently with Key Tips\n• Utilizing the Status Bar for Productivity \nModule 4: Formatting Data\n• Understanding the Basics of the Office Workspace\n• Exploring the Office Backstage\n• Mastering the Ribbon\n• Customizing the Quick Access Toolbar\n• Navigating Efficiently with Key Tips\n• Utilizing the Status Bar for Productivity \nModule 5: Formatting Worksheets\n• Understanding the Basics of the Office Workspace\n• Exploring the Office Backstage\n• Mastering the Ribbon\n• Customizing the Quick Access Toolbar\n• Navigating Efficiently with Key Tips\n• Utilizing the Status Bar for Productivity \nModule 6: Kickstart With Basic Formulas And Functions\n• Understanding the Fundamentals of Formulas and Functions\n• Optimizing Formula Entry and Management Techniques\n• Streamlining Complex Calculations with Efficient Function Usage\n• Exploring Advanced Tools for Formula and Function Integration \nModule 7: Adding Charts And Graphics\n• Mastering Data Visualization Techniques\n• Creating and Enhancing Charts for Data Representation\n• Modifying Charts for Enhanced Data Visualization\n• Integrating Data Changes within Charts for Real-Time Updates\n• Leveraging Advanced Drawing Tools for Customized Visuals \nModule 8: Viewing And Printing Workbooks\n• Efficient Workbook Viewing and Printing Techniques\n• Customizing Workbook Views for Optimal User Experience\n• Optimizing Data Management with Sorting and Filtering\n• Custom Page Layout\, Headers\, and Footers\n• Previewing and Printing Workbooks for Professional Presentation
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-basic-level-14/
LOCATION:Excel Academy\, Excel Academy\, VSQ@PJCC Block 6 Level 5\, Jalan Utara\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2024/07/HRDCorpClaimableCourse_Microsoft_Excel_Basic_Level_Dec2024.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20241218T090000
DTEND;TZID=Asia/Kuala_Lumpur:20241219T170000
DTSTAMP:20241017T034755Z
CREATED:20240718T060759Z
LAST-MODIFIED:20241017T034755Z
UID:13376-1734512400-1734627600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Data Analytics and Visualization Tools
DESCRIPTION:Download the Course Brochure Link \nThis comprehensive course is designed to equip participants with the skills and knowledge needed to proficiently handle data in Microsoft Excel\, from importing and cleaning to advanced analytics and visualization. Participants will delve into various aspects of Excel\, learning practical techniques for data manipulation\, logical analysis\, and effective visualization. The course also introduces Power BI integration to extend data visualization capabilities beyond Excel. \nWhat will you learn in this Microsoft Excel Data Analytics and Visualization Tools?\n• Import data from various sources and manage external data within Excel\n• Use Excel functions for text manipulation and ensure data accuracy\n• Seamlessly handle data types\, perform numerical operations\, and manage dates\n• Learn cell referencing\, naming\, and automation for organized data\n• Utilize SMART TABLES for organized data analysis with formatting and filtering\n• Master effective data visualization with charts and Power BI integration for advanced insights \nCourse Outline\nModule 1: Getting Data Into Microsoft Excel\n• Import data from various platforms into Microsoft Excel for further analysis\n• Explore methods for efficient data importing and connecting to external data sources \nModule 2: Data Cleaning And Manipulation\n• Utilize functions for combining and splitting text to enhance data readability\n• Clean data\, change case\, and remove unwanted characters for better analysis\n• Emphasize the importance of well-organized data for accurate and insightful analysis \nModule 3: Working With Numbers And Dates\n• Convert data types from text to numbers\, dates to text\, and both numbers and text to dates\n• Master functions for generating dates\, calculating days between two dates\, and more \nModule 4: Defined Names For Better Data Management\n• Learn the power of referencing and naming cells for improved data organization\n• Create named ranges and automate processes for enhanced efficiency and accuracy \nModule 5: Automating Data Manipulation With Tables\n• Utilize SMART TABLES to create\, format\, and manage data tables\n• Format\, select\, sort\, and filter data efficiently for improved organization\n• Enhance data analysis with structured referencing techniques \nModule 6: Logical And Lookup Functions\n• Evaluate data using nested IF functions for advanced logical operations.\n• Perform logical operations with IF and categorize data using VLOOKUP and XLOOKUP\n• Master advanced functions such as INDEX and MATCH for precise data matching \nModule 7: Data Transformation With Power Query\n• Use the Query Editor Engine to extract\, transform\, and load data seamlessly\n• Combine multiple datasets for a comprehensive and integrated analysis \nModule 8: Data Visualization\n• Visualize data effectively with conditional formatting\, sparklines\, and number formats\n• Utilize standard charts (line\, pie\, scatter) and specialized charts (hierarchy\, waterfall\, funnel\, geospatial\, gauge) for insightful data representation \nModule 9: Creating Interactive Dashboards\n• Summarize data dynamically with Pivot Tables for quick insights\n• Customize\, group\, sort\, and filter pivot data for interactive dashboards\n• Create engaging dashboards with pivot charts\, slicers\, and timelines \nModule 10: Data Visualization with Power BI\n• Explore Power BI for quick and advanced data visualization\n• Integrate Power BI with Excel for a seamless analytics experience\n• Create compelling visualizations for effective data communication
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-data-analytics-and-visualization-tools-6/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Data Analytics & Visualization In Excel,Microsoft Excel
ATTACH;FMTTYPE=image/webp:https://www.excelacademy.my/wp/wp-content/uploads/2024/07/HRDCorpClaimableCourse_Microsoft_Excel_Data_Analytics_And_Visualization_Tools_Dec2024-1.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR