Author
Michael McDonald
Updated
4/12/2019Released
1/25/2019- 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.
Skill Level Intermediate
Duration
Views
- [Michael] Excel is an underappreciated tool in a variety of fields, and this is certainly true in accounting. Excel can be used for profit and loss reporting, for making forecasts related to sales, expenses, and net income, and for business valuation. Tools like QuickBooks can actually export to Excel to make your life easier. From general ledger entry to effectively categorizing expenses, Excel can help make you a more efficient and effective accountant. I'm Dr. Michael McDonald. I'm a professor of finance and a frequent consultant on the use of data in finance and accounting for Fortune 500 companies and government agencies.
If you're ready to dive in and learn how to use Excel to make your life as an accountant easier, then please, join me here on Linkedin Learning.
-
Introduction
-
1. Major Tasks in the Accounting Industry
-
Cash flow budgeting in Excel3m 14s
-
P&L in Excel4m 31s
-
2. QuickBooks, Excel, and Small Business Record-Keeping
-
Pivot tables for accountants3m 58s
-
3. The General Ledger, Excel, and Corporate Record-Keeping
-
General ledger overview4m 16s
-
GL strings3m 39s
-
-
4. Business Valuation in Excel
-
Terminal values in Excel3m 35s
-
Conclusion
-
Next steps1m 16s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Excel for accountants