Udemy - Master Excel 2013 - Formulas and VBA Programming
File List
| File | Size |
|---|---|
| 1_-_Every_journey_begins_with_setting_the_goal/1.1_-_Course_Workbook.xlsx | 45.41 KB |
| 1_-_Every_journey_begins_with_setting_the_goal/1_-_What_s_this_course_about_and_why_should_I_be_interested.mp4 | 3.98 MB |
| 1_-_Every_journey_begins_with_setting_the_goal/2_-_Word_of_caution.mp4 | 4.05 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/3_-_Conditions_No_problem._Use_the_IF_Formula.mp4 | 5.87 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/4_-_IF_Function_with_OR_AND.mp4 | 10.6 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/5_-_How_to_sum_with_a_condition.mp4 | 11.02 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/6_-_All_right_but_what_if_I_have_several_conditions.mp4 | 16.34 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/7_-_What_about_counting_1_.mp4 | 5.47 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/8_-_What_about_counting_2_.mp4 | 4.95 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/9_-_counta_function.mp4 | 3.44 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/10_-_max_min_small_large.mp4 | 6.99 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/11_-_Maybe_most_often_used_-_the_vlookup_funtion.mp4 | 6.02 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/12_-_vlookup_-_when_to_use_approximate_match.mp4 | 9.46 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/13_-_There_is_hlookup_too.mp4 | 5.55 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/14_-_The_match_function.mp4 | 4.08 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/15_-_vlookup_with_more_than_1_table_Impossible_is_nothing.mp4 | 13.28 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/16_-_Index_and_match_function_instead_of_vlookup.mp4 | 7.62 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/17_-_Date_and_Time_Formula_-_simple_but_useful.mp4 | 11.34 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/18_-_sumproduct_-_one_of_my_personal_favourites.mp4 | 13.35 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/19_-_Array_formulas.mp4 | 5.02 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/20_-_mean_average_averageif_s_-_welcome_to_statistics.mp4 | 7.1 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/21_-_Excel_for_Finance_-_Future_Value_Function.mp4 | 6.1 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/22_-_Excel_for_Finance_-_PMT_Function.mp4 | 3.94 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/23_-_Excel_for_Finance_-_rate_Function.mp4 | 5.08 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/24_-_Excel_for_Finance_-_nper_Function.mp4 | 5.12 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/25_-_Excel_for_Finance_-_NPV_Function.mp4 | 4.52 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/26_-_Excel_for_Finance_-_IRR_Function.mp4 | 4.72 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/27_-_Excel_for_Finance_-_XIRR_and_XNPV.mp4 | 8.22 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/28_-_A_dream_comes_true_-_Goal_seek_in_Excel.mp4 | 5.85 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/29_-_Data_tables_-_One_of_the_most_powerful_tools_in_financial_analysis.mp4 | 15.5 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/30_-_Data_consolidation_with_consolidate.mp4 | 6.62 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/31_-_conditional_formating_with_formulas.mp4 | 12.53 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/32_-_Can_i_set_a_dynamic_range_for_my_data_validation_list_Sure_.mp4 | 13.7 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/33_-_Forget_filters_-_use_DSUM_instead.mp4 | 8.5 MB |
| 2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/34_-_Let_s_create_a_dynamic_chart.mp4 | 9.83 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/35_-_A_few_things_before_we_start.mp4 | 8.52 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/36_-_Form_Controls_-_A_powerful_tool_in_Excel.mp4 | 7.25 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/37_-_Congratulation_Your_first_own_macro.mp4 | 2.77 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/38_-_Greetings_from_Excel.mp4 | 6.59 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/39_-_How_to_get_the_last_row_Here_s_how_.mp4 | 10.13 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/40_-_Highlight_the_selected_cell.mp4 | 8.37 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/41_-_Loops_-saving_time_using_the_For_Loop.mp4 | 6.3 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/42_-_Don_t_like_the_for_loop_Use_the_while_loop_instead_.mp4 | 6.51 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/43_-_The_inputbox_and_select_case.mp4 | 5.18 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/44_-_Lonely_Excel_will_talk_to_you.mp4 | 2.28 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/45_-_Save_excelsheet_as_a_pdf.mp4 | 11.03 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/46_-_Open_a_website_from_vba.mp4 | 6.88 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/47_-_open_other_programs_with_vba.mp4 | 3.45 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/48_-_Lets_get_started_with_userforms.mp4 | 19.39 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/49_-_Transfer_data_from_my_userform_into_my_sheets.mp4 | 15.72 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/50_-_get_all_filenames_of_a_folder_and_save_them_in_excel.mp4 | 13.44 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/51_-_A_table_of_contents_for_my_workbook_with_vba_-_awesome_.mp4 | 19.73 MB |
| 3_-_Formulas_done_-_now_lets_go_on_with_VBA/52_-_A_macro_recorder_Thanks_microsoft.mp4 | 8.64 MB |
| 4_-_The_end_of_the_journey_A_few_words_from_your_instructor/54_-_What_I_want_to_tell_you.mp4 | 12.96 MB |
Trackers
No trackers found.