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:
14-15 November 2024
Thursday – Friday
9:00 AM – 5:00 PM
Training Fee per Participant:
Member Institution – Php 5,600.00
Non-Member Institution –Php 7,840.00
*VAT inclusive