Completed
1. Introduction.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Formulas for Accounting Bank Reconciliation with IF, ISNUMBER and SUM Functions - EMT 1921
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction.
- 2 2. Fundamental problem with tracking bank account balances, and thus why bank reconciliation is such an important accounting task.
- 3 3. Data Validation dropdown list feature to verify that only a y value can be added to the reconciliation column.
- 4 4. #1 Formula to calculate “My Book Balance” using the SUM, IF, and ISNUMBER functions.
- 5 SUM function trick to reference the previous bank balance Relative Cell Reference and not get a #VALUE! Error.
- 6 5. Angry Rabbit Crosshair Trick #1.
- 7 6. Angry Rabbit Crosshair Trick #2.
- 8 7. #2 Formula to calculate “Bank Balance” using the SUM, ISNUMBER, and two back-back nested IF functions.
- 9 8. Angry Rabbit Crosshair Trick #3.
- 10 9. Next video: Dynamic Spilled Array Formula.
- 11 10. Closing.
