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-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:20230822T080000
DTEND;TZID=Asia/Kuala_Lumpur:20230823T170000
DTSTAMP:20260515T032943
CREATED:20230728T074610Z
LAST-MODIFIED:20230728T074610Z
UID:9256-1692691200-1692810000@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Data Analytics & Visualization In Excel
DESCRIPTION:Transform Your Data into Insights with Excel\nUnlock the full potential of your data with our comprehensive Data Analytics and Visualization in Excel course. Whether you’re a beginner or an experienced user\, this course will teach you the skills you need to turn raw data into actionable insights. \nWith step-by-step instructions and hands-on exercises\, you’ll learn how to import\, clean\, and analyze data in Excel. You’ll also learn how to create interactive dashboards\, powerful visualizations\, and custom functions that can help you make informed decisions. \n  \nWho Should Join This Data Analytics and Visualization in Excel?\nA Data Analytics and Visualization in Excel course can benefit you in many ways. It can boost your career\, improve your problem-solving and decision-making skills\, make you more efficient in using Excel\, increase your data literacy\, and give you hands-on experience with real-world scenarios. This course is suitable for anyone looking to advance their career\, start a new one\, or learn a new skill. \n  \nHRD Corp Claimable Course\nThis course is not just eligible for HRD Corp claims\, it’s a must-have opportunity for those looking to invest in their personal and professional growth. By taking advantage of the organization’s human resource development program and getting reimbursed for the cost of the course\, you’ll not only be boosting your skillset and increasing your knowledge\, but you’ll also be maximizing the benefits offered by your employer. Don’t miss out on this incredible opportunity to enhance your career and secure your future success. Make the investment in yourself today and claim your spot in this valuable course. \n  \nCourse Outline\nGETTING DATA INTO MICROSOFT EXCEL\n– Import data from various platforms into Microsoft Excel for further analysis \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 dates\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 calculations \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 referencing \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\, and more\n– Utilize standard charts such as line charts\, pie charts\, and scatter charts\, as well as specialized charts such as hierarchy\, waterfall\, funnel\, geospatial\, and gauge charts \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. \n  \nFor more information about our Data Analytics and Visualization In Excel\, contact us at 1700-81-5520 or email us at training@excelacademy.my. To keep updated with our training you can follow us on Facebook\, https://www.facebook.com/excelacademyofexecutiveeducation \nCheck out other courses: https://www.excelacademy.my/hrdcorp-claimablecourse/
URL:https://www.excelacademy.my/event/hrd-corp-claimable-data-analytics-visualization-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/07/HRDCorpClaimableCourse-Data-Analytics-Visualization-In-Excel-Physical-AUG.webp
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR