种子简介

种子名称： [FreeCourseSite.com] Udemy - The Complete Financial Analyst Course 2018
文件类型： 视频
文件数目： 289个文件
文件大小： 8.2 GB
收录时间： 2019-5-19 13:52
已经下载： 3次
资源热度： 166
最近下载： 2024-12-20 12:23

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:1a84d0971a06161cd7ed0bdbdb6c17eba51135d0&dn=[FreeCourseSite.com] Udemy - The Complete Financial Analyst Course 2018 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseSite.com] Udemy - The Complete Financial Analyst Course 2018.torrent

Lesson_1._What_Does_the_Course_Cover_.mp476.24MB

Lesson_10._A_Beginner's_Introduction_to_Excel_Functions.mp421.93MB

Lesson_100._Building_a_Fixed_asset_roll_forward.mp440.94MB

Lesson_101._Building_a_Financial_liabilities_schedule.mp447.55MB

Lesson_102._Building_an_Equity_schedule.mp436.57MB

Lesson_103._Preparing_a_Cash_flow_structure.mp415.2MB

Lesson_104._Calculating_Cash_flows_and_completing_the_model.mp457.47MB

Lesson_105._Accounting-_The_Science_Behind_Financial_Figures.mp432.89MB

Lesson_106._What_is_Accounting_and_Why_Do_You_Need_It.mp464.01MB

Lesson_107._The_Importance_of_Bookkeeping_-_Good_Accounting_Records_Are_Essential.mp426.67MB

Lesson_108._An_Introduction_to_Financial_Accounting.mp431.96MB

Lesson_109._The_different_types_of_accounting_standards.mp421.67MB

Lesson_11._Work_Efficiently_by_Using_Cut,_Copy,_and_Paste.mp414.48MB

Lesson_110._The_three_financial_statements.mp411.82MB

Lesson_111._Types_of_revenues.mp426.53MB

Lesson_112._Types_of_revenues_-_exercise.mp418.62MB

Lesson_113._Types_of_expenses.mp445.18MB

Lesson_114._Income_taxes.mp417.91MB

Lesson_115._Depreciation_&_Amortization.mp440.12MB

Lesson_116._Types_of_assets.mp431.78MB

Lesson_117._Asset_categories_-_practical_example.mp429.13MB

Lesson_118._Types_of_liabilities.mp427.49MB

Lesson_119._Liability_categories_-_practical_example.mp423.84MB

Lesson_12._Pasting_Values,_Formulas_and_Formats_with_Paste_Special.mp414.18MB

Lesson_120._Equity.mp415.02MB

Lesson_121._Accrual_accounting.mp413.65MB

Lesson_122._The_importance_of_timing_when_recognizing_revenues.mp423.48MB

Lesson_123._Revenue_recognition_criteria_-_technical.mp432.24MB

Lesson_124._Potential_conflicts_of_interest_when_recognizing_revenue.mp418.79MB

Lesson_125._A_practical_example.mp439.53MB

Lesson_126._Cost_recognition_principles.mp413.78MB

Lesson_127._Technical_aspects_of_cost_recognition.mp427.67MB

Lesson_128._The_two_types_of_Income_Statement_formats.mp47.27MB

Lesson_129._The_Revenue_Recognition_Principle_-_Why_Is_it_so_Important_.mp424.39MB

Lesson_13._Inserting_a_Line_Break_with_Alt_+_Enter.mp46.19MB

Lesson_130._The_Expense_Recognition_Principle_-_When_to_Recognize_Expenses.mp425.26MB

Lesson_131._Historical_Cost_vs._Fair_Value_Accounting.mp424.26MB

Lesson_132._The_Accounting_Equation_and_Its_Importance.mp424.49MB

Lesson_133._Elements_of_the_Accounting_System-_General_Ledger.mp416.07MB

Lesson_134._T-Accounts-_The_Best_Way_to_Understand_Debits_and_Credits.mp421.4MB

Lesson_135._P&L_T-Accounts.mp413.32MB

Lesson_136._How_to_Calculate_Depreciation_Expense.mp440.12MB

Lesson_137._The_Double-Entry_Principle_-_The_Core_Principle_of_Bookkeeping.mp424.08MB

Lesson_138._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(14).mp468.32MB

Lesson_139._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(24).mp446.4MB

Lesson_14._Do_More_with_Your_Sales_Data_with_Excel's_Text_to_Columns_Feature.mp413.86MB

Lesson_140._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(34).mp453.36MB

Lesson_141._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(44).mp458.95MB

Lesson_142._Calculating_Cash_Flows_-_Understand_if_a_business_makes_or_burns_cash.mp427.68MB

Lesson_143._The_three_parts_of_Cash_Flow_statements_explained.mp419.98MB

Lesson_144._Cash_Flow_computations_-_The_Direct_method.mp419.72MB

Lesson_145._Cash_Flow_computations_-_The_Indirect_method.mp431.36MB

Lesson_146._Calculating_Cash_Flow_in_practice-_A_complete_example.mp450.61MB

Lesson_147._Timing_of_Cash_Flows_and_Why_It_Plays_an_Important_Role_in_a_Business.mp413.24MB

Lesson_148._Timing_of_Income-_Principles_of_Revenue_Recognition.mp426.87MB

Lesson_149._Timing_of_Expenses-_Principles_of_Cost_Recognition.mp415.8MB

Lesson_15._Create_Easily_Printable_Excel_Documents.mp49.19MB

Lesson_150._The_Four_Type_of_Accruals_Arising_in_Accounting_Transactions.mp449.57MB

Lesson_151._Why_a_company_needs_to_pay_attention_to_trade_receivables_.mp425.23MB

Lesson_152._What_if_clients_do_not_pay_on_time_.mp426.47MB

Lesson_153._How_to_handle_non-paying_customers__A_case-study.mp424.94MB

Lesson_154._A_technique_to_collect_trade_receivables_sooner.mp415.44MB

Lesson_155._The_different_types_of_Inventory_we_can_have.mp426.66MB

Lesson_156._The_connection_between_Cost_of_Goods_Sold_and_Inventory.mp417.24MB

Lesson_157._Cost_flow_methods.mp428.72MB

Lesson_158._Cost_flow_methods_-_a_practical_exercise.mp46.75MB

Lesson_159._The_different_types_of_fixed_assets.mp420.71MB

Lesson_16._How_to_Wrap_Text_in_Excel_and_Adjust_a_Cell's_Size.mp43.78MB

Lesson_160._Capitalizing_interest_expenses.mp47.66MB

Lesson_161._Fair_value_accounting.mp424.26MB

Lesson_162._Intangible_assets_with_finite_life_vs._Intangible_assets_with_infinite_life.mp435.3MB

Lesson_163._The_revaluation_model.mp439.06MB

Lesson_164._The_revaluation_model_-_practical_exercise.mp436.31MB

Lesson_165._Intangible_assets_created_internally.mp417.69MB

Lesson_166._How_we_account_for_trade_payables.mp422.54MB

Lesson_167._What_is_the_difference_between_accounts_payable_and_notes_payable_.mp410.9MB

Lesson_168._Why_use_e-invoicing_.mp425.93MB

Lesson_169._The_difference_between_debt_and_equity.mp414.8MB

Lesson_17._Insert_Hyperlinks_into_Excel_Spreadsheets.mp48.25MB

Lesson_170._Amortizing_a_loan.mp420.65MB

Lesson_171._Debt_covenants.mp425.79MB

Lesson_172._Debt_covenants_-_a_practical_example.mp413.68MB

Lesson_173._The_reason_companies_lease_assets.mp411.12MB

Lesson_174._Solving_a_complete_leasing_exercise.mp438.17MB

Lesson_175._What_is_leverage_and_why_companies_use_financial_leverage_.mp457.42MB

Lesson_176._The_implications_of_using_excessive_leverage.mp434.49MB

Lesson_177._The_different_types_of_equity.mp455.22MB

Lesson_178._Raising_equity_in_different_stages_of_a_company's_lifecycle.mp471.95MB

Lesson_179._The_types_of_dividends_companies_pay_to_shareholders.mp444.87MB

Lesson_18._Using_Excel's_Freeze_Panes_to_Handle_Large_Datasets.mp415.25MB

Lesson_180._Dividend_payments_-_a_timeline.mp436.18MB

Lesson_181._What_are_share_repurchases_and_why_companies_do_them.mp443.91MB

Lesson_182._The_idea_behind_stock_splits.mp436.06MB

Lesson_183._What_is_a_10-K_Report_and_Why_Is_It_important_for_Investors_.mp427.32MB

Lesson_184._Finding,_Downloading_and_Going_Through_the_Annual_Report_of_P&G.mp474.98MB

Lesson_185._What_is_the_Role_of_Auditing_Firms_and_What_Are_the_Benefits_of_an_Audit_.mp425.86MB

Lesson_186._Indispensable_Tools_for_Financial_Statement_Analysis.mp415.34MB

Lesson_187._Financial_Statement_Analysis_-_A_Natural_Continuation_of_Financial_Accounting.mp418.47MB

Lesson_188._First_Steps_in_Financial_Statement_Analysis.mp432.08MB

Lesson_189._Horizontal_vs._Vertical_Financial_Statement_Analysis.mp428.26MB

Lesson_19._Find_Excel_Functionalities_in_a_Quicker_Way_-_Tell_Me_What_You_Want_to_Do.mp49.2MB

Lesson_190._Calculating_Days_Payable_(DPO),_Days_Receivable_(DSO)_and_Days_Inventory_(DIO).mp411.85MB

Lesson_191._Using_Accounting_Ratios_to_Assess_Business_Performance.mp436.82MB

Lesson_192._Case_Study_-_Calculating_Ratios_and_Analyzing_P&G's_Financials_(12).mp455.78MB

Lesson_193._Case_Study_-_Calculating_Ratios_and_Analyzing_P&G's_Financials_(22).mp436.91MB

Lesson_194._COURSE_CHALLENGE_-_Part_2.mp418.75MB

Lesson_195._What_you_will_see_next_in_this_section.mp418.33MB

Lesson_196._How_to_download_Tesla's_historical_financials.mp414.41MB

Lesson_197._Calculating_and_analyzing_growth_and_profitability_ratios.mp4105.11MB

Lesson_198._Calculating_and_analyzing_liquidity_ratios.mp474.95MB

Lesson_199._Calculating_and_analyzing_solvency_ratios.mp420.02MB

Lesson_2._Everything_We_Will_Learn_Has_a_Practical_Application.mp425.7MB

Lesson_20._A_Quick_Introduction_to_Excel's_Pivot_Tables.mp425.36MB

Lesson_200._Introduction.mp423.43MB

Lesson_201._The_importance_of_working_capital_optimization-_case_study.mp489.98MB

Lesson_202._Overtrading_vs._excessive_investment.mp433.12MB

Lesson_203._Trade_receivables_management.mp476.15MB

Lesson_204._Re-order_level.mp431.31MB

Lesson_205._Economic_order_quantity_(EOQ).mp431.85MB

Lesson_206._Inventory_optimization_techniques.mp450.48MB

Lesson_207._Trade_payables_management.mp419.28MB

Lesson_208._Working_capital_optimization_-_a_roadmap.mp448.18MB

Lesson_209._Symptoms_of_inefficient_working_capital_-_Trade_payables.mp417.95MB

Lesson_21._Initial_Formatting_Is_Key_for_Creating_Professional-looking_Spreadsheets.mp413.86MB

Lesson_210._Finance_101-_Important_Financial_Principles_That_You_Will_Need.mp416.11MB

Lesson_211._Understanding_the_Time_Value_of_Money.mp46.23MB

Lesson_212._How_Interest_Rates_Play_an_Important_Role_in_the_Economy_.mp413.76MB

Lesson_213._The_Components_Forming_Interest_Rates_in_Real_Life.mp416.64MB

Lesson_214._What_Is_Libor_and_What_Purpose_Does_It_Serve_.mp417.12MB

Lesson_215._The_Difference_Between_Fixed_and_Variable_Interest_Rates.mp417.03MB

Lesson_216._What_Is_Default_Risk_and_How_Does_a_Bank_Account_For_It_.mp431.16MB

Lesson_217._Corporate_Loan_Specifics.mp425.8MB

Lesson_218._Calculating_the_Present_Value_of_Future_Cash_Flows.mp429.8MB

Lesson_219._A_Tool_That_Helps_Us_Decide_Whether_a_Project_Is_Feasible-_Net_Present_Value.mp429.11MB

Lesson_22._Macros_Are_a_Great_Timesaver!_Here's_Why..mp421.46MB

Lesson_220._Using_Annuities.mp424.25MB

Lesson_221._Calculating_a_Complete_Loan_Schedule.mp449.62MB

Lesson_222._COURSE_CHALLENGE_-_Part_3.mp413.88MB

Lesson_223._What_is_Capital_Budgeting_.mp413.24MB

Lesson_224._When_Do_We_Use_Capital_Budgeting_.mp420.52MB

Lesson_225._The_Time_Value_of_Money_in_a_Capital_Budgeting_Setting.mp418.91MB

Lesson_226._Calculating_Present_and_Future_Value.mp437.5MB

Lesson_227._Cost_of_Equity.mp455.85MB

Lesson_228._Project-specific_Beta.mp427.2MB

Lesson_229._The_Weighted_Average_Cost_of_Capital_(WACC).mp415.71MB

Lesson_23._The_Secret_to_Faster_Scrolling_in_Excel.mp420.84MB

Lesson_230._The_Different_Cash_Flow_Types_in_a_Capital_Budgeting_Exercise.mp424.31MB

Lesson_231._Modeling_Future_Cash_Flows.mp454.39MB

Lesson_232._An_introduction_to_the_Case_Study.mp425.3MB

Lesson_233._Organizing_inputs_in_the_Drivers_sheet.mp438.17MB

Lesson_234._Modeling_expected_savings_-_Building_cars_in_Italy_vs._Building_cars_in_Vietnam.mp434.75MB

Lesson_235._Preparing_a_fixed_asset_rollforward_schedule.mp447.37MB

Lesson_236._Calculating_the_cash_impact_of_extra_working_capital_required.mp418.35MB

Lesson_237._Debt_repayment_and_interest_expenses_calculation.mp422.14MB

Lesson_238._The_project's_P&L_sheet.mp413.93MB

Lesson_239._The_project's_cash_flow_calculation.mp430.85MB

Lesson_24._Using_Absolute_and_Relative_Cell_References.mp427.02MB

Lesson_240._Calculating_WACC_(Weighted_Average_Cost_of_Capital).mp418.53MB

Lesson_241._Estimating_cost_of_equity.mp440.39MB

Lesson_242._Discounting_project_cash_flows.mp422.57MB

Lesson_243._Performing_sensitivity_analysis_and_wrapping_up_the_Case_Study.mp434.12MB

Lesson_244._Organizing_external_inputs_in_a_'Drivers'_sheet.mp431MB

Lesson_245._The_input_data_we_will_work_with.mp415.81MB

Lesson_246._Forecasting_Tesla's_expected_deliveries.mp4114.92MB

Lesson_247._Comparing_delivery_figures_with_the_ones_of_industry_peers.mp420.98MB

Lesson_248._Estimating_an_average_selling_price_of_Tesla_vehicles.mp441.93MB

Lesson_249._Calculating_automotive_revenue.mp446.56MB

Lesson_25._Find_and_Select_Cells_That_Meet_Specific_Conditions.mp413.45MB

Lesson_250._Peer_comparison-_Gross_profit_%.mp417.19MB

Lesson_251._Calculating_automotive_gross_profit.mp427.79MB

Lesson_252._Calculating_automotive_cost_of_sales.mp417.53MB

Lesson_253._Forecasting_'energy'_and_'services'_revenue.mp425.29MB

Lesson_254._Calculating_'energy'_and_'services'_gross_profit_and_cost_of_sales.mp426.81MB

Lesson_255._Forecasting_operating_expenses.mp434.48MB

Lesson_256._Building_a_fixed_asset_roll_forward-_estimating_Capex.mp456.51MB

Lesson_257._Building_a_fixed_asset_roll_forward-_D&A_schedule.mp454.15MB

Lesson_258._Peer_comparison-_D&A_as_a_percentage_of_revenues.mp413.63MB

Lesson_259._Calculating_DSO,_DIO,_DPO.mp417.52MB

Lesson_26._How_to_Create_Dynamic_Names_in_Excel_Spreadsheets.mp415.14MB

Lesson_260._Producing_a_clean_P&L_output_sheet.mp48.44MB

Lesson_261._Fill_in_the_P&L_output_sheet.mp418.35MB

Lesson_262._Calculating_investments_in_working_capital.mp419.05MB

Lesson_263._Forecasting_Unlevered_Free_Cash_Flow.mp455.98MB

Lesson_264._Forecasting_other_assets.mp445.3MB

Lesson_265._Forecasting_other_liabilities.mp422.05MB

Lesson_266._Completing_Unlevered_Free_Cash_Flow.mp440.9MB

Lesson_267._Modeling_Tesla's_financing_needs_in_the_forecast_period.mp442.37MB

Lesson_268._Calculating_Net_income.mp414.8MB

Lesson_269._Bridging_Unlevered_Free_Cash_Flow_to_Net_Cash_Flow.mp450.67MB

Lesson_27._Using_Named_Ranges_to_Make_Formulas_More_Readable.mp49.12MB

Lesson_270._Balancing_the_Balance_sheet.mp413.29MB

Lesson_271._Microsoft_PowerPoint-_The_Most_Popular_Presentation_Software_for_the_Office.mp418.4MB

Lesson_272._The_Structure_of_the_PowerPoint_Ribbon.mp434.23MB

Lesson_273._General_Considerations_About_Slide_Structure.mp424.62MB

Lesson_274._Learn_How_to_Insert_Objects_in_PowerPoint.mp429.73MB

Lesson_275._Shortcuts_Allow_Us_To_Be_Much_Faster_When_Working_in_PowerPoint.mp415.52MB

Lesson_276._Add_Frequently_Used_Buttons_to_the_Quick_Access_Toolbar.mp422.78MB

Lesson_277._How_to_Easily_Align_Objects_in_PowerPoint.mp419.99MB

Lesson_278._How_to_Edit_Shapes_in_Your_Presentation.mp429.18MB

Lesson_279._How_to_Format_Text_Boxes_in_a_PowerPoint_Presentation.mp419.87MB

Lesson_28._Custom_Number_Formatting.mp49.89MB

Lesson_280._Changing_an_Object's_Size_and_Rotation.mp48.69MB

Lesson_281._Using_Slide_Masters.mp433.99MB

Lesson_282._Modifying_the_Beginning_and_Ending_of_a_Line_Object.mp412.16MB

Lesson_283._Join_Shapes_Together_By_Using_Connector_Lines.mp422.25MB

Lesson_284._Group_or_Ungroup_Shapes,_Pictures_or_Other_Objects.mp48.98MB

Lesson_285._This_is_How_You_Can_Fit_Text_When_It_Is_Larger_than_a_Shape.mp411.8MB

Lesson_286._PowerPoint's_Smart_Art_Feature_Offers_Great_Return_for_Your_Time.mp424.08MB

Lesson_287._Creating_Eye-Catching_Text_Effects_in_PowerPoint.mp413.33MB

Lesson_288._Practical_Exercise_-_Creating_an_Organisational_Chart.mp451.58MB

Lesson_289._COURSE_CHALLENGE_-_Part_4.mp426.05MB

Lesson_29._How_to_Add_a_Drop-down_List_in_Excel.mp416.29MB

Lesson_3._The_Best_Way_to_Take_This_Course.mp431.22MB

Lesson_30._Using_Custom-sort_to_Sort_Multiple_Columns_Within_a_Table.mp413.6MB

Lesson_31._Saving_Time_in_Excel_and_Doing_Everything_Faster_by_Using_Excel_Shortcuts.mp445.95MB

Lesson_32._Key_Excel_Functions-_Sum,_Sumif,_Sumifs.mp430.69MB

Lesson_33._Key_Excel_Functions-_Count,_Counta,_Countif,_Countifs.mp431.2MB

Lesson_34._Key_Excel_Functions-_Average_&_Averageif.mp415.11MB

Lesson_35._Key_Excel_Functions-_Left,_Right,_Mid,_Upper,_Lower,_Proper,_Concatenate,_&.mp430.36MB

Lesson_36._Find_the_Highest_and_Lowest_Values_in_a_Range-_Max_&_Min.mp47.54MB

Lesson_37._Use_Round_in_Your_Financial_Models.mp45.21MB

Lesson_38._Excel's_Lookup_Functions-_Vlookup_&_Hlookup_Made_Easy.mp460.27MB

Lesson_39._Index,_Match,_and_Their_Combination_-_The_Perfect_Substitute_for_Vlookup.mp461.79MB

Lesson_4._Microsoft_Excel-_The_World's_#1_Office_Software.mp422.03MB

Lesson_40._Using_Excel's_Iferror_Function_to_Trap_Spreadsheet_Errors.mp411.75MB

Lesson_41._Create_Flexible_Financial_Models_with_Choose.mp419.84MB

Lesson_42._Goal_Seek_Will_Help_You_Find_the_Result_You_Are_Looking_For.mp416.03MB

Lesson_43._Perform_Sensitivity_Analysis_with_Excel's_Data_Tables_Functionality.mp426.22MB

Lesson_44._Discounting_cash_flows_in_Microsoft_Excel.mp445.69MB

Lesson_45._Calculating_Internal_Rate_of_Return_(IRR)_in_Excel.mp422.76MB

Lesson_46._Using_the_PMT_function_to_create_a_complete_loan_schedule.mp440.07MB

Lesson_47._Date_functions_in_Excel.mp430.8MB

Lesson_48._Understand_Your_Data_Source_Before_You_Start_Working_on_It.mp439.36MB

Lesson_49._Ordering_the_Source_Worksheet.mp424.01MB

Lesson_5._Excel_Made_Easy-_A_Beginner's_Guide_to_Excel_Spreadsheets.mp422.75MB

Lesson_50._Create_a_Code-_The_Best_Way_to_Organize_Your_Data_and_Work_Efficiently_with_It.mp424.87MB

Lesson_51._Learn_How_to_Create_a_Database.mp423.6MB

Lesson_52._Using_Lookup_Functions_(Vlookup)_to_Fill_the_Database_Sheet.mp465.19MB

Lesson_53._Use_Sumif_to_Complete_the_Database_Sheet.mp450.72MB

Lesson_54._Using_Index_&_Match_as_a_Substitute_for_Vlookup.mp452.08MB

Lesson_55._Mapping_the_Rows_in_the_Database_Sheet.mp431.12MB

Lesson_56._Building_the_Structure_of_the_P&L_Sheet.mp420.8MB

Lesson_57._A_Practical_Example_of_Professional_Formatting_in_Excel.mp427.5MB

Lesson_58._Populate_the_P&L_Sheet_with_Sumif.mp427.77MB

Lesson_59._Learn_How_to_Find_Mistakes_with_Countif.mp429.44MB

Lesson_6._Data_Entry_Techniques_in_Excel.mp417.33MB

Lesson_60._Calculating_Growth_Rates_in_Excel.mp431.93MB

Lesson_61._Introduction_to_Excel_Charts.mp413.01MB

Lesson_62._Beginner's_Guide_to_Inserting_Charts_in_Excel.mp422.28MB

Lesson_63._Modifying_Excel_Charts_-_The_Easy_Way.mp426.05MB

Lesson_64._Making_Your_Excel_Charts_Sexier_-_Proven_Tips.mp432.69MB

Lesson_65._Creating_a_Bridge_Chart_in_Excel_2016_-_As_Easy_as_It_Gets.mp413.66MB

Lesson_66._New_Ways_to_Visualize_Your_Data_-_Treemap_Charts.mp411.51MB

Lesson_67._How_to_Represent_Trends_with_Sparklines.mp427.54MB

Lesson_68._Pivot_Tables_-_Excel's_Dynamic_and_Interactive_Tables.mp415.06MB

Lesson_69._Creating_a_Pivot_Table-_Choosing_Row_and_Column_Parameters.mp438.94MB

Lesson_7._How_to_Make_Your_Spreadsheets_Look_Professional.mp444.84MB

Lesson_70._Design_the_Layout_and_Format_of_Your_Pivot_Tables.mp421.54MB

Lesson_71._Additional_Techniques_That_Will_Ease_Your_Work_with_Pivot_Tables.mp446.01MB

Lesson_72._One_of_the_Most_Useful_Excel_Functions_-_GetPivotData.mp436.28MB

Lesson_73._Welcome_to_the_Future_-_Pivot_Table_Slicers.mp445.18MB

Lesson_74._Introduction_to_the_Course_Challenge.mp413.18MB

Lesson_75._COURSE_CHALLENGE_-_Part_1.mp414.38MB

Lesson_76._Introduction_to_the_Case_Study.mp426.73MB

Lesson_77._Working_with_an_SAP_data_extraction.mp439.2MB

Lesson_78._Preliminary_mapping_of_the_data_extraction.mp431.17MB

Lesson_79._Creating_an_output_structure_of_the_FMCG_model.mp422.18MB

Lesson_8._Inserting,_Deleting,_and_Modifying_Rows_&_Columns.mp412.36MB

Lesson_80._Improving_the_layout_and_appearance_of_the_FMCG_report.mp427.14MB

Lesson_81._Inserting_formulas_and_automating_calculations.mp418.09MB

Lesson_82._Creating_a_Master_Pivot_Table-_The_main_data_source_for_the_FMCG_report.mp421.78MB

Lesson_83._GetPivotData_is_great!_Extracting_data_from_the_Master_Pivot_Table.mp454.16MB

Lesson_84._Combining_Slicers_and_GetPivotData-_The_key_to_our_success.mp436.4MB

Lesson_85._Getting_fancy_with_Excel_slicers.mp435.81MB

Lesson_86._This_is_how_the_report_can_be_used_in_practice_by_high-level_executives.mp440.85MB

Lesson_87._Introduction_to_the_Exercise.mp436.66MB

Lesson_88._Let's_create_a_mapping_of_financials.mp430.73MB

Lesson_89._Building_an_output_P&L_sheet.mp430.55MB

Lesson_9._Excel_Formulas_for_Beginners.mp414.46MB

Lesson_90._Filling_in_the_output_P&L_sheet_with_historical_financials.mp423.9MB

Lesson_91._Calculating_percentage_variances_and_applying_conditional_formatting.mp427.21MB

Lesson_92._Building_an_output_Balance_sheet.mp429.48MB

Lesson_93._Using_Index,_Match,_Match_to_fill_in_the_output_Balance_sheet.mp443.49MB

Lesson_94._Adding_the_forecast_period.mp432.16MB

Lesson_95._Calculating_historical_percentage_ratios_and_use_Index_and_Match_for_scenarios.mp449.36MB

Lesson_96._Building_a_flexible_model_with_Choose_&_Match.mp416.07MB

Lesson_97._Building_a_flexible_model_with_Vlookup_&_Columns.mp436.27MB

Lesson_98._Calculating_historical_DSO,_DPO,_DIO,_Other_assets_%,_and_Other_liabilities_%.mp444.5MB

Lesson_99._Forecasting_DSO,_DPO,_DIO,_Other_assets_and_Other_liabilities.mp430.53MB