This is a past event. Registration is closed. View other Bankers Institute of the Philippines, Inc. events.

Event Details

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

Wholebrain Training & Consultancy


Schedule:

23-24 February 2022

Wednesday-Thursday

9:00 AM - 5:00 PM


Training Fee:

From Member Institution – P 4,480.00


From Non-Member Institution – P 6,720.00


**VAT inclusive

Menu