About Course

About the Program

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 training, participants will be able to:

1. Identify, assess, and manage credit risk using industry-standard methodologies.
2. Utilize Advanced Excel tools and functions to perform in-depth credit risk analysis and modeling.
3. Interpret financial statements and credit data for informed lending and investment decisions.
4. Structure, visualize, and present credit risk reports effectively to stakeholders using dynamic Excel dashboards.
5. 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

Credit Risk Analysis Training Course Modules

Module 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

Module 2: Credit Data Sorting, Summarizing And Analysis

• Power query
• Excel Data Model
• Advanced Pivot Table Options

Module 3: Understanding Credit Modeling Techniques In Excel

• Advanced credit Excel Tables
• Mixed Cell References
• Excel Add-Inns

Module 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

Module 5: Use Of Excel For Informed Decision Making

• Scenario Manager
• One Way Data Tables
• Two Way Data Tables

Module 6: Designing Effective Excel Credit Models

• Elements of Excel Models
• Good Excel Models Building Habits
• Types of Errors in Excel Models
• Dealing with Errors
• In-Built Auditing Tools
• Model Documentation
• Data Validation using Formulae

Module 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

Module 8: Credit Data Visualization And Presentation

• Designing Charts
• 3D Formatting
• Review of Charts
• Changing source Data
• Introduction to interactive chart
• Power Views
• Interactive Charts
• Advanced Chart Formatting
• Trending Tricks

Module 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

Related Courses

Training on Cost and Management Accounting

Financial Risk Management Training

Zero-Based Budgeting Training