The Complete Financial Analyst Course 2019

Vui lòng đăng nhập tài khoản để tiếp tục xem video

Đăng ký

Đăng nhập

“If you’re trying to prepare for an eventual career in finance, but are still looking to round out your knowledge of the subject, The Complete Financial Analyst Course might be a perfect fit for you.”, Business Insider “A Financial Analyst Career is one of the top-paying entry-level jobs on the market.” “Even in the toughest job markets, the best candidates find great positions.”, Forbes You simply have to find a way to acquire practical skills that will give you an edge over the other candidates.

Trình độ kỹ năng:Beginner
Học viên:1
Ngôn ngữ:En/Vi

Bài giảng:2
Thời lượng video: 06:00:00

“If you’re trying to prepare for an eventual career in finance, but are still looking to round out your knowledge of the subject, The Complete Financial Analyst Course might be a perfect fit for you.”, Business Insider “A Financial Analyst Career is one of the top-paying entry-level jobs on the market.” “Even in the toughest job markets, the best candidates find great positions.”, Forbes You simply have to find a way to acquire practical skills that will give you an edge over the other candidates.

Về khóa học này

Mô tả

Nội dung khóa học

Chương 10: 10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here 06:00:00

1. Introduction to the Case Study.mp4

2. Working with an SAP data extraction.mp4

3. Preliminary mapping of the data extraction.mp4

4. Creating an output structure of the FMCG model.mp4

5. Improving the layout and appearance of the FMCG report.mp4

6. Inserting formulas and automating calculations.mp4

7. Creating a Master Pivot Table The main data source for the FMCG report.mp4

8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4

9. GetPivotData fix.mp4

10. Combining Slicers and GetPivotData The key to our success.mp4

11. Getting fancy with Excel slicers.mp4

12. This is how the report can be used in practice by high-level executives.mp4

Chương 11: 11. Modeling in Excel - Building a complete 3-statement model 06:00:00

1. Introduction to the Exercise.mp4

2. Let's create a mapping of financials.mp4

3. Building an output P&L sheet.mp4

4. Filling in the output P&L sheet with historical financials.mp4

5. Calculating percentage variances and applying conditional formatting.mp4

6. Building an output Balance sheet.mp4

7. Using Index, Match, Match to fill in the output Balance sheet.mp4

8. Adding the forecast period.mp4

Chương 12: 12. Modeling in Excel - Let's build a flexible model with multiple scenarios 06:00:00

1. Calculating historical percentage ratios and use Index and Match for scenarios.mp4

2. Building a flexible model with Choose & Match.mp4

3. Building a flexible model with Vlookup & Columns.mp4

4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %.mp4

5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities.mp4

Chương 13: 13. Modeling in Excel - We are almost there! Completing the 3-statement model 06:00:00

1. Building a Fixed asset roll forward.mp4

2. Building a Financial liabilities schedule.mp4

3. Building an Equity schedule.mp4

4. Preparing a Cash flow structure.mp4

5. Calculating Cash flows and completing the model.mp4

Chương 14: 14. Accounting - Introduction to Accounting & Bookkeeping 06:00:00

1. Accounting The Science Behind Financial Figures.mp4

2. What is Accounting and Why Do You Need It.mp4

3. The Importance of Bookkeeping - Good Accounting Records Are Essential.mp4

4. An Introduction to Financial Accounting.mp4

Chương 15: 15. Accounting - Types of revenues, costs, assets, and liabilities 06:00:00

1. The different types of accounting standards.mp4

2. The three financial statements.mp4

3. Types of revenues.mp4

4. Types of revenues - exercise.mp4

5. Types of expenses.mp4

6. Income taxes.mp4

7. Depreciation & Amortization.mp4

8. Types of assets.mp4

9. Asset categories - practical example.mp4

10. Types of liabilities.mp4

11. Liability categories - practical example.mp4

12. Equity.mp4

Chương 16: 16. Accounting - Revenue recognition 06:00:00

1. Accrual accounting.mp4

2. The importance of timing when recognizing revenues.mp4

3. Revenue recognition criteria - technical.mp4

4. Potential conflicts of interest when recognizing revenue.mp4

5. A practical example.mp4

Chương 17: 17. Accounting - Cost recognition 06:00:00

1. Cost recognition principles.mp4

2. Technical aspects of cost recognition.mp4

3. The two types of Income Statement formats.mp4

Chương 18: 18. Accounting - Understanding the Big Picture Why, What, When, and How Much 06:00:00

1. The Revenue Recognition Principle - Why Is it so Important.mp4

2. The Expense Recognition Principle - When to Recognize Expenses.mp4

3. Historical Cost vs. Fair Value Accounting.mp4

Chương 19: 19. Accounting - The Core Principles of Accounting 06:00:00

1. The Accounting Equation and Its Importance.mp4

2. Elements of the Accounting System General Ledger.mp4

3. T-Accounts The Best Way to Understand Debits and Credits.mp4

4. P&L T-Accounts.mp4

5. How to Calculate Depreciation Expense.mp4

6. The Double-Entry Principle - The Core Principle of Bookkeeping.mp4

Chương 1: 1. Welcome! Course Introduction 06:00:00

1. What Does the Course Cover.mp4

2. Everything We Will Learn Has a Practical Application.mp4

3. The Best Way to Take This Course.mp4