Excel for Accountants [Updated: 2/23/2024]
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 4m | 341 MB
Instructor: Michael McDonald
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 4m | 341 MB
Instructor: Michael McDonald
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 Michael McDonald shows how to record transactions in a general ledger, categorize expenses for taxes, track business performance, use key financial statements, do a business valuation, and more. 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.
Learning objectives
- List the most common tasks and approaches faced by accountants in their daily lives.
- Determine whether transactions can be exported from Quickbooks to Excel or not.
- Outline the structure that the SUMIF function uses.
- Explain how to measure EBITDA.
- Identify at what level the General Ledger tracks expenses.
- Break down how to construct a business valuation using a cash flow analysis.