Completed
) Introduction to video topics and Excel files and how to navigate large workbook and video
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Excel for Accountants - Formulas, Functions & Formatting to Build Account Templates
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction to video topics and Excel files and how to navigate large workbook and video
- 2 ) Keyboards Rule Because They Are Fast
- 3 ) Number Formatting is a Façade
- 4 ) How to Add Quickly
- 5 ) Date Calculation Templates
- 6 ) EDATE functions
- 7 ) Angry Rabbit Mouse Copy Trick
- 8 ) Date Number Formatting
- 9 ) Formulas for Date Calculations
- 10 ) Absolute & Relative Cell References
- 11 ) Excel's Golden Rule
- 12 ) Payroll Quickly
- 13 ) ROUND Function Importance
- 14 ) Formulas Can NOT See Number Formatting
- 15 ) Create Cosumer Loan Amortization Table
- 16 ) PMT Function to calculate PMT on Annuity with Regular PMT and Constant Rate
- 17 ) Fill Series to generate list of numbners from 0 to 360
- 18 ) Smart Tags to Fill End of Month Only (And it knows Leap Year!!!)
- 19 ) Borders to enhance Report
- 20 ) Calculations for Amortization Table with Relative and Absolute Cell References
- 21 ) Invoice Template
- 22 ) VLOOKUP Function
- 23 ) Data Validation, List to add Drop-Down List to Cell
- 24 ) IF Function
- 25 ) ISBLANK Function
- 26 ) ROUND Function (link back to earlier part of video)
- 27 ) FV of Investment Template
- 28 ) Mixed Cell References
- 29 ) F4 Key to cycle through 4 different types of Cell References (Merry Go Round)
- 30 ) FV Function
- 31 ) SUMIFS and COUNTIFS to create Summary Reports. Also: Advantage of Formulas Over PivotTable.
- 32 ) Check Book Register Example
- 33 ) Border Formatting
- 34 ) Formula with Relative Cell References to calculate Balance
- 35 ) IF Function
- 36 ) ISNUMBER Function
- 37 ) 1) Data Validation For Reconciling Column. 2) Conditional Formatting for whole row using Mixed Cell References
- 38 ) Flash Fill to extract and clean Data Quickly
