Udemy Master Excel 2013 Formulas and VBA programming | 9633B6825DA47F928293C75CF7F4849416171152

Udemy Master Excel 2013 Formulas and VBA programming

Name	Udemy - Master Excel 2013 - Formulas and VBA programming	DOWNLOAD Copy Link
Total Size	462.4 MB
Total Files	54
Hash	9633B6825DA47F928293C75CF7F4849416171152

/1_-_Every_journey_begins_with_setting_the_goal/
1.1_-_Course_Workbook.xlsx	46.5 KB
1_-_What_s_this_course_about_and_why_should_I_be_interested.mp4	4.2 MB
2_-_Word_of_caution.mp4	4.3 MB
/2_-_Lets_get_started_-_Master_Formulas_in_Excel_2013/
3_-_Conditions_No_problem._Use_the_IF_Formula.mp4	6.2 MB
4_-_IF_Function_with_OR_AND.mp4	11.1 MB
5_-_How_to_sum_with_a_condition.mp4	11.6 MB
6_-_All_right_but_what_if_I_have_several_conditions.mp4	17.1 MB
7_-_What_about_counting_1_.mp4	5.7 MB
8_-_What_about_counting_2_.mp4	5.2 MB
9_-_counta_function.mp4	3.6 MB
10_-_max_min_small_large.mp4	7.3 MB
11_-_Maybe_most_often_used_-_the_vlookup_funtion.mp4	6.3 MB
12_-_vlookup_-_when_to_use_approximate_match.mp4	9.9 MB
13_-_There_is_hlookup_too.mp4	5.8 MB
14_-_The_match_function.mp4	4.3 MB
15_-_vlookup_with_more_than_1_table_Impossible_is_nothing.mp4	13.9 MB
16_-_Index_and_match_function_instead_of_vlookup.mp4	8.0 MB
17_-_Date_and_Time_Formula_-_simple_but_useful.mp4	11.9 MB
18_-_sumproduct_-_one_of_my_personal_favourites.mp4	14.0 MB
19_-_Array_formulas.mp4	5.3 MB
20_-_mean_average_averageif_s_-_welcome_to_statistics.mp4	7.4 MB
21_-_Excel_for_Finance_-_Future_Value_Function.mp4	6.4 MB
22_-_Excel_for_Finance_-_PMT_Function.mp4	4.1 MB
23_-_Excel_for_Finance_-_rate_Function.mp4	5.3 MB
24_-_Excel_for_Finance_-_nper_Function.mp4	5.4 MB
25_-_Excel_for_Finance_-_NPV_Function.mp4	4.7 MB
26_-_Excel_for_Finance_-_IRR_Function.mp4	5.0 MB
27_-_Excel_for_Finance_-_XIRR_and_XNPV.mp4	8.6 MB
28_-_A_dream_comes_true_-_Goal_seek_in_Excel.mp4	6.1 MB
29_-_Data_tables_-_One_of_the_most_powerful_tools_in_financial_analysis.mp4	16.3 MB
30_-_Data_consolidation_with_consolidate.mp4	6.9 MB
31_-_conditional_formating_with_formulas.mp4	13.1 MB
32_-_Can_i_set_a_dynamic_range_for_my_data_validation_list_Sure_.mp4	14.4 MB
33_-_Forget_filters_-_use_DSUM_instead.mp4	8.9 MB
34_-_Let_s_create_a_dynamic_chart.mp4	10.3 MB
/3_-_Formulas_done_-_now_lets_go_on_with_VBA/
35_-_A_few_things_before_we_start.mp4	8.9 MB
36_-_Form_Controls_-_A_powerful_tool_in_Excel.mp4	7.6 MB
37_-_Congratulation_Your_first_own_macro.mp4	2.9 MB
38_-_Greetings_from_Excel.mp4	6.9 MB
39_-_How_to_get_the_last_row_Here_s_how_.mp4	10.6 MB
40_-_Highlight_the_selected_cell.mp4	8.8 MB
41_-_Loops_-saving_time_using_the_For_Loop.mp4	6.6 MB
42_-_Don_t_like_the_for_loop_Use_the_while_loop_instead_.mp4	6.8 MB
43_-_The_inputbox_and_select_case.mp4	5.4 MB
44_-_Lonely_Excel_will_talk_to_you.mp4	2.4 MB
45_-_Save_excelsheet_as_a_pdf.mp4	11.6 MB
46_-_Open_a_website_from_vba.mp4	7.2 MB
47_-_open_other_programs_with_vba.mp4	3.6 MB
48_-_Lets_get_started_with_userforms.mp4	20.3 MB
49_-_Transfer_data_from_my_userform_into_my_sheets.mp4	16.5 MB
50_-_get_all_filenames_of_a_folder_and_save_them_in_excel.mp4	14.1 MB
51_-_A_table_of_contents_for_my_workbook_with_vba_-_awesome_.mp4	20.7 MB
52_-_A_macro_recorder_Thanks_microsoft.mp4	9.1 MB
/4_-_The_end_of_the_journey_A_few_words_from_your_instructor/
54_-_What_I_want_to_tell_you.mp4	13.6 MB
Total files 54