BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//NAST Training & Consultancy Sdn. Bhd. - ECPv5.14.2.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:NAST Training & Consultancy Sdn. Bhd.
X-ORIGINAL-URL:https://nastglobal.com
X-WR-CALDESC:Events for NAST Training & Consultancy Sdn. Bhd.
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Shanghai
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:CST
DTSTART:20220101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Shanghai:20220929T090000
DTEND;TZID=Asia/Shanghai:20220929T170000
DTSTAMP:20260609T111321
CREATED:20220815T171340Z
LAST-MODIFIED:20220815T175008Z
UID:7583-1664442000-1664470800@nastglobal.com
SUMMARY:Microsoft Excel 2016/365-Intermediate
DESCRIPTION:Program  Objective       \nThis course will enable participants to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target audience for this course are participants who desire to gain the skills necessary to manage worksheets\, sort and filter data\, creating charts and using Functions. In addition\, this course is suitable for those interested to step-up a level with existing knowledge of the basics of Excel\, including how to create\, edit\, format\, and print basic worksheets \n  \nPre-requisites \nParticipants should be familiar with using computers and have used a mouse and keyboard. Participants should be comfortable in the Windows environment and be able to use Windows to manage information on their computer \nTo get the most out of this course\, we recommend completion of one of the following courses\, or equivalent knowledge from another source: Windows 7 and above\, and Microsoft Excel 2016 Basic. \n  \nDelivery Method \nInstructor led\, group-paced\, classroom-delivery learning model with structured hands-on activities. \nDuration: 1 Day \nCOURSE Outline \nThe topics in this course are as follows: \nManaging Worksheets \n\nOrganizing Worksheets\nWorking with Multiple Worksheets\nFinding and Replacing Data\n\nFormat as Table \n\nUsing Quick Style\nRemoving Style from a Table\nDefining a Title\nUsing the Total Row Command\nRemoving Duplicates\nUsing a Slicer to View Table Data\nConverting a Table into a Range\n\nUsing Conditional Formatting \n\nApply a Specific Conditional Format\nApply Multiple Conditional Formatting Rules\nUse the Rules Manager to Apply Conditional Formats\n\nData Validation \n\nRestrict Cell Entries to Certain Data Types\nAllow Only Specific Values to Be Entered in Cells\nRemove Duplicate Rows from a Worksheet\n\nSorting Data \n\nSort Data on a Single Criterion\nSort Data on Multiple Criteria\nSort Data Using Cell Attributes\n\nFiltering Data \n\nUsing AutoFilter\nCreating a Custom AutoFilter\nFiltering Data Using Cell Attributes\n\nCreating Charts \n\nBuilding Charts\nFormatting a Chart with a Quick Style\nFormatting the Parts of a Chart Manually\nModifying a Chart\nUsing New Quick Analysis Tools\n\nUsing Functions  \n\nDisplaying Dates and Times with Functions\nSummarizing Data with Functions\nUncovering Formula Errors
URL:https://nastglobal.com/event/microsoft-excel-2016-365-intermediate/
LOCATION:NAST Training & Consultancy Sdn. Bhd.\, B-5-8 Plaza Mont Kiara\, Mont Kiara\, Kuala Lumpur\, 50480\, Malaysia
CATEGORIES:IT and Networking
ORGANIZER;CN="NAST%20Training%20And%20Consultancy":MAILTO:info@nastglobal.com
END:VEVENT
END:VCALENDAR