Become a better accountant by leveraging the power of Microsoft Excel. Learn how to use Excel for general ledger entry, forecasting, business valuation, interacting with QuickBooks, and more.
- [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.
- 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.