Beplugged Tech — home
All courses
Finance

Excel for Banking and Financial Services

Five days of Excel for banking professionals: building financial models, loan amortisation schedules, interest rate calculations, portfolio analysis, and regulatory reports. Every exercise uses banking-sector data and follows the conventions auditors expect.

Duration
5 days
Level
Intermediate
Delivery
In Pretoria, at your offices, or live online
Group size
Individuals or whole teams
What you will learn
  • Build financial models with scenario and sensitivity analysis
  • Create loan amortisation and interest rate calculation tools
  • Analyse portfolio performance and credit risk in Excel
  • Prepare regulatory and management reports
  • Automate recurring calculations and reporting with formulas and macros
Course outline
  1. 1Financial modelling foundations. Model structure, assumptions sheets, scenario toggles and sensitivity tables.
  2. 2Loan and interest calculations. Amortisation schedules, IRR, NPV, PMT and rate functions.
  3. 3Portfolio and risk analysis. Portfolio returns, standard deviation, correlation matrices and VaR approximations.
  4. 4Regulatory and management reporting. Building recurring reports, templates and cross-workbook consolidation.
  5. 5Automation and audit readiness. Named ranges, data validation, worksheet protection, macros and audit-trail formulas.
Upcoming dates
17–21 Feb 2027In person — Pretoria10 seats left
Book

Need a different date? Tell us when suits you — we schedule courses on demand for teams and individuals.

Who it is for

Banking analysts, risk officers, credit managers, treasury staff and compliance officers.

Before you start

Basic Excel use.

How the training runs
  • In person in Pretoria, South Africa; at your offices anywhere; or live online on Microsoft Teams or Google Meet.
  • International delegates are welcome in Pretoria — we arrange invitation letters for visa applications and recommend hotels near the venue.
  • Run for your team only, on dates that suit you, with examples from your own work; or join an open course.
  • Hands-on throughout: learners practise each step on their own device, not just watch.
  • A certificate of completion that can be verified online.
Questions
Where is the training held?

At your offices anywhere in South Africa or at our training centre in Pretoria. For international delegates, we arrange training in Pretoria with joining instructions and hotel recommendations. Live online delivery on Microsoft Teams or Google Meet is also available.

Do you train organisations outside South Africa?

Yes. We work with organisations across Africa and beyond. International delegates can attend in person in Pretoria, South Africa, or join live online. We arrange invitation letters for visa applications and handle all logistics.

Can the course be run for our team only?

Yes. Most courses are run in-house for one organisation, on dates that suit you, with examples from your own work. Larger teams are split into groups.

What do learners receive?

A Beplugged Tech certificate of completion that anyone can verify online. Where a course prepares for a certification exam (Certiport, Microsoft, Oracle, Google), the exam can be arranged at our testing centre or through the certification body.

How do we book, and what does it cost?

Send the enquiry form on this page with the number of people and your preferred dates. We reply within one working day with dates, the full outline and a quote.

Related courses