Excel for Accountants
1h 32mIntermediate2019-04-12
Authors
Michael McDonald
Researcher and Professor of Finance at Fairfield University
Course details
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, 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.
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.
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.
Skills covered
Accounting SkillsSpreadsheetsMicrosoft ExcelFinance and AccountingBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Excel for accountants
1. Major Tasks in the Accounting Industry
- 02 - Accounting tasks and career roles
- 03 - Basics of accounting industry
- 04 - Cash flow budgeting in Excel
- 05 - P&L in Excel
2. QuickBooks, Excel, and Small Business Record-Keeping
- 06 - Small business accounting overview
- 07 - Transactions in QuickBooks and Excel
- 08 - Quarterly profit and loss tracking in Excel
- 09 - QuickBooks and ledger records
- 10 - Taxes and Excel record-keeping
- 11 - Tracking business performance in Excel
- 12 - Pivot tables for accountants
- 13 - Import data from Excel to QuickBooks
3. The General Ledger, Excel, and Corporate Record-Keeping
- 14 - General ledger overview
- 15 - Recording transactions in a GL
- 16 - GL strings
- 17 - Corporate financial statements in Excel
- 18 - Financial statement links in Excel
- 19 - Key corporate accounting ratios
- 20 - International accounting standards vs. the US
- 21 - XBRL, Edgar, and corporate financial reporting
4. Business Valuation in Excel
- 22 - Historical statements to forward projections
- 23 - Terminal values in Excel
- 24 - Constructing a business valuation using cash flow analysis
Conclusion
- 25 - Next steps