FreeCourseLab com Udemy - Excel Essentials The Complete Excel Series - Level 1 2 & 3

1. 1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/1. Intro To Level 1.mp412.33MB
2. 1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/2. Before We Start...Viewing The Lectures, And Following Along On A Single Screen.mp49.51MB
3. 10. Bonus Section Student Questions Answered!/1. Reverse Engineering A Sample Spreadsheet.mp453.91MB
4. 10. Bonus Section Student Questions Answered!/2. Casing And Text Functions.mp443.49MB
5. 11. Excel Essentials Level 2 - IntermediateAdvanced/1. Intro To Level 2.mp48.94MB
6. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/1. Proof Of Concept.mp416.33MB
7. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/10. Importing A Template From An Existing Excel File.mp413.14MB
8. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/11. Converting Time To A Decimal.mp416.16MB
9. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/12. A Little Bit Of Simple Data Entry.mp49.13MB
10. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/13. Simple Conditional Formatting For A Cleaner View.mp415.7MB
11. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/14. Calculating Time Out Of House Using Travel Time.mp416.65MB
12. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/15. Simple Logical Testing And Nested Logical Testing.mp422.58MB
13. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/16. Building Text Strings With A Formula.mp443.46MB
14. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/17. Before We Move On...Accessing The Developer Ribbon.mp44.78MB
15. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/18. A Tick Box Exercise (Of Sorts).mp428.22MB
16. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/19. Auto-populating Check Boxes.mp434.15MB
17. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/2. Planning Ahead.mp44.74MB
18. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/20. PRACTICE EXERCISE 1 - Time To Add A New Entry.mp46.32MB
19. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/21. Defining A Working Area, And Protecting Your Work.mp416.15MB
20. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/22. PRACTICE EXERCISE 2 - Set Up A Working Area, And Limit User Entry.mp43.83MB
21. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/3. Creating Our Data Entry Screen.mp49.48MB
22. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/4. (Custom) Formatting Dates And Time.mp413.11MB
23. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/5. Simple Calculations With Time.mp45.02MB
24. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/6. More (Useful) Calculations With Time.mp419.5MB
25. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/7. It's About Time (And Dates!).mp416.4MB
26. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/8. Adding Time.mp48.88MB
27. 12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/9. Creating A Template From An Image.mp434.71MB
28. 13. Project 2 - Building A Database With Excel/1. Simple VLOOKUPs.mp48.58MB
29. 13. Project 2 - Building A Database With Excel/10. Data Arrays Don't Have To Start At A!.mp49.64MB
30. 13. Project 2 - Building A Database With Excel/11. Some Common Reasons VLook-Ups Fail.mp414.02MB
31. 13. Project 2 - Building A Database With Excel/12. One Inherent Flaw In Vlook Up.mp43.55MB
32. 13. Project 2 - Building A Database With Excel/13. POWER USER - A Breakdown Of Looking Up Backwards.mp413.25MB
33. 13. Project 2 - Building A Database With Excel/14. The Other Way Of Looking Up Backwards.mp414.2MB
34. 13. Project 2 - Building A Database With Excel/15. Backwards Look-Ups In Action.mp411.47MB
35. 13. Project 2 - Building A Database With Excel/16. POWER USER - Dealing With Inconsistencies In User Entry.mp428.16MB
36. 13. Project 2 - Building A Database With Excel/17. POWER USER - Fuzzy Vlook-Ups.mp410.44MB
37. 13. Project 2 - Building A Database With Excel/18. POWER USER - Vlook-Ups With Multiple Inputs.mp425.77MB
38. 13. Project 2 - Building A Database With Excel/19. POWER USER - Looking Up Multiple Inputs Using An Array Formula.mp414.7MB
39. 13. Project 2 - Building A Database With Excel/2. Step 1 - Get Some Data In, And Split It.mp417.47MB
40. 13. Project 2 - Building A Database With Excel/20. VLOOKUPs Brother...HLOOKUP.mp412.33MB
41. 13. Project 2 - Building A Database With Excel/21. POWER USER - The Holy Grail - How To Return Multiple Values From A Single Look U.mp432.47MB
42. 13. Project 2 - Building A Database With Excel/22. What To Look For When THAT Formula Didn't Work.mp410.19MB
43. 13. Project 2 - Building A Database With Excel/23. The Fastest Way To Modify Your Column Numbers.mp416.14MB
44. 13. Project 2 - Building A Database With Excel/24. POWER USER - Vlook-Ups With Moving Columns.mp47.52MB
45. 13. Project 2 - Building A Database With Excel/25. Putting It All Together.mp428.06MB
46. 13. Project 2 - Building A Database With Excel/26. The Finishing Touch - How Many Records Did I Find.mp412.55MB
47. 13. Project 2 - Building A Database With Excel/3. Using Data Validation To Get The Right Input.mp411.59MB
48. 13. Project 2 - Building A Database With Excel/4. Let's Build Our Database!.mp419MB
49. 13. Project 2 - Building A Database With Excel/5. Importing Data From A Text File.mp48.8MB
50. 13. Project 2 - Building A Database With Excel/6. Importing Data From A Word File.mp410.98MB
51. 13. Project 2 - Building A Database With Excel/7. Pulling Data From Multiple Sources.mp410.07MB
52. 13. Project 2 - Building A Database With Excel/8. Using OTHER Look-Ups To Look Up!.mp416.62MB
53. 13. Project 2 - Building A Database With Excel/9. LOOKUP From A LOOKUP With No Intermediary Step.mp45.95MB
54. 14. Project 3 - Named Ranges/1. A Simple Static Named Range Using A Single Cell.mp48.76MB
55. 14. Project 3 - Named Ranges/2. Creating A Named Range Using A Range Of Cells.mp46.32MB
56. 14. Project 3 - Named Ranges/3. Using Row Labels To Name Multiple Ranges.mp47.24MB
57. 14. Project 3 - Named Ranges/4. POWER USER - A Magic Trick Using Row And Column Labels.mp410.3MB
58. 14. Project 3 - Named Ranges/5. POWER USER - Dynamic Named Ranges.mp418.38MB
59. 14. Project 3 - Named Ranges/6. POWER USER - What To Do With Dynamic Names Ranges With Titles.mp416.57MB
60. 14. Project 3 - Named Ranges/7. 3035 - POWER USER - Dynamic Charts.mp448.61MB
61. 14. Project 3 - Named Ranges/8. 3040 - Horizontal Dynamic Named Ranges For Charts.mp442.61MB
62. 15. Project 4 - What Can I Have For Dinner/1. Welcome to What Can I Have For Dinner or...What Would I Use THAT for.mp42.49MB
63. 15. Project 4 - What Can I Have For Dinner/10. It's A One Or A Zero.mp45.18MB
64. 15. Project 4 - What Can I Have For Dinner/11. Working The Percentages And Adding Traffic Lights.mp48.54MB
65. 15. Project 4 - What Can I Have For Dinner/12. POWER USER - The HYPERLINK Function (And Problem).mp412.15MB
66. 15. Project 4 - What Can I Have For Dinner/13. PRACTICE EXERCISE 1 - Fill In The Blanks.mp42.03MB
67. 15. Project 4 - What Can I Have For Dinner/14. PRACTICE EXERCISE 2 - Pretty It Up (With A Macro).mp44.3MB
68. 15. Project 4 - What Can I Have For Dinner/15. PRACTICE EXERCISE 3 - Create A VLOOKUP Using A Built String With INDIRECT.mp44.66MB
69. 15. Project 4 - What Can I Have For Dinner/2. Hyperlinking To A Different Sheet In The Same Workbook.mp48.43MB
70. 15. Project 4 - What Can I Have For Dinner/3. Creating Our First Macro.mp412.68MB
71. 15. Project 4 - What Can I Have For Dinner/4. Assigning A Macro To A Button.mp49.89MB
72. 15. Project 4 - What Can I Have For Dinner/5. Creating A List For Our Dropdown Using A Dynamic Named Range.mp45.6MB
73. 15. Project 4 - What Can I Have For Dinner/6. Using A Conditional Format To Know When A Value Is Missing.mp410.12MB
74. 15. Project 4 - What Can I Have For Dinner/7. Copying Conditional Formats And Creating Our Drop-Downs.mp46.84MB
75. 15. Project 4 - What Can I Have For Dinner/8. Building Our Formula...INDIRECT Function.mp45.62MB
76. 15. Project 4 - What Can I Have For Dinner/9. Building Strings For Indirect Sheet And Cell References.mp418.23MB
77. 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/1. Creating A Gantt Chart Using A Worksheet.mp420.79MB
78. 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/2. Building The First Part Of Our Logical Test.mp412.94MB
79. 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/3. Multiple Logical Tests At Once Using AND.mp429.5MB
80. 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/4. Conditional Formatting...Where The Magic Happens.mp418.75MB
81. 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/5. Gantt Charts Using The Built In Charting Tools.mp429.58MB
82. 16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/6. SQA - Gantt Charts With Different Colours For Different Categories.mp420.01MB
83. 17. Bonus Section - Just For Fun/1. How I Created Randomly Generated License Plate Numbers!.mp427.77MB
84. 18. Student Questions Answered!/1. Calls Text Data - Or How To Return a Column Title If Value is 1.mp417.12MB
85. 18. Student Questions Answered!/10. Data Validation With Dependent Drop-downs.mp437.38MB
86. 18. Student Questions Answered!/11. Data Validation With Dependent Drop downs (Dynamic Named Range Workaround).mp477.6MB
87. 18. Student Questions Answered!/12. Using 2 Labels As A Lookup From Drop-downs.mp455.64MB
88. 18. Student Questions Answered!/2. Calls Text Data 2 - This Time Using Text!.mp438.65MB
89. 18. Student Questions Answered!/3. Extracting Phone Numbers From A Cell.mp46.86MB
90. 18. Student Questions Answered!/4. What Is The CHOOSE Function Really Used For.mp440.53MB
91. 18. Student Questions Answered!/5. Casing And Text Functions.mp414.37MB
92. 18. Student Questions Answered!/6. Dynamic Charting From A Drop Down.mp437.34MB
93. 18. Student Questions Answered!/7. Extracting a Unique List, And Summing The Money!.mp413.43MB
94. 18. Student Questions Answered!/8. SUMIF With Dynamic Sum Range.mp416.63MB
95. 18. Student Questions Answered!/9. Vlookups With Pictures!.mp420.3MB
96. 19. Excel Essentials Level 3 - VBA Programming/1. Why Should I Learn How To Code.mp439.65MB
97. 2. An Introduction To Level 1/1. Where Are My Practice Files.mp43.41MB
98. 20. What's It All About, Alan/1. The 15 Golden Rules Of Coding.mp411.38MB
99. 21. Introducing Your Personal Built In Translator...the Macro Recorder/1. Introducing The Visual Basic Editor, & Recording Our First Macro.mp435.36MB
100. 21. Introducing Your Personal Built In Translator...the Macro Recorder/10. Why You Can't Get By With Just Recording Macros.mp435.85MB
101. 21. Introducing Your Personal Built In Translator...the Macro Recorder/2. Saving Macro-Enabled Workbooks, And Security Settings.mp418.11MB
102. 21. Introducing Your Personal Built In Translator...the Macro Recorder/3. Moving Code Around.mp413.38MB
103. 21. Introducing Your Personal Built In Translator...the Macro Recorder/4. Stepping Out. Well, In Actually! - Debugging Made Easy ).mp425.83MB
104. 21. Introducing Your Personal Built In Translator...the Macro Recorder/5. With And End With.mp437.06MB
105. 21. Introducing Your Personal Built In Translator...the Macro Recorder/6. Streamlining You Code, Or, Get Rid Of What You Don't Need.mp426.94MB
106. 21. Introducing Your Personal Built In Translator...the Macro Recorder/7. Combining Your Code.mp422.29MB
107. 21. Introducing Your Personal Built In Translator...the Macro Recorder/8. A Little Privacy Please.mp412.53MB
108. 21. Introducing Your Personal Built In Translator...the Macro Recorder/9. Keyboard Shortcuts, And Why I Don't Use Them.mp44.14MB
109. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/1. Introduction To The Coding Section.mp410.05MB
110. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/10. The Offset Property.mp48.85MB
111. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/11. The End Property.mp412.95MB
112. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/12. Dynamic Range Selection.mp414.49MB
113. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/13. The CurrentRegion Property.mp48.05MB
114. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/14. ACTIVATE vs. SELECT.mp44.29MB
115. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/15. Between The Sheets.mp46.29MB
116. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/16. Calling A Sheet By Its VB Name.mp411.46MB
117. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/17. Sheets Vs. Worksheets.mp49.29MB
118. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/18. Getting Around The Workbooks.mp48.81MB
119. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/19. The Value Property - Writing Data.mp418.1MB
120. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/2. Getting All The Code For This Section.mp420.11MB
121. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/20. The Value Property - Reading And Writing Data.mp49.35MB
122. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/21. Copy And Paste.mp410.61MB
123. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/22. Commonly Used Properties.mp46.07MB
124. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/23. CODING EXERCISE The Rainbow.mp45.79MB
125. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/24. The Address Property.mp48.83MB
126. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/25. The Row and Column Properties.mp43.42MB
127. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/26. Capturing The Column Letter.mp44.4MB
128. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/27. More Useful Properties.mp48.89MB
129. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/28. Even More Useful Properties.mp46.74MB
130. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/29. Opening Another Workbook Programmatically.mp416.5MB
131. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/3. Changing Your VBE Settings.mp411.25MB
132. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/30. Closing Workbooks Programmatically.mp49.51MB
133. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/31. CODING EXERCISE OpenWriteClose.mp48.98MB
134. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/4. Protecting Your Code.mp44.76MB
135. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/5. Objects, Methods And Properties.mp416.78MB
136. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/6. Understanding The Hierarchy.mp48.44MB
137. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/7. The Range Object.mp47.06MB
138. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/8. The Cells Object.mp46.21MB
139. 22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/9. The ActiveCell Property.mp44.86MB
140. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/1. Introduction To The Programmers Toolbox.mp42.97MB
141. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/10. Looping With Do...Loop.mp413.37MB
142. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/11. Looping With For...Next.mp47.59MB
143. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/12. Looping With A Stepped For...Next.mp46.81MB
144. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/13. Looping With While...Wend.mp425.81MB
145. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/14. An Introduction To Logical Testing.mp44.78MB
146. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/15. Logical Testing - A Simple If Test.mp422.92MB
147. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/16. Logical Testing - A Simple If Test Using Cells.mp413.98MB
148. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/17. Logical Testing - If Then Else.mp413.08MB
149. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/18. Logical Testing - If Then Else Using Cells.mp416.49MB
150. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/19. Logical Testing - Testing Multiple Criteria.mp414.59MB
151. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/2. Variables - Local Variables.mp417.94MB
152. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/20. Logical Testing - Testing If One Is True, And One Is False.mp48.38MB
153. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/21. Logical Testing - Testing If Either Value Is True.mp414.44MB
154. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/22. Logical Testing - Select Case.mp420.61MB
155. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/23. Maths - Doing Simple Maths In Code.mp411.1MB
156. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/24. Maths - Writing Formulas To Single Cells.mp419.94MB
157. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/25. Maths - Writing Formulas To Ranges Of Cells.mp420.04MB
158. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/26. Maths - Using Excel's Built-in Functions.mp49.95MB
159. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/27. Maths - Built-in Functions With Defined Ranges.mp410.46MB
160. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/28. InputBox - Getting User Input Using The InputBox Function.mp415.99MB
161. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/29. Manipulating The User Input With Casing.mp418.73MB
162. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/3. Variables - Local Variables With A Twist.mp411.78MB
163. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/30. InputBox - Getting User Input Using The InputBox Method.mp419.89MB
164. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/31. Message Boxes - Simple Message Boxes.mp410.58MB
165. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/32. Message Boxes - Testing Which Button Was Pressed.mp412.78MB
166. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/33. Arrays - An Introduction.mp48.66MB
167. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/34. Arrays - A Simple One Dimensional Static Array.mp421.4MB
168. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/35. Arrays - A Simple One Dimensional Dynamic Array.mp418.12MB
169. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/36. Arrays - A Simple Two Dimensional Static Array.mp416.67MB
170. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/37. Arrays - The Most Efficient Way To Capture An Array.mp420.71MB
171. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/38. Arrays - Extracting Useful Data Based On User Input.mp426.05MB
172. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/39. Arrays - Using An Array As A Data Source For A VLookup.mp443.59MB
173. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/4. Variables - Module Level Variables.mp412.09MB
174. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/5. Variables - Project Level Variables.mp48.67MB
175. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/6. Bonus - Calling A Sub Stored In A DIFFERENT Workbook!.mp410.14MB
176. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/7. A Neat Trick To Force Variable Declaration.mp46.48MB
177. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/8. Variables - All The Techie Bits.mp418.44MB
178. 23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/9. An Introduction To Looping.mp42.79MB
179. 24. Automating All Your Reports!/1. Introduction To Report Automation Section.mp49.45MB
180. 24. Automating All Your Reports!/10. Changing The Chart Title (And Why We Do It Separately).mp49.18MB
181. 24. Automating All Your Reports!/11. Deconstructing The Pivot Tables (It's Slightly Different).mp422.68MB
182. 24. Automating All Your Reports!/12. Titles, Money And Sorting.mp415.79MB
183. 24. Automating All Your Reports!/13. Butchering One Table, To Create Another.mp419.55MB
184. 24. Automating All Your Reports!/14. Adding The Commentary - Building Strings Dynamically At Runtime.mp428MB
185. 24. Automating All Your Reports!/15. Adding The Comentary Using Data From The Sheet We're On.mp420.66MB
186. 24. Automating All Your Reports!/16. POWER USER - How DO You Make Specific Words Bold.mp422.02MB
187. 24. Automating All Your Reports!/17. POWER USER - INSTR...A Very Useful Function.mp414.28MB
188. 24. Automating All Your Reports!/18. INSTR And Paying Attention To Detail.mp411.82MB
189. 24. Automating All Your Reports!/19. Tidy Up The Title.mp416.79MB
190. 24. Automating All Your Reports!/2. A Special Note For Office 2010 Users.mp44.87MB
191. 24. Automating All Your Reports!/20. Easy As Pie (Chart).mp424.42MB
192. 24. Automating All Your Reports!/21. Prettying Up Our Pie Chart.mp411.19MB
193. 24. Automating All Your Reports!/22. Putting It All Together.mp420.83MB
194. 24. Automating All Your Reports!/3. Recording The Bones Of The Code.mp412.63MB
195. 24. Automating All Your Reports!/4. Streamlining The Add New Sheet Code.mp421.9MB
196. 24. Automating All Your Reports!/5. Deconstructing The Profit By Day Code.mp44.58MB
197. 24. Automating All Your Reports!/6. Building Source Data Strings Dynamically At Runtime.mp421.35MB
198. 24. Automating All Your Reports!/7. Creating The Run Order and Data Capture Subs.mp413.69MB
199. 24. Automating All Your Reports!/8. Solving That Naming Problem.mp414.04MB
200. 24. Automating All Your Reports!/9. POWER USER - Sizing Your Charts Precisely.mp49.08MB
201. 25. The Data Is Out There...On The Internet, That Is/1. Introduction To Web Query Section.mp49.86MB
202. 25. The Data Is Out There...On The Internet, That Is/2. Pulling Data From The Internet - Capturing The Data For Rome.mp417.14MB
203. 25. The Data Is Out There...On The Internet, That Is/3. Getting To Cancun And London From Rome.mp422.61MB
204. 25. The Data Is Out There...On The Internet, That Is/4. Data Clean Up.mp413.99MB
205. 25. The Data Is Out There...On The Internet, That Is/5. A Simple Find And Replace.mp48.7MB
206. 25. The Data Is Out There...On The Internet, That Is/6. Getting Our Formulas Right.mp420.21MB
207. 25. The Data Is Out There...On The Internet, That Is/7. Streamlining The Formulas Code.mp421.82MB
208. 25. The Data Is Out There...On The Internet, That Is/8. POWER USER - Displaying Messages In The Status Bar (Cool).mp410.95MB
209. 25. The Data Is Out There...On The Internet, That Is/9. Putting It All Together.mp410.94MB
210. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/1. Intro To The Events Section.mp44.63MB
211. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/10. WorkSheet Activate - You Might Pick This!.mp48.63MB
212. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/11. WorkSheet Change.mp46.45MB
213. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/12. WorkSheet Change - A More Useful Use.mp418.36MB
214. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/13. WorkSheet Activate - Top Secret Classified Information!.mp411.33MB
215. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/14. WorkSheet Events - BONUS - 4 New Things To Try.mp477.36MB
216. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/2. WorkBook SheetActivate.mp415.07MB
217. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/3. WorkBook BeforePrint.mp48.28MB
218. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/4. WorkBook SheetChange.mp43.01MB
219. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/5. WorkBook Open - Creating An Auto-Back Up.mp420.44MB
220. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/6. WorkBook Open - Creating A Splash Screen.mp414.7MB
221. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/7. WorkBook Open - Calling Other Code.mp423.06MB
222. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/8. WorkBook BeforeClose.mp47.96MB
223. 26. Workbook Events You Don't Have To Run Code To Have Code Run!/9. WorkSheet Activate - You Can't Pick This!.mp45.54MB
224. 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/1. User Defined Functions...What They Are, And How You Make Them.mp412.03MB
225. 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/2. Using A UDF To Return Information.mp43.66MB
226. 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/3. Creating A Countdown Timer With A UDF.mp416.35MB
227. 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/4. A Custom UDF For Calculating Volume Discount.mp48.14MB
228. 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/5. A UDF For Getting All Your Sheet Names.mp420.71MB
229. 27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/6. Calling A UDF From A Different Workbook.mp43.86MB
230. 28. Bonus Section Controlling Windows - Folder Creation Gizmo/1. Intro To Folder Creation Gizmo.mp46.05MB
231. 28. Bonus Section Controlling Windows - Folder Creation Gizmo/2. Creating A New Folder With A Single Line Of Code.mp42.03MB
232. 28. Bonus Section Controlling Windows - Folder Creation Gizmo/3. A Single Level Folder Structure.mp416.39MB
233. 28. Bonus Section Controlling Windows - Folder Creation Gizmo/4. Folders Within Folders.mp414.82MB
234. 29. Bonus Section eMail Automation...Why WRITE emails!/1. Intro To The Emailing Section.mp48.97MB
235. 29. Bonus Section eMail Automation...Why WRITE emails!/2. Understanding The eMail Routine.mp415.57MB
236. 29. Bonus Section eMail Automation...Why WRITE emails!/3. Deconstructing How We Capture All The Data.mp429.57MB
237. 29. Bonus Section eMail Automation...Why WRITE emails!/4. The eMail Loop.mp415.65MB
238. 3. Start Here - All The Basics/1. Opening Excel, and Creating a Shortcut.mp417.8MB
239. 3. Start Here - All The Basics/10. A Quick Word On Formatting.mp43.53MB
240. 3. Start Here - All The Basics/11. Formatting Text - Alignment.mp46.88MB
241. 3. Start Here - All The Basics/12. Saving Time With AutoFilling Sequences.mp411MB
242. 3. Start Here - All The Basics/13. POWER USER - Adding Your Own Lists To Autofill.mp418.04MB
243. 3. Start Here - All The Basics/14. Saving Time With Format Painter.mp46.56MB
244. 3. Start Here - All The Basics/15. Changing The Column Width.mp47.39MB
245. 3. Start Here - All The Basics/17. Tidy Large Titles With Merge And Centre.mp46.16MB
246. 3. Start Here - All The Basics/18. Entering Data - A Couple Of Shortcuts.mp48.27MB
247. 3. Start Here - All The Basics/2. The Anatomy Of A Workbook Where Everything Is, And What It Does!.mp449.57MB
248. 3. Start Here - All The Basics/3. A Quick Review Of What's Where.mp417.06MB
249. 3. Start Here - All The Basics/4. Always Do This First! - Save Your New Workbook!.mp44.71MB
250. 3. Start Here - All The Basics/5. Let's Enter Some Data.mp43.27MB
251. 3. Start Here - All The Basics/7. Editing Data.mp42.99MB
252. 3. Start Here - All The Basics/8. Ooops. I Made A Mistake - Undo and Redo.mp42.37MB
253. 3. Start Here - All The Basics/9. Changing Appearance Of Text With Formatting - Fonts.mp421.83MB
254. 30. Bonus Section Word Automation - Controlling Word From Excel/1. Intro To The Word Section.mp42.15MB
255. 30. Bonus Section Word Automation - Controlling Word From Excel/2. Understanding The Word Routine.mp44.65MB
256. 30. Bonus Section Word Automation - Controlling Word From Excel/3. Deconstructing How We Capture All The Data.mp411.16MB
257. 30. Bonus Section Word Automation - Controlling Word From Excel/4. Formula Modifications With Unique Values.mp415.73MB
258. 30. Bonus Section Word Automation - Controlling Word From Excel/5. Efficient Sorting.mp411.09MB
259. 30. Bonus Section Word Automation - Controlling Word From Excel/6. Building The Text And Wrap Up.mp415.26MB
260. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/1. Intro To PowerPoint Section.mp43.12MB
261. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/10. Final Slide, And Wrap Up.mp48.37MB
262. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/2. A Run Through The PowerPoint Base Code.mp425.52MB
263. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/3. Setting Up The Shell Of The Code.mp48.52MB
264. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/4. Who's Presenting This....mp49.54MB
265. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/5. Adding A Slide With A Logo And Text.mp430.2MB
266. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/6. Prettying Up The Formatting (More Lego Coding!).mp47.46MB
267. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/7. Using Slide 1 To Create Slide 2.mp416.39MB
268. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/8. Adding A Chart As A Picture.mp431.25MB
269. 31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/9. Adding Pivot Tables (And Another Chart).mp438.69MB
270. 32. Importing Specific Data From Multiple Files/1. Intro To Importing Data From A Folder Full Of Files.mp410MB
271. 32. Importing Specific Data From Multiple Files/2. Looping Through All Excel Files In A Folder.mp414.44MB
272. 32. Importing Specific Data From Multiple Files/3. The Folder Picker.mp410.83MB
273. 32. Importing Specific Data From Multiple Files/4. A More Useful Loop Through Files.mp47.9MB
274. 32. Importing Specific Data From Multiple Files/5. The Data Grabber(er).mp445.96MB
275. 33. Student Questions Answered/1. Get rid of rows in a array.mp416.66MB
276. 33. Student Questions Answered/10. Protecting Specific Cells and Data Validation.mp432.56MB
277. 33. Student Questions Answered/11. Dynamically Populating A Reusable Array While Looping Through A Table.mp415.26MB
278. 33. Student Questions Answered/12. Sequential PDF Creation With Pictures.mp449MB
279. 33. Student Questions Answered/13. File Picker, And Report Generator With Intelligent Filing.mp458.5MB
280. 33. Student Questions Answered/14. Help! My File Has Got HUGE!.mp426.28MB
281. 33. Student Questions Answered/15. Finding Updated Values In One Workbook, And Adding Them To Another Workbook.mp429.37MB
282. 33. Student Questions Answered/16. Gantt Charts...With A Little More Sophistication!.mp433.18MB
283. 33. Student Questions Answered/17. Vlookups (Or Any Application.WorksheetFunction) Over Ranges.mp4136.2MB
284. 33. Student Questions Answered/18. Adding A Date Stamp If A Change Has Been Made.mp447.41MB
285. 33. Student Questions Answered/2. Emailing Routine Adding a Specific Attachment Based On a Criteria.mp412.48MB
286. 33. Student Questions Answered/3. Adding A Date Stamp, And Going To The Insertion Point AUTOMATICALLY.mp417.41MB
287. 33. Student Questions Answered/4. Saving An Individual Sheet To A Specific Folder.mp429.72MB
288. 33. Student Questions Answered/5. Saving Multiple Sheets To A Single Workbook In A Specific Folder.mp480.94MB
289. 33. Student Questions Answered/6. Animated Charts...With A Little Something Extra!.mp424.35MB
290. 33. Student Questions Answered/7. Extracting Specific Data From A Big File, To A Bunch Of Little Ones.mp438.11MB
291. 33. Student Questions Answered/8. Finding A Search String in Another Workbook With Multiple Sheets.mp414.65MB
292. 33. Student Questions Answered/9. Extracting Unique Tables to Unique Sheets From A Big Data Set.mp444.87MB
293. 34. Thank You - Your Special Bonus!/1. Get Your Next Course Now!.mp44.4MB
294. 4. Doing The (Simple) Math/1. Sums - The Old Fashioned Way!.mp46.07MB
295. 4. Doing The (Simple) Math/10. The Order Of Mathematical Operation.mp412.55MB
296. 4. Doing The (Simple) Math/11. POWER USER - Evaluate Formula.mp410.39MB
297. 4. Doing The (Simple) Math/2. Sums - Using Autosum.mp413.14MB
298. 4. Doing The (Simple) Math/4. Copying Formulas.mp47.7MB
299. 4. Doing The (Simple) Math/5. SUMming Horizontally.mp47.38MB
300. 4. Doing The (Simple) Math/6. Basic Formulas - Subtraction.mp45.58MB
301. 4. Doing The (Simple) Math/7. Basic Formulas - Multiplication.mp43.55MB
302. 4. Doing The (Simple) Math/8. Basic Formulas - Division.mp42.77MB
303. 4. Doing The (Simple) Math/9. Average Function.mp47.14MB
304. 5. Rearranging Things/1. Inserting New Columns And Rows.mp416.22MB
305. 5. Rearranging Things/2. Moving Existing Columns And Rows.mp45.88MB
306. 5. Rearranging Things/3. Cutting, Copying, Inserting And Deleting.mp412.07MB
307. 5. Rearranging Things/4. Hiding Columns And Rows.mp48.14MB
308. 6. Formulas Learning The Clever Stuff!/1. ROUNDing Functions.mp415.28MB
309. 6. Formulas Learning The Clever Stuff!/2. Formatting Numbers.mp47.63MB
310. 6. Formulas Learning The Clever Stuff!/3. A Primer In Building Complex Formulas.mp46.09MB
311. 6. Formulas Learning The Clever Stuff!/4. Buliding a Compex Formula.mp411.27MB
312. 7. A Few More Essentials/1. Sorting.mp413.92MB
313. 7. A Few More Essentials/10. Getting Help.mp45.4MB
314. 7. A Few More Essentials/11. Filters.mp416.96MB
315. 7. A Few More Essentials/12. Highlighting Cells.mp48.47MB
316. 7. A Few More Essentials/14. Closing.mp43.76MB
317. 7. A Few More Essentials/2. Wrapping Text And Soft Enter.mp411.17MB
318. 7. A Few More Essentials/3. Adding A New Worksheet.mp43.82MB
319. 7. A Few More Essentials/4. Creating A Simple Chart.mp412.33MB
320. 7. A Few More Essentials/6. Adding Borders.mp48.17MB
321. 7. A Few More Essentials/7. Customizing the Quick Access Toolbar.mp46.82MB
322. 7. A Few More Essentials/8. Simple Printing.mp412.87MB
323. 7. A Few More Essentials/9. Freezing For An Easier View.mp413.73MB
324. 8. Bonus Section - The Keyboard Shortcuts/1. Bonus 1 Whizzing Around Excel.mp419.57MB
325. 8. Bonus Section - The Keyboard Shortcuts/2. Bonus 2 Keyboard Shortcuts.mp435.35MB
326. 9. Bonus Section Absolute and Relative Cell References/1. A1 Style - Relative Relative.mp45.56MB
327. 9. Bonus Section Absolute and Relative Cell References/2. $A$1 Style - Absolute Absolute.mp46.58MB
328. 9. Bonus Section Absolute and Relative Cell References/3. $A1 Style - Absolute Relative.mp44.69MB
329. 9. Bonus Section Absolute and Relative Cell References/4. A$1 Style - Relative Absolute.mp44.42MB