zhongziso
搜索
zhongziso
首页
首页
功能
磁力转BT
BT转磁力
关于
使用教程
免责声明
磁力助手
[Tutorialsplanet.NET] Udemy - Unlock Excel VBA and Excel Macros
magnet:?xt=urn:btih:56f9a0bc089a595ad881a7da0fd7775b3548a393&dn=[Tutorialsplanet.NET] Udemy - Unlock Excel VBA and Excel Macros
磁力链接详情
文件列表详情
56f9a0bc089a595ad881a7da0fd7775b3548a393
infohash:
144
文件数量
11.67 GB
文件大小
2021-11-17 00:05
创建日期
2024-11-29 09:23
最后访问
相关分词
Tutorialsplanet
NET
Udemy
-
Unlock
Excel
VBA
and
Excel
Macros
1. Introduction & Scope/1. Course Structure & Content.mp4 60.07 MB
1. Introduction & Scope/2. Important Compatibility & Setup Information.mp4 51.39 MB
1. Introduction & Scope/3. Course Resources Download Course Project Files.mp4 30.5 MB
1. Introduction & Scope/4. Course Expectations.mp4 52.55 MB
10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.mp4 18.02 MB
10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.mp4 51.05 MB
10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.mp4 33.26 MB
10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).mp4 16.31 MB
10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).mp4 208.32 MB
10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).mp4 25.88 MB
10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.mp4 98.12 MB
10. Looping in VBA (Controlling the Flow of Code)/6. Practical Example of Do Loop (with Inputbox).mp4 6.58 MB
10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.mp4 20.32 MB
10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.mp4 14.44 MB
10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.mp4 14.65 MB
11. Working with Arrays/1. Overview Working with Arrays in VBA.mp4 6.23 MB
11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).mp4 138.83 MB
11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).mp4 13.04 MB
11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).mp4 44.66 MB
11. Working with Arrays/5. Two Dimensional Arrays.mp4 75.64 MB
11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.mp4 17.14 MB
11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.mp4 159.85 MB
12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.mp4 50.48 MB
12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.mp4 76.44 MB
12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.mp4 95.86 MB
12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.mp4 166.08 MB
12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.mp4 90.52 MB
12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.mp4 44.56 MB
12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4 224.9 MB
13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.mp4 43.36 MB
13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.mp4 165.49 MB
13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.mp4 190.37 MB
13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.mp4 226.64 MB
13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.mp4 138.49 MB
14. Main Project #2 Sales Regional Reporting Tool/1. What You'll Learn (& Should be Aware of..).mp4 41.41 MB
14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.mp4 44.35 MB
14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.mp4 159.18 MB
14. Main Project #2 Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect.mp4 208.54 MB
14. Main Project #2 Sales Regional Reporting Tool/4. Setting up a Template as the Basis for Different Reports.mp4 310.42 MB
14. Main Project #2 Sales Regional Reporting Tool/5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4 188.21 MB
14. Main Project #2 Sales Regional Reporting Tool/6. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).mp4 114.61 MB
14. Main Project #2 Sales Regional Reporting Tool/7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).mp4 95.58 MB
14. Main Project #2 Sales Regional Reporting Tool/8. Track the List of Tasks Completed with VBA.mp4 113.02 MB
14. Main Project #2 Sales Regional Reporting Tool/9. Final Touches & Creating Interface to Hide Specific Tabs with a Password.mp4 112.41 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/1. Overview & Important Concepts when Interacting with Other Applications.mp4 54.16 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/2. Project PDF Save Specific Sheets as a PDF File.mp4 135.46 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/3. Project Email Automatically Create Personalized Emails with Attachments.mp4 87 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4 169.73 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4 185.44 MB
16. Workbook and Worksheet Events/1. Overview & What are Event Procedures.mp4 38.97 MB
16. Workbook and Worksheet Events/2. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).mp4 141.51 MB
16. Workbook and Worksheet Events/3. Worksheet Selection Change Dynamic Font Color of Selected Range.mp4 56.26 MB
16. Workbook and Worksheet Events/4. Refresh PivotTables Automatically & Concept of Range Intersection.mp4 154.87 MB
16. Workbook and Worksheet Events/5. Resetting a Dependent Drop-down when the first Drop-down is Changed.mp4 115.97 MB
16. Workbook and Worksheet Events/7. Project Link Page Header to Cell Value (BeforePrint Event).mp4 144.93 MB
16. Workbook and Worksheet Events/8. 2 Useful Tips when Working with Events & Key Takeaways.mp4 38.01 MB
17. Working with Userforms & ActiveX Controls/1. Overview UserForms & ActiveX Controls.mp4 31.71 MB
17. Working with Userforms & ActiveX Controls/10. Bonus ListBox to Print Multiple Pages in ONE GO.mp4 73.14 MB
17. Working with Userforms & ActiveX Controls/2. ActiveX Controls What you Need to Know.mp4 59.53 MB
17. Working with Userforms & ActiveX Controls/3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.mp4 77.13 MB
17. Working with Userforms & ActiveX Controls/4. ActiveX to Show and Hide Help.mp4 56.75 MB
17. Working with Userforms & ActiveX Controls/5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).mp4 92.5 MB
17. Working with Userforms & ActiveX Controls/6. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).mp4 132.39 MB
17. Working with Userforms & ActiveX Controls/7. UserForm Basics What You Need to Get Started.mp4 193.14 MB
17. Working with Userforms & ActiveX Controls/8. UserForm for Data Entry (Input & Check Boxes).mp4 126.85 MB
17. Working with Userforms & ActiveX Controls/9. UserForm to Document External Links & Comments (Combo Box & Option button).mp4 234.33 MB
18. Main Project #3 Invoice Generation Tool/1. Tool Overview What You Will Learn.mp4 132.84 MB
18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.mp4 238.85 MB
18. Main Project #3 Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data.mp4 178.16 MB
18. Main Project #3 Invoice Generation Tool/3. Working with Multi-Column ListBoxes.mp4 130.49 MB
18. Main Project #3 Invoice Generation Tool/4. Edit Master Data with UserForm.mp4 85.37 MB
18. Main Project #3 Invoice Generation Tool/5. Searchable ListBox (with Selection Change event).mp4 160.9 MB
18. Main Project #3 Invoice Generation Tool/6. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4 204.18 MB
18. Main Project #3 Invoice Generation Tool/7. MultiPage UserForm to Create Invoices & Email (Setup).mp4 218.91 MB
18. Main Project #3 Invoice Generation Tool/8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.mp4 280.48 MB
18. Main Project #3 Invoice Generation Tool/9. Create Email in Outlook & Attach PDF Invoice.mp4 134 MB
19. Create your own Custom Functions/1. Section Overview Function Procedures.mp4 32.26 MB
19. Create your own Custom Functions/2. Setting up a Simple Function (including Optional Arguments).mp4 64.27 MB
19. Create your own Custom Functions/3. Function to Calculate Age (Result in Years & Months).mp4 76.27 MB
19. Create your own Custom Functions/4. Functions that Split Text and Numbers from Cell Value.mp4 97.54 MB
19. Create your own Custom Functions/5. Using Functions in Sub Procedures.mp4 82.22 MB
19. Create your own Custom Functions/7. Project Function That Sums based on Cell Color.mp4 182.03 MB
2. Your First Macro/1. Overview Macros & Visual Basic Editor (VBE).mp4 7.1 MB
2. Your First Macro/2. Steps to Your First Macro Recording.mp4 11.72 MB
2. Your First Macro/3. Visual Basic Editor What You Need to Know.mp4 101.93 MB
2. Your First Macro/4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4 201.44 MB
2. Your First Macro/5. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.mp4 47.25 MB
2. Your First Macro/6. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).mp4 23.91 MB
20. Working with Charts/1. The Chart Object Library & Section Overview.mp4 32.29 MB
20. Working with Charts/2. Create and Modify a Chart with VBA.mp4 143.76 MB
20. Working with Charts/3. Animated Charts Different Methods.mp4 121.17 MB
20. Working with Charts/4. Show Charts inside UserForms.mp4 149.65 MB
21. Summary & Final Words/1. Your Next Steps & more Learning.mp4 45.94 MB
3. The Object Model/1. Overview VBA Object Model (What you need to become an expert in VBA).mp4 7.44 MB
3. The Object Model/2. VBA's Code Reference Object Library.mp4 8.77 MB
3. The Object Model/3. VB Color Guidelines & Keyboard Shortcuts.mp4 126.39 MB
3. The Object Model/4. Excel VBA Object Model.mp4 11.34 MB
3. The Object Model/5. Object Properties.mp4 9.26 MB
3. The Object Model/6. Object Methods.mp4 12.79 MB
3. The Object Model/7. How to Find the Object, Property & Method.mp4 16.75 MB
3. The Object Model/9. Conclusion Key Takeaways & Message from Me.mp4 7.06 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/1. Overview Referencing Ranges, Worksheets & Workbooks.mp4 5.02 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/10. Key Takeaways for Referencing Ranges.mp4 8.57 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/2. Referring to Ranges & Writing to Cells in VBA.mp4 24.33 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/3. Most Useful Range Properties & Methods.mp4 34.45 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/4. 4 Methods to Find the Last Row of your Range.mp4 36.14 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/5. Copying & resizing a variably sized range.mp4 27.82 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/6. Properly Referencing Worksheets.mp4 48.68 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/7. Properly Referencing Workbooks.mp4 27.65 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/9. Project Save Hard-coded Copy & Macro-free version of workbook.mp4 55.33 MB
5. Working with Variables/1. Overview Role of Assignment & Variables.mp4 9.62 MB
5. Working with Variables/2. Data Types for Better Performance.mp4 7.41 MB
5. Working with Variables/3. Declaring Variables, Arrays & Constants (Role of Option Explicit).mp4 90.14 MB
5. Working with Variables/4. Using Object Variables (Set statement).mp4 65.17 MB
5. Working with Variables/5. Scoping Variables.mp4 12.09 MB
5. Working with Variables/8. Key Takeaways for Working with Variables.mp4 23.38 MB
6. Looping through Collections & Making Decisions/1. Overview Why Collections are a VBA Essential.mp4 29.42 MB
6. Looping through Collections & Making Decisions/2. With & End With for Easier Code Writing.mp4 16.92 MB
6. Looping through Collections & Making Decisions/3. For Each to Loop Through Collections (sheets, ranges etc.) in one go.mp4 98.05 MB
6. Looping through Collections & Making Decisions/4. IF Then (Else, ElseIF) for Conditional Outcomes.mp4 25.67 MB
6. Looping through Collections & Making Decisions/5. Select Case as Alternative for Many IF Statements.mp4 10.87 MB
6. Looping through Collections & Making Decisions/6. Goto Statement to Change Program Flow.mp4 17.93 MB
6. Looping through Collections & Making Decisions/8. Project Get the Number of Formulas on the Worksheet.mp4 122.08 MB
6. Looping through Collections & Making Decisions/9. Bonus Unhide All Sheets in One Go.mp4 91.59 MB
7. Useful Built-in Functions/1. Overview VBA versus Worksheet Functions.mp4 44.16 MB
7. Useful Built-in Functions/2. Most Useful VBA Functions.mp4 83.96 MB
7. Useful Built-in Functions/3. Message Box (also with Yes, No buttons).mp4 20.57 MB
7. Useful Built-in Functions/4. Input Box (VBA InputBox Function).mp4 17.97 MB
7. Useful Built-in Functions/5. Input Box that can Select Ranges (Excel InputBox Method).mp4 112.09 MB
7. Useful Built-in Functions/7. Project Show Top 3 Values in a Message box based on Range Selected.mp4 189.42 MB
8. Debugging, Error Handling & Procedure Scope/1. Overview Debugging, Handling Errors & Procedure Scope.mp4 12.37 MB
8. Debugging, Error Handling & Procedure Scope/2. Debugging Options Watch, Locals, Immediate Windows & More.mp4 140.09 MB
8. Debugging, Error Handling & Procedure Scope/3. Error Handling Different Methods.mp4 111.84 MB
8. Debugging, Error Handling & Procedure Scope/4. Faster Code by Suppressing Pop-ups & Flickering Screen.mp4 28.21 MB
8. Debugging, Error Handling & Procedure Scope/5. Procedure Scope & Running one Sub from Another.mp4 15.03 MB
8. Debugging, Error Handling & Procedure Scope/6. Passing Arguments to Sub Procedures (By Ref, By Val).mp4 24.14 MB
8. Debugging, Error Handling & Procedure Scope/8. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.mp4 29 MB
8. Debugging, Error Handling & Procedure Scope/9. Key Takeaways Debugging, Error Handling & Course Map Status.mp4 22.72 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/1. Project overview Table of Contents (TOC) with one click.mp4 31.42 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/2. TOC Project The Basics.mp4 82.33 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/3. TOC Project Adding Hyperlinks.mp4 11.04 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/4. TOC Project Testing the VBA Code.mp4 8.84 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/5. TOC Project Adding Error Handling & More Checks.mp4 159.19 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/6. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).mp4 77.48 MB
其他位置