Modes of Training Delivery
 Virtual: Live Streaming, Face to Face
 In-Class

Microsoft Excel 2016 Power Functions

Learn the Next Level of Advanced Functions in Microsoft Excel

Businesses are constantly challenged with obtaining information and results quickly to more complex conditions. It is no longer merely getting simple totals and averages from a list of values but now based on a condition or multiple conditions.

With demands that push for faster and more accurate data, data retrieval have become more challenging which requires the extraction of specific data from a string of data or from specific cell or cells that satifies certain conditions.

Working with dates in Excel have become increasingly common in daily work such as determining the week of the week from a given date or number of working days between two given dates, or converting a text string into an Excel date format.

This 2-day course will help you achieve such challenges and demands in Microsoft Excel and more. Design and paced with lots of hands-on practices to ensure you understand and become familiar with the many helpful functions that will be covered.

Who is this course for?

Learners who have attended our Microsoft Excel 2016 Basic to Intermediate module or must be well versed in those topics covered in the module.

Public Sector - Div. 1, 2 & 3
Private Sector - Applicable to All

Course Outline for MS Excel 2016 Power Functions

• Tips and Shortcuts
• Using Information Functions to handle errors and validations
• Using IFS Functions to perform calculations on data
• Using Statistical and Maths Functions to perform data analysis and calculations
• Using Date Functions to perform date value computations
• Using Text and Lookup to perform searches on data
• Using Database Functions to calculate statistics

Questions to Ask Yourself

I am a very experienced user of an earlier version of Microsoft Excel; can I take up this course?

Yes, you can, ONLY IF you are familiar with the Excel 2016 interface, well-versed in formula creation and know how to use basic Excel functions, otherwise we would recommend you first attend our Microsoft Excel 2016 Basic to Intermediate module before attending this course.

After completing this course do I still need to take up your Microsoft Excel 2016 Advanced module?

Yes, this is not a replacement course of our Advanced Excel module which covers other essential Excel skills that you would need.