Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel & Business Math - Bank Reconciliation Made Easy

ExcelIsFun via YouTube

Start learning Write review
Coursera Ad

Coursera Plus Annual Nearly 45% Off

Learn More → CodeSignal Ad

Free AI-powered learning to build in-demand skills

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn the essentials of bank reconciliation and Excel techniques in this comprehensive 45-minute video tutorial. Explore the anatomy of checks, types of endorsements, and common bank services and fees. Master bank reconciliation through practical examples, including how to ensure both sides are equal and how to use a reconciliation form. Discover Excel tips such as displaying two worksheets side-by-side and utilizing Conditional Formatting and Data Validation to highlight reconciled items. Download accompanying materials to enhance your learning experience and gain valuable skills in Excel and business mathematics.

Syllabus

) Introduction.
) Parts of a Checks.
) Types of Endorsements.
) Bank Services & Fees.
) Bank Reconciliation Example 1: Make sure both sides are actually Equal..
) Bank Reconciliation Example 2: Make sure both sides are actually Equal and enter the bank statement entries that are not in our records, into our records.
) Bank Reconciliation Example 3: Bank Reconciliation with a Bank Reconciliation Form.
) How to show two worksheets from the same workbook side-by-side: View, New Window, Arrange All.
) How to use Conditional Formatting and Data Validation to format or highlight row that has an “X” for “item has been reconciled”..
) Summary.

Taught by

ExcelIsFun

Reviews

4.0 rating, based on 1 Class Central review

Start your review of Excel & Business Math - Bank Reconciliation Made Easy

  • Profile image for Lloyd Andrew Baccay
    Lloyd Andrew Baccay
    The Bank Reconciliation Review Course was very informative and easy to understand. It clearly explained the purpose and steps of reconciling bank records with company books. The examples and exercises helped me understand how to identify outstanding checks, deposits in transit, and bank errors. The instructor also provided practical tips on how to handle discrepancies efficiently.

    Overall, it’s a great course for beginners and accounting students who want to strengthen their understanding of cash management and financial accuracy.
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.