Excel for Accountants

Focused View

Michael McDonald

2:04:00

23 View

01 - Introduction

01 - Excel for accountants.mp4

00:49

02 - 1. Major Tasks in the Accounting Industry

01 - Accounting tasks and career roles.mp4

02:09

02 - Basics of accounting industry.mp4

03:41

03 - Cash flow budgeting in Excel.mp4

03:14

04 - P&L in Excel.mp4

04:31

03 - 2. QuickBooks, Excel, and Small Business Record-Keeping

01 - Small business accounting overview.mp4

03:47

02 - Transactions in QuickBooks and Excel.mp4

04:51

03 - Quarterly profit and loss tracking in Excel.mp4

04:39

04 - QuickBooks and ledger records.mp4

03:38

05 - Taxes and Excel record-keeping.mp4

03:58

06 - Tracking business performance in Excel.mp4

04:43

07 - Pivot tables for accountants.mp4

03:58

08 - Import data from Excel to QuickBooks.mp4

04:42

04 - 3. The General Ledger, Excel, and Corporate Record-Keeping

01 - General ledger overview.mp4

04:16

02 - Recording transactions in a GL.mp4

04:54

03 - GL strings.mp4

03:39

04 - Corporate financial statements in Excel.mp4

04:19

05 - Financial statement links in Excel.mp4

03:25

06 - Key corporate accounting ratios.mp4

04:14

07 - International accounting standards vs. the US.mp4

02:14

08 - XBRL, Edgar, and corporate financial reporting.mp4

03:55

05 - 4. Business Valuation in Excel

01 - Historical statements to forward projections.mp4

03:43

02 - Terminal values in Excel.mp4

03:35

03 - Constructing a business valuation using cash flow analysis.mp4

03:42

06 - 5. Performance Presentation in Excel

01 - KPIs and Excel.mp4

08:06

02 - Waterfall charts in Excel.mp4

07:01

03 - Using financial ratios in Excel.mp4

05:24

04 - Variances in Excel.mp4

05:38

05 - Using Excel for regressions in audit work.mp4

06:01

07 - Conclusion

01 - Thanks for taking this course. After this video, you'll be able to locate additional resources to enhance your knowledge of Excel for accounting tasks.mp4

01:14

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Accounting

Michael McDonald

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.