Description
Course Outline:
- Logical functions
- Conditional functions
- Financial functions (SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS)
- Text functions
- Date and time functions
- Error functions (ISNA, ISERROR)
- Using lookup functions
- Creating and using names
- Managing names
- Validating cell entries
- Advanced filtering
- Conditional formatting
- Outlining and consolidating data
- Creating subtotals
- Pivot Tables and Pivot Charts
- Working with Pivot Tables
- Modifying Pivot Table data
- FormattingPivotTables
- UsingPivotCharts
- Exporting and importing text files
- Exporting and importing MS Access files
- GoalSeek
- Scenarios
- DataTables
- Running and recording a macro
- Working with VBA code
Resource Speaker:
Ms. Maria Anna Masindo
Whole Brain Training & Consultancy
Schedule:
December 18-19, 2025 (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