Udemy - Master Excel 2013 - Formulas and VBA programming

1. 1_-_Every_journey_begins_with_setting_the_goal/1_-_What_s_this_course_about_and_why_should_I_be_interested.mp43.98MB
2. 1_-_Every_journey_begins_with_setting_the_goal/2_-_Word_of_caution.mp44.05MB
3. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/3_-_Conditions_No_problem._Use_the_IF_Formula.mp45.87MB
4. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/4_-_IF_Function_with_OR_AND.mp410.6MB
5. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/5_-_How_to_sum_with_a_condition.mp411.02MB
6. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/6_-_All_right_but_what_if_I_have_several_conditions.mp416.34MB
7. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/7_-_What_about_counting_1_.mp45.47MB
8. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/8_-_What_about_counting_2_.mp44.95MB
9. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/9_-_counta_function.mp43.44MB
10. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/10_-_max_min_small_large.mp46.99MB
11. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/11_-_Maybe_most_often_used_-_the_vlookup_funtion.mp46.02MB
12. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/12_-_vlookup_-_when_to_use_approximate_match.mp49.46MB
13. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/13_-_There_is_hlookup_too.mp45.55MB
14. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/14_-_The_match_function.mp44.08MB
15. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/15_-_vlookup_with_more_than_1_table_Impossible_is_nothing.mp413.28MB
16. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/16_-_Index_and_match_function_instead_of_vlookup.mp47.62MB
17. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/17_-_Date_and_Time_Formula_-_simple_but_useful.mp411.34MB
18. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/18_-_sumproduct_-_one_of_my_personal_favourites.mp413.35MB
19. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/19_-_Array_formulas.mp45.02MB
20. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/20_-_mean_average_averageif_s_-_welcome_to_statistics.mp47.1MB
21. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/21_-_Excel_for_Finance_-_Future_Value_Function.mp46.1MB
22. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/22_-_Excel_for_Finance_-_PMT_Function.mp43.94MB
23. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/23_-_Excel_for_Finance_-_rate_Function.mp45.08MB
24. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/24_-_Excel_for_Finance_-_nper_Function.mp45.12MB
25. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/25_-_Excel_for_Finance_-_NPV_Function.mp44.52MB
26. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/26_-_Excel_for_Finance_-_IRR_Function.mp44.72MB
27. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/27_-_Excel_for_Finance_-_XIRR_and_XNPV.mp48.22MB
28. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/28_-_A_dream_comes_true_-_Goal_seek_in_Excel.mp45.85MB
29. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/29_-_Data_tables_-_One_of_the_most_powerful_tools_in_financial_analysis.mp415.5MB
30. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/30_-_Data_consolidation_with_consolidate.mp46.62MB
31. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/31_-_conditional_formating_with_formulas.mp412.53MB
32. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/32_-_Can_i_set_a_dynamic_range_for_my_data_validation_list_Sure_.mp413.7MB
33. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/33_-_Forget_filters_-_use_DSUM_instead.mp48.5MB
34. 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/34_-_Let_s_create_a_dynamic_chart.mp49.83MB
35. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/35_-_A_few_things_before_we_start.mp48.52MB
36. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/36_-_Form_Controls_-_A_powerful_tool_in_Excel.mp47.25MB
37. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/37_-_Congratulation_Your_first_own_macro.mp42.77MB
38. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/38_-_Greetings_from_Excel.mp46.59MB
39. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/39_-_How_to_get_the_last_row_Here_s_how_.mp410.13MB
40. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/40_-_Highlight_the_selected_cell.mp48.37MB
41. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/41_-_Loops_-saving_time_using_the_For_Loop.mp46.3MB
42. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/42_-_Don_t_like_the_for_loop_Use_the_while_loop_instead_.mp46.51MB
43. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/43_-_The_inputbox_and_select_case.mp45.18MB
44. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/44_-_Lonely_Excel_will_talk_to_you.mp42.28MB
45. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/45_-_Save_excelsheet_as_a_pdf.mp411.03MB
46. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/46_-_Open_a_website_from_vba.mp46.88MB
47. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/47_-_open_other_programs_with_vba.mp43.45MB
48. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/48_-_Lets_get_started_with_userforms.mp419.39MB
49. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/49_-_Transfer_data_from_my_userform_into_my_sheets.mp415.72MB
50. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/50_-_get_all_filenames_of_a_folder_and_save_them_in_excel.mp413.44MB
51. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/51_-_A_table_of_contents_for_my_workbook_with_vba_-_awesome_.mp419.73MB
52. 3_-_Formulas_done_-_now_lets_go_on_with_VBA/52_-_A_macro_recorder_Thanks_microsoft.mp48.64MB
53. 4_-_The_end_of_the_journey_A_few_words_from_your_instructor/54_-_What_I_want_to_tell_you.mp412.96MB