SMS-115     Productive Formulas & Functions for Corporates in Excel

• Overview
• Course Objectives
• Course Content
• For Whom
• Schedule and Hours

<

>

This course is intended for users of Microsoft Office Excel who want to learn about useful formulas and functions. Get to know the COMPULSORY and Essential Excel Fundamental to understand and learn new and advanced Excel features with ease. How to work with Functions you have never worked with before. Learning skills in solving tricky problems without memorising formulas and functions.

After completing this course, students will be able to:

• Apply Formula and Functions Basic
• Statistical and Logical Functions
• Lookup and Reference Formulas
• Text Formulas
• Date and Time Formulas
• Array and Database Functions
• Efficiency Tips 

• Making Data Work for You
• Statistical and Logical Functions
• Understanding Data Model
• Date and Time Formulas 
• Solving Problems with Array Formulas
• Lookup and Reference Functions
• Productive Less-known Features in Excel with Special Tips and Tricks

This workshop is designed for administrative, executives or managers who would like to learn about useful formulas and functions.  

This is a 2-days programme.
​
This course runs from 9:00am – 5:00pm with an hour for lunch and periodic short breaks.
 
This is an intensive session designed to include as much discussion as possible. Lunch and breaks provide an opportunity for further questioning and discussion with the instructors.

We are HRD Corp (Human Resource Development Corporation) Registered Training Provider.
​All of our training modules are claimable under HRD Corp.