Udemy The Ultimate Excel Programmer Course MyFOM | EEF22F5C1DDAD53BADC666EF13C2232012EC95C5

Udemy The Ultimate Excel Programmer Course MyFOM

Name	[udemy] The Ultimate Excel Programmer Course [MyFOM]	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.2 GB
Total Files	168
Hash	EEF22F5C1DDAD53BADC666EF13C2232012EC95C5

/
MyFreeOnlineMovies.com.png	15.6 KB
Torrent Downloaded from Glodls.to.txt	0.2 KB
/Section 1 The Range Object/
01_-_Intro_and_Course_Workbooks_download.mp4	2.9 MB
02_-_Get_the_Developer_Tab_and_Intro_to_Developer_Tab.mp4	3.8 MB
03_-_How_to_Leave_a_Udemy_Review.mp4	5.8 MB
04_-_Getting_started_with_Range_object.mp4	2.1 MB
05_-_Creating_Your_First_Macro_From_Scratch.mp4	4.5 MB
06_-_Adding_a_Secondary_Command._._..mp4	1.6 MB
07_-_Debugging_in_Excel_VBA.mp4	2.6 MB
08_-_Saving_a_Macro-Enabled_Workbook_.xlsm_.mp4	2.5 MB
09_-_Several_Ways_to_trigger_your_Macro.mp4	2.2 MB
10_-_Affecting_Multiple_Cells_with_One_Range_Command_-_2_Methods.mp4	3.2 MB
11_-_Adding_Strings_of_Text_to_a_Cell.mp4	2.7 MB
12_-_Using_a_Named_Range_with_the_Range_Object.mp4	2.3 MB
/Section 10 Activex Controls on Worksheets/
112_-_Activex_Controls_vs_Forms_Controls.mp4	6.1 MB
113_-_Button_Click_-_Wage_Calculator.mp4	6.9 MB
114_-_Keydown_Event.mp4	6.4 MB
115_-_BONUS_-_Capturing_Shift_Alt_Ctrl_or_some_combination_using_the_Shift_variable.mp4	7.1 MB
116_-_KeyPress_Event.mp4	7.0 MB
117_-_MouseMove_Event.mp4	3.6 MB
118_-_MouseMove_Event_with_Application.Statusbar_-_fun_and_useful.mp4	6.7 MB
119_-_MouseUp_and_MouseDown_Events_-_Left_Middle_and_Rightclick_Shift_Alt_and_Ctrl.mp4	12.0 MB
120_-_GotFocus_and_LostFocus_Events.mp4	2.4 MB
121_-_Use_a_Checkbox_for_its_VALUE.mp4	4.8 MB
122_-_Checkbox_Event_Without_a_Button.mp4	3.0 MB
123_-_LinkedCell_Property_with_a_Checkbox.mp4	2.4 MB
124_-_Option_Buttons_Intro_-_What_is_an_Option_Button_and_Grouping.mp4	4.7 MB
125_-_Grouping_Alignment_and_Aesthetics_for_Controls.mp4	4.7 MB
126_-_Homemade_Quiz_using_Option_Buttons_and_a_Command_Button.mp4	7.4 MB
127_-_Compliance_Checker_for_your_Forms_or_Quizzes_Part_1.mp4	6.9 MB
128_-_Compliance_check_part_2.mp4	21.0 MB
129_-_SpinButton_with_Cell_A1.mp4	7.0 MB
130_-_SpinButtons_with_Textboxes_and_Numbers.mp4	10.4 MB
131_-_SpinButton_BONUS_-_Move_Textbox_Position_with_SpinButton.mp4	9.2 MB
132_-_SpinButton_with_Dates_in_a_Textbox.mp4	7.2 MB
133_-_Activex_Label_Control_-_Basics.mp4	7.1 MB
134_-_ComboBox_-_Fill_with_ListFillRange.mp4	8.1 MB
135_-_Creating_a_Dynamic_Range.mp4	9.1 MB
136_-_ComboBox_-_How_to_use_Multiple_Columns.mp4	6.6 MB
137_-_Using_.ADDITEM_to_Get_Specific_items_in_your_Combobox_List.mp4	18.6 MB
138_-_Noteworthy_Properties_of_a_Combobox.mp4	12.6 MB
139_-_Multiple_Columns_in_Combobox_with_.ADDITEM_and_List_ListCount_etc.mp4	17.0 MB
140_-_ListBox_Basics_using_Dynamic_Range.mp4	16.1 MB
141_-_Listbox_Click_event_and_Dynamic_Options.mp4	7.5 MB
142_-_ListBox_-_Referencing_Column_0_and_1_in_a_cell_Dynamically_.mp4	11.1 MB
143_-_Dynamic_ListBoxes_Using_.ADDITEM_and_More.mp4	20.8 MB
144_-_Make_and_Utilize_INVISIBLE_Columns_-_Special_Trick_.mp4	6.8 MB
145_-_Using_a_Scroll_Bar_on_a_worksheet.mp4	4.9 MB
146_-_Pictures_on_a_Worksheet_plus_using_FollowHyperlink_Method.mp4	14.6 MB
147_-_Toggle_Button.mp4	4.8 MB
148_-_A_Brief_Note_on_Alternate_3rd_Party_Controls.mp4	3.0 MB
/Section 11 Userforms - the best thing. EVER/
149_-_Userform_-_Hide_Show_and_Unload.mp4	9.6 MB
150_-_Sample_Database_and_Creating_a_Data_Entry_Form.mp4	36.2 MB
151_-_Fill_Status_combobox_with_Rowsource_when_Userform_starts_-_2_methods.mp4	9.8 MB
152_-_New_Employee_Data_Entry_Form_.mp4	38.3 MB
153_-_Format_Textbox_Numbers_as_Numerals_Clearing_out_Form_upon_Submission.mp4	9.1 MB
154_-_Set_the_Tab_Order_for_Userform_Controls.mp4	5.8 MB
155_-_Set_Default_Values_to_Make_Data_Entry_Easier.mp4	5.7 MB
156_-_Avoid_Duplicate_Employee_ID_and_other_Fun_Automation_Tricks.mp4	16.5 MB
157_-_Edit_Mode_for_Employee_Database_-_Part_1.mp4	39.1 MB
158_-_Edit_Mode_for_Employee_Database_-_Part_2.mp4	26.3 MB
159_-_Edit_Mode_Pt_3_-_Adding_Automation_and_Save_Button.mp4	46.1 MB
160_-_Userform_Report_with_Filters_-_Part_1.mp4	27.7 MB
161_-_Userform_Report_with_Filters_-_Part_2.mp4	16.5 MB
162_-_Applying_the_Dynamic_Filters_to_Reports.mp4	8.9 MB
163_-_Clear_out_Last_Report.mp4	7.3 MB
164_-_Report_Generation_and_Aesthetics_Headers_Footers_Repeat_Rows_etc..mp4	11.2 MB
165_-_Concluding_Thoughts._._..mp4	3.5 MB
/Section 12 BONUS Section - VBA Functions/
Sorry No Content Bare With Me.txt	0.0 KB
/Section 2 Range Properties/
13_-_.VALUE_Property.mp4	3.1 MB
14_-_.TEXT_Property.mp4	1.7 MB
15_-_.ROW_and_.COLUMN_Properties.mp4	2.2 MB
16_-_.SELECT_Property.mp4	1.6 MB
17_-_.COUNT_Property.mp4	4.0 MB
18_-_.ADDRESS_Property.mp4	3.6 MB
19_-_.FORMULA_Property.mp4	7.7 MB
20_-_.NUMBERFORMAT_Property.mp4	3.8 MB
21_-_FONT.BOLD_UNDERLINE_or_ITALIC_Properties.mp4	5.0 MB
/Section 3 The Cells Object/
22_-_The_Cells_Object.mp4	4.7 MB
23_-_Using_Column_Letters_instead_of_Numbers.mp4	2.3 MB
24_-_Using_Cells_Positionally_within_a_Range.mp4	4.0 MB
25_-_Affecting_ALL_Cells_in_a_Worksheet.mp4	5.8 MB
26_-_Using_Range_Object_with_Cells_Object.mp4	5.8 MB
/Section 4 Variables/
27_-_Intro_to_Variables.mp4	2.4 MB
28_-_Declaring_Variables_-_Variable_Types.mp4	5.2 MB
29_-_Declaring_Variables_-_Types_Demo.mp4	5.7 MB
30_-_Calling_a_Procedure_from_Another.mp4	2.4 MB
31_-_Public_and_Private_Variables.mp4	5.2 MB
32_-_Using_Constants.mp4	3.5 MB
/Section 5 Toolbars and Menus/
33_-_File_Menu_walkthrough.mp4	5.1 MB
34_-_Edit_Menu_walkthrough.mp4	10.5 MB
35_-_View_Menu_walkthrough.mp4	6.0 MB
36_-_View_Menu2_-_Watch_Window_Locals_Window_and_Immediate_Window.mp4	13.7 MB
37_-_Watch_Window_Wonders_.mp4	10.4 MB
38_-_Insert_and_Format_Menus.mp4	1.8 MB
39_-_Debug_Menu_Important_.mp4	9.8 MB
40_-_Run_and_Tools_Menus.mp4	7.9 MB
/Section 6 Super Important Tools and Excel Logic/
41_-_Determining_the_Last_Row_in_your_Data_Set.mp4	8.3 MB
42_-_Determining_the_Last_Column_in_your_Data_Set.mp4	5.1 MB
43_-_Determining_the_Next_Row_in_your_Data_Set.mp4	3.3 MB
44_-_Recording_a_Macro.mp4	7.6 MB
45_-_Absolute_vs_Relative_References.mp4	8.3 MB
46_-_Using_With_and_End_With.mp4	6.7 MB
47_-_Comparison_Operators_in_Excel_VBA.mp4	2.0 MB
48_-_If_Then_Statement.mp4	4.2 MB
49_-_Using_Is_Not_Equal_To_.mp4	1.6 MB
50_-_Logical_Operator_NOT.mp4	1.9 MB
51_-_If_Then_Else_Statement.mp4	2.9 MB
52_-_If_Then_ElseIF_Statement._._..mp4	4.1 MB
53_-_Comparitive_Operators_with_Text_and_Numbers_.mp4	4.1 MB
54_-_Use_If_Then_Statements_in_a_One-Liner_of_code.mp4	3.0 MB
55_-_Using_GOTO_and_Labels.mp4	3.1 MB
56_-_Select_Case_as_Alternative_to_IF_THEN_Statements.mp4	4.4 MB
57_-_Message_Box_with_Yes_and_No_Buttons.mp4	20.0 MB
58_-_Relative_Positioning_using_Offset.mp4	5.8 MB
/Section 7 Loops and Report Writing Basics/
59_-_Intro_to_Loops_the_For_Next_Loop.mp4	4.2 MB
60_-_Fun_with_our_For_Next_Loop.mp4	7.2 MB
61_-_Beginning_our_first_Report_using_Loops.mp4	11.4 MB
62_-_Using_an_InputBox.mp4	5.3 MB
63_-_Adding_InputBox_to_Our_First_Report_to_make_it_Dynamic.mp4	5.4 MB
64_-_Add_a_Button_to_Open_Our_Report.mp4	8.1 MB
65_-_Add_a_Cool_Looking_Button_or_Image_to_Open_Report.mp4	6.4 MB
66_-_Our_First_Printable_Report_part_1_-_Declaring_and_Setting_the_Sheets.mp4	9.3 MB
67_-_Printable_Report_Part_2_-_Getting_Items_On_Report_Sheet.mp4	12.1 MB
68_-_Printable_Report_Part_3_-_Clearing_Last_Report.mp4	13.0 MB
69_-_Printable_Report_Part_4_-_Ensuring_Visibility_and_Autoselect_Report_Sheet.mp4	10.9 MB
70_-_Using_PrintPreview_Automatically.mp4	3.3 MB
71_-_Using_PrintOut_to_Send_Directly_to_Default_Printer.mp4	5.6 MB
72_-_Handling_Debug_Error_When_Cancelling_InputBox.mp4	7.4 MB
73_-_For_Loop_Going_Backwards_using_STEP.mp4	8.2 MB
74_-_The_FOR_EACH_Loop.mp4	10.0 MB
75_-_FOR_EACH_Loop_-_Practical_Examples.mp4	6.7 MB
76_-_Intro_to_DO_LOOPS.mp4	7.9 MB
77_-_DO_Until.mp4	3.1 MB
78_-_Loop_Until.mp4	2.4 MB
79_-_DO_While.mp4	2.8 MB
80_-_Loop_While.mp4	1.7 MB
81_-_EXIT_DO_-_Multiple_Exits_using_your_own_Criteria_along_the_Way_.mp4	2.5 MB
/Section 8 EVENTS Worksheet Events made Easy/
82_-_Intro_to_Worksheet_Events_and_Selection_Change.mp4	6.7 MB
83_-_Worksheet_Activate_Event.mp4	2.6 MB
84_-_Worksheet_Deactivate_Event.mp4	4.6 MB
85_-_BeforeDelete_Event_-_for_Worksheet_Deletion.mp4	2.5 MB
86_-_BeforeDoubleClick_Event_-_Trigger_a_Macro_when_Double_Clicking.mp4	5.1 MB
87_-_BeforeRightClick_Event_-_Trigger_a_Macro_when_Right-Clicking.mp4	2.8 MB
88_-_Calculate_Event.mp4	6.2 MB
89_-_How_to_Disable_Events_on_the_Workbook.mp4	2.9 MB
90_-_Intro_to_Change_Event.mp4	2.2 MB
91_-_Change_Event_with_EnableEvents_toggle_-_Avoid_endless_loop_.mp4	8.1 MB
92_-_Change_Event_Triggered_with_Custom_Range_Using_Intersect.mp4	5.8 MB
93_-_FollowHyperlinks_Event.mp4	6.5 MB
94_-_Final_Thoughts_on_Worksheet_Events_and_Review_Other_Events.mp4	4.7 MB
/Section 9 WorkBook Events/
100_-_Before_Print.mp4	3.7 MB
101_-_Deactivate.mp4	3.5 MB
102_-_NewChart.mp4	9.7 MB
103_-_NewSheet.mp4	4.5 MB
104_-_Sheet_Activate.mp4	7.2 MB
105_-_Delete_DoubleClick_RightClick_Calculate_Change.mp4	13.0 MB
106_-_SheetDeactivate.mp4	7.4 MB
107_-_Follow_Hyperlink.mp4	3.7 MB
108_-_SheetSelectionChange.mp4	4.6 MB
109_-_WindowActivate.mp4	3.5 MB
110_-_WindowDeactivate.mp4	2.5 MB
111_-_WindowResize.mp4	7.6 MB
95_-_Workbook_Open.mp4	9.3 MB
96_-_Workbook_Activate.mp4	4.9 MB
97_-_Before_Save.mp4	5.4 MB
98_-_After_Save.mp4	7.8 MB
99_-_Before_Close.mp4	10.3 MB
Total files 168