Description
Learn the Next Level of Advanced Functions in Microsoft Excel
Course Code: VTLOKEPF6
Duration: 2 Days (14 Hours)
Course Description:
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.
This course is 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 – Division 1, 2 & 3
Private Sector – Applicable to All
Course Outline
- 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.
For Your Delight
Refreshments are provided for morning and afternoon tea breaks.A Certificate of Attendance will be given subject to 90% attendance.
Course Customisation
We can tailor this course to suit your needs in terms of course dates, times and location. If you are an organisation, we can further customise the course to meet your training needs and requirements.