|
/
|
|
Lesson_1._What_Does_the_Course_Cover_.mp4
|
79.9 MB
|
|
Lesson_10._A_Beginner's_Introduction_to_Excel_Functions.mp4
|
23.0 MB
|
|
Lesson_100._Building_a_Fixed_asset_roll_forward.mp4
|
42.9 MB
|
|
Lesson_101._Building_a_Financial_liabilities_schedule.mp4
|
49.9 MB
|
|
Lesson_102._Building_an_Equity_schedule.mp4
|
38.3 MB
|
|
Lesson_103._Preparing_a_Cash_flow_structure.mp4
|
15.9 MB
|
|
Lesson_104._Calculating_Cash_flows_and_completing_the_model.mp4
|
60.3 MB
|
|
Lesson_105._Accounting-_The_Science_Behind_Financial_Figures.mp4
|
34.5 MB
|
|
Lesson_106._What_is_Accounting_and_Why_Do_You_Need_It.mp4
|
67.1 MB
|
|
Lesson_107._The_Importance_of_Bookkeeping_-_Good_Accounting_Records_Are_Essential.mp4
|
28.0 MB
|
|
Lesson_108._An_Introduction_to_Financial_Accounting.mp4
|
33.5 MB
|
|
Lesson_109._The_different_types_of_accounting_standards.mp4
|
22.7 MB
|
|
Lesson_11._Work_Efficiently_by_Using_Cut,_Copy,_and_Paste.mp4
|
15.2 MB
|
|
Lesson_110._The_three_financial_statements.mp4
|
12.4 MB
|
|
Lesson_111._Types_of_revenues.mp4
|
27.8 MB
|
|
Lesson_112._Types_of_revenues_-_exercise.mp4
|
19.5 MB
|
|
Lesson_113._Types_of_expenses.mp4
|
47.4 MB
|
|
Lesson_114._Income_taxes.mp4
|
18.8 MB
|
|
Lesson_115._Depreciation_&_Amortization.mp4
|
42.1 MB
|
|
Lesson_116._Types_of_assets.mp4
|
33.3 MB
|
|
Lesson_117._Asset_categories_-_practical_example.mp4
|
30.5 MB
|
|
Lesson_118._Types_of_liabilities.mp4
|
28.8 MB
|
|
Lesson_119._Liability_categories_-_practical_example.mp4
|
25.0 MB
|
|
Lesson_12._Pasting_Values,_Formulas_and_Formats_with_Paste_Special.mp4
|
14.9 MB
|
|
Lesson_120._Equity.mp4
|
15.8 MB
|
|
Lesson_121._Accrual_accounting.mp4
|
14.3 MB
|
|
Lesson_122._The_importance_of_timing_when_recognizing_revenues.mp4
|
24.6 MB
|
|
Lesson_123._Revenue_recognition_criteria_-_technical.mp4
|
33.8 MB
|
|
Lesson_124._Potential_conflicts_of_interest_when_recognizing_revenue.mp4
|
19.7 MB
|
|
Lesson_125._A_practical_example.mp4
|
41.4 MB
|
|
Lesson_126._Cost_recognition_principles.mp4
|
14.4 MB
|
|
Lesson_127._Technical_aspects_of_cost_recognition.mp4
|
29.0 MB
|
|
Lesson_128._The_two_types_of_Income_Statement_formats.mp4
|
7.6 MB
|
|
Lesson_129._The_Revenue_Recognition_Principle_-_Why_Is_it_so_Important_.mp4
|
25.6 MB
|
|
Lesson_13._Inserting_a_Line_Break_with_Alt_+_Enter.mp4
|
6.5 MB
|
|
Lesson_130._The_Expense_Recognition_Principle_-_When_to_Recognize_Expenses.mp4
|
26.5 MB
|
|
Lesson_131._Historical_Cost_vs._Fair_Value_Accounting.mp4
|
25.4 MB
|
|
Lesson_132._The_Accounting_Equation_and_Its_Importance.mp4
|
25.7 MB
|
|
Lesson_133._Elements_of_the_Accounting_System-_General_Ledger.mp4
|
16.8 MB
|
|
Lesson_134._T-Accounts-_The_Best_Way_to_Understand_Debits_and_Credits.mp4
|
22.4 MB
|
|
Lesson_135._P&L_T-Accounts.mp4
|
14.0 MB
|
|
Lesson_136._How_to_Calculate_Depreciation_Expense.mp4
|
42.1 MB
|
|
Lesson_137._The_Double-Entry_Principle_-_The_Core_Principle_of_Bookkeeping.mp4
|
25.2 MB
|
|
Lesson_138._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(14).mp4
|
71.6 MB
|
|
Lesson_139._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(24).mp4
|
48.7 MB
|
|
Lesson_14._Do_More_with_Your_Sales_Data_with_Excel's_Text_to_Columns_Feature.mp4
|
14.5 MB
|
|
Lesson_140._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(34).mp4
|
56.0 MB
|
|
Lesson_141._Case_Study_-_The_Accounting_Transactions_of_a_Lemonade_Stand_(44).mp4
|
61.8 MB
|
|
Lesson_142._Calculating_Cash_Flows_-_Understand_if_a_business_makes_or_burns_cash.mp4
|
29.0 MB
|
|
Lesson_143._The_three_parts_of_Cash_Flow_statements_explained.mp4
|
20.9 MB
|
|
Lesson_144._Cash_Flow_computations_-_The_Direct_method.mp4
|
20.7 MB
|
|
Lesson_145._Cash_Flow_computations_-_The_Indirect_method.mp4
|
32.9 MB
|
|
Lesson_146._Calculating_Cash_Flow_in_practice-_A_complete_example.mp4
|
53.1 MB
|
|
Lesson_147._Timing_of_Cash_Flows_and_Why_It_Plays_an_Important_Role_in_a_Business.mp4
|
13.9 MB
|
|
Lesson_148._Timing_of_Income-_Principles_of_Revenue_Recognition.mp4
|
28.2 MB
|
|
Lesson_149._Timing_of_Expenses-_Principles_of_Cost_Recognition.mp4
|
16.6 MB
|
|
Lesson_15._Create_Easily_Printable_Excel_Documents.mp4
|
9.6 MB
|
|
Lesson_150._The_Four_Type_of_Accruals_Arising_in_Accounting_Transactions.mp4
|
52.0 MB
|
|
Lesson_151._Why_a_company_needs_to_pay_attention_to_trade_receivables_.mp4
|
26.5 MB
|
|
Lesson_152._What_if_clients_do_not_pay_on_time_.mp4
|
27.8 MB
|
|
Lesson_153._How_to_handle_non-paying_customers__A_case-study.mp4
|
26.2 MB
|
|
Lesson_154._A_technique_to_collect_trade_receivables_sooner.mp4
|
16.2 MB
|
|
Lesson_155._The_different_types_of_Inventory_we_can_have.mp4
|
28.0 MB
|
|
Lesson_156._The_connection_between_Cost_of_Goods_Sold_and_Inventory.mp4
|
18.1 MB
|
|
Lesson_157._Cost_flow_methods.mp4
|
30.1 MB
|
|
Lesson_158._Cost_flow_methods_-_a_practical_exercise.mp4
|
7.1 MB
|
|
Lesson_159._The_different_types_of_fixed_assets.mp4
|
21.7 MB
|
|
Lesson_16._How_to_Wrap_Text_in_Excel_and_Adjust_a_Cell's_Size.mp4
|
4.0 MB
|
|
Lesson_160._Capitalizing_interest_expenses.mp4
|
8.0 MB
|
|
Lesson_161._Fair_value_accounting.mp4
|
25.4 MB
|
|
Lesson_162._Intangible_assets_with_finite_life_vs._Intangible_assets_with_infinite_life.mp4
|
37.0 MB
|
|
Lesson_163._The_revaluation_model.mp4
|
41.0 MB
|
|
Lesson_164._The_revaluation_model_-_practical_exercise.mp4
|
38.1 MB
|
|
Lesson_165._Intangible_assets_created_internally.mp4
|
18.5 MB
|
|
Lesson_166._How_we_account_for_trade_payables.mp4
|
23.6 MB
|
|
Lesson_167._What_is_the_difference_between_accounts_payable_and_notes_payable_.mp4
|
11.4 MB
|
|
Lesson_168._Why_use_e-invoicing_.mp4
|
27.2 MB
|
|
Lesson_169._The_difference_between_debt_and_equity.mp4
|
15.5 MB
|
|
Lesson_17._Insert_Hyperlinks_into_Excel_Spreadsheets.mp4
|
8.6 MB
|
|
Lesson_170._Amortizing_a_loan.mp4
|
21.6 MB
|
|
Lesson_171._Debt_covenants.mp4
|
27.0 MB
|
|
Lesson_172._Debt_covenants_-_a_practical_example.mp4
|
14.3 MB
|
|
Lesson_173._The_reason_companies_lease_assets.mp4
|
11.7 MB
|
|
Lesson_174._Solving_a_complete_leasing_exercise.mp4
|
40.0 MB
|
|
Lesson_175._What_is_leverage_and_why_companies_use_financial_leverage_.mp4
|
60.2 MB
|
|
Lesson_176._The_implications_of_using_excessive_leverage.mp4
|
36.2 MB
|
|
Lesson_177._The_different_types_of_equity.mp4
|
57.9 MB
|
|
Lesson_178._Raising_equity_in_different_stages_of_a_company's_lifecycle.mp4
|
75.4 MB
|
|
Lesson_179._The_types_of_dividends_companies_pay_to_shareholders.mp4
|
47.1 MB
|
|
Lesson_18._Using_Excel's_Freeze_Panes_to_Handle_Large_Datasets.mp4
|
16.0 MB
|
|
Lesson_180._Dividend_payments_-_a_timeline.mp4
|
37.9 MB
|
|
Lesson_181._What_are_share_repurchases_and_why_companies_do_them.mp4
|
46.0 MB
|
|
Lesson_182._The_idea_behind_stock_splits.mp4
|
37.8 MB
|
|
Lesson_183._What_is_a_10-K_Report_and_Why_Is_It_important_for_Investors_.mp4
|
28.7 MB
|
|
Lesson_184._Finding,_Downloading_and_Going_Through_the_Annual_Report_of_P&G.mp4
|
78.6 MB
|
|
Lesson_185._What_is_the_Role_of_Auditing_Firms_and_What_Are_the_Benefits_of_an_Audit_.mp4
|
27.1 MB
|
|
Lesson_186._Indispensable_Tools_for_Financial_Statement_Analysis.mp4
|
16.1 MB
|
|
Lesson_187._Financial_Statement_Analysis_-_A_Natural_Continuation_of_Financial_Accounting.mp4
|
19.4 MB
|
|
Lesson_188._First_Steps_in_Financial_Statement_Analysis.mp4
|
33.6 MB
|
|
Lesson_189._Horizontal_vs._Vertical_Financial_Statement_Analysis.mp4
|
29.6 MB
|
|
Lesson_19._Find_Excel_Functionalities_in_a_Quicker_Way_-_Tell_Me_What_You_Want_to_Do.mp4
|
9.7 MB
|
|
Lesson_190._Calculating_Days_Payable_(DPO),_Days_Receivable_(DSO)_and_Days_Inventory_(DIO).mp4
|
12.4 MB
|
|
Lesson_191._Using_Accounting_Ratios_to_Assess_Business_Performance.mp4
|
38.6 MB
|
|
Lesson_192._Case_Study_-_Calculating_Ratios_and_Analyzing_P&G's_Financials_(12).mp4
|
58.5 MB
|
|
Lesson_193._Case_Study_-_Calculating_Ratios_and_Analyzing_P&G's_Financials_(22).mp4
|
38.7 MB
|
|
Lesson_194._COURSE_CHALLENGE_-_Part_2.mp4
|
19.7 MB
|
|
Lesson_195._What_you_will_see_next_in_this_section.mp4
|
19.2 MB
|
|
Lesson_196._How_to_download_Tesla's_historical_financials.mp4
|
15.1 MB
|
|
Lesson_197._Calculating_and_analyzing_growth_and_profitability_ratios.mp4
|
110.2 MB
|
|
Lesson_198._Calculating_and_analyzing_liquidity_ratios.mp4
|
78.6 MB
|
|
Lesson_199._Calculating_and_analyzing_solvency_ratios.mp4
|
21.0 MB
|
|
Lesson_2._Everything_We_Will_Learn_Has_a_Practical_Application.mp4
|
26.9 MB
|
|
Lesson_20._A_Quick_Introduction_to_Excel's_Pivot_Tables.mp4
|
26.6 MB
|
|
Lesson_200._Introduction.mp4
|
24.6 MB
|
|
Lesson_201._The_importance_of_working_capital_optimization-_case_study.mp4
|
94.4 MB
|
|
Lesson_202._Overtrading_vs._excessive_investment.mp4
|
34.7 MB
|
|
Lesson_203._Trade_receivables_management.mp4
|
79.8 MB
|
|
Lesson_204._Re-order_level.mp4
|
32.8 MB
|
|
Lesson_205._Economic_order_quantity_(EOQ).mp4
|
33.4 MB
|
|
Lesson_206._Inventory_optimization_techniques.mp4
|
52.9 MB
|
|
Lesson_207._Trade_payables_management.mp4
|
20.2 MB
|
|
Lesson_208._Working_capital_optimization_-_a_roadmap.mp4
|
50.5 MB
|
|
Lesson_209._Symptoms_of_inefficient_working_capital_-_Trade_payables.mp4
|
18.8 MB
|
|
Lesson_21._Initial_Formatting_Is_Key_for_Creating_Professional-looking_Spreadsheets.mp4
|
14.5 MB
|
|
Lesson_210._Finance_101-_Important_Financial_Principles_That_You_Will_Need.mp4
|
16.9 MB
|
|
Lesson_211._Understanding_the_Time_Value_of_Money.mp4
|
6.5 MB
|
|
Lesson_212._How_Interest_Rates_Play_an_Important_Role_in_the_Economy_.mp4
|
14.4 MB
|
|
Lesson_213._The_Components_Forming_Interest_Rates_in_Real_Life.mp4
|
17.4 MB
|
|
Lesson_214._What_Is_Libor_and_What_Purpose_Does_It_Serve_.mp4
|
18.0 MB
|
|
Lesson_215._The_Difference_Between_Fixed_and_Variable_Interest_Rates.mp4
|
17.9 MB
|
|
Lesson_216._What_Is_Default_Risk_and_How_Does_a_Bank_Account_For_It_.mp4
|
32.7 MB
|
|
Lesson_217._Corporate_Loan_Specifics.mp4
|
27.1 MB
|
|
Lesson_218._Calculating_the_Present_Value_of_Future_Cash_Flows.mp4
|
31.2 MB
|
|
Lesson_219._A_Tool_That_Helps_Us_Decide_Whether_a_Project_Is_Feasible-_Net_Present_Value.mp4
|
30.5 MB
|
|
Lesson_22._Macros_Are_a_Great_Timesaver!_Here's_Why..mp4
|
22.5 MB
|
|
Lesson_220._Using_Annuities.mp4
|
25.4 MB
|
|
Lesson_221._Calculating_a_Complete_Loan_Schedule.mp4
|
52.0 MB
|
|
Lesson_222._COURSE_CHALLENGE_-_Part_3.mp4
|
14.6 MB
|
|
Lesson_223._What_is_Capital_Budgeting_.mp4
|
13.9 MB
|
|
Lesson_224._When_Do_We_Use_Capital_Budgeting_.mp4
|
21.5 MB
|
|
Lesson_225._The_Time_Value_of_Money_in_a_Capital_Budgeting_Setting.mp4
|
19.8 MB
|
|
Lesson_226._Calculating_Present_and_Future_Value.mp4
|
39.3 MB
|
|
Lesson_227._Cost_of_Equity.mp4
|
58.6 MB
|
|
Lesson_228._Project-specific_Beta.mp4
|
28.5 MB
|
|
Lesson_229._The_Weighted_Average_Cost_of_Capital_(WACC).mp4
|
16.5 MB
|
|
Lesson_23._The_Secret_to_Faster_Scrolling_in_Excel.mp4
|
21.8 MB
|
|
Lesson_230._The_Different_Cash_Flow_Types_in_a_Capital_Budgeting_Exercise.mp4
|
25.5 MB
|
|
Lesson_231._Modeling_Future_Cash_Flows.mp4
|
57.0 MB
|
|
Lesson_232._An_introduction_to_the_Case_Study.mp4
|
26.5 MB
|
|
Lesson_233._Organizing_inputs_in_the_Drivers_sheet.mp4
|
40.0 MB
|
|
Lesson_234._Modeling_expected_savings_-_Building_cars_in_Italy_vs._Building_cars_in_Vietnam.mp4
|
36.4 MB
|
|
Lesson_235._Preparing_a_fixed_asset_rollforward_schedule.mp4
|
49.7 MB
|
|
Lesson_236._Calculating_the_cash_impact_of_extra_working_capital_required.mp4
|
19.2 MB
|
|
Lesson_237._Debt_repayment_and_interest_expenses_calculation.mp4
|
23.2 MB
|
|
Lesson_238._The_project's_P&L_sheet.mp4
|
14.6 MB
|
|
Lesson_239._The_project's_cash_flow_calculation.mp4
|
32.3 MB
|
|
Lesson_24._Using_Absolute_and_Relative_Cell_References.mp4
|
28.3 MB
|
|
Lesson_240._Calculating_WACC_(Weighted_Average_Cost_of_Capital).mp4
|
19.4 MB
|
|
Lesson_241._Estimating_cost_of_equity.mp4
|
42.3 MB
|
|
Lesson_242._Discounting_project_cash_flows.mp4
|
23.7 MB
|
|
Lesson_243._Performing_sensitivity_analysis_and_wrapping_up_the_Case_Study.mp4
|
35.8 MB
|
|
Lesson_244._Organizing_external_inputs_in_a_'Drivers'_sheet.mp4
|
32.5 MB
|
|
Lesson_245._The_input_data_we_will_work_with.mp4
|
16.6 MB
|
|
Lesson_246._Forecasting_Tesla's_expected_deliveries.mp4
|
120.5 MB
|
|
Lesson_247._Comparing_delivery_figures_with_the_ones_of_industry_peers.mp4
|
22.0 MB
|
|
Lesson_248._Estimating_an_average_selling_price_of_Tesla_vehicles.mp4
|
44.0 MB
|
|
Lesson_249._Calculating_automotive_revenue.mp4
|
48.8 MB
|
|
Lesson_25._Find_and_Select_Cells_That_Meet_Specific_Conditions.mp4
|
14.1 MB
|
|
Lesson_250._Peer_comparison-_Gross_profit_%.mp4
|
18.0 MB
|
|
Lesson_251._Calculating_automotive_gross_profit.mp4
|
29.1 MB
|
|
Lesson_252._Calculating_automotive_cost_of_sales.mp4
|
18.4 MB
|
|
Lesson_253._Forecasting_'energy'_and_'services'_revenue.mp4
|
26.5 MB
|
|
Lesson_254._Calculating_'energy'_and_'services'_gross_profit_and_cost_of_sales.mp4
|
28.1 MB
|
|
Lesson_255._Forecasting_operating_expenses.mp4
|
36.2 MB
|
|
Lesson_256._Building_a_fixed_asset_roll_forward-_estimating_Capex.mp4
|
59.3 MB
|
|
Lesson_257._Building_a_fixed_asset_roll_forward-_D&A_schedule.mp4
|
56.8 MB
|
|
Lesson_258._Peer_comparison-_D&A_as_a_percentage_of_revenues.mp4
|
14.3 MB
|
|
Lesson_259._Calculating_DSO,_DIO,_DPO.mp4
|
18.4 MB
|
|
Lesson_26._How_to_Create_Dynamic_Names_in_Excel_Spreadsheets.mp4
|
15.9 MB
|
|
Lesson_260._Producing_a_clean_P&L_output_sheet.mp4
|
8.9 MB
|
|
Lesson_261._Fill_in_the_P&L_output_sheet.mp4
|
19.2 MB
|
|
Lesson_262._Calculating_investments_in_working_capital.mp4
|
20.0 MB
|
|
Lesson_263._Forecasting_Unlevered_Free_Cash_Flow.mp4
|
58.7 MB
|
|
Lesson_264._Forecasting_other_assets.mp4
|
47.5 MB
|
|
Lesson_265._Forecasting_other_liabilities.mp4
|
23.1 MB
|
|
Lesson_266._Completing_Unlevered_Free_Cash_Flow.mp4
|
42.9 MB
|
|
Lesson_267._Modeling_Tesla's_financing_needs_in_the_forecast_period.mp4
|
44.4 MB
|
|
Lesson_268._Calculating_Net_income.mp4
|
15.5 MB
|
|
Lesson_269._Bridging_Unlevered_Free_Cash_Flow_to_Net_Cash_Flow.mp4
|
53.1 MB
|
|
Lesson_27._Using_Named_Ranges_to_Make_Formulas_More_Readable.mp4
|
9.6 MB
|
|
Lesson_270._Balancing_the_Balance_sheet.mp4
|
13.9 MB
|
|
Lesson_271._Microsoft_PowerPoint-_The_Most_Popular_Presentation_Software_for_the_Office.mp4
|
19.3 MB
|
|
Lesson_272._The_Structure_of_the_PowerPoint_Ribbon.mp4
|
35.9 MB
|
|
Lesson_273._General_Considerations_About_Slide_Structure.mp4
|
25.8 MB
|
|
Lesson_274._Learn_How_to_Insert_Objects_in_PowerPoint.mp4
|
31.2 MB
|
|
Lesson_275._Shortcuts_Allow_Us_To_Be_Much_Faster_When_Working_in_PowerPoint.mp4
|
16.3 MB
|
|
Lesson_276._Add_Frequently_Used_Buttons_to_the_Quick_Access_Toolbar.mp4
|
23.9 MB
|
|
Lesson_277._How_to_Easily_Align_Objects_in_PowerPoint.mp4
|
21.0 MB
|
|
Lesson_278._How_to_Edit_Shapes_in_Your_Presentation.mp4
|
30.6 MB
|
|
Lesson_279._How_to_Format_Text_Boxes_in_a_PowerPoint_Presentation.mp4
|
20.8 MB
|
|
Lesson_28._Custom_Number_Formatting.mp4
|
10.4 MB
|
|
Lesson_280._Changing_an_Object's_Size_and_Rotation.mp4
|
9.1 MB
|
|
Lesson_281._Using_Slide_Masters.mp4
|
35.6 MB
|
|
Lesson_282._Modifying_the_Beginning_and_Ending_of_a_Line_Object.mp4
|
12.8 MB
|
|
Lesson_283._Join_Shapes_Together_By_Using_Connector_Lines.mp4
|
23.3 MB
|
|
Lesson_284._Group_or_Ungroup_Shapes,_Pictures_or_Other_Objects.mp4
|
9.4 MB
|
|
Lesson_285._This_is_How_You_Can_Fit_Text_When_It_Is_Larger_than_a_Shape.mp4
|
12.4 MB
|
|
Lesson_286._PowerPoint's_Smart_Art_Feature_Offers_Great_Return_for_Your_Time.mp4
|
25.3 MB
|
|
Lesson_287._Creating_Eye-Catching_Text_Effects_in_PowerPoint.mp4
|
14.0 MB
|
|
Lesson_288._Practical_Exercise_-_Creating_an_Organisational_Chart.mp4
|
54.1 MB
|
|
Lesson_289._COURSE_CHALLENGE_-_Part_4.mp4
|
27.3 MB
|
|
Lesson_29._How_to_Add_a_Drop-down_List_in_Excel.mp4
|
17.1 MB
|
|
Lesson_3._The_Best_Way_to_Take_This_Course.mp4
|
32.7 MB
|
|
Lesson_30._Using_Custom-sort_to_Sort_Multiple_Columns_Within_a_Table.mp4
|
14.3 MB
|
|
Lesson_31._Saving_Time_in_Excel_and_Doing_Everything_Faster_by_Using_Excel_Shortcuts.mp4
|
48.2 MB
|
|
Lesson_32._Key_Excel_Functions-_Sum,_Sumif,_Sumifs.mp4
|
32.2 MB
|
|
Lesson_33._Key_Excel_Functions-_Count,_Counta,_Countif,_Countifs.mp4
|
32.7 MB
|
|
Lesson_34._Key_Excel_Functions-_Average_&_Averageif.mp4
|
15.8 MB
|
|
Lesson_35._Key_Excel_Functions-_Left,_Right,_Mid,_Upper,_Lower,_Proper,_Concatenate,_&.mp4
|
31.8 MB
|
|
Lesson_36._Find_the_Highest_and_Lowest_Values_in_a_Range-_Max_&_Min.mp4
|
7.9 MB
|
|
Lesson_37._Use_Round_in_Your_Financial_Models.mp4
|
5.5 MB
|
|
Lesson_38._Excel's_Lookup_Functions-_Vlookup_&_Hlookup_Made_Easy.mp4
|
63.2 MB
|
|
Lesson_39._Index,_Match,_and_Their_Combination_-_The_Perfect_Substitute_for_Vlookup.mp4
|
64.8 MB
|
|
Lesson_4._Microsoft_Excel-_The_World's_#1_Office_Software.mp4
|
23.1 MB
|
|
Lesson_40._Using_Excel's_Iferror_Function_to_Trap_Spreadsheet_Errors.mp4
|
12.3 MB
|
|
Lesson_41._Create_Flexible_Financial_Models_with_Choose.mp4
|
20.8 MB
|
|
Lesson_42._Goal_Seek_Will_Help_You_Find_the_Result_You_Are_Looking_For.mp4
|
16.8 MB
|
|
Lesson_43._Perform_Sensitivity_Analysis_with_Excel's_Data_Tables_Functionality.mp4
|
27.5 MB
|
|
Lesson_44._Discounting_cash_flows_in_Microsoft_Excel.mp4
|
47.9 MB
|
|
Lesson_45._Calculating_Internal_Rate_of_Return_(IRR)_in_Excel.mp4
|
23.9 MB
|
|
Lesson_46._Using_the_PMT_function_to_create_a_complete_loan_schedule.mp4
|
42.0 MB
|
|
Lesson_47._Date_functions_in_Excel.mp4
|
32.3 MB
|
|
Lesson_48._Understand_Your_Data_Source_Before_You_Start_Working_on_It.mp4
|
41.3 MB
|
|
Lesson_49._Ordering_the_Source_Worksheet.mp4
|
25.2 MB
|
|
Lesson_5._Excel_Made_Easy-_A_Beginner's_Guide_to_Excel_Spreadsheets.mp4
|
23.9 MB
|
|
Lesson_50._Create_a_Code-_The_Best_Way_to_Organize_Your_Data_and_Work_Efficiently_with_It.mp4
|
26.1 MB
|
|
Lesson_51._Learn_How_to_Create_a_Database.mp4
|
24.8 MB
|
|
Lesson_52._Using_Lookup_Functions_(Vlookup)_to_Fill_the_Database_Sheet.mp4
|
68.4 MB
|
|
Lesson_53._Use_Sumif_to_Complete_the_Database_Sheet.mp4
|
53.2 MB
|
|
Lesson_54._Using_Index_&_Match_as_a_Substitute_for_Vlookup.mp4
|
54.6 MB
|
|
Lesson_55._Mapping_the_Rows_in_the_Database_Sheet.mp4
|
32.6 MB
|
|
Lesson_56._Building_the_Structure_of_the_P&L_Sheet.mp4
|
21.8 MB
|
|
Lesson_57._A_Practical_Example_of_Professional_Formatting_in_Excel.mp4
|
28.8 MB
|
|
Lesson_58._Populate_the_P&L_Sheet_with_Sumif.mp4
|
29.1 MB
|
|
Lesson_59._Learn_How_to_Find_Mistakes_with_Countif.mp4
|
30.9 MB
|
|
Lesson_6._Data_Entry_Techniques_in_Excel.mp4
|
18.2 MB
|
|
Lesson_60._Calculating_Growth_Rates_in_Excel.mp4
|
33.5 MB
|
|
Lesson_61._Introduction_to_Excel_Charts.mp4
|
13.6 MB
|
|
Lesson_62._Beginner's_Guide_to_Inserting_Charts_in_Excel.mp4
|
23.4 MB
|
|
Lesson_63._Modifying_Excel_Charts_-_The_Easy_Way.mp4
|
27.3 MB
|
|
Lesson_64._Making_Your_Excel_Charts_Sexier_-_Proven_Tips.mp4
|
34.3 MB
|
|
Lesson_65._Creating_a_Bridge_Chart_in_Excel_2016_-_As_Easy_as_It_Gets.mp4
|
14.3 MB
|
|
Lesson_66._New_Ways_to_Visualize_Your_Data_-_Treemap_Charts.mp4
|
12.1 MB
|
|
Lesson_67._How_to_Represent_Trends_with_Sparklines.mp4
|
28.9 MB
|
|
Lesson_68._Pivot_Tables_-_Excel's_Dynamic_and_Interactive_Tables.mp4
|
15.8 MB
|
|
Lesson_69._Creating_a_Pivot_Table-_Choosing_Row_and_Column_Parameters.mp4
|
40.8 MB
|
|
Lesson_7._How_to_Make_Your_Spreadsheets_Look_Professional.mp4
|
47.0 MB
|
|
Lesson_70._Design_the_Layout_and_Format_of_Your_Pivot_Tables.mp4
|
22.6 MB
|
|
Lesson_71._Additional_Techniques_That_Will_Ease_Your_Work_with_Pivot_Tables.mp4
|
48.2 MB
|
|
Lesson_72._One_of_the_Most_Useful_Excel_Functions_-_GetPivotData.mp4
|
38.0 MB
|
|
Lesson_73._Welcome_to_the_Future_-_Pivot_Table_Slicers.mp4
|
47.4 MB
|
|
Lesson_74._Introduction_to_the_Course_Challenge.mp4
|
13.8 MB
|
|
Lesson_75._COURSE_CHALLENGE_-_Part_1.mp4
|
15.1 MB
|
|
Lesson_76._Introduction_to_the_Case_Study.mp4
|
28.0 MB
|
|
Lesson_77._Working_with_an_SAP_data_extraction.mp4
|
41.1 MB
|
|
Lesson_78._Preliminary_mapping_of_the_data_extraction.mp4
|
32.7 MB
|
|
Lesson_79._Creating_an_output_structure_of_the_FMCG_model.mp4
|
23.3 MB
|
|
Lesson_8._Inserting,_Deleting,_and_Modifying_Rows_&_Columns.mp4
|
13.0 MB
|
|
Lesson_80._Improving_the_layout_and_appearance_of_the_FMCG_report.mp4
|
28.5 MB
|
|
Lesson_81._Inserting_formulas_and_automating_calculations.mp4
|
19.0 MB
|
|
Lesson_82._Creating_a_Master_Pivot_Table-_The_main_data_source_for_the_FMCG_report.mp4
|
22.8 MB
|
|
Lesson_83._GetPivotData_is_great!_Extracting_data_from_the_Master_Pivot_Table.mp4
|
56.8 MB
|
|
Lesson_84._Combining_Slicers_and_GetPivotData-_The_key_to_our_success.mp4
|
38.2 MB
|
|
Lesson_85._Getting_fancy_with_Excel_slicers.mp4
|
37.6 MB
|
|
Lesson_86._This_is_how_the_report_can_be_used_in_practice_by_high-level_executives.mp4
|
42.8 MB
|
|
Lesson_87._Introduction_to_the_Exercise.mp4
|
38.4 MB
|
|
Lesson_88._Let's_create_a_mapping_of_financials.mp4
|
32.2 MB
|
|
Lesson_89._Building_an_output_P&L_sheet.mp4
|
32.0 MB
|
|
Lesson_9._Excel_Formulas_for_Beginners.mp4
|
15.2 MB
|
|
Lesson_90._Filling_in_the_output_P&L_sheet_with_historical_financials.mp4
|
25.1 MB
|
|
Lesson_91._Calculating_percentage_variances_and_applying_conditional_formatting.mp4
|
28.5 MB
|
|
Lesson_92._Building_an_output_Balance_sheet.mp4
|
30.9 MB
|
|
Lesson_93._Using_Index,_Match,_Match_to_fill_in_the_output_Balance_sheet.mp4
|
45.6 MB
|
|
Lesson_94._Adding_the_forecast_period.mp4
|
33.7 MB
|
|
Lesson_95._Calculating_historical_percentage_ratios_and_use_Index_and_Match_for_scenarios.mp4
|
51.8 MB
|
|
Lesson_96._Building_a_flexible_model_with_Choose_&_Match.mp4
|
16.8 MB
|
|
Lesson_97._Building_a_flexible_model_with_Vlookup_&_Columns.mp4
|
38.0 MB
|
|
Lesson_98._Calculating_historical_DSO,_DPO,_DIO,_Other_assets_%,_and_Other_liabilities_%.mp4
|
46.7 MB
|
|
Lesson_99._Forecasting_DSO,_DPO,_DIO,_Other_assets_and_Other_liabilities.mp4
|
32.0 MB
|
|
Materials.zip
|
462.8 MB
|
|
[CourseClub.NET].url
|
0.1 KB
|
|
[FCS Forum].url
|
0.1 KB
|
|
[FreeCourseSite.com].url
|
0.1 KB
|
|
Total files 293
|
