Best Excel Modeling Courses to Learn Retail Banking and Consumer Lending?

I recently joined the Strategy team at a retail bank and will be working on a project focused on deposit gathering and payroll linked lending.

I have a background in strategy consulting and some financial modeling experience, but I'm a bit rusty and not particularly familiar with the economics and mechanics of retail banking.

I'm looking to get up to speed quickly, especially on how banks make money, loan portfolio economics, credit risk, and financial modeling in Excel.

Any recommendations for courses, modeling programs, or other resources? Ideally something hands on and specific to banking rather than generic corporate finance.

3 Comments
 

Based on the most helpful WSO content, here are some excellent Excel modeling courses and resources tailored to your needs in retail banking and consumer lending:

  1. WSO Elite Modeling Package
    This package includes six comprehensive courses, such as:

    • Excel Modeling Course: A foundational course covering Excel efficiency, shortcuts, and best practices.
    • Financial Statement Modeling: Learn to build 3-statement models, which are crucial for understanding bank financials.
    • Valuation Modeling Course: Focuses on trading and precedent comps, which can help analyze bank performance.
    • LBO Modeling Course: While more private equity-focused, it can provide insights into loan portfolio structuring.
  2. Excel Modeling Best Practices
    This course emphasizes advanced Excel formulas, Index Match, and conditional formatting, which are essential for building robust models in retail banking.

  3. DCF Modeling Training - Free Guide
    While not specific to retail banking, this guide can help you understand cash flow mechanics, which are relevant for deposit gathering and loan portfolio analysis.

  4. WSO Financial Modeling Templates
    These templates include pre-built models for various scenarios, which can save time and provide a hands-on learning experience.

  5. Industry Reports and Technical Knowledge Articles
    WSO offers resources on banking-specific topics, such as credit risk, loan portfolio economics, and deposit gathering strategies. These can complement your modeling skills with industry insights.

For a hands-on and banking-specific approach, the WSO Elite Modeling Package is highly recommended, as it combines technical modeling skills with practical applications in finance.

Sources: Top Financial Modeling Courses - List of Top Financial Analyst Courses, Seeking advice on Corporate Banking modeling, Excel Master Bootcamp (4-Hour) OPEN NOW - July 23 - Only 15 Seats, Banking, eh?, Real Estate Skills: Excel and VBA Courses

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

Velit aspernatur et provident. Voluptates alias repellat corrupti est et laboriosam quis. Aut dolore consequatur tenetur velit quia impedit nihil. Sapiente nulla et non fugit labore quia sunt.

Sequi corrupti dicta voluptatem id saepe quo. Sit et est omnis. Neque qui accusamus quia quisquam quibusdam quas atque nobis.

Rerum perspiciatis dolorem enim voluptatem hic ratione. Quod laborum aut qui ut ad. Sequi totam quia officia et deleniti ad quod.

Soluta totam velit et labore rerum ratione. Quaerat ut eius nisi iste. Quo aut eligendi sint qui ut incidunt. Maxime vero eius non et. Quibusdam quae vero enim quia earum corrupti.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
DrApeman's picture
DrApeman
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”