{"id":109,"date":"2023-02-15T07:02:33","date_gmt":"2023-02-15T07:02:33","guid":{"rendered":"https:\/\/nils.gov.lk\/2019\/07\/15\/targeted-email-campaign-2\/"},"modified":"2023-02-19T15:30:52","modified_gmt":"2023-02-19T15:30:52","slug":"microsoft-excel-advanced-skills","status":"publish","type":"post","link":"https:\/\/nils.gov.lk\/?p=109","title":{"rendered":"Microsoft Excel 365 Advanced Skills"},"content":{"rendered":"\n

Content<\/strong><\/p>\n\n\n\n

\u27a2 Using Logic statements to make decisions
\u27a2 Data Management & handling using VLOOKUP, HLOOKUP, MATCH, INDEX and other
advanced functions
\u27a2 Conditional Formatting
\u27a2 Drop Down Lists & Unique
Values
\u27a2 Pivot Tables & Pivot Charts
\u27a2 Text Functions
\u27a2 Time & Date Functions<\/p>\n\n\n\n

\n

15th, 16th & 17th
February 2023
08.30 am- 5.00 pm<\/p>\n\n\n\n

20,500\/=<\/strong>
(Certificates, Stationeries, Lunch
& refreshments included)<\/p>\n<\/blockquote>\n\n\n\n

Introducing the Microsoft Excel 365 Advanced Skills workshop designed for Development Officers in Management Assistance engaged in public sector support services related to procurement, including Technical Officers, other related officers, and officers in equivalent categories.<\/p>\n\n\n\n

This workshop is designed to provide attendees with advanced Microsoft Excel skills that will help them streamline their work processes and improve their productivity. The workshop will cover a variety of topics, including using logic statements to make decisions, data management and handling using VLOOKUP, HLOOKUP, MATCH, INDEX and other advanced functions, conditional formatting, drop-down lists, unique values, pivot tables, pivot charts, text functions, time, and date functions.<\/p>\n\n\n\n

By attending this workshop, attendees will learn how to automate repetitive tasks, organize and analyze data more effectively, and gain insights into complex data sets. This workshop will also enable attendees to develop more efficient and effective strategies for managing data and generating insights, which will ultimately lead to improved decision-making and enhanced organizational performance.<\/p>\n\n\n\n

This workshop is ideal for Development Officers in Management Assistance, Technical Officers, other related officers, and officers in equivalent categories who work in the public sector and want to advance their Microsoft Excel skills. Whether you are an experienced Excel user or just getting started, this workshop will provide you with the advanced skills and knowledge needed to take your work to the next level.<\/p>\n\n\n\n

Don’t miss this opportunity to enhance your skills and increase your productivity. Sign up for the Microsoft Excel 365 Advanced Skills workshop today and take your Excel skills to the next level.<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Content \u27a2 Using Logic statements to make decisions\u27a2 Data Management & handling using VLOOKUP, HLOOKUP, MATCH, INDEX and otheradvanced functions\u27a2 Conditional Formatting\u27a2 Drop Down Lists & UniqueValues\u27a2 Pivot Tables & Pivot Charts\u27a2 Text Functions\u27a2 Time & Date Functions 15th, 16th & 17thFebruary 202308.30 am- 5.00 pm 20,500\/=(Certificates, Stationeries, Lunch& refreshments included) Introducing the Microsoft Excel […]<\/p>\n","protected":false},"author":1,"featured_media":384,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[40,41,42],"class_list":["post-109","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-app","tag-book","tag-reading"],"_links":{"self":[{"href":"https:\/\/nils.gov.lk\/index.php?rest_route=\/wp\/v2\/posts\/109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nils.gov.lk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nils.gov.lk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nils.gov.lk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nils.gov.lk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=109"}],"version-history":[{"count":3,"href":"https:\/\/nils.gov.lk\/index.php?rest_route=\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":390,"href":"https:\/\/nils.gov.lk\/index.php?rest_route=\/wp\/v2\/posts\/109\/revisions\/390"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nils.gov.lk\/index.php?rest_route=\/wp\/v2\/media\/384"}],"wp:attachment":[{"href":"https:\/\/nils.gov.lk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nils.gov.lk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nils.gov.lk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}