Description
By the end of the module, the students will be able to execute advance functions of Excel, create business forms, time management system, sales tracking and analysis and more. This module is made specially for managers and supervisors.
Topics Covered:
- Logical functions
- Conditional functions
- Financial functions (SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS)
- Validating cell entries
- Advanced filtering
- Conditional formatting
- Outlining and consolidating data
- Creating subtotals
- PivotTables and PivotCharts
- Formatting PivotT ables
- Using PivotCharts
- Data Tables
- Excel Dashboard Using Pivot Tables
- Text
· Table
· Dynamic Data · Pivot
· Pivot Charts
· Slicer
Resource Speaker:
Ms. Maria Anna Masindo
Whole Brain Center for Business Intelligence
Schedule:
February 24-25, 2025 (Monday – Tuesday) 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