About Course

Credit Risk Analysis Training: Using Advanced Excel

Category: Accounting and Finance Training

Overview

The Expedition

This Credit Risk Analysis Training Using Advanced Excel training equips participants with practical skills to assess and manage credit risk using real data. You will learn to analyze credit information, build risk models and present findings through dynamic Excel dashboards.

The course is available both online and in person. A Certificate of Completion is awarded to all participants who finish the training.

Program Objectives

By the end of this credit risk analysis training Course, participants will be able to:

Identify, assess, and manage credit risk using industry-standard methodologies.
Utilize Advanced Excel tools and functions to perform in-depth credit risk analysis and modeling.
Interpret financial statements and credit data for informed lending and investment decisions.
Structure, visualize, and present credit risk reports effectively to stakeholders using dynamic Excel dashboards.
Develop customized risk scoring models and decision-support tools for credit evaluation.

Target Audience

This course is recommended for credit officers, credit analyst, credit managers, loan officers, loan monitoring and evaluation department, loan recovery officers and branch managers

Training Period

In-Person: 5Days

Virtual: 7Days

Training Modules

1: An Introduction To Credit Risk Analysis

The Foundations of Credit Risk Analysis
The risk and return profile in the context of credit risk analysis
How is credit risk undertaken?
The 5 Cs of credit risk
Why the banks undertake credit risk analysis
How Credit Risk is Undertaken
Product Design
Credit Analysis
Monitoring
Loan Repayment

2: Credit Data Sorting, Summarizing And Analysis

Power query
Excel Data Model
Advanced Pivot Table Options

3: Understanding Credit Modeling Techniques In Excel

Advanced credit Excel Tables
Mixed Cell References
Excel Add-Inns

4: Excel Functions And Tools For Credit Decisions

Look up & Reference Functions (Lookup, Offset, Choose, Get Pivot
• Data, Index, Match
• Logical Functions (Nested IF, And, True, False, Not, Or)
• Working with Array Formulas
• Conditional formatting using Formulae
• Application of Excel camera

5: Use Of Excel For Informed Decision Making

Scenario Manager
One Way Data Tables
Two Way Data Tables

6: Designing Effective Excel Credit Models

7: More Excel Functions And Tools For Credit Reporting

Writing, Editing and using Macros
Form Controls and Active Controls
Button, Combo Box, Check Box, Spin Button, Option Button, Scroll Bar

8: Credit Data Visualization And Presentation

9: Writing A Credit Report

Sharing Workbooks
Editing a shared Workbook
Stopping sharing a Workbook

Delivery Method

This program is taught through a mix of practical activities, theory, group work and case studies. Training manuals and additional reference materials are provided to the participants

Certification

Upon successful completion of the training, participants will be awarded a certificate of course completion

Financial Risk Management Training

Zero-Based Budgeting Training

Course Training Calendar

Kindly note that you can customize venue when registering

Date

Venue

Kenyan Price

Non Kenyan

8 Dec - 12 Dec

Nairobi

110000

1200

19th Jan-23rd Jan 2026

Nairobi

110000

1200

26th Jan-30th Jan 2026

Nairobi

110000

1200

2nd Feb- 6th Feb

Nairobi

110000

1200

16th Feb-20th Feb

Nairobi

110000

1200

9th Mar-13th Mar

Nairobi

110000

1200

23rd Mar-27th Mar

Nairobi

110000

1200

6th Apr-10th Apr

Nairobi

110000

1200

20th Apr-24th Apr

Nairobi

110000

1200

11th May-15th May

Nairobi

110000

1200

25th May-29th May

Nairobi

110000

1200

8th Jun-12th Jun

Nairobi

110000

1200

22nd Jun-26th Jun

Nairobi

110000

1200

13th Jul-17th Jul

Nairobi

110000

1200

Agricultural Marketing Training- Kenya

Cynet

Climate Change and Agriculture Training

5 Days

All levels

0 Lessons

0 Quizzes

0 Students

Agricultural Marketing Training equips participants with the skills to transition agricultural production from subsistence to...

$1,200.00

Crisis Management and Organizational Resilience Training

Cynet

Governance and Leadership

5 Days

All levels

0 Lessons

0 Quizzes

0 Students

This Crisis Management and Organizational Resilience training helps professionals build the skills to handle risks...

$1,200.00

EXECUTIVE LEADERSHIP DEVELOPMENT.

Cynet

Governance and Leadership

5 Days

All levels

31 Lessons

0 Quizzes

1 Student

About the Program Executive leadership development- An Executive Leadership Development Program is a structured and...

$1,200.00

Agriculture Value Chain Management and Market Linkages

Cynet

Customer Experience and Communication Training

5 Days

All levels

32 Lessons

0 Quizzes

0 Students

About the Program Value chains encompass the full range of activities and services required to...

$1,200.00

Data Processing and Management using CSPro Training

Cynet

Mobile Data Collection Training

5 Days

All levels

0 Lessons

0 Quizzes

0 Students

The Data Processing and Management using CSPro Training program is designed to build participants’ skills...

$1,200.00

Cash Flow Liquidity Management Training | Kenya

Cynet

Accounting and Finance Training

5 Days

All levels

0 Lessons

0 Quizzes

0 Students

About the Program Cash Flow Liquidity Management Training gives treasury professionals the skills to forecast...

$1,200.00

MOBILE DATA COLLECTION USING ODK TRAINING

Cynet

5 Days

All levels

43 Lessons

0 Quizzes

0 Students

Program Background Technology has introduced new ways of collecting data for monitoring and evaluation that...

$1,200.00

About Course

Credit Risk Analysis Training: Using Advanced Excel

Program Objectives

Target Audience

Training Period

Training Modules

1: An Introduction To Credit Risk Analysis

2: Credit Data Sorting, Summarizing And Analysis

3: Understanding Credit Modeling Techniques In Excel

4: Excel Functions And Tools For Credit Decisions

5: Use Of Excel For Informed Decision Making

6: Designing Effective Excel Credit Models

7: More Excel Functions And Tools For Credit Reporting

8: Credit Data Visualization And Presentation

9: Writing A Credit Report

Delivery Method

Certification

Related Courses

Curriculum

Course Training Calendar

Kindly note that you can customize venue when registering

Agricultural Marketing Training- Kenya

Crisis Management and Organizational Resilience Training

EXECUTIVE LEADERSHIP DEVELOPMENT.

Agriculture Value Chain Management and Market Linkages

Data Processing and Management using CSPro Training

Cash Flow Liquidity Management Training | Kenya

MOBILE DATA COLLECTION USING ODK TRAINING

Newsletter

Head Office

Drop a Line

Email Address

Visit office

Uganda Office

Drop a Line

Email Address

Visit office

About Course

Credit Risk Analysis Training: Using Advanced Excel

Program Objectives

Target Audience

Training Period

Training Modules

1: An Introduction To Credit Risk Analysis

2: Credit Data Sorting, Summarizing And Analysis

3: Understanding Credit Modeling Techniques In Excel

4: Excel Functions And Tools For Credit Decisions

5: Use Of Excel For Informed Decision Making

6: Designing Effective Excel Credit Models

7: More Excel Functions And Tools For Credit Reporting

8: Credit Data Visualization And Presentation

9: Writing A Credit Report

Delivery Method

Certification

Related Courses

Curriculum

Course Training Calendar

Kindly note that you can customize venue when registering

Newsletter

Head Office

Uganda Office

Modal title