About This Course
-
Learning Objectives
Individuals will be adapted with the various advanced features and functions. Working files are included, for further understanding and follow up throughout the lessons.
Prerequisites
Microsoft Excel Basic knowledge is required.
Target Audience
Participants who have basic Microsoft Excel knowledge and wants to pursue further. This course is for individuals whose job responsibilities include maintaining data protection, handling complex formulas, tools and analysis as well as making use of Macros.
Training Outline
- Using Cell References In Formulas
- Conditional Formatting
- Text Manipulation Functions
- Data Tools
- Conditional Functions
- Introducing Lookup Formulas
- Protection
- Index & Match
- Charts
- Pivot Table