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:20231030
DTEND;VALUE=DATE:20231101
DTSTAMP:20260430T193100
CREATED:20230720T005925Z
LAST-MODIFIED:20230720T202900Z
UID:8288-1698624000-1698796799@uoa-academy.com
SUMMARY:Level 1: Microsoft Excel (Fundamental)
DESCRIPTION:Objectives\nMicrosoft Excel is a powerful spreadsheet software used to organize\, analyze\, and present data efficiently. This one-day course is designed for beginners and aims to provide participants with a strong foundation in using Excel for everyday tasks. By the end of the course\, participants will be able to create\, format\, and manipulate spreadsheets\, perform basic calculations\, and gain a good understanding of Excel’s essential features. \nTarget Audience\nThe target audience for this Microsoft Excel Fundamentals – Level 1 course is beginners and individuals with little to no prior experience with Excel. It is ideal for office workers\, students\, administrative professionals\, or anyone who needs to work with data and wants to gain a\nfundamental understanding of Excel’s basic functionalities. \nLearning Outcomes\n● Navigate the Excel interface confidently and efficiently.\n● Create\, save\, and manage spreadsheets and workbooks.\n● Format data and cells to make the spreadsheet visually appealing and organized.\n● Perform basic calculations using formulas and functions\, such as addition\, subtraction\, multiplication\, and division.\n● Develop a solid foundation in Microsoft Excel\, providing a basis for further learning and more advanced Excel courses. \nCourse Outline:\nModule 1: Introduction to Microsoft Excel\n● Excel interface and navigation\n● Working with workbooks and worksheets\n● Basic data entry and editing techniques \nModule 2: Formatting Data and Cells\n● Applying font styles and formatting\n● Adjusting cell alignments and indents\n● Using borders and shading\n● Formatting numbers and dates \nModule 3: Basic Formulas and Functions\n● Understanding cell references (relative and absolute)\n● Performing arithmetic calculations\n● Using SUM\, AVERAGE\, COUNT\, and other essential functions\n● Applying auto-fill and auto-series techniques \nModule 4: Data Sorting and Filtering\n● Sorting data in ascending and descending order\n● Applying custom sorts based on specific criteria\n● Using AutoFilter to filter data \nDay 2:\nModule 5: Working with Tables\n● Creating and managing Excel tables\n● Using table features for data organization and analysis\n● Utilizing the “Total Row” feature to calculate summary statistics within the table\n● Understanding the benefits of using structured references in formulas within tables \nModule 6: Data Visualization with Charts\n● Creating different chart types (column\, bar\, pie\, line\, etc.)\n● Formatting and customizing charts for better visualization\n● Applying chart elements like axis titles and chart titles for better context\n● Modifying chart types and switching rows/columns for varied chart representations \nModule 7: Conditional Formatting\n● Applying conditional formatting to highlight data based on specific rules\n● Using icon sets\, data bars\, and color scales\n● Utilizing conditional formatting to identify duplicates or unique values in data\n● Managing and clearing conditional formatting rules as needed \nModule 8: Printing and Page Setup\n● Previewing and adjusting print settings\n● Page layout and print area settings\n● Printing options for worksheets and workbooks \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-1-microsoft-excel-fundamental/
END:VEVENT
END:VCALENDAR