种子简介

种子名称： [Tutorialsplanet.NET] Udemy - The Ultimate Excel Programmer Course
文件类型： 视频
文件数目： 211个文件
文件大小： 3.58 GB
收录时间： 2019-9-2 13:26
已经下载： 3次
资源热度： 128
最近下载： 2024-6-10 17:26

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:d419dff50641ee8f3073ae102d3a46d9d92807f7&dn=[Tutorialsplanet.NET] Udemy - The Ultimate Excel Programmer Course 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[Tutorialsplanet.NET] Udemy - The Ultimate Excel Programmer Course.torrent

1. The Range Object/1. Intro and Course Workbooks download.mp474.3MB

1. The Range Object/10. Exercise 01 - Question.mp4559.04KB

1. The Range Object/11. Exercise 01 - Answer.mp48.18MB

1. The Range Object/12. Several Ways to trigger your Macro.mp410.21MB

1. The Range Object/13. Affecting Multiple Cells with One Range Command - 2 Methods.mp412.09MB

1. The Range Object/14. Adding Strings of Text to a Cell.mp411.54MB

1. The Range Object/15. Using a Named Range with the Range Object.mp49.95MB

1. The Range Object/2. Get the Developer Tab and Intro to Developer Tab.mp411.73MB

1. The Range Object/3. Getting started with Range object.mp47.89MB

1. The Range Object/4. Quick Tip - Project Explorer and Properties Window!.mp47.33MB

1. The Range Object/5. Creating Your First Macro From Scratch.mp417.31MB

1. The Range Object/6. Adding a Secondary Command. . ..mp46.18MB

1. The Range Object/7. Debugging in Excel VBA.mp410.59MB

1. The Range Object/8. Saving a Macro-Enabled Workbook (.xlsm).mp49.07MB

1. The Range Object/9. Before You Begin The Exercises....mp48.89MB

10. Activex Controls on Worksheets/1. Activex Controls vs Forms Controls.mp45.84MB

10. Activex Controls on Worksheets/10. Use a Checkbox for its VALUE.mp44.55MB

10. Activex Controls on Worksheets/11. Checkbox Event Without a Button.mp42.85MB

10. Activex Controls on Worksheets/12. LinkedCell Property with a Checkbox.mp42.29MB

10. Activex Controls on Worksheets/13. Option Buttons Intro - What is an Option Button and Grouping.mp44.53MB

10. Activex Controls on Worksheets/14. Grouping, Alignment and Aesthetics for Controls.mp44.52MB

10. Activex Controls on Worksheets/15. Homemade Quiz using Option Buttons and a Command Button.mp47.02MB

10. Activex Controls on Worksheets/16. Compliance Checker for your Forms or Quizzes Part 1.mp46.55MB

10. Activex Controls on Worksheets/17. Compliance check part 2.mp420.01MB

10. Activex Controls on Worksheets/18. SpinButton with Cell A1.mp46.67MB

10. Activex Controls on Worksheets/19. SpinButtons with Textboxes and Numbers.mp49.95MB

10. Activex Controls on Worksheets/2. Button Click - Wage Calculator.mp46.6MB

10. Activex Controls on Worksheets/20. SpinButton BONUS - Move Textbox Position with SpinButton.mp48.75MB

10. Activex Controls on Worksheets/21. SpinButton with Dates in a Textbox.mp46.86MB

10. Activex Controls on Worksheets/22. Activex Label Control - Basics.mp46.8MB

10. Activex Controls on Worksheets/23. ComboBox - Fill with ListFillRange.mp47.74MB

10. Activex Controls on Worksheets/24. Creating a Dynamic Range.mp48.64MB

10. Activex Controls on Worksheets/25. ComboBox - How to use Multiple Columns.mp46.26MB

10. Activex Controls on Worksheets/26. Using .ADDITEM to Get Specific items in your Combobox List.mp417.74MB

10. Activex Controls on Worksheets/27. Noteworthy Properties of a Combobox.mp412.01MB

10. Activex Controls on Worksheets/28. Multiple Columns in Combobox with .ADDITEM and List, ListCount etc.mp416.22MB

10. Activex Controls on Worksheets/29. ListBox Basics using Dynamic Range.mp415.38MB

10. Activex Controls on Worksheets/3. Keydown Event.mp46.09MB

10. Activex Controls on Worksheets/30. Listbox Click event and Dynamic Options.mp47.12MB

10. Activex Controls on Worksheets/31. BONUS - Manipulating and Using Multiselect Items in a Listbox.mp438.06MB

10. Activex Controls on Worksheets/32. ListBox - Referencing Column 0 and 1 in a cell Dynamically!.mp410.61MB

10. Activex Controls on Worksheets/33. Dynamic ListBoxes Using .ADDITEM and More.mp419.81MB

10. Activex Controls on Worksheets/34. Make and Utilize INVISIBLE Columns - Special Trick!.mp46.48MB

10. Activex Controls on Worksheets/35. Using a Scroll Bar on a worksheet.mp44.73MB

10. Activex Controls on Worksheets/36. Pictures on a Worksheet, plus using FollowHyperlink Method.mp413.92MB

10. Activex Controls on Worksheets/37. Toggle Button.mp44.57MB

10. Activex Controls on Worksheets/38. A Brief Note on Alternate, 3rd Party Controls.mp42.91MB

10. Activex Controls on Worksheets/4. BONUS Capturing Shift, Alt, Ctrl or some combination using the Shift variable.mp46.78MB

10. Activex Controls on Worksheets/5. KeyPress Event.mp46.68MB

10. Activex Controls on Worksheets/6. MouseMove Event.mp43.4MB

10. Activex Controls on Worksheets/7. MouseMove Event with Application.Statusbar - fun and useful.mp46.42MB

10. Activex Controls on Worksheets/8. MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl.mp411.41MB

10. Activex Controls on Worksheets/9. GotFocus and LostFocus Events.mp42.28MB

11. Userforms - the best thing. EVER/1. Userform - Hide, Show and Unload.mp49.14MB

11. Userforms - the best thing. EVER/10. Edit Mode for Employee Database - Part 2.mp425.05MB

11. Userforms - the best thing. EVER/11. Edit Mode Pt 3 - Adding Automation and Save Button.mp443.95MB

11. Userforms - the best thing. EVER/12. BONUS - Refreshing the RowSource After Updating Data!.mp48.38MB

11. Userforms - the best thing. EVER/13. BONUS - Combobox by Last Name Instead of EmpID.mp4116.8MB

11. Userforms - the best thing. EVER/14. BONUS - Search Name and ID.mp4189.82MB

11. Userforms - the best thing. EVER/15. Userform Report with Filters - Part 1.mp426.38MB

11. Userforms - the best thing. EVER/16. Userform Report with Filters - Part 2.mp459.71MB

11. Userforms - the best thing. EVER/17. Applying the Dynamic Filters to Reports.mp48.47MB

11. Userforms - the best thing. EVER/18. Clear out Last Report.mp429.59MB

11. Userforms - the best thing. EVER/19. Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc..mp410.65MB

11. Userforms - the best thing. EVER/2. Sample Database and Creating a Data Entry Form.mp434.48MB

11. Userforms - the best thing. EVER/20. Advanced Exercise - Review of Objectives.mp415.62MB

11. Userforms - the best thing. EVER/21. Advanced Exercise 01 - Solution.mp418.79MB

11. Userforms - the best thing. EVER/22. Advanced Exercise 02 - Solution.mp49.86MB

11. Userforms - the best thing. EVER/23. Advanced Exercise 03 and 04 - Solutions.mp413.49MB

11. Userforms - the best thing. EVER/24. Advanced Exercise BONUS A and B - Solutions.mp46.31MB

11. Userforms - the best thing. EVER/25. Advanced Exercise BONUS C Automate the Workflow for Efficiency - Solutions.mp47.42MB

11. Userforms - the best thing. EVER/26. Concluding Thoughts. . ..mp43.37MB

11. Userforms - the best thing. EVER/3. Fill Status combobox with Rowsource when Userform starts - 2 methods.mp49.4MB

11. Userforms - the best thing. EVER/4. New Employee Data Entry Form!.mp4139.38MB

11. Userforms - the best thing. EVER/5. Format Textbox Numbers as Numerals, Clearing out Form upon Submission.mp48.7MB

11. Userforms - the best thing. EVER/6. Set the Tab Order for Userform Controls.mp45.52MB

11. Userforms - the best thing. EVER/7. Set Default Values to Make Data Entry Easier.mp45.48MB

11. Userforms - the best thing. EVER/8. Avoid Duplicate Employee ID and other Fun Automation Tricks.mp4118.83MB

11. Userforms - the best thing. EVER/9. Edit Mode for Employee Database - Part 1.mp437.33MB

12. BONUS Section - VBA Functions/1. InStr Function - Search for Text Within Other Text.mp414.79MB

12. BONUS Section - VBA Functions/2. The EVALUATE Function - Mac-Daddy of all functions.mp413.47MB

12. BONUS Section - VBA Functions/3. Sum Function in Excel VBA - EASY!.mp47.75MB

12. BONUS Section - VBA Functions/4. Count Function in VBA.mp44.75MB

2. Range Properties/1. .VALUE Property.mp413.09MB

2. Range Properties/10. .NUMBERFORMAT Property.mp417.16MB

2. Range Properties/11. FONT.BOLD, UNDERLINE or ITALIC Properties.mp421.93MB

2. Range Properties/12. Exercise 02b - Question.mp4559.04KB

2. Range Properties/13. Exercise 02b - Answer.mp416.15MB

2. Range Properties/2. .TEXT Property.mp46.7MB

2. Range Properties/3. .ROW and .COLUMN Properties.mp48.03MB

2. Range Properties/4. .SELECT Property.mp46.32MB

2. Range Properties/5. .COUNT Property.mp413.71MB

2. Range Properties/6. Exercise 02a - Question.mp4559.04KB

2. Range Properties/7. Exercise 02a - Answer.mp411.52MB

2. Range Properties/8. .ADDRESS Property.mp415.68MB

2. Range Properties/9. .FORMULA Property.mp430.85MB

3. The Cells Object/1. The Cells Object.mp417.49MB

3. The Cells Object/2. Using Column Letters instead of Numbers.mp48.37MB

3. The Cells Object/3. Using Cells Positionally within a Range.mp415.27MB

3. The Cells Object/4. Affecting ALL Cells in a Worksheet.mp418.8MB

3. The Cells Object/5. Exercise 03 - Question.mp4559.04KB

3. The Cells Object/6. Exercise 03 - Answer.mp411.08MB

3. The Cells Object/7. Using Range Object with Cells Object.mp426.78MB

4. Variables/1. Intro to Variables.mp413.5MB

4. Variables/10. Using Constants.mp416.63MB

4. Variables/11. BONUS! Passing Variables to Another Procedure - ByVal and ByRef.mp414.57MB

4. Variables/2. Declaring Variables - Variable Types.mp421.26MB

4. Variables/3. Declaring Variables - Types Demo.mp427.49MB

4. Variables/4. Concatenation - Joining Two Or More Strings!.mp48.35MB

4. Variables/5. BONUS - Date Math Fun!.mp416.4MB

4. Variables/6. Exercise 04 - Question.mp4559.04KB

4. Variables/7. Exercise 04 - Answer.mp48.09MB

4. Variables/8. Calling a Procedure from Another.mp49.97MB

4. Variables/9. Public and Private Variables.mp424.24MB

5. Toolbars and Menus/1. File Menu walkthrough.mp417.03MB

5. Toolbars and Menus/2. Edit Menu walkthrough.mp443.68MB

5. Toolbars and Menus/3. View Menu walkthrough.mp421.94MB

5. Toolbars and Menus/4. View Menu2 - Watch Window, Locals Window and Immediate Window.mp463.01MB

5. Toolbars and Menus/5. Watch Window Wonders!.mp433.32MB

5. Toolbars and Menus/6. Insert and Format Menus.mp45.29MB

5. Toolbars and Menus/7. Debug Menu (Important!).mp441.7MB

5. Toolbars and Menus/8. Run and Tools Menus.mp422.93MB

6. Super Important Tools and Excel Logic/1. Determining the Last Row in your Data Set.mp425.82MB

6. Super Important Tools and Excel Logic/10. Using Is Not Equal To ().mp44.5MB

6. Super Important Tools and Excel Logic/11. Logical Operator, NOT.mp47.28MB

6. Super Important Tools and Excel Logic/12. Exercise 06a - Question.mp4559.04KB

6. Super Important Tools and Excel Logic/13. Exercise 06a - Answer.mp410.32MB

6. Super Important Tools and Excel Logic/14. If, Then, Else Statement.mp49.87MB

6. Super Important Tools and Excel Logic/15. If, Then, ElseIF Statement. . ..mp415.12MB

6. Super Important Tools and Excel Logic/16. Comparitive Operators with Text and Numbers!.mp417.76MB

6. Super Important Tools and Excel Logic/17. Use If Then Statements in a One-Liner of code.mp411.01MB

6. Super Important Tools and Excel Logic/18. Using GOTO and Labels.mp412.03MB

6. Super Important Tools and Excel Logic/19. Select Case as Alternative to IF THEN Statements.mp417.87MB

6. Super Important Tools and Excel Logic/2. Determining the Last Column in your Data Set.mp417.25MB

6. Super Important Tools and Excel Logic/20. Message Box with Yes and No Buttons.mp446.83MB

6. Super Important Tools and Excel Logic/21. Exercise 06b - Question.mp4559.04KB

6. Super Important Tools and Excel Logic/22. Exercise 06b - Answer.mp415.79MB

6. Super Important Tools and Excel Logic/23. Relative Positioning using Offset.mp428.53MB

6. Super Important Tools and Excel Logic/24. BONUS - User Defined Functions 101.mp47.29MB

6. Super Important Tools and Excel Logic/25. BONUS - UDF Lesson 2.mp46.04MB

6. Super Important Tools and Excel Logic/3. Determining the Next Row in your Data Set.mp411.81MB

6. Super Important Tools and Excel Logic/4. Recording a Macro.mp47.27MB

6. Super Important Tools and Excel Logic/5. BONUS! - Dynamic Sorting!.mp456.23MB

6. Super Important Tools and Excel Logic/6. Absolute vs Relative References.mp47.9MB

6. Super Important Tools and Excel Logic/7. Using With and End With.mp427.22MB

6. Super Important Tools and Excel Logic/8. Comparison Operators in Excel VBA.mp48.49MB

6. Super Important Tools and Excel Logic/9. If Then Statement.mp419.2MB

7. Loops and Report Writing Basics/1. Intro to Loops; the For Next Loop.mp419.39MB

7. Loops and Report Writing Basics/10. Printable Report Part 3 - Clearing Last Report.mp435.29MB

7. Loops and Report Writing Basics/11. Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet.mp433.11MB

7. Loops and Report Writing Basics/12. Exercise 07a - Question.mp4559.04KB

7. Loops and Report Writing Basics/13. Exercise 07a - Answer.mp429.69MB

7. Loops and Report Writing Basics/14. Using PrintPreview Automatically.mp47.7MB

7. Loops and Report Writing Basics/15. Using PrintOut to Send Directly to Default Printer.mp419.22MB

7. Loops and Report Writing Basics/16. Handling Debug Error When Cancelling InputBox.mp423.86MB

7. Loops and Report Writing Basics/17. For Loop Going Backwards using STEP.mp426.93MB

7. Loops and Report Writing Basics/18. The FOR EACH Loop.mp440.79MB

7. Loops and Report Writing Basics/19. FOR EACH Loop - Practical Examples.mp426.36MB

7. Loops and Report Writing Basics/2. Fun with our For Next Loop.mp432.52MB

7. Loops and Report Writing Basics/20. Exercise 07b - Question.mp4559.04KB

7. Loops and Report Writing Basics/21. Exercise 07b - Answer.mp419.63MB

7. Loops and Report Writing Basics/22. Intro to DO LOOPS.mp430.6MB

7. Loops and Report Writing Basics/23. DO Until.mp413.77MB

7. Loops and Report Writing Basics/24. Loop Until.mp49.46MB

7. Loops and Report Writing Basics/25. DO While.mp49.76MB

7. Loops and Report Writing Basics/26. Loop While.mp45.84MB

7. Loops and Report Writing Basics/27. EXIT DO - Multiple Exits using your own Criteria along the Way!.mp410.54MB

7. Loops and Report Writing Basics/28. BONUS - Loop Through Multiple Files in a Folder and Scrape Data From Each.mp425.86MB

7. Loops and Report Writing Basics/3. Beginning our first Report using Loops.mp440.65MB

7. Loops and Report Writing Basics/4. Using an InputBox.mp419.39MB

7. Loops and Report Writing Basics/5. Adding InputBox to Our First Report to make it Dynamic.mp420.71MB

7. Loops and Report Writing Basics/6. Add a Button to Open Our Report.mp423.95MB

7. Loops and Report Writing Basics/7. Add a Cool Looking Button or Image to Open Report.mp421.89MB

7. Loops and Report Writing Basics/8. Our First Printable Report part 1 - Declaring and Setting the Sheets.mp438.94MB

7. Loops and Report Writing Basics/9. Printable Report Part 2 - Getting Items On Report Sheet.mp453.17MB

8. EVENTS Worksheet Events made Easy/1. Intro to Worksheet Events and Selection_Change.mp429.59MB

8. EVENTS Worksheet Events made Easy/10. How to Disable Events on the Workbook.mp411.15MB

8. EVENTS Worksheet Events made Easy/11. Intro to Change Event.mp49.07MB

8. EVENTS Worksheet Events made Easy/12. Change Event with EnableEvents toggle - Avoid endless loop!.mp437.05MB

8. EVENTS Worksheet Events made Easy/13. Change Event Triggered with Custom Range Using Intersect.mp426.12MB

8. EVENTS Worksheet Events made Easy/14. FollowHyperlinks Event.mp423.23MB

8. EVENTS Worksheet Events made Easy/15. Final Thoughts on Worksheet Events and Review Other Events.mp422.14MB

8. EVENTS Worksheet Events made Easy/16. Exercise 08b - Question.mp4559.04KB

8. EVENTS Worksheet Events made Easy/17. Exercise 08b - Answer.mp411.83MB

8. EVENTS Worksheet Events made Easy/2. Worksheet Activate Event.mp49.32MB

8. EVENTS Worksheet Events made Easy/3. Worksheet Deactivate Event.mp419.43MB

8. EVENTS Worksheet Events made Easy/4. BeforeDelete Event - for Worksheet Deletion.mp48.96MB

8. EVENTS Worksheet Events made Easy/5. BeforeDoubleClick Event - Trigger a Macro when Double Clicking.mp420.37MB

8. EVENTS Worksheet Events made Easy/6. BeforeRightClick Event - Trigger a Macro when Right-Clicking.mp410.49MB

8. EVENTS Worksheet Events made Easy/7. Calculate Event.mp421.4MB

8. EVENTS Worksheet Events made Easy/8. Exercise 08a - Question.mp4559.04KB

8. EVENTS Worksheet Events made Easy/9. Exercise 08a - Answer.mp46.72MB

9. WorkBook Events/1. Workbook Open.mp438.62MB

9. WorkBook Events/10. Exercise 09 - Question.mp4559.04KB

9. WorkBook Events/11. Exercise 09 - Answer.mp411.89MB

9. WorkBook Events/12. Sheet Activate.mp46.84MB

9. WorkBook Events/13. Delete, DoubleClick, RightClick, Calculate, Change.mp412.4MB

9. WorkBook Events/14. SheetDeactivate.mp47.03MB

9. WorkBook Events/15. Follow Hyperlink.mp43.49MB

9. WorkBook Events/16. SheetSelectionChange.mp44.37MB

9. WorkBook Events/17. WindowActivate.mp43.39MB

9. WorkBook Events/18. WindowDeactivate.mp42.36MB

9. WorkBook Events/19. WindowResize.mp47.29MB

9. WorkBook Events/2. Workbook Activate.mp44.65MB

9. WorkBook Events/3. Before Save.mp45.12MB

9. WorkBook Events/4. After Save.mp47.46MB

9. WorkBook Events/5. Before Close.mp49.82MB

9. WorkBook Events/6. Before Print.mp43.53MB

9. WorkBook Events/7. Deactivate.mp43.37MB

9. WorkBook Events/8. NewChart.mp49.23MB

9. WorkBook Events/9. NewSheet.mp44.27MB