Excel & Business Math 27: Bank Reconciliation Made Easy
Download Start Excel File: http://ift.tt/2Bxb4zg
Download pdf Notes: http://ift.tt/2o0wqgO
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn about checks and Bank Reconciliation. Learn about the concepts of why and how we perform bank reconciliation. Also learn about how to show two worksheets from the same workbook side-by-side. Also learn hoe to create Conditional Formatting and data Validation to format or highlight a row in a checkbook register.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. Parts of a Checks
3. Types of Endorsements
4. Bank Services & Fees
5. Bank Reconciliation Example 1: Make sure both sides are actually Equal.
6. 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
7. Bank Reconciliation Example 3: Bank Reconciliation with a Bank Reconciliation Form
8. How to show two worksheets from the same workbook side-by-side: View, New Window, Arrange All
9. How to use Conditional Formatting and Data Validation to format or highlight row that has an “X” for “item has been reconciled”.
10. () Summary
Next Video: 28 Excel & Business Math