Loading...

Excel for Banker Seats available

Wishlist

What Will You Learn?

  • Create EMI schedules & interest statements
  • Automate monthly reports & loan sheets
  • Clean & analyze branch/customer data
  • Use Pivot Tables, VLOOKUP, SUMIF, PMT & more
  • Build dashboards for credit & deposit analysis

Course Content

1.Excel Fundamentals for Bankers

  • Introduction to Excel for Banking Tasks
  • Data Entry & Formatting
  • Cell Referencing

2.Data Management & Cleaning

3.Banking Formulas & Functions

4.Loan & Interest Calculations

5.Working with Dates & Time

6.Financial Statements in Excel

7.Dashboards & Reporting

8.Data Analysis for Credit & Risk

9.Excel for Audit & Compliance

10.Automation with Excel (Beginner VBA)

11.Case Studies from Real Banking Work

12.Final Assessment & Certification

Earn a certificate

কোর্সটি সফলভাবে সম্পন্ন করার পর আপনাকে একটি সার্টিফিকেট প্রদান করা হবে।

selected template