Microsoft Excel Tips and Tricks for Accountants

سرفصل های دوره

Learn the core Microsoft Excel skills every accountant or financial professional needs

1. Introduction

1. Introduction

2. Tasks in Accounting Industry

1. Accounting tasks and career roles

2. Basics of accounting industry

3.1 Ex_Files_Excel_for_Accountants_2019Q2.zip

3. Cash flow budgeting in Excel

4. P&L in Excel

3. Quickbooks, Excel & Small Business Record Keeping

1. Small business accounting overview

2. Transactions in Quickbooks & Excel

3. Quarterly profit and loss tracking in Excel

4. QuickBooks and ledger records

5. Taxes and Excel record-keeping

6. Tracking business performance in Excel

7. Pivot tables for accountants

8. Import data from Excel to QuickBooks

4. General Ledger

1. General ledger overview

2. Recording transactions in a GL

3. GL strings

4. Corporate financial statements in Excel

5. Financial statement links in Excel

6. Key corporate accounting ratios

7. International accounting standards vs. the US

8. XBRL, Edgar, and corporate financial reporting

5. Business Valuation in Excel

1. Historical statements to forward projections

2. Terminal values in Excel

3. Constructing a business valuation using cash flow analysis

6. Conclusion

1. Conclusion

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training