589689.xyz

[] ultimate-excel-programmer

  • 收录时间:2018-03-05 19:05:23
  • 文件大小:1GB
  • 下载次数:243
  • 最近下载:2021-01-07 08:41:42
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 11 Userforms - the best thing. EVER/164 Edit Mode Pt 3 - Adding Automation and Save Button.mp4 44MB
  2. 11 Userforms - the best thing. EVER/162 Edit Mode for Employee Database - Part 1.mp4 37MB
  3. 11 Userforms - the best thing. EVER/157 New Employee Data Entry Form.mp4 37MB
  4. 01 The Range Object/001 Intro and Course Workbooks download.mp4 36MB
  5. 11 Userforms - the best thing. EVER/155 Sample Database and Creating a Data Entry Form.mp4 34MB
  6. 11 Userforms - the best thing. EVER/165 Userform Report with Filters - Part 1.mp4 26MB
  7. 11 Userforms - the best thing. EVER/163 Edit Mode for Employee Database - Part 2.mp4 25MB
  8. 10 Activex Controls on Worksheets/132 Compliance check part 2.mp4 20MB
  9. 10 Activex Controls on Worksheets/148 Dynamic ListBoxes Using .ADDITEM and More.mp4 20MB
  10. 10 Activex Controls on Worksheets/141 Using .ADDITEM to Get Specific items in your Combobox List.mp4 18MB
  11. 06 Super Important Tools and Excel Logic/045 BONUS - Dynamic Sorting.mp4 17MB
  12. 10 Activex Controls on Worksheets/143 Multiple Columns in Combobox with .ADDITEM and List ListCount etc.mp4 16MB
  13. 11 Userforms - the best thing. EVER/161 Avoid Duplicate Employee ID and other Fun Automation Tricks.mp4 16MB
  14. 11 Userforms - the best thing. EVER/166 Userform Report with Filters - Part 2.mp4 16MB
  15. 08 EVENTS Worksheet Events made Easy/098 Events Exercise 1.mp4 16MB
  16. 10 Activex Controls on Worksheets/144 ListBox Basics using Dynamic Range.mp4 15MB
  17. 12 BONUS Section - VBA Functions/171 InStr Function - Search for Text Within Other Text.mp4 15MB
  18. 04 Variables/032 BONUS Passing Variables to Another Procedure - ByVal and ByRef.mp4 15MB
  19. 10 Activex Controls on Worksheets/151 Pictures on a Worksheet plus using FollowHyperlink Method.mp4 14MB
  20. 06 Super Important Tools and Excel Logic/060 BONUS - User Defined Functions 101.mp4 13MB
  21. 12 BONUS Section - VBA Functions/172 The EVALUATE Function - Mac-Daddy of all functions.mp4 13MB
  22. 05 Toolbars and Menus/036 View Menu2 - Watch Window Locals Window and Immediate Window.mp4 13MB
  23. 06 Super Important Tools and Excel Logic/061 BONUS - UDF Lesson 2.mp4 13MB
  24. 09 WorkBook Events/109 Delete DoubleClick RightClick Calculate Change.mp4 12MB
  25. 07 Loops and Report Writing Basics/071 Printable Report Part 3 - Clearing Last Report.mp4 12MB
  26. 10 Activex Controls on Worksheets/142 Noteworthy Properties of a Combobox.mp4 12MB
  27. 07 Loops and Report Writing Basics/070 Printable Report Part 2 - Getting Items On Report Sheet.mp4 12MB
  28. 10 Activex Controls on Worksheets/123 MouseUp and MouseDown Events - Left Middle Rightclick Shift Alt Ctrl.mp4 11MB
  29. 07 Loops and Report Writing Basics/064 Beginning our first Report using Loops.mp4 11MB
  30. 11 Userforms - the best thing. EVER/169 Report Generation and Aesthetics Headers Footers Repeat Rows etc..mp4 11MB
  31. 10 Activex Controls on Worksheets/147 ListBox - Referencing Column 0 and 1 in a cell Dynamically.mp4 11MB
  32. 10 Activex Controls on Worksheets/146 BONUS - Manipulating and Using Multiselect Items in a Listbox.mp4 11MB
  33. 07 Loops and Report Writing Basics/072 Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.mp4 10MB
  34. 05 Toolbars and Menus/034 Edit Menu walkthrough.mp4 10MB
  35. 06 Super Important Tools and Excel Logic/058 Message Box with Yes and No Buttons.mp4 10MB
  36. 10 Activex Controls on Worksheets/134 SpinButtons with Textboxes and Numbers.mp4 10MB
  37. 05 Toolbars and Menus/037 Watch Window Wonders.mp4 10MB
  38. 09 WorkBook Events/103 Before Close.mp4 10MB
  39. 07 Loops and Report Writing Basics/077 The FOR EACH Loop.mp4 9MB
  40. 11 Userforms - the best thing. EVER/156 Fill Status combobox with Rowsource when Userform starts - 2 methods.mp4 9MB
  41. 05 Toolbars and Menus/039 Debug Menu Important.mp4 9MB
  42. 09 WorkBook Events/106 NewChart.mp4 9MB
  43. 11 Userforms - the best thing. EVER/154 Userform - Hide Show and Unload.mp4 9MB
  44. 07 Loops and Report Writing Basics/069 Our First Printable Report part 1 - Declaring and Setting the Sheets.mp4 9MB
  45. 09 WorkBook Events/099 Workbook Open.mp4 9MB
  46. 10 Activex Controls on Worksheets/135 SpinButton BONUS - Move Textbox Position with SpinButton.mp4 9MB
  47. 11 Userforms - the best thing. EVER/158 Format Textbox Numbers as Numerals Clearing out Form upon Submission.mp4 9MB
  48. 10 Activex Controls on Worksheets/139 Creating a Dynamic Range.mp4 9MB
  49. 11 Userforms - the best thing. EVER/167 Applying the Dynamic Filters to Reports.mp4 8MB
  50. 06 Super Important Tools and Excel Logic/041 Determining the Last Row in your Data Set.mp4 8MB
  51. 06 Super Important Tools and Excel Logic/046 Absolute vs Relative References.mp4 8MB
  52. 07 Loops and Report Writing Basics/076 For Loop Going Backwards using STEP.mp4 8MB
  53. 07 Loops and Report Writing Basics/067 Add a Button to Open Our Report.mp4 8MB
  54. 12 BONUS Section - VBA Functions/173 Sum Function in Excel VBA - EASY.mp4 8MB
  55. 08 EVENTS Worksheet Events made Easy/094 Change Event with EnableEvents toggle - Avoid endless loop.mp4 8MB
  56. 10 Activex Controls on Worksheets/138 ComboBox - Fill with ListFillRange.mp4 8MB
  57. 05 Toolbars and Menus/040 Run and Tools Menus.mp4 8MB
  58. 07 Loops and Report Writing Basics/079 Intro to DO LOOPS.mp4 8MB
  59. 09 WorkBook Events/102 After Save.mp4 7MB
  60. 02 Range Properties/018 .FORMULA Property.mp4 7MB
  61. 09 WorkBook Events/115 WindowResize.mp4 7MB
  62. 06 Super Important Tools and Excel Logic/044 Recording a Macro.mp4 7MB
  63. 10 Activex Controls on Worksheets/145 Listbox Click event and Dynamic Options.mp4 7MB
  64. 07 Loops and Report Writing Basics/075 Handling Debug Error When Cancelling InputBox.mp4 7MB
  65. 09 WorkBook Events/110 SheetDeactivate.mp4 7MB
  66. 10 Activex Controls on Worksheets/130 Homemade Quiz using Option Buttons and a Command Button.mp4 7MB
  67. 11 Userforms - the best thing. EVER/168 Clear out Last Report.mp4 7MB
  68. 10 Activex Controls on Worksheets/136 SpinButton with Dates in a Textbox.mp4 7MB
  69. 07 Loops and Report Writing Basics/063 Fun with our For Next Loop.mp4 7MB
  70. 09 WorkBook Events/108 Sheet Activate.mp4 7MB
  71. 10 Activex Controls on Worksheets/137 Activex Label Control - Basics.mp4 7MB
  72. 10 Activex Controls on Worksheets/119 BONUS Capturing Shift Alt Ctrl or some combination using the Shift variable.mp4 7MB
  73. 10 Activex Controls on Worksheets/120 KeyPress Event.mp4 7MB
  74. 10 Activex Controls on Worksheets/133 SpinButton with Cell A1.mp4 7MB
  75. 10 Activex Controls on Worksheets/117 Button Click - Wage Calculator.mp4 7MB
  76. 10 Activex Controls on Worksheets/131 Compliance Checker for your Forms or Quizzes Part 1.mp4 7MB
  77. 10 Activex Controls on Worksheets/149 Make and Utilize INVISIBLE Columns - Special Trick.mp4 6MB
  78. 10 Activex Controls on Worksheets/122 MouseMove Event with Application.Statusbar - fun and useful.mp4 6MB
  79. 07 Loops and Report Writing Basics/078 FOR EACH Loop - Practical Examples.mp4 6MB
  80. 08 EVENTS Worksheet Events made Easy/085 Intro to Worksheet Events and Selection_Change.mp4 6MB
  81. 06 Super Important Tools and Excel Logic/047 Using With and End With.mp4 6MB
  82. 10 Activex Controls on Worksheets/140 ComboBox - How to use Multiple Columns.mp4 6MB
  83. 08 EVENTS Worksheet Events made Easy/096 FollowHyperlinks Event.mp4 6MB
  84. 10 Activex Controls on Worksheets/118 Keydown Event.mp4 6MB
  85. 07 Loops and Report Writing Basics/068 Add a Cool Looking Button or Image to Open Report.mp4 6MB
  86. 03 The Cells Object/021 The Cells Object.mp4 6MB
  87. 08 EVENTS Worksheet Events made Easy/091 Calculate Event.mp4 6MB
  88. 10 Activex Controls on Worksheets/116 Activex Controls vs Forms Controls.mp4 6MB
  89. 05 Toolbars and Menus/035 View Menu walkthrough.mp4 6MB
  90. 08 EVENTS Worksheet Events made Easy/095 Change Event Triggered with Custom Range Using Intersect.mp4 6MB
  91. 03 The Cells Object/024 Affecting ALL Cells in a Worksheet.mp4 6MB
  92. 11 Userforms - the best thing. EVER/159 Set the Tab Order for Userform Controls.mp4 6MB
  93. 06 Super Important Tools and Excel Logic/059 Relative Positioning using Offset.mp4 6MB
  94. 03 The Cells Object/025 Using Range Object with Cells Object.mp4 6MB
  95. 04 Variables/028 Declaring Variables - Types Demo.mp4 5MB
  96. 11 Userforms - the best thing. EVER/160 Set Default Values to Make Data Entry Easier.mp4 5MB
  97. 07 Loops and Report Writing Basics/074 Using PrintOut to Send Directly to Default Printer.mp4 5MB
  98. 07 Loops and Report Writing Basics/066 Adding InputBox to Our First Report to make it Dynamic.mp4 5MB
  99. 09 WorkBook Events/101 Before Save.mp4 5MB
  100. 07 Loops and Report Writing Basics/065 Using an InputBox.mp4 5MB
  101. 04 Variables/030 Public and Private Variables.mp4 5MB
  102. 04 Variables/027 Declaring Variables - Variable Types.mp4 5MB
  103. 05 Toolbars and Menus/033 File Menu walkthrough.mp4 5MB
  104. 08 EVENTS Worksheet Events made Easy/089 BeforeDoubleClick Event - Trigger a Macro when Double Clicking.mp4 5MB
  105. 06 Super Important Tools and Excel Logic/042 Determining the Last Column in your Data Set.mp4 5MB
  106. 12 BONUS Section - VBA Functions/174 Count Function in VBA.mp4 5MB
  107. 02 Range Properties/020 FONT.BOLD UNDERLINE or ITALIC Properties.mp4 5MB
  108. 10 Activex Controls on Worksheets/150 Using a Scroll Bar on a worksheet.mp4 5MB
  109. 09 WorkBook Events/100 Workbook Activate.mp4 5MB
  110. 10 Activex Controls on Worksheets/152 Toggle Button.mp4 5MB
  111. 10 Activex Controls on Worksheets/125 Use a Checkbox for its VALUE.mp4 5MB
  112. 10 Activex Controls on Worksheets/128 Option Buttons Intro - What is an Option Button and Grouping.mp4 5MB
  113. 10 Activex Controls on Worksheets/129 Grouping Alignment and Aesthetics for Controls.mp4 5MB
  114. 08 EVENTS Worksheet Events made Easy/097 Final Thoughts on Worksheet Events and Review Other Events.mp4 4MB
  115. 09 WorkBook Events/112 SheetSelectionChange.mp4 4MB
  116. 08 EVENTS Worksheet Events made Easy/087 Worksheet Deactivate Event.mp4 4MB
  117. 09 WorkBook Events/107 NewSheet.mp4 4MB
  118. 01 The Range Object/004 Creating Your First Macro From Scratch.mp4 4MB
  119. 06 Super Important Tools and Excel Logic/057 Select Case as Alternative to IF THEN Statements.mp4 4MB
  120. 06 Super Important Tools and Excel Logic/049 If Then Statement.mp4 4MB
  121. 07 Loops and Report Writing Basics/062 Intro to Loops the For Next Loop.mp4 4MB
  122. 06 Super Important Tools and Excel Logic/054 Comparitive Operators with Text and Numbers.mp4 4MB
  123. 06 Super Important Tools and Excel Logic/053 If Then ElseIF Statement. . ..mp4 4MB
  124. 03 The Cells Object/023 Using Cells Positionally within a Range.mp4 4MB
  125. 02 Range Properties/016 .COUNT Property.mp4 4MB
  126. 02 Range Properties/019 .NUMBERFORMAT Property.mp4 4MB
  127. 01 The Range Object/002 Get the Developer Tab and Intro to Developer Tab.mp4 4MB
  128. 09 WorkBook Events/104 Before Print.mp4 4MB
  129. 09 WorkBook Events/111 Follow Hyperlink.mp4 3MB
  130. 02 Range Properties/017 .ADDRESS Property.mp4 3MB
  131. 10 Activex Controls on Worksheets/121 MouseMove Event.mp4 3MB
  132. 09 WorkBook Events/113 WindowActivate.mp4 3MB
  133. 09 WorkBook Events/105 Deactivate.mp4 3MB
  134. 11 Userforms - the best thing. EVER/170 Concluding Thoughts. . ..mp4 3MB
  135. 04 Variables/031 Using Constants.mp4 3MB
  136. 07 Loops and Report Writing Basics/073 Using PrintPreview Automatically.mp4 3MB
  137. 06 Super Important Tools and Excel Logic/043 Determining the Next Row in your Data Set.mp4 3MB
  138. 01 The Range Object/009 Affecting Multiple Cells with One Range Command - 2 Methods.mp4 3MB
  139. 02 Range Properties/012 .VALUE Property.mp4 3MB
  140. 06 Super Important Tools and Excel Logic/056 Using GOTO and Labels.mp4 3MB
  141. 07 Loops and Report Writing Basics/080 DO Until.mp4 3MB
  142. 10 Activex Controls on Worksheets/153 A Brief Note on Alternate 3rd Party Controls.mp4 3MB
  143. 10 Activex Controls on Worksheets/126 Checkbox Event Without a Button.mp4 3MB
  144. 06 Super Important Tools and Excel Logic/055 Use If Then Statements in a One-Liner of code.mp4 3MB
  145. 08 EVENTS Worksheet Events made Easy/092 How to Disable Events on the Workbook.mp4 3MB
  146. 06 Super Important Tools and Excel Logic/052 If Then Else Statement.mp4 3MB
  147. 07 Loops and Report Writing Basics/082 DO While.mp4 3MB
  148. 08 EVENTS Worksheet Events made Easy/090 BeforeRightClick Event - Trigger a Macro when Right-Clicking.mp4 3MB
  149. 01 The Range Object/010 Adding Strings of Text to a Cell.mp4 3MB
  150. 01 The Range Object/006 Debugging in Excel VBA.mp4 3MB
  151. 08 EVENTS Worksheet Events made Easy/086 Worksheet Activate Event.mp4 2MB
  152. 08 EVENTS Worksheet Events made Easy/088 BeforeDelete Event - for Worksheet Deletion.mp4 2MB
  153. 01 The Range Object/007 Saving a Macro-Enabled Workbook .xlsm.mp4 2MB
  154. 07 Loops and Report Writing Basics/084 EXIT DO - Multiple Exits using your own Criteria along the Way.mp4 2MB
  155. 09 WorkBook Events/114 WindowDeactivate.mp4 2MB
  156. 04 Variables/026 Intro to Variables.mp4 2MB
  157. 04 Variables/029 Calling a Procedure from Another.mp4 2MB
  158. 07 Loops and Report Writing Basics/081 Loop Until.mp4 2MB
  159. 10 Activex Controls on Worksheets/127 LinkedCell Property with a Checkbox.mp4 2MB
  160. 10 Activex Controls on Worksheets/124 GotFocus and LostFocus Events.mp4 2MB
  161. 03 The Cells Object/022 Using Column Letters instead of Numbers.mp4 2MB
  162. 01 The Range Object/011 Using a Named Range with the Range Object.mp4 2MB
  163. 08 EVENTS Worksheet Events made Easy/093 Intro to Change Event.mp4 2MB
  164. 01 The Range Object/008 Several Ways to trigger your Macro.mp4 2MB
  165. 02 Range Properties/014 .ROW and .COLUMN Properties.mp4 2MB
  166. 01 The Range Object/003 Getting started with Range object.mp4 2MB
  167. 06 Super Important Tools and Excel Logic/048 Comparison Operators in Excel VBA.mp4 2MB
  168. 06 Super Important Tools and Excel Logic/051 Logical Operator NOT.mp4 2MB
  169. 05 Toolbars and Menus/038 Insert and Format Menus.mp4 2MB
  170. 02 Range Properties/013 .TEXT Property.mp4 2MB
  171. 07 Loops and Report Writing Basics/083 Loop While.mp4 2MB
  172. 01 The Range Object/005 Adding a Secondary Command. . ..mp4 2MB
  173. 02 Range Properties/015 .SELECT Property.mp4 2MB
  174. 06 Super Important Tools and Excel Logic/050 Using Is Not Equal To.mp4 2MB
  175. 01 The Range Object/attached_files/001 Intro and Course Workbooks download/Workbooks-Download.zip 882KB
  176. 01 The Range Object/attached_files/001 Intro and Course Workbooks download/Excel-VBA-PC-vs-Mac-Help.pdf 412KB
  177. 06 Super Important Tools and Excel Logic/attached_files/048 Comparison Operators in Excel VBA/Comparison-Operators-In-Excel-VBA.pdf 170KB
  178. 04 Variables/attached_files/026 Intro to Variables/How-To-Use-Variables-In-Excel-Sub-Procedures-In-Visual-Basic-For-Applications.pdf 165KB
  179. 10 Activex Controls on Worksheets/attached_files/123 MouseUp and MouseDown Events - Left Middle Rightclick Shift Alt Ctrl/Mouse-Down-Event-Excel-VBA-Language-Reference-.pdf 148KB
  180. 10 Activex Controls on Worksheets/attached_files/143 Multiple Columns in Combobox with .ADDITEM and List ListCount etc/List-Box-Combobox-LIST-Principles.pdf 138KB
  181. 10 Activex Controls on Worksheets/attached_files/118 Keydown Event/Key-Code-Constants-Used-With-Key-Down-Events.pdf 109KB
  182. 10 Activex Controls on Worksheets/attached_files/147 ListBox - Referencing Column 0 and 1 in a cell Dynamically/Additional-List-Index-And-List-Info.pdf 96KB
  183. 10 Activex Controls on Worksheets/attached_files/120 KeyPress Event/Ascii-Table.xls 58KB
  184. 06 Super Important Tools and Excel Logic/attached_files/045 BONUS - Dynamic Sorting/06-BONUS-Dynamic-Sorting.zip 31KB
  185. 08 EVENTS Worksheet Events made Easy/attached_files/098 Events Exercise 1/Events-Exercise1-Finished-Version-w-Source-Code.xlsm 24KB
  186. 08 EVENTS Worksheet Events made Easy/attached_files/098 Events Exercise 1/Events-Exercise1-Practice-Version.xlsm 19KB
  187. 04 Variables/attached_files/032 BONUS Passing Variables to Another Procedure - ByVal and ByRef/Passing-Variables-ByRef-and-ByVal.xlsm 13KB
  188. 01 The Range Object/attached_files/001 Intro and Course Workbooks download/User-Defined-Functions.zip 11KB
  189. 06 Super Important Tools and Excel Logic/attached_files/060 BONUS - User Defined Functions 101/User-Defined-Functions.zip 11KB
  190. 06 Super Important Tools and Excel Logic/quizzes/006 Super Important Info Quiz.html 7KB
  191. 07 Loops and Report Writing Basics/quizzes/007 Loops and Reports Quiz.html 6KB
  192. 04 Variables/quizzes/004 Variables Quiz.html 6KB
  193. 01 The Range Object/quizzes/001 Range Object Quiz.html 5KB
  194. 02 Range Properties/quizzes/002 Properties Quiz.html 5KB
  195. 08 EVENTS Worksheet Events made Easy/quizzes/008 Worksheet Events Quiz.html 5KB
  196. 03 The Cells Object/quizzes/003 Cells Quiz.html 4KB
  197. 05 Toolbars and Menus/quizzes/005 Toolbars Quiz.html 4KB
  198. Freetutorials.us.url 119B
  199. [FreeTutorials.us].txt 78B