Intermediate Excel Training for Bankers

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