Excel Formulas & Functions (V2010) (MDA137)

22 September 2017 - 23 September 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) 2010

DURATION
2 days

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

DATES
22 – 23 September 2017
14 – 15 November 2017

*Training dates are subject to changes