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.
 

Voluptas sapiente eos suscipit dolor nihil. Harum sit voluptatum consequuntur mollitia qui. Accusantium quod molestias dolorem qui aspernatur. Ipsa provident voluptas pariatur. Ad tempore vitae dicta deserunt sed enim.

Impedit dolores harum qui aspernatur est deleniti perferendis. Maiores neque eos illum architecto autem. Sed ducimus animi culpa deleniti facilis quos et rerum.

Career Advancement Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 07 97.9%
  • Guggenheim Partners 01 97.4%

Overall Employee Satisfaction

October 2026 Investment Banking

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

Professional Growth Opportunities

October 2026 Investment Banking

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

Total Avg Compensation

October 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
CompBanker's picture
CompBanker
98.9
6
DrApeman's picture
DrApeman
98.9
7
GameTheory's picture
GameTheory
98.9
8
dosk17's picture
dosk17
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
bolo up's picture
bolo up
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...”