FreeCourseSite com Udemy - The Complete Financial Analyst Course 2018

1. Lesson_1._What_Does_the_Course_Cover_.mp476.24MB
2. Lesson_10._A_Beginner's_Introduction_to_Excel_Functions.mp421.93MB
3. Lesson_100._Building_a_Fixed_asset_roll_forward.mp440.94MB
4. Lesson_101._Building_a_Financial_liabilities_schedule.mp447.55MB
5. Lesson_102._Building_an_Equity_schedule.mp436.57MB
6. Lesson_103._Preparing_a_Cash_flow_structure.mp415.2MB
7. Lesson_104._Calculating_Cash_flows_and_completing_the_model.mp457.47MB
8. Lesson_105._Accounting-_The_Science_Behind_Financial_Figures.mp432.89MB
9. Lesson_106._What_is_Accounting_and_Why_Do_You_Need_It.mp464.01MB
10. Lesson_107._The_Importance_of_Bookkeeping_-_Good_Accounting_Records_Are_Essential.mp426.67MB
11. Lesson_108._An_Introduction_to_Financial_Accounting.mp431.96MB
12. Lesson_109._The_different_types_of_accounting_standards.mp421.67MB
13. Lesson_11._Work_Efficiently_by_Using_Cut,_Copy,_and_Paste.mp414.48MB
14. Lesson_110._The_three_financial_statements.mp411.82MB
15. Lesson_111._Types_of_revenues.mp426.53MB
16. Lesson_112._Types_of_revenues_-_exercise.mp418.62MB
17. Lesson_113._Types_of_expenses.mp445.18MB
18. Lesson_114._Income_taxes.mp417.91MB
19. Lesson_115._Depreciation_&_Amortization.mp440.12MB
20. Lesson_116._Types_of_assets.mp431.78MB
21. Lesson_117._Asset_categories_-_practical_example.mp429.13MB
22. Lesson_118._Types_of_liabilities.mp427.49MB
23. Lesson_119._Liability_categories_-_practical_example.mp423.84MB
24. Lesson_12._Pasting_Values,_Formulas_and_Formats_with_Paste_Special.mp414.18MB
25. Lesson_120._Equity.mp415.02MB
26. Lesson_121._Accrual_accounting.mp413.65MB
27. Lesson_122._The_importance_of_timing_when_recognizing_revenues.mp423.48MB
28. Lesson_123._Revenue_recognition_criteria_-_technical.mp432.24MB
29. Lesson_124._Potential_conflicts_of_interest_when_recognizing_revenue.mp418.79MB
30. Lesson_125._A_practical_example.mp439.53MB
31. Lesson_126._Cost_recognition_principles.mp413.78MB
32. Lesson_127._Technical_aspects_of_cost_recognition.mp427.67MB
33. Lesson_128._The_two_types_of_Income_Statement_formats.mp47.27MB
34. Lesson_129._The_Revenue_Recognition_Principle_-_Why_Is_it_so_Important_.mp424.39MB
35. Lesson_13._Inserting_a_Line_Break_with_Alt_+_Enter.mp46.19MB
36. Lesson_130._The_Expense_Recognition_Principle_-_When_to_Recognize_Expenses.mp425.26MB
37. Lesson_131._Historical_Cost_vs._Fair_Value_Accounting.mp424.26MB
38. Lesson_132._The_Accounting_Equation_and_Its_Importance.mp424.49MB
39. Lesson_133._Elements_of_the_Accounting_System-_General_Ledger.mp416.07MB
40. Lesson_134._T-Accounts-_The_Best_Way_to_Understand_Debits_and_Credits.mp421.4MB
41. Lesson_135._P&L_T-Accounts.mp413.32MB
42. Lesson_136._How_to_Calculate_Depreciation_Expense.mp440.12MB
43. Lesson_137._The_Double-Entry_Principle_-_The_Core_Principle_of_Bookkeeping.mp424.08MB
44. Lesson_138._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(14).mp468.32MB
45. Lesson_139._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(24).mp446.4MB
46. Lesson_14._Do_More_with_Your_Sales_Data_with_Excel's_Text_to_Columns_Feature.mp413.86MB
47. Lesson_140._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(34).mp453.36MB
48. Lesson_141._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(44).mp458.95MB
49. Lesson_142._Calculating_Cash_Flows_-_Understand_if_a_business_makes_or_burns_cash.mp427.68MB
50. Lesson_143._The_three_parts_of_Cash_Flow_statements_explained.mp419.98MB
51. Lesson_144._Cash_Flow_computations_-_The_Direct_method.mp419.72MB
52. Lesson_145._Cash_Flow_computations_-_The_Indirect_method.mp431.36MB
53. Lesson_146._Calculating_Cash_Flow_in_practice-_A_complete_example.mp450.61MB
54. Lesson_147._Timing_of_Cash_Flows_and_Why_It_Plays_an_Important_Role_in_a_Business.mp413.24MB
55. Lesson_148._Timing_of_Income-_Principles_of_Revenue_Recognition.mp426.87MB
56. Lesson_149._Timing_of_Expenses-_Principles_of_Cost_Recognition.mp415.8MB
57. Lesson_15._Create_Easily_Printable_Excel_Documents.mp49.19MB
58. Lesson_150._The_Four_Type_of_Accruals_Arising_in_Accounting_Transactions.mp449.57MB
59. Lesson_151._Why_a_company_needs_to_pay_attention_to_trade_receivables_.mp425.23MB
60. Lesson_152._What_if_clients_do_not_pay_on_time_.mp426.47MB
61. Lesson_153._How_to_handle_non-paying_customers__A_case-study.mp424.94MB
62. Lesson_154._A_technique_to_collect_trade_receivables_sooner.mp415.44MB
63. Lesson_155._The_different_types_of_Inventory_we_can_have.mp426.66MB
64. Lesson_156._The_connection_between_Cost_of_Goods_Sold_and_Inventory.mp417.24MB
65. Lesson_157._Cost_flow_methods.mp428.72MB
66. Lesson_158._Cost_flow_methods_-_a_practical_exercise.mp46.75MB
67. Lesson_159._The_different_types_of_fixed_assets.mp420.71MB
68. Lesson_16._How_to_Wrap_Text_in_Excel_and_Adjust_a_Cell's_Size.mp43.78MB
69. Lesson_160._Capitalizing_interest_expenses.mp47.66MB
70. Lesson_161._Fair_value_accounting.mp424.26MB
71. Lesson_162._Intangible_assets_with_finite_life_vs._Intangible_assets_with_infinite_life.mp435.3MB
72. Lesson_163._The_revaluation_model.mp439.06MB
73. Lesson_164._The_revaluation_model_-_practical_exercise.mp436.31MB
74. Lesson_165._Intangible_assets_created_internally.mp417.69MB
75. Lesson_166._How_we_account_for_trade_payables.mp422.54MB
76. Lesson_167._What_is_the_difference_between_accounts_payable_and_notes_payable_.mp410.9MB
77. Lesson_168._Why_use_e-invoicing_.mp425.93MB
78. Lesson_169._The_difference_between_debt_and_equity.mp414.8MB
79. Lesson_17._Insert_Hyperlinks_into_Excel_Spreadsheets.mp48.25MB
80. Lesson_170._Amortizing_a_loan.mp420.65MB
81. Lesson_171._Debt_covenants.mp425.79MB
82. Lesson_172._Debt_covenants_-_a_practical_example.mp413.68MB
83. Lesson_173._The_reason_companies_lease_assets.mp411.12MB
84. Lesson_174._Solving_a_complete_leasing_exercise.mp438.17MB
85. Lesson_175._What_is_leverage_and_why_companies_use_financial_leverage_.mp457.42MB
86. Lesson_176._The_implications_of_using_excessive_leverage.mp434.49MB
87. Lesson_177._The_different_types_of_equity.mp455.22MB
88. Lesson_178._Raising_equity_in_different_stages_of_a_company's_lifecycle.mp471.95MB
89. Lesson_179._The_types_of_dividends_companies_pay_to_shareholders.mp444.87MB
90. Lesson_18._Using_Excel's_Freeze_Panes_to_Handle_Large_Datasets.mp415.25MB
91. Lesson_180._Dividend_payments_-_a_timeline.mp436.18MB
92. Lesson_181._What_are_share_repurchases_and_why_companies_do_them.mp443.91MB
93. Lesson_182._The_idea_behind_stock_splits.mp436.06MB
94. Lesson_183._What_is_a_10-K_Report_and_Why_Is_It_important_for_Investors_.mp427.32MB
95. Lesson_184._Finding,_Downloading_and_Going_Through_the_Annual_Report_of_P&G.mp474.98MB
96. Lesson_185._What_is_the_Role_of_Auditing_Firms_and_What_Are_the_Benefits_of_an_Audit_.mp425.86MB
97. Lesson_186._Indispensable_Tools_for_Financial_Statement_Analysis.mp415.34MB
98. Lesson_187._Financial_Statement_Analysis_-_A_Natural_Continuation_of_Financial_Accounting.mp418.47MB
99. Lesson_188._First_Steps_in_Financial_Statement_Analysis.mp432.08MB
100. Lesson_189._Horizontal_vs._Vertical_Financial_Statement_Analysis.mp428.26MB
101. Lesson_19._Find_Excel_Functionalities_in_a_Quicker_Way_-_Tell_Me_What_You_Want_to_Do.mp49.2MB
102. Lesson_190._Calculating_Days_Payable_(DPO),_Days_Receivable_(DSO)_and_Days_Inventory_(DIO).mp411.85MB
103. Lesson_191._Using_Accounting_Ratios_to_Assess_Business_Performance.mp436.82MB
104. Lesson_192._Case_Study_-_Calculating_Ratios_and_Analyzing_P&G's_Financials_(12).mp455.78MB
105. Lesson_193._Case_Study_-_Calculating_Ratios_and_Analyzing_P&G's_Financials_(22).mp436.91MB
106. Lesson_194._COURSE_CHALLENGE_-_Part_2.mp418.75MB
107. Lesson_195._What_you_will_see_next_in_this_section.mp418.33MB
108. Lesson_196._How_to_download_Tesla's_historical_financials.mp414.41MB
109. Lesson_197._Calculating_and_analyzing_growth_and_profitability_ratios.mp4105.11MB
110. Lesson_198._Calculating_and_analyzing_liquidity_ratios.mp474.95MB
111. Lesson_199._Calculating_and_analyzing_solvency_ratios.mp420.02MB
112. Lesson_2._Everything_We_Will_Learn_Has_a_Practical_Application.mp425.7MB
113. Lesson_20._A_Quick_Introduction_to_Excel's_Pivot_Tables.mp425.36MB
114. Lesson_200._Introduction.mp423.43MB
115. Lesson_201._The_importance_of_working_capital_optimization-_case_study.mp489.98MB
116. Lesson_202._Overtrading_vs._excessive_investment.mp433.12MB
117. Lesson_203._Trade_receivables_management.mp476.15MB
118. Lesson_204._Re-order_level.mp431.31MB
119. Lesson_205._Economic_order_quantity_(EOQ).mp431.85MB
120. Lesson_206._Inventory_optimization_techniques.mp450.48MB
121. Lesson_207._Trade_payables_management.mp419.28MB
122. Lesson_208._Working_capital_optimization_-_a_roadmap.mp448.18MB
123. Lesson_209._Symptoms_of_inefficient_working_capital_-_Trade_payables.mp417.95MB
124. Lesson_21._Initial_Formatting_Is_Key_for_Creating_Professional-looking_Spreadsheets.mp413.86MB
125. Lesson_210._Finance_101-_Important_Financial_Principles_That_You_Will_Need.mp416.11MB
126. Lesson_211._Understanding_the_Time_Value_of_Money.mp46.23MB
127. Lesson_212._How_Interest_Rates_Play_an_Important_Role_in_the_Economy_.mp413.76MB
128. Lesson_213._The_Components_Forming_Interest_Rates_in_Real_Life.mp416.64MB
129. Lesson_214._What_Is_Libor_and_What_Purpose_Does_It_Serve_.mp417.12MB
130. Lesson_215._The_Difference_Between_Fixed_and_Variable_Interest_Rates.mp417.03MB
131. Lesson_216._What_Is_Default_Risk_and_How_Does_a_Bank_Account_For_It_.mp431.16MB
132. Lesson_217._Corporate_Loan_Specifics.mp425.8MB
133. Lesson_218._Calculating_the_Present_Value_of_Future_Cash_Flows.mp429.8MB
134. Lesson_219._A_Tool_That_Helps_Us_Decide_Whether_a_Project_Is_Feasible-_Net_Present_Value.mp429.11MB
135. Lesson_22._Macros_Are_a_Great_Timesaver!_Here's_Why..mp421.46MB
136. Lesson_220._Using_Annuities.mp424.25MB
137. Lesson_221._Calculating_a_Complete_Loan_Schedule.mp449.62MB
138. Lesson_222._COURSE_CHALLENGE_-_Part_3.mp413.88MB
139. Lesson_223._What_is_Capital_Budgeting_.mp413.24MB
140. Lesson_224._When_Do_We_Use_Capital_Budgeting_.mp420.52MB
141. Lesson_225._The_Time_Value_of_Money_in_a_Capital_Budgeting_Setting.mp418.91MB
142. Lesson_226._Calculating_Present_and_Future_Value.mp437.5MB
143. Lesson_227._Cost_of_Equity.mp455.85MB
144. Lesson_228._Project-specific_Beta.mp427.2MB
145. Lesson_229._The_Weighted_Average_Cost_of_Capital_(WACC).mp415.71MB
146. Lesson_23._The_Secret_to_Faster_Scrolling_in_Excel.mp420.84MB
147. Lesson_230._The_Different_Cash_Flow_Types_in_a_Capital_Budgeting_Exercise.mp424.31MB
148. Lesson_231._Modeling_Future_Cash_Flows.mp454.39MB
149. Lesson_232._An_introduction_to_the_Case_Study.mp425.3MB
150. Lesson_233._Organizing_inputs_in_the_Drivers_sheet.mp438.17MB
151. Lesson_234._Modeling_expected_savings_-_Building_cars_in_Italy_vs._Building_cars_in_Vietnam.mp434.75MB
152. Lesson_235._Preparing_a_fixed_asset_rollforward_schedule.mp447.37MB
153. Lesson_236._Calculating_the_cash_impact_of_extra_working_capital_required.mp418.35MB
154. Lesson_237._Debt_repayment_and_interest_expenses_calculation.mp422.14MB
155. Lesson_238._The_project's_P&L_sheet.mp413.93MB
156. Lesson_239._The_project's_cash_flow_calculation.mp430.85MB
157. Lesson_24._Using_Absolute_and_Relative_Cell_References.mp427.02MB
158. Lesson_240._Calculating_WACC_(Weighted_Average_Cost_of_Capital).mp418.53MB
159. Lesson_241._Estimating_cost_of_equity.mp440.39MB
160. Lesson_242._Discounting_project_cash_flows.mp422.57MB
161. Lesson_243._Performing_sensitivity_analysis_and_wrapping_up_the_Case_Study.mp434.12MB
162. Lesson_244._Organizing_external_inputs_in_a_'Drivers'_sheet.mp431MB
163. Lesson_245._The_input_data_we_will_work_with.mp415.81MB
164. Lesson_246._Forecasting_Tesla's_expected_deliveries.mp4114.92MB
165. Lesson_247._Comparing_delivery_figures_with_the_ones_of_industry_peers.mp420.98MB
166. Lesson_248._Estimating_an_average_selling_price_of_Tesla_vehicles.mp441.93MB
167. Lesson_249._Calculating_automotive_revenue.mp446.56MB
168. Lesson_25._Find_and_Select_Cells_That_Meet_Specific_Conditions.mp413.45MB
169. Lesson_250._Peer_comparison-_Gross_profit_%.mp417.19MB
170. Lesson_251._Calculating_automotive_gross_profit.mp427.79MB
171. Lesson_252._Calculating_automotive_cost_of_sales.mp417.53MB
172. Lesson_253._Forecasting_'energy'_and_'services'_revenue.mp425.29MB
173. Lesson_254._Calculating_'energy'_and_'services'_gross_profit_and_cost_of_sales.mp426.81MB
174. Lesson_255._Forecasting_operating_expenses.mp434.48MB
175. Lesson_256._Building_a_fixed_asset_roll_forward-_estimating_Capex.mp456.51MB
176. Lesson_257._Building_a_fixed_asset_roll_forward-_D&A_schedule.mp454.15MB
177. Lesson_258._Peer_comparison-_D&A_as_a_percentage_of_revenues.mp413.63MB
178. Lesson_259._Calculating_DSO,_DIO,_DPO.mp417.52MB
179. Lesson_26._How_to_Create_Dynamic_Names_in_Excel_Spreadsheets.mp415.14MB
180. Lesson_260._Producing_a_clean_P&L_output_sheet.mp48.44MB
181. Lesson_261._Fill_in_the_P&L_output_sheet.mp418.35MB
182. Lesson_262._Calculating_investments_in_working_capital.mp419.05MB
183. Lesson_263._Forecasting_Unlevered_Free_Cash_Flow.mp455.98MB
184. Lesson_264._Forecasting_other_assets.mp445.3MB
185. Lesson_265._Forecasting_other_liabilities.mp422.05MB
186. Lesson_266._Completing_Unlevered_Free_Cash_Flow.mp440.9MB
187. Lesson_267._Modeling_Tesla's_financing_needs_in_the_forecast_period.mp442.37MB
188. Lesson_268._Calculating_Net_income.mp414.8MB
189. Lesson_269._Bridging_Unlevered_Free_Cash_Flow_to_Net_Cash_Flow.mp450.67MB
190. Lesson_27._Using_Named_Ranges_to_Make_Formulas_More_Readable.mp49.12MB
191. Lesson_270._Balancing_the_Balance_sheet.mp413.29MB
192. Lesson_271._Microsoft_PowerPoint-_The_Most_Popular_Presentation_Software_for_the_Office.mp418.4MB
193. Lesson_272._The_Structure_of_the_PowerPoint_Ribbon.mp434.23MB
194. Lesson_273._General_Considerations_About_Slide_Structure.mp424.62MB
195. Lesson_274._Learn_How_to_Insert_Objects_in_PowerPoint.mp429.73MB
196. Lesson_275._Shortcuts_Allow_Us_To_Be_Much_Faster_When_Working_in_PowerPoint.mp415.52MB
197. Lesson_276._Add_Frequently_Used_Buttons_to_the_Quick_Access_Toolbar.mp422.78MB
198. Lesson_277._How_to_Easily_Align_Objects_in_PowerPoint.mp419.99MB
199. Lesson_278._How_to_Edit_Shapes_in_Your_Presentation.mp429.18MB
200. Lesson_279._How_to_Format_Text_Boxes_in_a_PowerPoint_Presentation.mp419.87MB
201. Lesson_28._Custom_Number_Formatting.mp49.89MB
202. Lesson_280._Changing_an_Object's_Size_and_Rotation.mp48.69MB
203. Lesson_281._Using_Slide_Masters.mp433.99MB
204. Lesson_282._Modifying_the_Beginning_and_Ending_of_a_Line_Object.mp412.16MB
205. Lesson_283._Join_Shapes_Together_By_Using_Connector_Lines.mp422.25MB
206. Lesson_284._Group_or_Ungroup_Shapes,_Pictures_or_Other_Objects.mp48.98MB
207. Lesson_285._This_is_How_You_Can_Fit_Text_When_It_Is_Larger_than_a_Shape.mp411.8MB
208. Lesson_286._PowerPoint's_Smart_Art_Feature_Offers_Great_Return_for_Your_Time.mp424.08MB
209. Lesson_287._Creating_Eye-Catching_Text_Effects_in_PowerPoint.mp413.33MB
210. Lesson_288._Practical_Exercise_-_Creating_an_Organisational_Chart.mp451.58MB
211. Lesson_289._COURSE_CHALLENGE_-_Part_4.mp426.05MB
212. Lesson_29._How_to_Add_a_Drop-down_List_in_Excel.mp416.29MB
213. Lesson_3._The_Best_Way_to_Take_This_Course.mp431.22MB
214. Lesson_30._Using_Custom-sort_to_Sort_Multiple_Columns_Within_a_Table.mp413.6MB
215. Lesson_31._Saving_Time_in_Excel_and_Doing_Everything_Faster_by_Using_Excel_Shortcuts.mp445.95MB
216. Lesson_32._Key_Excel_Functions-_Sum,_Sumif,_Sumifs.mp430.69MB
217. Lesson_33._Key_Excel_Functions-_Count,_Counta,_Countif,_Countifs.mp431.2MB
218. Lesson_34._Key_Excel_Functions-_Average_&_Averageif.mp415.11MB
219. Lesson_35._Key_Excel_Functions-_Left,_Right,_Mid,_Upper,_Lower,_Proper,_Concatenate,_&.mp430.36MB
220. Lesson_36._Find_the_Highest_and_Lowest_Values_in_a_Range-_Max_&_Min.mp47.54MB
221. Lesson_37._Use_Round_in_Your_Financial_Models.mp45.21MB
222. Lesson_38._Excel's_Lookup_Functions-_Vlookup_&_Hlookup_Made_Easy.mp460.27MB
223. Lesson_39._Index,_Match,_and_Their_Combination_-_The_Perfect_Substitute_for_Vlookup.mp461.79MB
224. Lesson_4._Microsoft_Excel-_The_World's_#1_Office_Software.mp422.03MB
225. Lesson_40._Using_Excel's_Iferror_Function_to_Trap_Spreadsheet_Errors.mp411.75MB
226. Lesson_41._Create_Flexible_Financial_Models_with_Choose.mp419.84MB
227. Lesson_42._Goal_Seek_Will_Help_You_Find_the_Result_You_Are_Looking_For.mp416.03MB
228. Lesson_43._Perform_Sensitivity_Analysis_with_Excel's_Data_Tables_Functionality.mp426.22MB
229. Lesson_44._Discounting_cash_flows_in_Microsoft_Excel.mp445.69MB
230. Lesson_45._Calculating_Internal_Rate_of_Return_(IRR)_in_Excel.mp422.76MB
231. Lesson_46._Using_the_PMT_function_to_create_a_complete_loan_schedule.mp440.07MB
232. Lesson_47._Date_functions_in_Excel.mp430.8MB
233. Lesson_48._Understand_Your_Data_Source_Before_You_Start_Working_on_It.mp439.36MB
234. Lesson_49._Ordering_the_Source_Worksheet.mp424.01MB
235. Lesson_5._Excel_Made_Easy-_A_Beginner's_Guide_to_Excel_Spreadsheets.mp422.75MB
236. Lesson_50._Create_a_Code-_The_Best_Way_to_Organize_Your_Data_and_Work_Efficiently_with_It.mp424.87MB
237. Lesson_51._Learn_How_to_Create_a_Database.mp423.6MB
238. Lesson_52._Using_Lookup_Functions_(Vlookup)_to_Fill_the_Database_Sheet.mp465.19MB
239. Lesson_53._Use_Sumif_to_Complete_the_Database_Sheet.mp450.72MB
240. Lesson_54._Using_Index_&_Match_as_a_Substitute_for_Vlookup.mp452.08MB
241. Lesson_55._Mapping_the_Rows_in_the_Database_Sheet.mp431.12MB
242. Lesson_56._Building_the_Structure_of_the_P&L_Sheet.mp420.8MB
243. Lesson_57._A_Practical_Example_of_Professional_Formatting_in_Excel.mp427.5MB
244. Lesson_58._Populate_the_P&L_Sheet_with_Sumif.mp427.77MB
245. Lesson_59._Learn_How_to_Find_Mistakes_with_Countif.mp429.44MB
246. Lesson_6._Data_Entry_Techniques_in_Excel.mp417.33MB
247. Lesson_60._Calculating_Growth_Rates_in_Excel.mp431.93MB
248. Lesson_61._Introduction_to_Excel_Charts.mp413.01MB
249. Lesson_62._Beginner's_Guide_to_Inserting_Charts_in_Excel.mp422.28MB
250. Lesson_63._Modifying_Excel_Charts_-_The_Easy_Way.mp426.05MB
251. Lesson_64._Making_Your_Excel_Charts_Sexier_-_Proven_Tips.mp432.69MB
252. Lesson_65._Creating_a_Bridge_Chart_in_Excel_2016_-_As_Easy_as_It_Gets.mp413.66MB
253. Lesson_66._New_Ways_to_Visualize_Your_Data_-_Treemap_Charts.mp411.51MB
254. Lesson_67._How_to_Represent_Trends_with_Sparklines.mp427.54MB
255. Lesson_68._Pivot_Tables_-_Excel's_Dynamic_and_Interactive_Tables.mp415.06MB
256. Lesson_69._Creating_a_Pivot_Table-_Choosing_Row_and_Column_Parameters.mp438.94MB
257. Lesson_7._How_to_Make_Your_Spreadsheets_Look_Professional.mp444.84MB
258. Lesson_70._Design_the_Layout_and_Format_of_Your_Pivot_Tables.mp421.54MB
259. Lesson_71._Additional_Techniques_That_Will_Ease_Your_Work_with_Pivot_Tables.mp446.01MB
260. Lesson_72._One_of_the_Most_Useful_Excel_Functions_-_GetPivotData.mp436.28MB
261. Lesson_73._Welcome_to_the_Future_-_Pivot_Table_Slicers.mp445.18MB
262. Lesson_74._Introduction_to_the_Course_Challenge.mp413.18MB
263. Lesson_75._COURSE_CHALLENGE_-_Part_1.mp414.38MB
264. Lesson_76._Introduction_to_the_Case_Study.mp426.73MB
265. Lesson_77._Working_with_an_SAP_data_extraction.mp439.2MB
266. Lesson_78._Preliminary_mapping_of_the_data_extraction.mp431.17MB
267. Lesson_79._Creating_an_output_structure_of_the_FMCG_model.mp422.18MB
268. Lesson_8._Inserting,_Deleting,_and_Modifying_Rows_&_Columns.mp412.36MB
269. Lesson_80._Improving_the_layout_and_appearance_of_the_FMCG_report.mp427.14MB
270. Lesson_81._Inserting_formulas_and_automating_calculations.mp418.09MB
271. Lesson_82._Creating_a_Master_Pivot_Table-_The_main_data_source_for_the_FMCG_report.mp421.78MB
272. Lesson_83._GetPivotData_is_great!_Extracting_data_from_the_Master_Pivot_Table.mp454.16MB
273. Lesson_84._Combining_Slicers_and_GetPivotData-_The_key_to_our_success.mp436.4MB
274. Lesson_85._Getting_fancy_with_Excel_slicers.mp435.81MB
275. Lesson_86._This_is_how_the_report_can_be_used_in_practice_by_high-level_executives.mp440.85MB
276. Lesson_87._Introduction_to_the_Exercise.mp436.66MB
277. Lesson_88._Let's_create_a_mapping_of_financials.mp430.73MB
278. Lesson_89._Building_an_output_P&L_sheet.mp430.55MB
279. Lesson_9._Excel_Formulas_for_Beginners.mp414.46MB
280. Lesson_90._Filling_in_the_output_P&L_sheet_with_historical_financials.mp423.9MB
281. Lesson_91._Calculating_percentage_variances_and_applying_conditional_formatting.mp427.21MB
282. Lesson_92._Building_an_output_Balance_sheet.mp429.48MB
283. Lesson_93._Using_Index,_Match,_Match_to_fill_in_the_output_Balance_sheet.mp443.49MB
284. Lesson_94._Adding_the_forecast_period.mp432.16MB
285. Lesson_95._Calculating_historical_percentage_ratios_and_use_Index_and_Match_for_scenarios.mp449.36MB
286. Lesson_96._Building_a_flexible_model_with_Choose_&_Match.mp416.07MB
287. Lesson_97._Building_a_flexible_model_with_Vlookup_&_Columns.mp436.27MB
288. Lesson_98._Calculating_historical_DSO,_DPO,_DIO,_Other_assets_%,_and_Other_liabilities_%.mp444.5MB
289. Lesson_99._Forecasting_DSO,_DPO,_DIO,_Other_assets_and_Other_liabilities.mp430.53MB