Tabellab

Excel for Bank Branch Staff: Loans, Deposits, Interest & Fees

20 hands-on labs at a fictional community bank branch: simple vs compound interest, APY with EFFECT, CD maturity values, loan payments and amortization, debt-to-income checks, overdraft fees, cash balancing, cross-sell counts, savings goals, currency exchange and a branch KPI dashboard – plus true loan rates with RATE, home-loan pre-checks with PV, teller staffing, ATM cash, fee waivers, deposit mix, delinquency buckets and a monthly scorecard.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This beginner course teaches the spreadsheet skills used at a bank branch, with a fictional community bank as the example. In 20 hands-on labs you compare simple and compound interest, turn APR into APY with EFFECT, value certificates of deposit with FV, quote loan payments with PMT, split payments with IPMT and PPMT and screen debt-to-income ratios. You calculate overdraft fees, balance a cash drawer, count product holdings, plan savings goals, price foreign currency and build a KPI dashboard. The second part compares loan offers by their true rate with RATE, pre-checks home loans with PV, staffs the teller line by hour, sizes ATM refills, applies fee-waiver rules, analyses the deposit mix, sorts loans into past-due buckets and finishes with a monthly scorecard.

Lessons

  1. Simple vs Compound Interest on Savings DepositsLabFree
  2. APY from APR: Comparing Savings Products with EFFECTLab Locked
  3. Certificates of Deposit: Maturity Values with FVLab Locked
  4. Personal Loans: Monthly Payment and Total Interest with PMTLab Locked
  5. Amortization Schedule: The First Six Payments with IPMT and PPMTLab Locked
  6. Loan Applications: The Debt-to-Income CheckLab Locked
  7. Checking Accounts: Calculating Overdraft FeesLab Locked
  8. End of Day: Balancing the Branch Cash DrawerLab Locked
  9. Cross-Selling: Counting Product Holdings with COUNTIFSLab Locked
  10. Savings Goal Planner: How Long and How Much with NPER and PMTLab Locked
  11. Foreign Currency at the Counter: Buy and Sell Rates with a SpreadLab Locked
  12. Branch KPI Dashboard: Totals, Chart and Target HighlightsLab Locked
  13. Comparing Loan Offers: Origination Fees & the True Annual Rate with RATELab Locked
  14. Home Loan Pre-Check: Housing Ratio, Maximum Payment & Maximum Loan with PVLab Locked
  15. Teller Lines: Arrivals per Hour, Workload & Tellers NeededLab Locked
  16. ATM Cash: Average Daily Withdrawals, Days of Cash Left & Refill AmountsLab Locked
  17. Monthly Account Fees: Waiver Rules with IF and ORLab Locked
  18. Deposit Mix: Balances by Product, Weighted Average Rate & Interest CostLab Locked
  19. Loan Delinquency: Days-Past-Due Buckets, Balances at Risk & a ChartLab Locked
  20. Final Project: Branch Monthly Scorecard – Targets, Attainment, Status & a ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy