Excel for Accountants | 2+ hrs Video Course

Excel for Accountants, bookkeeper or financial analyst |2+ hrs Video Course

Become a better accountant, bookkeeper, or financial analyst with Microsoft Excel. Excel can be used for profit-and-loss (P&L) reporting, forecasting sales, business valuation, quickly analyzing data from programs like QuickBooks, and more. This course shows you how to perform key accounting tasks in Excel, including small business and corporate record-keeping, and importing and exporting data from QuickBooks to Excel. Professor shows how to record transactions in a general ledger, categorize expenses for taxes, track business performance, use key financial statements, and do a business valuation. The course is for working professionals and business students alike, with short, focused lessons to give you maximum learning in the minimum amount of time

Topics covered |duration : 2+ hrs Video Course

01 Major Tasks in the Accounting Industry

02 QuickBooks, Excel, and Small Business Record-Keeping

03 The General Ledger, Excel, and Corporate Record-Keeping

04 Business Valuation in Excel