|
/1. The Range Object/
|
|
1. Intro and Course Workbooks download.mp4
|
77.9 MB
|
|
1. Intro and Course Workbooks download.vtt
|
5.3 KB
|
|
1.1 User Defined Functions.zip.zip
|
11.7 KB
|
|
1.2 Workbooks Download.zip
|
903.1 KB
|
|
1.3 Excel VBA - PC vs Mac Help.pdf.pdf
|
421.4 KB
|
|
10. Exercise 01 - Question.mp4
|
572.5 KB
|
|
10. Exercise 01 - Question.vtt
|
0.3 KB
|
|
10.1 Exercise 01 - Question.xlsm.xlsm
|
24.5 KB
|
|
11. Exercise 01 - Answer.mp4
|
8.6 MB
|
|
11. Exercise 01 - Answer.vtt
|
5.2 KB
|
|
11.1 Exercise 01 - Answer.xlsm.xlsm
|
30.3 KB
|
|
12. Several Ways to trigger your Macro.mp4
|
10.7 MB
|
|
12. Several Ways to trigger your Macro.vtt
|
1.8 KB
|
|
13. Affecting Multiple Cells with One Range Command - 2 Methods.mp4
|
12.7 MB
|
|
13. Affecting Multiple Cells with One Range Command - 2 Methods.vtt
|
1.5 KB
|
|
14. Adding Strings of Text to a Cell.mp4
|
12.1 MB
|
|
14. Adding Strings of Text to a Cell.vtt
|
1.9 KB
|
|
15. Using a Named Range with the Range Object.mp4
|
10.4 MB
|
|
15. Using a Named Range with the Range Object.vtt
|
1.9 KB
|
|
16. Range Object Quiz.html
|
0.1 KB
|
|
2. Get the Developer Tab and Intro to Developer Tab.mp4
|
12.3 MB
|
|
2. Get the Developer Tab and Intro to Developer Tab.vtt
|
2.0 KB
|
|
3. Getting started with Range object.mp4
|
8.3 MB
|
|
3. Getting started with Range object.vtt
|
1.7 KB
|
|
4. Quick Tip - Project Explorer and Properties Window!.mp4
|
7.7 MB
|
|
4. Quick Tip - Project Explorer and Properties Window!.vtt
|
1.4 KB
|
|
5. Creating Your First Macro From Scratch.mp4
|
18.1 MB
|
|
5. Creating Your First Macro From Scratch.vtt
|
3.4 KB
|
|
6. Adding a Secondary Command. . ..mp4
|
6.5 MB
|
|
6. Adding a Secondary Command. . ..vtt
|
1.0 KB
|
|
7. Debugging in Excel VBA.mp4
|
11.1 MB
|
|
7. Debugging in Excel VBA.vtt
|
2.1 KB
|
|
8. Saving a Macro-Enabled Workbook (.xlsm).mp4
|
9.5 MB
|
|
8. Saving a Macro-Enabled Workbook (.xlsm).vtt
|
1.4 KB
|
|
9. Before You Begin The Exercises....mp4
|
9.3 MB
|
|
9. Before You Begin The Exercises....vtt
|
4.2 KB
|
|
/10. Activex Controls on Worksheets/
|
|
1. Activex Controls vs Forms Controls.mp4
|
6.1 MB
|
|
1. Activex Controls vs Forms Controls.vtt
|
5.5 KB
|
|
10. Use a Checkbox for its VALUE.mp4
|
4.8 MB
|
|
10. Use a Checkbox for its VALUE.vtt
|
3.2 KB
|
|
11. Checkbox Event Without a Button.mp4
|
3.0 MB
|
|
11. Checkbox Event Without a Button.vtt
|
2.7 KB
|
|
12. LinkedCell Property with a Checkbox.mp4
|
2.4 MB
|
|
12. LinkedCell Property with a Checkbox.vtt
|
2.7 KB
|
|
13. Option Buttons Intro - What is an Option Button and Grouping.mp4
|
4.7 MB
|
|
13. Option Buttons Intro - What is an Option Button and Grouping.vtt
|
4.2 KB
|
|
14. Grouping, Alignment and Aesthetics for Controls.mp4
|
4.7 MB
|
|
14. Grouping, Alignment and Aesthetics for Controls.vtt
|
3.5 KB
|
|
15. Homemade Quiz using Option Buttons and a Command Button.mp4
|
7.4 MB
|
|
15. Homemade Quiz using Option Buttons and a Command Button.vtt
|
6.1 KB
|
|
16. Compliance Checker for your Forms or Quizzes Part 1.mp4
|
6.9 MB
|
|
16. Compliance Checker for your Forms or Quizzes Part 1.vtt
|
4.3 KB
|
|
17. Compliance check part 2.mp4
|
21.0 MB
|
|
17. Compliance check part 2.vtt
|
11.7 KB
|
|
18. SpinButton with Cell A1.mp4
|
7.0 MB
|
|
18. SpinButton with Cell A1.vtt
|
5.8 KB
|
|
19. SpinButtons with Textboxes and Numbers.mp4
|
10.4 MB
|
|
19. SpinButtons with Textboxes and Numbers.vtt
|
7.0 KB
|
|
2. Button Click - Wage Calculator.mp4
|
6.9 MB
|
|
2. Button Click - Wage Calculator.vtt
|
5.4 KB
|
|
20. SpinButton BONUS - Move Textbox Position with SpinButton.mp4
|
9.2 MB
|
|
20. SpinButton BONUS - Move Textbox Position with SpinButton.vtt
|
4.3 KB
|
|
21. SpinButton with Dates in a Textbox.mp4
|
7.2 MB
|
|
21. SpinButton with Dates in a Textbox.vtt
|
4.2 KB
|
|
22. Activex Label Control - Basics.mp4
|
7.1 MB
|
|
22. Activex Label Control - Basics.vtt
|
4.8 KB
|
|
23. ComboBox - Fill with ListFillRange.mp4
|
8.1 MB
|
|
23. ComboBox - Fill with ListFillRange.vtt
|
4.1 KB
|
|
24. Creating a Dynamic Range.mp4
|
9.1 MB
|
|
24. Creating a Dynamic Range.vtt
|
5.5 KB
|
|
25. ComboBox - How to use Multiple Columns.mp4
|
6.6 MB
|
|
25. ComboBox - How to use Multiple Columns.vtt
|
3.8 KB
|
|
26. Using .ADDITEM to Get Specific items in your Combobox List.mp4
|
18.6 MB
|
|
26. Using .ADDITEM to Get Specific items in your Combobox List.vtt
|
10.0 KB
|
|
27. Noteworthy Properties of a Combobox.mp4
|
12.6 MB
|
|
27. Noteworthy Properties of a Combobox.vtt
|
7.1 KB
|
|
28. Multiple Columns in Combobox with .ADDITEM and List, ListCount etc.mp4
|
17.0 MB
|
|
28. Multiple Columns in Combobox with .ADDITEM and List, ListCount etc.vtt
|
17.0 MB
|
|
28.1 List Box Combobox LIST Principles.pdf
|
141.2 KB
|
|
29. ListBox Basics using Dynamic Range.mp4
|
16.1 MB
|
|
29. ListBox Basics using Dynamic Range.vtt
|
9.4 KB
|
|
3. Keydown Event.mp4
|
6.4 MB
|
|
3. Keydown Event.vtt
|
4.8 KB
|
|
3.1 Key Code Constants Used With Key Down Events.pdf
|
111.6 KB
|
|
30. Listbox Click event and Dynamic Options.mp4
|
7.5 MB
|
|
30. Listbox Click event and Dynamic Options.vtt
|
4.5 KB
|
|
31. BONUS - Manipulating and Using Multiselect Items in a Listbox.mp4
|
39.9 MB
|
|
31. BONUS - Manipulating and Using Multiselect Items in a Listbox.vtt
|
6.3 KB
|
|
32. ListBox - Referencing Column 0 and 1 in a cell Dynamically!.mp4
|
11.1 MB
|
|
32. ListBox - Referencing Column 0 and 1 in a cell Dynamically!.vtt
|
3.9 KB
|
|
32.1 Additional List Index And List Info.pdf
|
98.1 KB
|
|
33. Dynamic ListBoxes Using .ADDITEM and More.mp4
|
20.8 MB
|
|
33. Dynamic ListBoxes Using .ADDITEM and More.vtt
|
11.4 KB
|
|
34. Make and Utilize INVISIBLE Columns - Special Trick!.mp4
|
6.8 MB
|
|
34. Make and Utilize INVISIBLE Columns - Special Trick!.vtt
|
4.5 KB
|
|
35. Using a Scroll Bar on a worksheet.mp4
|
5.0 MB
|
|
35. Using a Scroll Bar on a worksheet.vtt
|
4.4 KB
|
|
36. Pictures on a Worksheet, plus using FollowHyperlink Method.mp4
|
14.6 MB
|
|
36. Pictures on a Worksheet, plus using FollowHyperlink Method.vtt
|
6.9 KB
|
|
37. Toggle Button.mp4
|
4.8 MB
|
|
37. Toggle Button.vtt
|
3.1 KB
|
|
38. A Brief Note on Alternate, 3rd Party Controls.mp4
|
3.0 MB
|
|
38. A Brief Note on Alternate, 3rd Party Controls.vtt
|
1.9 KB
|
|
4. BONUS Capturing Shift, Alt, Ctrl or some combination using the Shift variable.mp4
|
7.1 MB
|
|
4. BONUS Capturing Shift, Alt, Ctrl or some combination using the Shift variable.vtt
|
4.6 KB
|
|
4.1 KeyDown, KeyUp Events.html
|
0.1 KB
|
|
5. KeyPress Event.mp4
|
7.0 MB
|
|
5. KeyPress Event.vtt
|
3.4 KB
|
|
5.1 Ascii Table.xls
|
59.9 KB
|
|
6. MouseMove Event.mp4
|
3.6 MB
|
|
6. MouseMove Event.vtt
|
2.8 KB
|
|
7. MouseMove Event with Application.Statusbar - fun and useful.mp4
|
6.7 MB
|
|
7. MouseMove Event with Application.Statusbar - fun and useful.vtt
|
4.8 KB
|
|
8. MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl.mp4
|
12.0 MB
|
|
8. MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl.vtt
|
7.9 KB
|
|
8.1 Mouse Down Event [ Excel VBA Language Reference ].pdf
|
152.0 KB
|
|
9. GotFocus and LostFocus Events.mp4
|
2.4 MB
|
|
9. GotFocus and LostFocus Events.vtt
|
1.5 KB
|
|
/11. Userforms - the best thing. EVER/
|
|
1. Userform - Hide, Show and Unload.mp4
|
9.6 MB
|
|
1. Userform - Hide, Show and Unload.vtt
|
7.0 KB
|
|
10. Edit Mode for Employee Database - Part 2.mp4
|
26.3 MB
|
|
10. Edit Mode for Employee Database - Part 2.vtt
|
8.8 KB
|
|
11. Edit Mode Pt 3 - Adding Automation and Save Button.mp4
|
46.1 MB
|
|
11. Edit Mode Pt 3 - Adding Automation and Save Button.vtt
|
17.0 KB
|
|
12. BONUS - Refreshing the RowSource After Updating Data!.mp4
|
8.8 MB
|
|
12. BONUS - Refreshing the RowSource After Updating Data!.vtt
|
4.6 KB
|
|
13. BONUS - Combobox by Last Name Instead of EmpID.mp4
|
122.5 MB
|
|
13. BONUS - Combobox by Last Name Instead of EmpID.vtt
|
12.4 KB
|
|
14. BONUS - Search Name and ID.mp4
|
199.0 MB
|
|
14. BONUS - Search Name and ID.vtt
|
20.2 KB
|
|
15. Userform Report with Filters - Part 1.mp4
|
27.7 MB
|
|
15. Userform Report with Filters - Part 1.vtt
|
11.8 KB
|
|
16. Userform Report with Filters - Part 2.mp4
|
62.6 MB
|
|
16. Userform Report with Filters - Part 2.vtt
|
6.0 KB
|
|
17. Applying the Dynamic Filters to Reports.mp4
|
8.9 MB
|
|
17. Applying the Dynamic Filters to Reports.vtt
|
3.1 KB
|
|
18. Clear out Last Report.mp4
|
31.0 MB
|
|
18. Clear out Last Report.vtt
|
3.0 KB
|
|
19. Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc..mp4
|
11.2 MB
|
|
19. Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc..vtt
|
7.9 KB
|
|
2. Sample Database and Creating a Data Entry Form.mp4
|
36.2 MB
|
|
2. Sample Database and Creating a Data Entry Form.vtt
|
7.1 KB
|
|
20. Advanced Exercise - Review of Objectives.mp4
|
16.4 MB
|
|
20. Advanced Exercise - Review of Objectives.vtt
|
8.9 KB
|
|
20.1 Events Exercise1 - Finished Version w Source Code.xlsm.xlsm
|
24.3 KB
|
|
20.2 Events Exercise1 - Practice Version.xlsm.xlsm
|
19.4 KB
|
|
21. Advanced Exercise 01 - Solution.mp4
|
19.7 MB
|
|
21. Advanced Exercise 01 - Solution.vtt
|
9.7 KB
|
|
21.1 Advanced Exercise 01 - Practice.xlsm.xlsm
|
19.4 KB
|
|
21.2 Advanced Exercise 01 - Solution.xlsm.xlsm
|
22.0 KB
|
|
22. Advanced Exercise 02 - Solution.mp4
|
10.3 MB
|
|
22. Advanced Exercise 02 - Solution.vtt
|
4.5 KB
|
|
22.1 Advanced Exercise 02 - Practice.xlsm.xlsm
|
22.0 KB
|
|
22.2 Advanced Exercise 02 - Solution.xlsm.xlsm
|
22.2 KB
|
|
23. Advanced Exercise 03 and 04 - Solutions.mp4
|
14.1 MB
|
|
23. Advanced Exercise 03 and 04 - Solutions.vtt
|
9.4 KB
|
|
23.1 Advanced Exercise 03 and 04 - Practice.xlsm.xlsm
|
22.2 KB
|
|
23.2 Advanced Exercise 03 and 04 - Solution.xlsm.xlsm
|
24.5 KB
|
|
24. Advanced Exercise BONUS A and B - Solutions.mp4
|
6.6 MB
|
|
24. Advanced Exercise BONUS A and B - Solutions.vtt
|
4.7 KB
|
|
24.1 Advanced Exercise BONUS A and B - Solutions.xlsm.xlsm
|
24.5 KB
|
|
24.2 Advanced Exercise BONUS A and B - Practice.xlsm.xlsm
|
24.5 KB
|
|
25. Advanced Exercise BONUS C Automate the Workflow for Efficiency - Solutions.mp4
|
7.8 MB
|
|
25. Advanced Exercise BONUS C Automate the Workflow for Efficiency - Solutions.vtt
|
3.9 KB
|
|
25.1 Advanced Exercise BONUS C Automate Workflow for Efficiency - Practice.xlsm.xlsm
|
24.5 KB
|
|
25.2 Advanced Exercise BONUS C Automate Workflow for Efficiency - Solutions.xlsm.xlsm
|
24.2 KB
|
|
26. Concluding Thoughts. . ..mp4
|
3.5 MB
|
|
26. Concluding Thoughts. . ..vtt
|
3.4 KB
|
|
3. Fill Status combobox with Rowsource when Userform starts - 2 methods.mp4
|
9.9 MB
|
|
3. Fill Status combobox with Rowsource when Userform starts - 2 methods.vtt
|
4.6 KB
|
|
4. New Employee Data Entry Form!.mp4
|
146.2 MB
|
|
4. New Employee Data Entry Form!.vtt
|
142.4 MB
|
|
5. Format Textbox Numbers as Numerals, Clearing out Form upon Submission.mp4
|
9.1 MB
|
|
5. Format Textbox Numbers as Numerals, Clearing out Form upon Submission.vtt
|
3.7 KB
|
|
6. Set the Tab Order for Userform Controls.mp4
|
5.8 MB
|
|
6. Set the Tab Order for Userform Controls.vtt
|
2.6 KB
|
|
7. Set Default Values to Make Data Entry Easier.mp4
|
5.7 MB
|
|
7. Set Default Values to Make Data Entry Easier.vtt
|
2.9 KB
|
|
8. Avoid Duplicate Employee ID and other Fun Automation Tricks.mp4
|
124.6 MB
|
|
8. Avoid Duplicate Employee ID and other Fun Automation Tricks.vtt
|
14.4 KB
|
|
9. Edit Mode for Employee Database - Part 1.mp4
|
39.1 MB
|
|
9. Edit Mode for Employee Database - Part 1.vtt
|
12.7 KB
|
|
/12. BONUS Section - VBA Functions/
|
|
1. InStr Function - Search for Text Within Other Text.mp4
|
15.5 MB
|
|
1. InStr Function - Search for Text Within Other Text.vtt
|
9.2 KB
|
|
2. The EVALUATE Function - Mac-Daddy of all functions.mp4
|
14.1 MB
|
|
2. The EVALUATE Function - Mac-Daddy of all functions.vtt
|
7.5 KB
|
|
3. Sum Function in Excel VBA - EASY!.mp4
|
8.1 MB
|
|
3. Sum Function in Excel VBA - EASY!.vtt
|
4.2 KB
|
|
4. Count Function in VBA.mp4
|
5.0 MB
|
|
4. Count Function in VBA.vtt
|
3.3 KB
|
|
5. BONUS LECTURE.html
|
0.1 KB
|
|
5.1 bonus-lecture.pdf.pdf
|
848.4 KB
|
|
/2. Range Properties/
|
|
1. .VALUE Property.mp4
|
13.7 MB
|
|
1. .VALUE Property.vtt
|
2.1 KB
|
|
10. .NUMBERFORMAT Property.mp4
|
18.0 MB
|
|
10. .NUMBERFORMAT Property.vtt
|
2.6 KB
|
|
11. FONT.BOLD, UNDERLINE or ITALIC Properties.mp4
|
23.0 MB
|
|
11. FONT.BOLD, UNDERLINE or ITALIC Properties.vtt
|
2.9 KB
|
|
12. Exercise 02b - Question.mp4
|
572.5 KB
|
|
12. Exercise 02b - Question.vtt
|
0.3 KB
|
|
12.1 Exercise 02b - Question.xlsm.xlsm
|
78.4 KB
|
|
13. Exercise 02b - Answer.mp4
|
16.9 MB
|
|
13. Exercise 02b - Answer.vtt
|
7.7 KB
|
|
13.1 Exercise 02b - Answer.xlsm.xlsm
|
81.1 KB
|
|
14. Properties Quiz.html
|
0.1 KB
|
|
2. .TEXT Property.mp4
|
7.0 MB
|
|
2. .TEXT Property.vtt
|
1.1 KB
|
|
3. .ROW and .COLUMN Properties.mp4
|
8.4 MB
|
|
3. .ROW and .COLUMN Properties.vtt
|
1.1 KB
|
|
4. .SELECT Property.mp4
|
6.6 MB
|
|
4. .SELECT Property.vtt
|
1.1 KB
|
|
5. .COUNT Property.mp4
|
14.4 MB
|
|
5. .COUNT Property.vtt
|
2.1 KB
|
|
6. Exercise 02a - Question.mp4
|
572.5 KB
|
|
6. Exercise 02a - Question.vtt
|
0.3 KB
|
|
6.1 Exercise 02a - Question.xlsm.xlsm
|
41.7 KB
|
|
7. Exercise 02a - Answer.mp4
|
12.1 MB
|
|
7. Exercise 02a - Answer.vtt
|
4.7 KB
|
|
7.1 Exercise 02a - Answer.xlsm.xlsm
|
44.1 KB
|
|
8. .ADDRESS Property.mp4
|
16.4 MB
|
|
8. .ADDRESS Property.vtt
|
2.0 KB
|
|
9. .FORMULA Property.mp4
|
32.4 MB
|
|
9. .FORMULA Property.vtt
|
4.4 KB
|
|
/3. The Cells Object/
|
|
1. The Cells Object.mp4
|
18.3 MB
|
|
1. The Cells Object.vtt
|
2.6 KB
|
|
2. Using Column Letters instead of Numbers.mp4
|
8.8 MB
|
|
2. Using Column Letters instead of Numbers.vtt
|
1.0 KB
|
|
3. Using Cells Positionally within a Range.mp4
|
16.0 MB
|
|
3. Using Cells Positionally within a Range.vtt
|
2.6 KB
|
|
4. Affecting ALL Cells in a Worksheet.mp4
|
19.7 MB
|
|
4. Affecting ALL Cells in a Worksheet.vtt
|
2.5 KB
|
|
5. Exercise 03 - Question.mp4
|
572.5 KB
|
|
5. Exercise 03 - Question.vtt
|
0.3 KB
|
|
5.1 Exercise 03 - Question.xlsm.xlsm
|
14.7 KB
|
|
6. Exercise 03 - Answer.mp4
|
11.6 MB
|
|
6. Exercise 03 - Answer.vtt
|
4.6 KB
|
|
6.1 Exercise 03 - Answer.xlsm.xlsm
|
14.0 KB
|
|
7. Using Range Object with Cells Object.mp4
|
28.1 MB
|
|
7. Using Range Object with Cells Object.vtt
|
3.4 KB
|
|
8. Cells Quiz.html
|
0.1 KB
|
|
/4. Variables/
|
|
1. Intro to Variables.mp4
|
14.2 MB
|
|
1. Intro to Variables.vtt
|
2.7 KB
|
|
1.1 How To Use Variables In Excel Sub Procedures In Visual Basic For Applications.pdf
|
169.0 KB
|
|
10. Using Constants.mp4
|
17.4 MB
|
|
10. Using Constants.vtt
|
2.1 KB
|
|
11. BONUS! Passing Variables to Another Procedure - ByVal and ByRef.mp4
|
15.3 MB
|
|
11. BONUS! Passing Variables to Another Procedure - ByVal and ByRef.vtt
|
9.1 KB
|
|
11.1 Passing Variables ByRef and ByVal.xlsm.xlsm
|
13.6 KB
|
|
12. Variables Quiz.html
|
0.1 KB
|
|
2. Declaring Variables - Variable Types.mp4
|
22.3 MB
|
|
2. Declaring Variables - Variable Types.vtt
|
3.3 KB
|
|
3. Declaring Variables - Types Demo.mp4
|
28.8 MB
|
|
3. Declaring Variables - Types Demo.vtt
|
27.8 MB
|
|
4. Concatenation - Joining Two Or More Strings!.mp4
|
8.8 MB
|
|
4. Concatenation - Joining Two Or More Strings!.vtt
|
2.8 KB
|
|
5. BONUS - Date Math Fun!.mp4
|
17.2 MB
|
|
5. BONUS - Date Math Fun!.vtt
|
4.4 KB
|
|
6. Exercise 04 - Question.mp4
|
572.5 KB
|
|
6. Exercise 04 - Question.vtt
|
0.3 KB
|
|
6.1 Exercise 04 - Question.xlsm.xlsm
|
20.5 KB
|
|
7. Exercise 04 - Answer.mp4
|
8.5 MB
|
|
7. Exercise 04 - Answer.vtt
|
4.6 KB
|
|
7.1 Exercise 04 - Answer.xlsm.xlsm
|
21.1 KB
|
|
8. Calling a Procedure from Another.mp4
|
10.4 MB
|
|
8. Calling a Procedure from Another.vtt
|
2.3 KB
|
|
9. Public and Private Variables.mp4
|
25.4 MB
|
|
9. Public and Private Variables.vtt
|
3.6 KB
|
|
/5. Toolbars and Menus/
|
|
1. File Menu walkthrough.mp4
|
17.9 MB
|
|
1. File Menu walkthrough.vtt
|
2.4 KB
|
|
2. Edit Menu walkthrough.mp4
|
45.8 MB
|
|
2. Edit Menu walkthrough.vtt
|
6.3 KB
|
|
3. View Menu walkthrough.mp4
|
23.0 MB
|
|
3. View Menu walkthrough.vtt
|
2.8 KB
|
|
4. View Menu2 - Watch Window, Locals Window and Immediate Window.mp4
|
66.1 MB
|
|
4. View Menu2 - Watch Window, Locals Window and Immediate Window.vtt
|
9.4 KB
|
|
5. Watch Window Wonders!.mp4
|
34.9 MB
|
|
5. Watch Window Wonders!.vtt
|
3.9 KB
|
|
6. Insert and Format Menus.mp4
|
5.5 MB
|
|
6. Insert and Format Menus.vtt
|
0.8 KB
|
|
7. Debug Menu (Important!).mp4
|
43.7 MB
|
|
7. Debug Menu (Important!).vtt
|
6.2 KB
|
|
8. Run and Tools Menus.mp4
|
24.0 MB
|
|
8. Run and Tools Menus.vtt
|
2.8 KB
|
|
9. Toolbars Quiz.html
|
0.1 KB
|
|
/6. Super Important Tools and Excel Logic/
|
|
1. Determining the Last Row in your Data Set.mp4
|
27.1 MB
|
|
1. Determining the Last Row in your Data Set.vtt
|
4.0 KB
|
|
10. Using Is Not Equal To ().mp4
|
4.7 MB
|
|
10. Using Is Not Equal To ().vtt
|
0.7 KB
|
|
11. Logical Operator, NOT.mp4
|
7.6 MB
|
|
11. Logical Operator, NOT.vtt
|
1.0 KB
|
|
12. Exercise 06a - Question.mp4
|
572.5 KB
|
|
12. Exercise 06a - Question.vtt
|
0.3 KB
|
|
12.1 Exercise 06a - Question.xlsm.xlsm
|
71.1 KB
|
|
13. Exercise 06a - Answer.mp4
|
10.8 MB
|
|
13. Exercise 06a - Answer.vtt
|
5.5 KB
|
|
13.1 Exercise 06a - Answer.xlsm.xlsm
|
71.3 KB
|
|
14. If, Then, Else Statement.mp4
|
10.4 MB
|
|
14. If, Then, Else Statement.vtt
|
1.6 KB
|
|
15. If, Then, ElseIF Statement. . ..mp4
|
15.8 MB
|
|
15. If, Then, ElseIF Statement. . ..vtt
|
2.2 KB
|
|
16. Comparitive Operators with Text and Numbers!.mp4
|
18.6 MB
|
|
16. Comparitive Operators with Text and Numbers!.vtt
|
2.9 KB
|
|
17. Use If Then Statements in a One-Liner of code.mp4
|
11.5 MB
|
|
17. Use If Then Statements in a One-Liner of code.vtt
|
1.7 KB
|
|
18. Using GOTO and Labels.mp4
|
12.6 MB
|
|
18. Using GOTO and Labels.vtt
|
1.8 KB
|
|
19. Select Case as Alternative to IF THEN Statements.mp4
|
18.7 MB
|
|
19. Select Case as Alternative to IF THEN Statements.vtt
|
2.6 KB
|
|
2. Determining the Last Column in your Data Set.mp4
|
18.1 MB
|
|
2. Determining the Last Column in your Data Set.vtt
|
3.0 KB
|
|
20. Message Box with Yes and No Buttons.mp4
|
49.1 MB
|
|
20. Message Box with Yes and No Buttons.vtt
|
7.3 KB
|
|
21. Exercise 06b - Question.mp4
|
572.5 KB
|
|
21. Exercise 06b - Question.vtt
|
0.3 KB
|
|
21.1 Exercise 06b - Question.xlsm.xlsm
|
89.1 KB
|
|
22. Exercise 06b - Answer.mp4
|
16.6 MB
|
|
22. Exercise 06b - Answer.vtt
|
7.5 KB
|
|
22.1 Exercise 06b - Answer.xlsm.xlsm
|
94.5 KB
|
|
23. Relative Positioning using Offset.mp4
|
29.9 MB
|
|
23. Relative Positioning using Offset.vtt
|
4.8 KB
|
|
24. BONUS - User Defined Functions 101.mp4
|
7.6 MB
|
|
24. BONUS - User Defined Functions 101.vtt
|
5.6 KB
|
|
24.1 User Defined Functions.zip.zip
|
11.7 KB
|
|
25. BONUS - UDF Lesson 2.mp4
|
6.3 MB
|
|
25. BONUS - UDF Lesson 2.vtt
|
4.7 KB
|
|
26. Super Important Info Quiz.html
|
0.1 KB
|
|
3. Determining the Next Row in your Data Set.mp4
|
12.4 MB
|
|
3. Determining the Next Row in your Data Set.vtt
|
1.5 KB
|
|
4. Recording a Macro.mp4
|
7.6 MB
|
|
4. Recording a Macro.vtt
|
5.4 KB
|
|
5. BONUS! - Dynamic Sorting!.mp4
|
59.0 MB
|
|
5. BONUS! - Dynamic Sorting!.vtt
|
6.5 KB
|
|
5.1 06 BONUS Dynamic Sorting.zip
|
32.2 KB
|
|
6. Absolute vs Relative References.mp4
|
8.3 MB
|
|
6. Absolute vs Relative References.vtt
|
5.9 KB
|
|
7. Using With and End With.mp4
|
28.5 MB
|
|
7. Using With and End With.vtt
|
3.6 KB
|
|
8. Comparison Operators in Excel VBA.mp4
|
8.9 MB
|
|
8. Comparison Operators in Excel VBA.vtt
|
1.4 KB
|
|
8.1 Comparison Operators In Excel VBA.pdf
|
174.5 KB
|
|
9. If Then Statement.mp4
|
20.1 MB
|
|
9. If Then Statement.vtt
|
2.9 KB
|
|
/7. Loops and Report Writing Basics/
|
|
1. Intro to Loops; the For Next Loop.mp4
|
20.3 MB
|
|
1. Intro to Loops; the For Next Loop.vtt
|
3.6 KB
|
|
10. Printable Report Part 3 - Clearing Last Report.mp4
|
37.0 MB
|
|
10. Printable Report Part 3 - Clearing Last Report.vtt
|
3.5 KB
|
|
11. Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.mp4
|
34.7 MB
|
|
11. Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.vtt
|
4.4 KB
|
|
12. Exercise 07a - Question.mp4
|
572.5 KB
|
|
12. Exercise 07a - Question.vtt
|
0.3 KB
|
|
12.1 Exercise 07a - Question.xlsm.xlsm
|
20.5 KB
|
|
13. Exercise 07a - Answer.mp4
|
31.1 MB
|
|
13. Exercise 07a - Answer.vtt
|
13.5 KB
|
|
13.1 Exercise 07a - Answer to BONUS Question.xlsm.xlsm
|
21.7 KB
|
|
13.2 Exercise 07a - Answer.xlsm.xlsm
|
21.0 KB
|
|
14. Using PrintPreview Automatically.mp4
|
8.1 MB
|
|
14. Using PrintPreview Automatically.vtt
|
1.1 KB
|
|
15. Using PrintOut to Send Directly to Default Printer.mp4
|
20.2 MB
|
|
15. Using PrintOut to Send Directly to Default Printer.vtt
|
2.5 KB
|
|
16. Handling Debug Error When Cancelling InputBox.mp4
|
25.0 MB
|
|
16. Handling Debug Error When Cancelling InputBox.vtt
|
2.6 KB
|
|
17. For Loop Going Backwards using STEP.mp4
|
28.2 MB
|
|
17. For Loop Going Backwards using STEP.vtt
|
3.0 KB
|
|
18. The FOR EACH Loop.mp4
|
42.8 MB
|
|
18. The FOR EACH Loop.vtt
|
5.9 KB
|
|
19. FOR EACH Loop - Practical Examples.mp4
|
27.6 MB
|
|
19. FOR EACH Loop - Practical Examples.vtt
|
3.5 KB
|
|
2. Fun with our For Next Loop.mp4
|
34.1 MB
|
|
2. Fun with our For Next Loop.vtt
|
4.5 KB
|
|
20. Exercise 07b - Question.mp4
|
572.5 KB
|
|
20. Exercise 07b - Question.vtt
|
0.3 KB
|
|
20.1 Exercise 07b - Question.xlsm.xlsm
|
41.4 KB
|
|
21. Exercise 07b - Answer.mp4
|
20.6 MB
|
|
21. Exercise 07b - Answer.vtt
|
8.4 KB
|
|
21.1 Exercise 07b - Answer.xlsm.xlsm
|
45.0 KB
|
|
22. Intro to DO LOOPS.mp4
|
32.1 MB
|
|
22. Intro to DO LOOPS.vtt
|
4.0 KB
|
|
23. DO Until.mp4
|
14.4 MB
|
|
23. DO Until.vtt
|
2.1 KB
|
|
24. Loop Until.mp4
|
9.9 MB
|
|
24. Loop Until.vtt
|
1.7 KB
|
|
25. DO While.mp4
|
10.2 MB
|
|
25. DO While.vtt
|
1.8 KB
|
|
26. Loop While.mp4
|
6.1 MB
|
|
26. Loop While.vtt
|
1.1 KB
|
|
27. EXIT DO - Multiple Exits using your own Criteria along the Way!.mp4
|
11.0 MB
|
|
27. EXIT DO - Multiple Exits using your own Criteria along the Way!.vtt
|
2.0 KB
|
|
28. BONUS - Loop Through Multiple Files in a Folder and Scrape Data From Each.mp4
|
27.1 MB
|
|
28. BONUS - Loop Through Multiple Files in a Folder and Scrape Data From Each.vtt
|
14.0 KB
|
|
28.1 Temp.zip.zip
|
38.5 KB
|
|
29. Loops and Reports Quiz.html
|
0.1 KB
|
|
3. Beginning our first Report using Loops.mp4
|
42.6 MB
|
|
3. Beginning our first Report using Loops.vtt
|
6.4 KB
|
|
4. Using an InputBox.mp4
|
20.3 MB
|
|
4. Using an InputBox.vtt
|
3.5 KB
|
|
5. Adding InputBox to Our First Report to make it Dynamic.mp4
|
21.7 MB
|
|
5. Adding InputBox to Our First Report to make it Dynamic.vtt
|
3.9 KB
|
|
6. Add a Button to Open Our Report.mp4
|
25.1 MB
|
|
6. Add a Button to Open Our Report.vtt
|
3.1 KB
|
|
7. Add a Cool Looking Button or Image to Open Report.mp4
|
23.0 MB
|
|
7. Add a Cool Looking Button or Image to Open Report.vtt
|
3.0 KB
|
|
8. Our First Printable Report part 1 - Declaring and Setting the Sheets.mp4
|
40.8 MB
|
|
8. Our First Printable Report part 1 - Declaring and Setting the Sheets.vtt
|
5.6 KB
|
|
9. Printable Report Part 2 - Getting Items On Report Sheet.mp4
|
55.8 MB
|
|
9. Printable Report Part 2 - Getting Items On Report Sheet.vtt
|
8.1 KB
|
|
/8. EVENTS Worksheet Events made Easy/
|
|
1. Intro to Worksheet Events and Selection_Change.mp4
|
31.0 MB
|
|
1. Intro to Worksheet Events and Selection_Change.vtt
|
4.4 KB
|
|
10. How to Disable Events on the Workbook.mp4
|
11.7 MB
|
|
10. How to Disable Events on the Workbook.vtt
|
1.7 KB
|
|
11. Intro to Change Event.mp4
|
9.5 MB
|
|
11. Intro to Change Event.vtt
|
1.6 KB
|
|
12. Change Event with EnableEvents toggle - Avoid endless loop!.mp4
|
38.8 MB
|
|
12. Change Event with EnableEvents toggle - Avoid endless loop!.vtt
|
5.3 KB
|
|
13. Change Event Triggered with Custom Range Using Intersect.mp4
|
27.4 MB
|
|
13. Change Event Triggered with Custom Range Using Intersect.vtt
|
3.2 KB
|
|
14. FollowHyperlinks Event.mp4
|
24.4 MB
|
|
14. FollowHyperlinks Event.vtt
|
3.1 KB
|
|
15. Final Thoughts on Worksheet Events and Review Other Events.mp4
|
23.2 MB
|
|
15. Final Thoughts on Worksheet Events and Review Other Events.vtt
|
2.8 KB
|
|
16. Exercise 08b - Question.mp4
|
572.5 KB
|
|
16. Exercise 08b - Question.vtt
|
0.3 KB
|
|
16.1 Exercise 08b - Question.xlsm.xlsm
|
17.0 KB
|
|
17. Exercise 08b - Answer.mp4
|
12.4 MB
|
|
17. Exercise 08b - Answer.vtt
|
6.4 KB
|
|
17.1 Exercise 08b - Answer.xlsm.xlsm
|
18.4 KB
|
|
18. Worksheet Events Quiz.html
|
0.1 KB
|
|
2. Worksheet Activate Event.mp4
|
9.8 MB
|
|
2. Worksheet Activate Event.vtt
|
1.6 KB
|
|
3. Worksheet Deactivate Event.mp4
|
20.4 MB
|
|
3. Worksheet Deactivate Event.vtt
|
3.2 KB
|
|
4. BeforeDelete Event - for Worksheet Deletion.mp4
|
9.4 MB
|
|
4. BeforeDelete Event - for Worksheet Deletion.vtt
|
1.2 KB
|
|
5. BeforeDoubleClick Event - Trigger a Macro when Double Clicking.mp4
|
21.4 MB
|
|
5. BeforeDoubleClick Event - Trigger a Macro when Double Clicking.vtt
|
3.5 KB
|
|
6. BeforeRightClick Event - Trigger a Macro when Right-Clicking.mp4
|
11.0 MB
|
|
6. BeforeRightClick Event - Trigger a Macro when Right-Clicking.vtt
|
2.4 KB
|
|
7. Calculate Event.mp4
|
22.4 MB
|
|
7. Calculate Event.vtt
|
3.1 KB
|
|
8. Exercise 08a - Question.mp4
|
572.5 KB
|
|
8. Exercise 08a - Question.vtt
|
0.3 KB
|
|
8.1 Exercise 08a - Question.xlsm.xlsm
|
16.0 KB
|
|
9. Exercise 08a - Answer.mp4
|
7.0 MB
|
|
9. Exercise 08a - Answer.vtt
|
2.6 KB
|
|
9.1 Exercise 08a - Answer.xlsm.xlsm
|
17.5 KB
|
|
/9. WorkBook Events/
|
|
1. Workbook Open.mp4
|
40.5 MB
|
|
1. Workbook Open.vtt
|
6.1 KB
|
|
10. Exercise 09 - Question.mp4
|
572.5 KB
|
|
10. Exercise 09 - Question.vtt
|
0.3 KB
|
|
10.1 Exercise 09 - Question.xlsm.xlsm
|
21.5 KB
|
|
11. Exercise 09 - Answer.mp4
|
12.5 MB
|
|
11. Exercise 09 - Answer.vtt
|
5.7 KB
|
|
11.1 Exercise 09 - Answer.xlsm.xlsm
|
27.4 KB
|
|
12. Sheet Activate.mp4
|
7.2 MB
|
|
12. Sheet Activate.vtt
|
2.9 KB
|
|
13. Delete, DoubleClick, RightClick, Calculate, Change.mp4
|
13.0 MB
|
|
13. Delete, DoubleClick, RightClick, Calculate, Change.vtt
|
6.2 KB
|
|
14. SheetDeactivate.mp4
|
7.4 MB
|
|
14. SheetDeactivate.vtt
|
3.3 KB
|
|
15. Follow Hyperlink.mp4
|
3.7 MB
|
|
15. Follow Hyperlink.vtt
|
0.9 KB
|
|
16. SheetSelectionChange.mp4
|
4.6 MB
|
|
16. SheetSelectionChange.vtt
|
0.8 KB
|
|
17. WindowActivate.mp4
|
3.6 MB
|
|
17. WindowActivate.vtt
|
1.2 KB
|
|
18. WindowDeactivate.mp4
|
2.5 MB
|
|
18. WindowDeactivate.vtt
|
0.6 KB
|
|
19. WindowResize.mp4
|
7.6 MB
|
|
19. WindowResize.vtt
|
2.5 KB
|
|
2. Workbook Activate.mp4
|
4.9 MB
|
|
2. Workbook Activate.vtt
|
2.8 KB
|
|
3. Before Save.mp4
|
5.4 MB
|
|
3. Before Save.vtt
|
3.0 KB
|
|
4. After Save.mp4
|
7.8 MB
|
|
4. After Save.vtt
|
2.5 KB
|
|
5. Before Close.mp4
|
10.3 MB
|
|
5. Before Close.vtt
|
3.9 KB
|
|
6. Before Print.mp4
|
3.7 MB
|
|
6. Before Print.vtt
|
1.8 KB
|
|
7. Deactivate.mp4
|
3.5 MB
|
|
7. Deactivate.vtt
|
1.5 KB
|
|
8. NewChart.mp4
|
9.7 MB
|
|
8. NewChart.vtt
|
4.1 KB
|
|
9. NewSheet.mp4
|
4.5 MB
|
|
9. NewSheet.vtt
|
2.0 KB
|
|
/
|
|
[Tutorialsplanet.NET].url
|
0.1 KB
|
|
Total files 485
|
