Master Your Excel Functions in Professional Way at the Workplace
Excel functions are powerful tool that can help you manipulate and analyze data efficiently. Becoming an Excel expert takes time, practice and a willingness to explore the various features and functionalities in the software. The above course will ensure all participants to be drilled in ensuring their Excel competencies will be increased by the end of the session.
Learning Outcomes
By the end of this program, participants will learn :
- Fundamentals
- The absolute essentials of formulas, call references and basic functions
-
Essential Functions
-
Master the most commonly used functions for calculations and data analysis.
-
-
Logical & Text Functions
-
Create powerful decision-making formulas and manipulate text strings with ease.
-
-
Lookup & Reference Functions
-
Perform advanced data lookups using VLOOKUP, HLOOKUP, XLOOKUP, and INDEX/MATCH.
-
-
Dynamic Array Functions
-
Harness the power of Excel's latest functions to filter, sort, and extract data dynamically.
-
-
Practical Applications
-
Apply your knowledge through hands-on exercises and real-world case studies.
-
Prerequisites
Participants are require to have basic knowledge about computer usage.
Course Outline
Topic to be covered :
-
Relative and Absolute Cell Reference
-
Concatenate function
-
Date and DATEDIF functions
-
EDATE and EOMONTH functions
-
CHOOSE and SWITCH functions
-
LEFT, MID, RIGHT & LEN functions
-
SORT and SORTBY functions
-
FILTER and UNIQUE functions
-
VLOOKUP functions
-
XLOOKUP functions0
-
Approximate MATCH with VLOOKUP functions
-
DROP DOWN List & Filtering
-
Dependent DROP DOWN List
-
Most Comman Excel Shortcut Keys
About This Course
Excel functions are powerful tool that can help you manipulate and analyze data efficiently. Becoming an Excel expert takes time, practice and a willingness to explore the various features and functionalities in the software. The above course will ensure all participants to be drilled in ensuring their Excel competencies will be increased by the end of the session.
Learning Outcomes
By the end of this program, participants will learn :
- Fundamentals
- The absolute essentials of formulas, call references and basic functions
-
Essential Functions
-
Master the most commonly used functions for calculations and data analysis.
-
-
Logical & Text Functions
-
Create powerful decision-making formulas and manipulate text strings with ease.
-
-
Lookup & Reference Functions
-
Perform advanced data lookups using VLOOKUP, HLOOKUP, XLOOKUP, and INDEX/MATCH.
-
-
Dynamic Array Functions
-
Harness the power of Excel's latest functions to filter, sort, and extract data dynamically.
-
-
Practical Applications
-
Apply your knowledge through hands-on exercises and real-world case studies.
-
Prerequisites
Participants are require to have basic knowledge about computer usage.
Course Outline
Topic to be covered :
-
Relative and Absolute Cell Reference
-
Concatenate function
-
Date and DATEDIF functions
-
EDATE and EOMONTH functions
-
CHOOSE and SWITCH functions
-
LEFT, MID, RIGHT & LEN functions
-
SORT and SORTBY functions
-
FILTER and UNIQUE functions
-
VLOOKUP functions
-
XLOOKUP functions0
-
Approximate MATCH with VLOOKUP functions
-
DROP DOWN List & Filtering
-
Dependent DROP DOWN List
-
Most Comman Excel Shortcut Keys
Upcoming Sessions
There are currently no scheduled sessions for this course.
We'll notify you when new sessions are scheduled
Your Instructor
Graduated from Universiti Teknologi Malaysia with a bachelor’s degree in computer science in 2001, Kharil Iszuddin Is...
Upcoming Sessions
There are currently no scheduled sessions for this course.
We'll notify you when new sessions are scheduled
Course Information
Your Instructor
Khairil-Iszuddin bin Ismail
Professional Experience
Graduated from Universiti Teknologi Malaysia with a bachelor’s degree in computer science in 2001, Kharil Iszuddin Is...
View Profile