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