BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.15.20//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:20230101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20240626T090000
DTEND;TZID=Asia/Kuala_Lumpur:20240627T170000
DTSTAMP:20260514T163940
CREATED:20240228T081842Z
LAST-MODIFIED:20240416T054007Z
UID:12674-1719392400-1719507600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Data Analytics and Visualization Tools
DESCRIPTION:Download the Course Brochure Link Here \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-3/
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/2024/02/HRDCorpClaimableCourse_Microsoft_Excel_Data_Analytics_And_Visualization_Tools_Jun2024_Excel_Academy.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR