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:

22-23 September 2022

Thursday-Friday

9:00 AM - 5:00 PM

Training Fee per Participant:

From Member Institution – P 5,600.00

From Non-Member Institution – P 7,840.00

**VAT inclusive