Download file: people.highline.edu This is a Business Mathematics Class (Busn Math 135) taught by Mike excelisfun Girvin at Highline Community College. In this video learn how to calculate: 1. Basics of Bank Reconciliation 2. Data Validation Drop Down List For Reconciling column 3. Conditional Formatting to highlight row when you add x to reconcile column
Take Checkbook Register data from multiple sheets and for multiple banks accounts and summarize it based on Account Names. See these tricks: 1.Formula to display different chart of accounts for different companies 2.Formula to summarize account data from different sheets and for different banks accounts 3.Dynamic Formulas that choose different Chart Of Accounts and Different Calculations using the amazing CHOOSE function. 4.See how to use SUMIF to add from some worksheets but not others. 5.See the functions IF, ROWS, COUNTA, CHOOSE, VLOOKUP, INDEX, SUMIF 6.Create Names From Selection 7.Data Validation List 8.Dynamic Ranges using Table / List feature
Video Rating: 4 / 5