Loading, Please wait..

Advanced Excel Training for Bankers

ADVEXCEL001 | Information Technology & Security
Online
Mode

Duration

Schedule:
Registration:

Description
Course Outline:

V-Lookup Function
Logical If
Nested Ifs
Conditional Formatting
Sumif and Sumifs
Countif and Countifs
Pivoting table & Chart
Concatenate Functions
Upper, Lower and Proper
Left, Right and MID Formulas
Excel Dashboard Using Functions
Importing Data
INDEX-MATCH
VLOOKUP
Preparing data
AVERAGEIF
ERROR / IFERROR
INDIRECT
OFFSET
MINIF
MAXIF
REPT

Resource Speaker:
Ms. Maria Anna Masindo
Whole Brain Center for Business Intelligence

Schedule:
November 26 - 27, 2026 (Thursday - Friday) 9:00 AM - 5:00 PM

Training Fee per Participant:
Member Institution - Php7,840.00
Non-Member Institution - Php10,080.00

*VAT inclusive

About this
Mode:Online
Provider

Bankers Institute of the Philippines, Inc. (BAIPHIL)

Address

Unit 2103, The Peak Tower Condominium, 107 Leviste St., Salcedo Village
Makati City, Philippines 1227