FreeTutorials Us ultimate-excel-programmer

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