Excel & Business Math 27: Bank Reconciliation Made Easy

Download Start Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo27BankReconciliation.xlsm
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo27BankReconciliation.pdf
Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm

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. (01:39) Parts of a Checks
3. (06:11) Types of Endorsements
4. (10:15) Bank Services & Fees
5. (13:55) Bank Reconciliation Example 1: Make sure both sides are actually Equal.
6. (15:47) 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. (21:40) Bank Reconciliation Example 3: Bank Reconciliation with a Bank Reconciliation Form
8. (22:10) How to show two worksheets from the same workbook side-by-side: View, New Window, Arrange All
9. (34:00) How to use Conditional Formatting and Data Validation to format or highlight row that has an “X” for “item has been reconciled”.
10. (44:00) Summary

Next Video: 28 Excel & Business Math

Видео Excel & Business Math 27: Bank Reconciliation Made Easy канала ExcelIsFun