Excel for Banking Professionals

Offered By: LinkedIn Learning

Tags

Corporate Finance Courses Banking Courses Investment Banking Courses Insurance Courses Financial Modeling Courses

Course Description

Overview

Discover the best ways to use Excel for a variety of key tasks in the insurance, commercial banking, and investment banking fields.

Syllabus

Introduction

Using Excel in banking careers

1. Getting Started with Excel in Banking

Excel uses in commercial banking
Excel uses in investment banking
Excel uses in insurance

2. Commercial Banking and Excel

Key tools in Excel for commercial banking
Debits, credits, and transactions in Excel
Commercial banking financial models
Using Excel in loan amortizations
Using Excel in loan portfolios
Building Excel models for commercial banking

3. Investment Banking and Excel

Key tools in Excel for investment banking
Using Excel in merger and acquisition deals
Using Excel in corporate finance actions
Sum of parts modeling in Excel
IPO modeling in Excel
Building Excel models for investment banking

4. Insurance and Excel

Key tools in Excel for insurance
Using Excel in loss modeling
Using Excel in pricing analysis
Scenario analysis with Excel
Investment portfolio management with Excel

Conclusion

Moving forward in banking

Taught by

Michael McDonald

Related Courses

Introduction to Corporate Finance
Wharton School of the University of Pennsylvania via Coursera Основы корпоративных финансов (Fundamentals of Corporate Finance)
Higher School of Economics via Coursera An Introduction to Credit Risk Management
Delft University of Technology via edX Corporate Finance Essentials
IESE Business School via Coursera Corporate Finance I: Measuring and Promoting Value Creation
University of Illinois at Urbana-Champaign via Coursera