Excel for Banking Professionals

Excel for Banking Professionals

1h 47mIntermediate2021-07-22

Authors

Michael McDonald

Michael McDonald

Researcher and Professor of Finance at Fairfield University

Course details

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.

Skills covered

Personal FinanceCorporate FinanceSpreadsheetsMicrosoft ExcelFinance and AccountingPersonaProfessional DevelopmentBusiness Software and ToolsMicrosoft

Concepts

Introduction

  • Using Excel in banking careers

Getting Started with Excel in Banking

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

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

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

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
40,000 Toman