| 5WH: Who | What | Where | When | Why | How macro | Not assigned student level | SQL | VBA Problems | What can Excel do? Beginner | Advanced Beginner | Intermediate | Advanced A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9 !@$* |
| 2. | What is a Excel Macro? | |
| 3. | Excel Macros | |
| 4. | Excel Data Validation | |
| 5. | Excel Code from KW | |
| 6. | Excel VBA Syntax Errors | |
| 7. | 58 Reasons I Love Microsoft Excel | |
| 7. | 83 Reasons I love Excel | |
| 8. | Screenupdating - to speed up VBA | |
| 9. | Use Excel to create comma separated list from column of numbers | |
| 10. | FindDataRow - routine to return the row that data is in a column | |
| 11. | Worksheet | |
| 12. | Workbook | |
| 13. | Chart | |
| 14. | Use Excel to load data to a Website | |
| 15. | Use Excel VBA to debug ASP Code | |
| 16. | VBA Code to ExtractTextFromLink | |
| 17. | VBA Code to remove text from a string | |
| 18. | Enable Excel Macros | |
| 19. | Where is a file | |
| 20. | Removing Excel Macros - Code to run Excel Macros on a server and them remove them | |
| 21. | How to change VBA Code | |
| 22. | How to learn vba? | |
| 23. | How to learn programming | |
| 24. | What can Excel Do? (WCED) | |
| 25. | What are instances of Excel? | |
| 26. | How to Run a Excel Macro | |
| 27. | Creating a Excel Macro formula to replace text | |
| 28. | Add a button to a spreadsheet | |
| 29. | Learn about a cell | |
| 30. | Chess board looks like a spreadsheet | |
| 31. | The number of attempts to get a program to work is so much higher than you would expect | |
| 32. | Can be used to email from a spreadsheet using CDO | |
| 33. | Excel Risk - Risk that a production process occurs via Excel | |
| 34. | Using a VBA function in Excel | |
| 35. | Extracting value from data | |
| 36. | Filelen | |
| 37. | mid | |
| 38. | concatenation | |
| 39. | if | |
| 40. | xml | |
| 41. | files | |
| 42. | Ribbon | |
| 43. | Send Emails | |
| 44. | Excel standards | |
| 45. | Code to Hide/Show data when moving activecell | |
| 46. | Comparison Code - Align_on_key and Diffs | |
| 47. | Spreadsheet is like a rube goldberg machine | |
| 48. | Building a ribbon in Excel | |
| 49. | Excel interfacing with PowerPoint (12) | |
| 50. | Querying data via Excel | |
| 50. | Bulletproof the code | |
| 51. | DQ/Data Quality/Standard Errors to handle/check | |
| 52. | Excel Standards (10) | |
| 53. | Excel Macro Recorder | |
| 54. | VBA | |
| 55. | instr | |
| 56. | ||
| 57. | mid | |
| 58. | Immediate Window | |
| 59. | If | |
| 60. | DispYN | |
| 61. | and vs or | |
| 62. | Precedence | |
| 63. | Assignment statement | |
| 64. | counters | |
| 65. | for | |
| 66. | looping | |
| 67. | Forms | |
| 68. | Buttons | |
| 69. | Function/Sub | |
| 70. | Syntax | |
| 71. | Comments | |
| 72. | VBE/VB Editor | |
| 73. | SQL/Database | |
| 74. | Microsoft Access | |
| 75. | Files | |
| 76. | Folders/Directories | |
| 77. | Lessons | |
| 78. | Courses | |
| 79. | Documents | |
| 80. | #NAME? | |
| 81. | #VALUE! | |
| 82. | #N/A | |
| 83. | Debugging | |
| 84. | statusbar | |
| 85. | status | |
| 86. | Cancel Long Task | |
| 87. | Windows API | |
| 88. | Borders | |
| 89. | Fixing Recorder statements | |
| 90. | Formatting | |
| 91. | Dashboard | |
| 92. | Flowcharting | |
| 93. | Doevents | |
| 94. | Indentation | |
| 95. | Variable Naming | |
| 96. | MsgBox | |
| 97. | Poor Error Messages | |
| 98. | Error Handling | |
| 99. | Opening Excel | |
| 100. | Installing Excel | |
| 101. | Installing Software | |
| 102. | Saving files | |
| 103. | Versioning | |
| 104. | Autosave | |
| 105. | Processing File data | |
| 106. | Open File | |
| 107. | Close File | |
| 108. | Read a file | |
| 109. | Write a file | |
| 110. | Formula Debugging | |
| 111. | VBA running Excel Formulas | |
| 112. | Comments | |
| 113. | Rows | |
| 114. | Columns | |
| 115. | Cells | |
| 116. | Sheet | |
| 117. | Spreadsheet | |
| 118. | Edit a Cell | |
| 119. | Enter data to a cell | |
| 120. | Range of cells or range | |
| 121. | Area | |
| 122. | Windows, Mouse, Keyboard, Disk | |
| 123. | Why Learn Excel? | |
| 124. | What if you don't know Excel? | |
| 125. | Holy Sh!t. Excel can do that!: 72 Amazing thing you can do with Excel | |
| 126. | Excel and Job Security | |
| 127. | Problems to Solution | |
| 128. | Shortcuts | |
| 129. | Ribbon | |
| 130. | Home Ribbon | |
| 131. | Hover | |
| 132. | Cursors | |
| 133. | Active Cell | |
| 134. | Typing into a cell | |
| 135. | Experiment | |
| 136. | Excel Helped me get > 69,000 followers on Twitter | |
| 137. | Basic Computer commands/terms | |
| 138. | Excel can help you lose weight | |
| 139. | Who uses Excel? | |
| 140. | Who built Excel? - Microsoft | |
| 141. | Duplicates | |
| 142. | Danger with Excel Macros | |
| 143. | Differences in Excel versions | |
| 144. | Shortcut keys | |
| 145. | Monitor Your PC Usage, manager', co-workers, staff's | |
| 146. | Helped me learn ASP (Active Server Pages) and create dynamic websites | |
| 147. | Create questionnaire to help someone learn a topic | |
| 148. | Rows(1:1).... --> Rows("1:1") - left out quotes | |
| 149. | Simulate to gain knowledge | |
| 150. | Brute force statistics | |
| 151. | Excel can help you lose weight | |
| 152. | What is Excel? | |
| 153. | Excel is like a Rube Goldberg machine | |
| 154. | Holy Sh!t; Excel can do That! | |
| 155. | PowerPoint issues (3) | |
| 156. | Running single SQL query | |
| 157. | Running multiple SQL Queries in one command | |
| 158. | Running SQL from a file | |
| 159. | Calculation, Recalculation of the sheet | |
| 160. | Access web data from Excel | |
| 161. | Developer Ribbon | |
| 162. | Excel Macro virus | |
| 163. | xlsm file suffix | |
| 164. | Excel Macro Warning | |
| 165. | Excel Macro settings | |
| 166. | What can a Excel Macro do? | |
| 167. | What is Excel? | |
| 168. | Jobs that use Excel | |
| 169. | Verify input data | |
| 170. | Manual vs. automated | |
| 171. | New sheet | |
| 172. | Think you're done lesson with Excel, but your not even close | |
| 173. | Not having permission/access to a system/document/resource | |
| 174. | Using a reserved word of a system as a variable | |
| 175. | Variable not defined | |
| 176. | Block without end if | |
| 177. | On Error Resume Next Problem | |
| 178. | Excel Todo list | |
| 179. | Run SQL commands against a database | |
| 180. | Run SQL in a file and substitute parameters | |
| 181. | Create charts | |
| 182. | Pivot Data | |
| 183. | Detect if there is a later version than the Excel you're working on | |
| 184. | 1 Problems with Excel | |
| 185. | Preventing sending emails with issues | |
| 186. | #VALUE error caused by negative time where I subtract one time from another and the result is negative | |
| 187. | Speed up Excel | |
| 188. | Turn off calcuation | |
| 189. | Screenupdating | |
| 190. | Compress Pictures | |
| 191. | Shapes collection | |
| 192. | Collections | |
| 193. | Excel to PowerPoint | |
| 194. | What skills are needed to learn Excel? | |
| 195. | Hardcoding | |
| 196. | Error handling | |
| 197. | '@ code | |
| 198. | Custom Ribbon | |
| 199. | Shrink Sheet code | |
| 200. | 55 Error - File Already Open | |
| 201. | Work-arounds | |
| 202. | Enable Macros | |
| 203. | Where is a file? | |
| 204. | Understanding someone else's spreadsheet | |
| 205. | Changing code | |
| 206. | Debugging VBA | |
| 207. | Excel instances | |
| 208. | Convert an Excel Chart to an image and upload to twitter or webpage | |
| 1000. | Excel File suffixes | |
| 1000. | xl training plan | |
| 1000. | 13 Things You Must Know About Microsoft #Excel | |
| 10000. | Excel (2) (Course, diet..) | |
| 10000. | Cool Math/Excel Stuff | |
| 10000. | Demo on PPTTools | |
| 10001. | Excel UCs | |
| 10002. | Work Success Book Using Excel, Word and PowerPoint | |
| 10003. | Excel Stuff | |
| 10004. | transferred Excel beginner valued at > $1000 with code 7%=0,5B)X(CI48F3 |