➢ Using Logic statements to make decisions
➢ Data Management & handling using VLOOKUP, HLOOKUP, MATCH, INDEX and other
➢ Conditional Formatting
➢ Drop Down Lists & Unique
➢ Pivot Tables & Pivot Charts
➢ Text Functions
➢ Time & Date Functions
15th, 16th & 17th
08.30 am- 5.00 pm
(Certificates, Stationeries, Lunch
& refreshments included)
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.
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.
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.
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.
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.