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:20220101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231219T080000
DTEND;TZID=Asia/Kuala_Lumpur:20231220T170000
DTSTAMP:20260514T234115
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
END:VCALENDAR