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:
February 13-14, 2025 (Thursday – Friday) 9:00 AM – 5:00 PM
Training Fee per Participant:
Member Institution – Php 7,840.00
Non-Member Institution – Php 10,080.00
*VAT inclusive