01 - Introduction
02 - 1. Major Tasks in the Accounting Industry
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
06 - Conclusion
Ex_Files_Excel_for_Accountants_2019Q2
