FreeTutorials Us the-complete-financial-analyst-course

1. 01 Welcome Course Introduction/001 What Does the Course Cover.mp410.55MB
2. 01 Welcome Course Introduction/002 Everything We Will Learn Has a Practical Application.mp410.21MB
3. 01 Welcome Course Introduction/003 The Best Way to Take This Course.mp48.85MB
4. 01 Welcome Course Introduction/attached_files/003 The Best Way to Take This Course/The-Best-way-to-take-it-new.mov10.42MB
5. 02 Microsoft Excel - Quick Introduction/004 Microsoft Excel The Worlds 1 Software for the Office.mp419.5MB
6. 02 Microsoft Excel - Quick Introduction/005 Excel Made Easy A Beginners Guide to Excel Spreadsheets.mp48.09MB
7. 02 Microsoft Excel - Quick Introduction/006 Data Entry Techniques in Excel.mp47.02MB
8. 02 Microsoft Excel - Quick Introduction/007 How to Make Your Spreadsheets Look Professional.mp414.7MB
9. 02 Microsoft Excel - Quick Introduction/008 Inserting Deleting and Modifying Rows Columns.mp44.08MB
10. 02 Microsoft Excel - Quick Introduction/009 Excel Formulas for Beginners.mp45.43MB
11. 02 Microsoft Excel - Quick Introduction/010 A Beginners Introduction to Excel Functions.mp47.42MB
12. 02 Microsoft Excel - Quick Introduction/011 Work Efficiently by Using Cut Copy and Paste.mp45.63MB
13. 02 Microsoft Excel - Quick Introduction/012 Pasting Values Formulas and Formats with Paste Special.mp45.62MB
14. 03 Microsoft Excel - Useful Tools/013 Inserting a Line Break with Alt Enter.mp43.46MB
15. 03 Microsoft Excel - Useful Tools/014 Do More with Your Sales Data with Excels Text to Columns Feature.mp44.19MB
16. 03 Microsoft Excel - Useful Tools/015 Create Easily Printable Excel Documents.mp43.39MB
17. 03 Microsoft Excel - Useful Tools/016 How to Wrap Text in Excel and Adjust a Cells Size.mp41.42MB
18. 03 Microsoft Excel - Useful Tools/017 Insert Hyperlinks in Excel Spreadsheets.mp43.11MB
19. 03 Microsoft Excel - Useful Tools/018 Using Excels Freeze Panes to Handle Large Datasets.mp45.71MB
20. 03 Microsoft Excel - Useful Tools/019 Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do.mp45.43MB
21. 03 Microsoft Excel - Useful Tools/020 A Quick Introduction to Excels Pivot Tables.mp413.43MB
22. 04 Microsoft Excel - Best Practices That Will Make a Difference/021 Initial Formatting Is Key for Creating Professional - Looking Spreadsheets.mp47.49MB
23. 04 Microsoft Excel - Best Practices That Will Make a Difference/022 Macros Are a Great Timesaver Heres Why..mp49.92MB
24. 04 Microsoft Excel - Best Practices That Will Make a Difference/023 The Secret to Faster Scrolling in Excel.mp47.25MB
25. 04 Microsoft Excel - Best Practices That Will Make a Difference/024 Using Absolute and Relative Cell References.mp415.11MB
26. 04 Microsoft Excel - Best Practices That Will Make a Difference/025 Find and Select Cells That Meet Specific Conditions.mp43.95MB
27. 04 Microsoft Excel - Best Practices That Will Make a Difference/026 How to Create Dynamic Names in Excel Spreadsheets.mp45.21MB
28. 04 Microsoft Excel - Best Practices That Will Make a Difference/027 Using Named Ranges to Make Formulas More Readable.mp43.26MB
29. 04 Microsoft Excel - Best Practices That Will Make a Difference/028 Custom Number Formatting.mp43.43MB
30. 04 Microsoft Excel - Best Practices That Will Make a Difference/029 How to Add a Drop-down List in Excel.mp44.48MB
31. 04 Microsoft Excel - Best Practices That Will Make a Difference/030 Using Custom-sort to Sort Multiple Columns Within a Table.mp47.15MB
32. 04 Microsoft Excel - Best Practices That Will Make a Difference/031 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp413.31MB
33. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/032 Key Excel Functions Sum Sumif Sumifs.mp410.64MB
34. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/033 Key Excel Functions Count Counta Countif Countifs.mp414.78MB
35. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/034 Key Excel Functions Average Averageif.mp47.59MB
36. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/035 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate.mp416.78MB
37. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/036 Find the Highest and the Lowest Values in a Range Max Min.mp45.43MB
38. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/037 Use Round in Your Financial Models.mp42.44MB
39. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/038 Excels Lookup Functions Vlookup Hlookup Made Easy.mp419.25MB
40. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/039 Index Match and Their Combination - The Perfect Substitute of Vlookup.mp431.5MB
41. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/040 Using Excels Iferror Function to Trap Spreadsheet Errors.mp45.67MB
42. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/041 Create Flexible Financial Models with Choose.mp49.77MB
43. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/042 Goal Seek Will Help You Find the Result You Are Looking For.mp47.65MB
44. 05 Microsoft Excel - Beginner Intermediate Advanced Functions/043 Perform Sensitivity Analysis with Excels Data Tables Functionality.mp412.82MB
45. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/044 Understand Your Data Source Before You Start Working on It.mp428.21MB
46. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/045 Ordering the Source Worksheet.mp413.73MB
47. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/046 Create a Code The Best Way to Organize Your Data and Work Efficiently with It.mp415.94MB
48. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/047 Learn How to Create a Database.mp414.49MB
49. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/048 Using Lookup Functions Vlookup to Fill the Database Sheet.mp437.74MB
50. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/049 Use Sumif to Complete the Database Sheet.mp429.8MB
51. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/050 Using Index Match as a Substitute of Vlookup.mp433.88MB
52. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/051 Mapping of the Rows in the Database Sheet.mp421.48MB
53. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/052 Building the Structure of the PL Sheet.mp410.1MB
54. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/053 A Practical Example of Professional Formatting in Excel.mp413.1MB
55. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/054 Populate the PL Sheet with Sumif.mp415.44MB
56. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/055 Learn How to Find Mistakes with Countif.mp419.04MB
57. 06 Microsoft Excel - Practical Exercise Build a PL From Scratch/056 Calculating Growth Rates in Excel.mp416.35MB
58. 07 Microsoft Excel - Building Professional Charts in Excel/057 Introduction to Excel Charts.mp46.55MB
59. 07 Microsoft Excel - Building Professional Charts in Excel/058 Beginners Guide to Inserting Charts in Excel.mp410.94MB
60. 07 Microsoft Excel - Building Professional Charts in Excel/059 Modifying Excel Charts - The Easy Way to Do It.mp413.02MB
61. 07 Microsoft Excel - Building Professional Charts in Excel/060 Make Your Excel Charts Look Sexier - Proven Tips.mp415.81MB
62. 07 Microsoft Excel - Building Professional Charts in Excel/061 Creating a Bridge Chart in Excel 2016 - As Easy as It Gets.mp46.16MB
63. 07 Microsoft Excel - Building Professional Charts in Excel/062 New Ways to Visualize Your Data - Treemap Charts.mp45.68MB
64. 07 Microsoft Excel - Building Professional Charts in Excel/063 How to Represent Trends with Sparklines.mp412.67MB
65. 08 Microsoft Excel - Working with Pivot Tables in Excel/064 Pivot Tables - Excels Dynamic and Interactive Tables.mp46MB
66. 08 Microsoft Excel - Working with Pivot Tables in Excel/065 Creating a Pivot Table Choosing Row and Column Parameters.mp419.37MB
67. 08 Microsoft Excel - Working with Pivot Tables in Excel/066 Design the Layout and Format of Your Pivot Tables.mp411.27MB
68. 08 Microsoft Excel - Working with Pivot Tables in Excel/067 Additional Techniques That Will Ease Your Work with Pivot Tables.mp423MB
69. 08 Microsoft Excel - Working with Pivot Tables in Excel/068 One of the Most Useful Excel Functions - GetPivotData.mp418.06MB
70. 08 Microsoft Excel - Working with Pivot Tables in Excel/069 Welcome to the Future - Pivot Table Slicers.mp422.16MB
71. 08 Microsoft Excel - Working with Pivot Tables in Excel/070 Introduction to the Course Challenge.mp44.06MB
72. 08 Microsoft Excel - Working with Pivot Tables in Excel/071 COURSE CHALLENGE - Part 1.mp47.89MB
73. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/072 Introduction to the Case Study.mp421.07MB
74. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/073 Working with an SAP data extraction.mp421.95MB
75. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/074 Preliminary mapping of the data extraction.mp422.6MB
76. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/075 Creating an output structure of the FMCG model.mp411.65MB
77. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/076 Improving the layout and appearance of the FMCG report.mp412.65MB
78. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/077 Inserting formulas and automating calculations.mp48.83MB
79. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/078 Creating a Master Pivot Table The main data source for the FMCG report.mp413.82MB
80. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/079 GetPivotData is great Extracting data from the Master Pivot Table.mp431.04MB
81. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/080 Combining Slicers and GetPivotData The key to our success.mp417.83MB
82. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/081 Getting fancy with Excel slicers - Good-looking Excel slicers.mp417.11MB
83. 09 Pivot Tables Slicers in Practice - World-Class Financial Reporting Shown Here/082 This is how the report can be used in practice by high-level executives.mp419.8MB
84. 10 Building a complete 3-statement model/083 Introduction to the Exercise.mp412.25MB
85. 10 Building a complete 3-statement model/084 Lets create a mapping of financials.mp411.1MB
86. 10 Building a complete 3-statement model/085 Building an output PL sheet.mp411.06MB
87. 10 Building a complete 3-statement model/086 Filling in the output PL sheet with historical financials.mp48.27MB
88. 10 Building a complete 3-statement model/087 Calculating percentage variances and applying conditional formatting.mp48.6MB
89. 10 Building a complete 3-statement model/088 Building an output Balance sheet.mp410.54MB
90. 10 Building a complete 3-statement model/089 Using Index Match Match to fill in the output Balance sheet.mp414.4MB
91. 10 Building a complete 3-statement model/090 Adding the forecast period.mp410.82MB
92. 11 Lets build a flexible model with multiple scenarios/091 Calculating historical percentage ratios and use Index and Match for scenarios.mp415.23MB
93. 11 Lets build a flexible model with multiple scenarios/092 Building a flexible model with Choose Match.mp44.32MB
94. 11 Lets build a flexible model with multiple scenarios/093 Building a flexible model with Vlookup Columns.mp410.7MB
95. 11 Lets build a flexible model with multiple scenarios/094 Calculating historical DSO DPO DIO Other assets and Other liabilities.mp414.71MB
96. 11 Lets build a flexible model with multiple scenarios/095 Forecasting DSO DPO DIO Other assets and Other liabilities.mp49.04MB
97. 12 We are almost there Completing the 3-statement model/096 Building a Fixed asset roll forward.mp414.34MB
98. 12 We are almost there Completing the 3-statement model/097 Building a Financial liabilities schedule.mp416.71MB
99. 12 We are almost there Completing the 3-statement model/098 Building an Equity schedule.mp413.04MB
100. 12 We are almost there Completing the 3-statement model/099 Preparing a Cash flow structure.mp46.2MB
101. 12 We are almost there Completing the 3-statement model/100 Calculating Cash flows and completing the model.mp420.07MB
102. 13 Accounting - Introduction to Accounting Bookkeeping/101 Accounting The Science Behind Financial Figures.mp427.1MB
103. 13 Accounting - Introduction to Accounting Bookkeeping/102 What is Accounting and Why Do You Need It.mp419.75MB
104. 13 Accounting - Introduction to Accounting Bookkeeping/103 The Importance of Bookkeeping - Good Accounting Records Are Essential.mp410.97MB
105. 13 Accounting - Introduction to Accounting Bookkeeping/104 An Introduction to Financial Accounting.mp413.32MB
106. 14 Accounting - The Three Main Statements in Financial Accounting/105 The Three Core Financial Statements PL Balance Sheet and Cash Flow.mp49.71MB
107. 14 Accounting - The Three Main Statements in Financial Accounting/106 The Key Accounts You Will Find in a PL.mp427.22MB
108. 14 Accounting - The Three Main Statements in Financial Accounting/107 The Main Balance Sheet Items.mp418.57MB
109. 14 Accounting - The Three Main Statements in Financial Accounting/attached_files/107 The Main Balance Sheet Items/5.Balance-Sheet-items.mp427.9MB
110. 15 Accounting - Understanding the Big Picture Why What When and How Much/108 The Revenue Recognition Principle - Why Is it so Important.mp48.85MB
111. 15 Accounting - Understanding the Big Picture Why What When and How Much/109 The Expense Recognition Principle - When to Recognize Expenses.mp49.88MB
112. 15 Accounting - Understanding the Big Picture Why What When and How Much/110 Historical Cost vs. Fair Value Accounting.mp47.54MB
113. 16 Accounting - The Core Principles of Accounting/111 The Accounting Equation and Its Importance.mp410.69MB
114. 16 Accounting - The Core Principles of Accounting/112 Elements of the Accounting System General Ledger.mp47.5MB
115. 16 Accounting - The Core Principles of Accounting/113 T-Accounts The Best Way to Understand Debits and Credits.mp49.97MB
116. 16 Accounting - The Core Principles of Accounting/114 PL T-Accounts.mp46.78MB
117. 16 Accounting - The Core Principles of Accounting/115 How to Calculate Depreciation Expense.mp413.91MB
118. 16 Accounting - The Core Principles of Accounting/116 The Double-Entry Principle - The Core Principle of Bookkeeping.mp410.15MB
119. 16 Accounting - The Core Principles of Accounting/attached_files/112 Elements of the Accounting System General Ledger/General-Ledgers.mp411.49MB
120. 17 Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/117 Case Study - The Accounting Transactions of a Lemonade Stand 14.mp430.26MB
121. 17 Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/118 Case Study - The Accounting Transactions of a Lemonade Stand 24.mp421.75MB
122. 17 Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/119 Case Study - The Accounting Transactions of a Lemonade Stand 34.mp417.06MB
123. 17 Accounting - Practical Exercise The Accounting Transactions of a Lemonade Stand/120 Case Study - The Accounting Transactions of a Lemonade Stand 44.mp427.38MB
124. 18 Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/121 Calculating Cash Flows - Understand if a business makes or burns cash.mp410.28MB
125. 18 Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/122 The three parts of Cash Flow statements explained.mp47.26MB
126. 18 Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/123 Cash Flow computations - The Direct method.mp47.31MB
127. 18 Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/124 Cash Flow computations - The Indirect method.mp412.2MB
128. 18 Accounting - Preparing a Cash Flow Statement Understanding Cash Flow Analysis/125 Calculating Cash Flow in practice A complete example.mp420.14MB
129. 19 Accounting - The Importance of Timing/126 Timing of Cash Flows and Why It Plays an Important Role for a Business.mp45.08MB
130. 19 Accounting - The Importance of Timing/127 Timing of Income Principles of Revenue Recognition.mp412.68MB
131. 19 Accounting - The Importance of Timing/128 Timing of Expenses Principles of Cost Recognition.mp47.51MB
132. 19 Accounting - The Importance of Timing/129 The Four Type of Accruals Arising in Accounting Transactions.mp418.72MB
133. 20 Accounting - Introduction to Financial Statement Analysis/130 What is a 10-K Report and Why Is It important for Investors.mp411.17MB
134. 20 Accounting - Introduction to Financial Statement Analysis/131 Finding Downloading and Going Through the Annual Report of PG.mp452.78MB
135. 20 Accounting - Introduction to Financial Statement Analysis/132 What is the Role of Auditing Firms and What Are the Benefits of an Audit.mp49.96MB
136. 20 Accounting - Introduction to Financial Statement Analysis/133 Indispensable Tools for Financial Statement Analysis.mp46.97MB
137. 21 Accounting - Subtleties of Financial Statement Analysis/134 Financial Statement Analysis - A Natural Continuation of Financial Accounting.mp48.31MB
138. 21 Accounting - Subtleties of Financial Statement Analysis/135 First Steps in Financial Statement Analysis.mp412.47MB
139. 21 Accounting - Subtleties of Financial Statement Analysis/136 Horizontal vs. Vertical Financial Statement Analysis.mp415.05MB
140. 21 Accounting - Subtleties of Financial Statement Analysis/137 Calculating Days Payable DPO Days Receivable DSO and Days Inventory DIO.mp44.51MB
141. 21 Accounting - Subtleties of Financial Statement Analysis/138 Using Accounting Ratios to Assess Business Performance.mp418.99MB
142. 22 Accounting - Practical Case Study Analyzing PGs Financials/139 Case Study - Calculating Ratios and Analyzing PGs Financials 12.mp427.62MB
143. 22 Accounting - Practical Case Study Analyzing PGs Financials/140 Case Study - Calculating Ratios and Analyzing PGs Financials 22.mp418.77MB
144. 22 Accounting - Practical Case Study Analyzing PGs Financials/141 COURSE CHALLENGE - Part 2.mp49.68MB
145. 24 Finance 101 - The Time Value of Money and Interest Rate Components/143 Finance 101 Important Financial Principles That You Will Need.mp414.92MB
146. 24 Finance 101 - The Time Value of Money and Interest Rate Components/144 Understanding the Time Value of Money.mp43.32MB
147. 24 Finance 101 - The Time Value of Money and Interest Rate Components/145 Why Interest Rates Play an Important Role in the Economy.mp46.34MB
148. 24 Finance 101 - The Time Value of Money and Interest Rate Components/146 The Components Forming Interest Rates in Real Life.mp48.99MB
149. 24 Finance 101 - The Time Value of Money and Interest Rate Components/147 What Is Libor and What Does It Serve For.mp49.19MB
150. 24 Finance 101 - The Time Value of Money and Interest Rate Components/148 The Difference Between Fixed and Variable Interest Rates.mp47.3MB
151. 24 Finance 101 - The Time Value of Money and Interest Rate Components/149 What Is Default Risk and How Does a Bank Account For It.mp415.61MB
152. 24 Finance 101 - The Time Value of Money and Interest Rate Components/150 Corporate Loan Specifics.mp412.56MB
153. 25 Finance 101 - The Value of Cash Flows with Different Timing/151 Calculating the Present Value of Future Cash Flows.mp413.66MB
154. 25 Finance 101 - The Value of Cash Flows with Different Timing/152 A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value.mp412.3MB
155. 26 Loan Calculations/153 Using Annuities.mp48.67MB
156. 26 Loan Calculations/154 Calculating a Complete Loan Schedule.mp416.98MB
157. 26 Loan Calculations/155 COURSE CHALLENGE - Part 3.mp47.65MB
158. 27 PowerPoint - Introduction to PowerPoint/156 Microsoft PowerPoint The Most Popular Presentation Software for the Office.mp416.79MB
159. 27 PowerPoint - Introduction to PowerPoint/157 The Structure of the PowerPoint Ribbon.mp416.33MB
160. 27 PowerPoint - Introduction to PowerPoint/158 General Considerations About Slide Structure.mp411.34MB
161. 27 PowerPoint - Introduction to PowerPoint/159 Learn How to Insert Objects in PowerPoint.mp413.38MB
162. 27 PowerPoint - Introduction to PowerPoint/160 Shortcuts Allow Us To Be Much Faster When Working in PowerPoint.mp47.49MB
163. 27 PowerPoint - Introduction to PowerPoint/161 Add Frequently Used Buttons to the Quick Access Toolbar.mp410.36MB
164. 27 PowerPoint - Introduction to PowerPoint/162 How to Easily Align Objects in PowerPoint.mp49.42MB
165. 27 PowerPoint - Introduction to PowerPoint/163 Editing Shapes in Your Presentation - The Format Shape Menu.mp413.55MB
166. 27 PowerPoint - Introduction to PowerPoint/164 How to Format Text Boxes in a PowerPoint Presentation.mp49.06MB
167. 27 PowerPoint - Introduction to PowerPoint/165 Changing an Objects Size and Learning About Rotation Options.mp44.29MB
168. 27 PowerPoint - Introduction to PowerPoint/166 Work Efficiently By Using Slide Masters.mp414.01MB
169. 28 PowerPoint - Tips Tricks That Will Transform You Into An Advanced User/167 Modifying the Beginning and Ending of a Line Object.mp46.46MB
170. 28 PowerPoint - Tips Tricks That Will Transform You Into An Advanced User/168 Join Shapes Together By Using Connector Lines.mp48.48MB
171. 28 PowerPoint - Tips Tricks That Will Transform You Into An Advanced User/169 Group or Ungroup Shapes Pircutres or Other Objects.mp44.13MB
172. 28 PowerPoint - Tips Tricks That Will Transform You Into An Advanced User/170 This is How You Can Fit Text When It Is Larger than a Shape.mp46.13MB
173. 28 PowerPoint - Tips Tricks That Will Transform You Into An Advanced User/171 PowerPoints Smart Art Feature Offers Great Return for Your Time.mp49.01MB
174. 28 PowerPoint - Tips Tricks That Will Transform You Into An Advanced User/172 Creating Eye-Catching Text Effects in PowerPoint.mp46.52MB
175. 28 PowerPoint - Tips Tricks That Will Transform You Into An Advanced User/173 Practical Exercise - Creating an Organisational Chart.mp422.73MB
176. 28 PowerPoint - Tips Tricks That Will Transform You Into An Advanced User/174 COURSE CHALLENGE - Part 4.mp412.75MB