Excel & Business Math - Bank Reconciliation Made Easy

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

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.