Excel Formulas & Functions (V2007) (MDA126)

17 August 2017 - 18 August 2017

OBJECTIVE
To master operators, error values, naming techniques, to understand and apply the build in functions and array formulas in Excel

COURSE OUTLINE

Module A: About Formula
• Operators in Formulas
• Cell and Range Reference
• Convert Formulas to Values
• Hiding Formulas

Module B: About Range Names
• Naming Methods
• Create Multisheet Names
• Working with Range and Cell Names
• Problems with Range Names
• Use Functions to Name a Range

Module C: About Worksheet Functions
• Function Argument Types
• Ways to Enter Functions
• Text Functions
• Date & Time-Related Functions
• Counting & Summing Functions
• Lookup Functions
• Database Functions
• Rounding Numbers

Module D: About Array
• Introduction on Array Formulas
• Dimensions of Array
• Working with Array Formulas
• Using Single-Cell and Multicell Array Formulas

Module E: Debugging Formulas
• Formula Problems and Solutions
• Using Excel Auditing Tools

Pre-requisite
MS Excel (Intermediate-Advance) 2007

DURATION
2 days

COURSE FEE
Program 100% Claimable Under SBL Khas Scheme
PSDC Members: RM 580/pax
Non-Members:   RM 630/pax

DATES
19 – 20 April 2017
17 – 18 August 2017

*Training dates are subject to changes