BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//UOA Academy - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:UOA Academy
X-ORIGINAL-URL:https://uoa-academy.com
X-WR-CALDESC:Events for UOA Academy
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20220101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20231213
DTEND;VALUE=DATE:20231215
DTSTAMP:20260422T054036
CREATED:20230720T183703Z
LAST-MODIFIED:20230720T200848Z
UID:8360-1702425600-1702598399@uoa-academy.com
SUMMARY:Level 3: Microsoft Excel (Advance)
DESCRIPTION:LEVEL 3: Microsoft Excel (Advance) (2 Days)\nObjectives\nThe Microsoft Excel (Advanced) course is designed to enhance participants’ proficiency in using Excel for advanced data analysis\, automation\, and visualization. Over the course of two days\, participants will dive deep into Excel’s advanced features\, functions\, and\ntechniques. Through hands-on exercises and practical examples\, participants will gain the skills and confidence to work with complex formulas\, create dynamic reports\, automate repetitive tasks\, and unlock the full potential of Excel for advanced data analysis. \nTarget Audience\nThis advanced Microsoft Excel course is designed for professionals\, analysts\, data scientists\, and individuals who already have a solid foundation in Excel and want to enhance their skills in data analysis\, automation\, and visualization. It is suitable for individuals who\nregularly work with large datasets\, perform complex calculations\, create dynamic reports\, and seek to optimize their productivity using Excel’s advanced features. \nLearning Outcomes\n● Utilize advanced formulas\, functions\, and data analysis tools in Excel.\n● Work with large datasets\, filtering\, sorting\, and advanced data manipulation.\n● Create dynamic reports using pivot tables\, slicers\, and advanced charting techniques.\n● Automate tasks and workflows using macros and VBA (Visual Basic for Applications).\n● Perform advanced data analysis\, including goal seeking\, scenarios\, and solver. \nCourse Outlines:\nDay 1\nModule 1: Advanced Function and Formulas\n● Using logical functions (IF\, AND\, OR) for complex data analysis.\n● Working with lookup functions (VLOOKUP\, HLOOKUP\, INDEX\, MATCH).\n● Utilizing statistical functions (AVERAGEIF\, COUNTIFS\, SUMIFS) for advanced calculations. \nModule 2: Data Manipulation and Analysis\n● Sorting and filtering data effectively in large datasets.\n● Working with data validation and conditional formatting.\n● Advanced data manipulation techniques using functions (TEXT\, CONCATENATE\, etc.). \nModule 3: Dynamic Reporting with PivotTables and Charts\n● Creating and customizing PivotTables for data summarization and analysis.\n● Using slicers and timelines to interactively filter and analyze data.\n● Advanced charting techniques\, including combo charts and dynamic chart ranges. \nDay 2:\nModule 4: Automation with Macros and VBA\n● Recording and editing macros for automating repetitive tasks.\n● Introduction to VBA programming for advanced automation.\n● Creating user-defined functions (UDFs) to extend Excel’s capabilities. \nModule 5: Advanced Data Analysis\n● Goal seeking and data modeling for what-if analysis.\n● Scenario analysis and using data tables for sensitivity analysis.\n● Solver tool for optimization and constraint-based analysis. \nModule 6: Collaboration and Workbook Management\n● Sharing and protecting workbooks with advanced security settings.\n● Tracking changes and comments for collaborative work.\n● Managing multiple worksheets and workbooks efficiently. \nModule 7: Excel Tips\, Shortcuts\, and Best Practices\n● Time-saving tips\, keyboard shortcuts\, and productivity-enhancing features.\n● Data validation techniques and error handling best practices. \nPricing:\nRM 1\,000.00 Per Person (HRD Corp Claimable Course)\n \nKindly scan or click on the link below for your \nLearning Registration.\n \nFor any enquiries\, please contact us at:\n \nUOA Academy Sdn Bhd\nUOA Corporate Tower\, Lobby A\, Avenue 10\, The Vertical\nBangsar South City\, No 8 Jalan Kerinchi\n59200 Kuala Lumpur\, Malaysia.\nTel: 6019 225 0942 / 6016 806 1760 / 6016 241 3517\nEmail: register@uoa-academy.com\n \n\nhttps://www.surveymonkey.com/r/uoaapb \n \nCancellation & Transfer\nPlease note that should this registration be cancelled fourteen (14) days before the day of the training\, a 50% cancellation charge will be imposed. If cancellation is made seven (7) days before the training\, full payment of the training will be levied. Please note that amendments can only be made to the above arrangement by giving a minimum of three (3) working days’ notice.\n \nDisclaimer: UOA Academy reserves the right to make changes to the venue\, date\, and speaker\, including cancellation of the workshop if warranted by circumstances beyond its control.\n  \n\n  \nJoin Today!
URL:https://uoa-academy.com/events/level-3-microsoft-excel-advance/
END:VEVENT
END:VCALENDAR