Excel for Banking Professionals

Focused View

1:47:04

265 View

01 - Introduction

01 - Using Excel in banking careers.mp4

01:01

02 - Getting Started with Excel in Banking

01 - Excel uses in commercial banking.mp4

03:27

02 - Excel uses in investment banking.mp4

05:00

03 - Excel uses in insurance.mp4

04:19

03 - Commercial Banking and Excel

01 - Key tools in Excel for commercial banking.mp4

05:26

02 - Debits, credits, and transactions in Excel.mp4

07:36

03 - Commercial banking financial models.mp4

07:08

04 - Using Excel in loan amortizations.mp4

05:04

05 - Using Excel in loan portfolios.mp4

06:44

06 - Building Excel models for commercial banking.mp4

05:36

04 - Investment Banking and Excel

01 - Key tools in Excel for investment banking.mp4

04:04

02 - Using Excel in merger and acquisition deals.mp4

06:13

03 - Using Excel in corporate finance actions.mp4

05:20

04 - Sum of parts modeling in Excel.mp4

04:13

05 - IPO modeling in Excel.mp4

03:30

06 - Building Excel models for investment banking.mp4

03:10

05 - Insurance and Excel

01 - Key tools in Excel for insurance.mp4

03:03

02 - Using Excel in loss modeling.mp4

04:06

03 - Using Excel in pricing analysis.mp4

06:03

04 - Scenario analysis with Excel.mp4

08:02

05 - Investment portfolio management with Excel.mp4

06:11

06 - Conclusion

01 - Moving forward in banking.mp4

01:48

Exercise Files

Ex_Files_Excel_for_Banking_Professionals.zip

Description

Across the world of banking and finance, Excel is simply indispensable. This critical tool serves as a blank canvas for building business and financial models of all types. In this course, instructor Michael McDonald shows banking professionals how to use Excel to model key questions in the fields of insurance, commercial banking, and investment banking. In the area of commercial banking, Michael covers everything from front-office loan amortization to loan portfolio modeling. For insurance, he examines how to use Excel for issues like loss modeling and pricing analysis. Plus, he shows investment banking professionals how to build models covering merger and acquisition deals, IPO pricing, and corporate actions. Tune in to learn Excel skills that you can apply to the real-world issues you face at work.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Banking

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.