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:20241120T090000
DTEND;TZID=Asia/Kuala_Lumpur:20241120T170000
DTSTAMP:20240718T075505Z
CREATED:20240716T013934Z
LAST-MODIFIED:20240718T075505Z
UID:13288-1732093200-1732122000@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-13/
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_Nov2024.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20241120T090000
DTEND;TZID=Asia/Kuala_Lumpur:20241121T170000
DTSTAMP:20240718T074949Z
CREATED:20240716T014814Z
LAST-MODIFIED:20240718T074949Z
UID:13293-1732093200-1732208400@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-12/
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_Nov2024.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR