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:

 

Training Fee per Participant:

Member Institution – Php7,840.00

Non-Member Institution – Php10,080.00

*VAT inclusive

 

REGISTER HERE!