Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Excel for Accountants - Formulas, Functions & Formatting to Build Account Templates

ExcelIsFun via YouTube

Start learning Write review

Details

Start learning

Provider

YouTube
Pricing

Free Video
Languages

English
Effort

1 hour 37 minutes
Sessions

Self-Paced
Level

Beginner

Found in

This beginner course teaches Excel fundamentals and practical accounting templates through guided examples covering formulas, functions, formatting, cell references, data validation, conditional formatting, and Flash Fill. Examples include payroll, invoices, amortization tables, investment calculations, and checkbook registers.

Syllabus

) Introduction to video topics and Excel files and how to navigate large workbook and video.
) Keyboards Rule Because They Are Fast.
) Number Formatting is a Façade.
) How to Add Quickly.
) Date Calculation Templates.
) EDATE functions.
) Angry Rabbit Mouse Copy Trick.
) Date Number Formatting.
) Formulas for Date Calculations.
) Absolute & Relative Cell References.
) Excel's Golden Rule.
) Payroll Quickly.
) ROUND Function Importance.
) Formulas Can NOT See Number Formatting.
) Create Cosumer Loan Amortization Table.
) PMT Function to calculate PMT on Annuity with Regular PMT and Constant Rate.
) Fill Series to generate list of numbners from 0 to 360.
) Smart Tags to Fill End of Month Only (And it knows Leap Year!!!).
) Borders to enhance Report.
) Calculations for Amortization Table with Relative and Absolute Cell References.
) Invoice Template.
) VLOOKUP Function.
) Data Validation, List to add Drop-Down List to Cell.
) IF Function.
) ISBLANK Function.
) ROUND Function (link back to earlier part of video) .
) FV of Investment Template.
) Mixed Cell References.
) F4 Key to cycle through 4 different types of Cell References (Merry Go Round).
) FV Function.
) SUMIFS and COUNTIFS to create Summary Reports. Also: Advantage of Formulas Over PivotTable..
) Check Book Register Example.
) Border Formatting.
) Formula with Relative Cell References to calculate Balance.
) IF Function.
) ISNUMBER Function.
) 1) Data Validation For Reconciling Column. 2) Conditional Formatting for whole row using Mixed Cell References.
) Flash Fill to extract and clean Data Quickly.