Become a better accountant with the power of Microsoft Excel. Learn how to use it for general ledger entry, forecasting, business valuation, interacting with QuickBooks, and more.
Overview
Syllabus
Introduction
- Excel for accountants
- Accounting tasks and career roles
- Basics of accounting industry
- Cash flow budgeting in Excel
- P&L in Excel
- Small business accounting overview
- Transactions in QuickBooks and Excel
- Quarterly profit and loss tracking in Excel
- QuickBooks and ledger records
- Taxes and Excel record-keeping
- Tracking business performance in Excel
- Pivot tables for accountants
- Import data from Excel to QuickBooks
- General ledger overview
- Recording transactions in a GL
- GL strings
- Corporate financial statements in Excel
- Financial statement links in Excel
- Key corporate accounting ratios
- International accounting standards vs. the US
- XBRL, Edgar, and corporate financial reporting
- Historical statements to forward projections
- Terminal values in Excel
- Constructing a business valuation using cash flow analysis
- KPIs and Excel
- Waterfall charts in Excel
- Using financial ratios in Excel
- Variances in Excel
- Using Excel for regressions in audit work
- Thanks for taking this course. After this video, you'll be able to locate additional resources to enhance your knowledge of Excel for accounting tasks
Taught by
Michael McDonald