04 - P&L in Excel | ILEAD GLOBAL TRAINING CENTER

Autoplay
Autocomplete

Previous Lesson Complete and Continue

IGTC01AF - Excel for Accountants (EN)

01 - Introduction

01 - Excel for accountants (0:48)

02 - 1. Major Tasks in the Accounting Industry

02 - Basics of accounting industry (3:41)
01 - Accounting tasks and career roles (2:09)
03 - Cash flow budgeting in Excel (3:14)
04 - P&L in Excel (4:32)

03 - 2. QuickBooks, Excel, and Small Business Record-Keeping

01 - Small business accounting overview (3:47)
02 - Transactions in QuickBooks and Excel (4:51)
03 - Quarterly profit and loss tracking in Excel (4:39)
04 - QuickBooks and ledger records (3:38)
05 - Taxes and Excel record-keeping (3:58)
06 - Tracking business performance in Excel (4:43)
07 - Pivot tables for accountants (3:58)
08 - Import data from Excel to QuickBooks (4:42)

04 - 3. The General Ledger, Excel, and Corporate Record-Keeping

01 - General ledger overview (4:16)
02 - Recording transactions in a GL (4:54)
03 - GL strings (3:40)
04 - Corporate financial statements in Excel (4:20)
05 - Financial statement links in Excel (3:25)
06 - Key corporate accounting ratios (4:14)
07 - International accounting standards vs. the US (2:14)
08 - XBRL, Edgar, and corporate financial reporting (3:55)

05 - 4. Business Valuation in Excel

01 - Historical statements to forward projections (3:43)
02 - Terminal values in Excel (3:35)
03 - Constructing a business valuation using cash flow analysis (3:42)

06 - Conclusion

01 - Next steps (1:16)

Ex_Files_Excel_for_Accountants_2019Q2

Ex_Files_Excel_for_Accountants_2019Q2

Teach online with

04 - P&L in Excel

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock