Udemy - Unlock Excel VBA and Excel Macros

To download this torrent, you need a BitTorrent client: Vuze or BTGuard

下载这洪流
Download using Magnet Link

健康:

种子: 91
懒鬼: 19
已完成: 1,037
上次检查: 31-07-2019 12:58:53

上传者的声誉点 : 1052

Thanks By

Write a Review for the Uploader:	0	Say Thanks with one good review:

Share on Facebook

Details

name:	Udemy - Unlock Excel VBA and Excel Macros
说明: Go from Beginner to Excel VBA Expert! I'll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects.
YouTube 视频:
类别:	Tutorials
语言:	English
总大小:	11.67 GB
哈希信息:	DBD35546098F1C707D96105E0548BF19493EE42B
增加:	fclab16
加入的日期:	2019-02-06 09:02:31
洪流地位:	Torrent Verified

评级:

Not Yet Rated (Log in to rate it)

Tracker:
udp://thetracker.org:80/announce

这个洪流也有备份的纤夫

URL	播种机	懒鬼	已完成
udp://thetracker.org:80/announce	0	0	0
udp://tracker.cyberia.is:6969/announce	6	0	62
udp://open.demonii.si:1337/announce	6	1	6
udp://denis.stalker.upeer.me:6969/announce	6	1	5
udp://tracker.port443.xyz:6969/announce	0	0	0
udp://torrentclub.tech:6969/announce	5	1	12
udp://tracker.filemail.com:6969/announce	4	1	411
udp://tracker.filepit.to:6969/announce	4	1	25
udp://tracker.moeking.me:6969/announce	5	0	25
udp://00.syo.mx:53/announce	0	0	0
https://1.tracker.eu.org:443/announce	0	0	0
https://2.tracker.eu.org:443/announce	0	0	0
udp://newtoncity.org:6969/announce	4	1	30
udp://tracker.novg.net:6969/announce	0	0	0
https://3.tracker.eu.org:443/announce	0	0	0
udp://bt.oiyo.tk:6969/announce	0	0	0
udp://retracker.lanta-net.ru:2710/announce	3	0	21
udp://tracker.uw0.xyz:6969/announce	3	1	7
udp://exodus.desync.com:6969/announce	5	2	34
udp://tracker.birkenwald.de:6969/announce	0	0	0
udp://chihaya.toss.li:9696/announce	0	0	0
udp://retracker.netbynet.ru:2710/announce	3	1	110
udp://tracker.skynetcloud.tk:6969/announce	0	0	0
udp://tracker.beeimg.com:6969/announce	0	0	0
http://tracker2.dler.org:80/announce	0	0	0
udp://tracker.tiny-vps.com:6969/announce	5	0	1
udp://tracker.torrent.eu.org:451/announce	4	1	43
udp://tracker.nyaa.uk:6969/announce	3	1	17
http://0d.kebhana.mx:443/announce	0	0	0
http://vps02.net.orel.ru:80/announce	3	0	19
http://tracker.openzim.org:80/announce	0	0	0
http://tracker.bz:80/announce	3	2	0
udp://retracker.hotplug.ru:2710/announce	0	0	0
udp://tracker.dyn.im:6969/announce	0	0	0
udp://tracker4.itzmx.com:2710/announce	1	1	49
udp://explodie.org:6969/announce	0	0	0
http://t.acg.rip:6699/announce	0	0	0
udp://tracker.dler.org:6969/announce	2	0	2
http://t.nyaatracker.com:80/announce	0	0	0
udp://ipv4.tracker.harry.lu:80/announce	0	1	0
udp://bt.xxx-tracker.com:2710/announce	5	1	41
udp://bigfoot1942.sektori.org:6969/announce	0	0	0
udp://hk1.opentracker.ga:6969/announce	0	0	0
udp://tracker.opentrackr.org:1337/announce	6	1	115
udp://tracker.internetwarriors.net:1337/announce	5	1	2
http://torrent.nwps.ws:80/announce	0	0	0

文件列表:

文件	大小
1. Introduction & Scope/1. Course Structure & Content.mp4	70.59 MB
1. Introduction & Scope/1. Course Structure & Content.vtt	5.00 kB
1. Introduction & Scope/2. Important Compatibility & Setup Information.mp4	51.38 MB
1. Introduction & Scope/2. Important Compatibility & Setup Information.vtt	4.48 kB
1. Introduction & Scope/3. Download Course Project Files.mp4	34.38 MB
1. Introduction & Scope/3. Download Course Project Files.vtt	2.19 kB
1. Introduction & Scope/3.1 Excel_VBA_Course_Slides.pdf.pdf	2.53 MB
1. Introduction & Scope/3.2 ALL_VBA_Section_Milestone_Files_In_One_Place.zip.zip	3.32 MB
1. Introduction & Scope/3.3 VBA_Project_Guide.pdf.pdf	553.96 kB
1. Introduction & Scope/3.4 How_to_Ask_Questions.pdf.pdf	864.93 kB
1. Introduction & Scope/3.5 IconSets.xlsx.xlsx	838.61 kB
1. Introduction & Scope/4. Course Expectations.mp4	52.54 MB
1. Introduction & Scope/4. Course Expectations.vtt	3.37 kB
10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.mp4	18.03 MB
10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.vtt	2.72 kB
10. Looping in VBA (Controlling the Flow of Code)/1.1 S10_Looping_Start.xlsx.xlsx	313.49 kB
10. Looping in VBA (Controlling the Flow of Code)/1.2 S10_Looping.xlsm.xlsm	333.28 kB
10. Looping in VBA (Controlling the Flow of Code)/10. Activity Document all Comments in Workbook in a Sheet.html	1.14 kB
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)/11. Project Document all Comments in Workbook in a Sheet.vtt	11.91 kB
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)/12. Useful VBA Statements & Key takeaways for Looping in VBA.vtt	4.13 kB
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)/2. For Next Counter Loops (Simple Example).vtt	9.03 kB
10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).mp4	208.31 MB
10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).vtt	16.14 kB
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)/4. For Next Reverse Loop (Delete FilteredHidden Rows).vtt	9.39 kB
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)/5. Do Until & Do While Loop.vtt	10.28 kB
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)/6. Practical Example of Do Loop (with Inputbox).vtt	3.41 kB
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)/7. Find Method for Quicker Lookup Results.vtt	9.75 kB
10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.mp4	14.45 MB
10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.vtt	6.86 kB
10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.mp4	14.65 MB
10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.vtt	8.78 kB
11. Working with Arrays/1. Overview Working with Arrays in VBA.mp4	6.24 MB
11. Working with Arrays/1. Overview Working with Arrays in VBA.vtt	1.82 kB
11. Working with Arrays/1.1 S11_Arrays_Start.xlsx.xlsx	54.58 kB
11. Working with Arrays/1.2 S11_Arrays.xlsm.xlsm	77.22 kB
11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).mp4	138.82 MB
11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).vtt	14.45 kB
11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).mp4	13.04 MB
11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).vtt	7.12 kB
11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).mp4	44.67 MB
11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).vtt	4.23 kB
11. Working with Arrays/5. Two Dimensional Arrays.mp4	75.64 MB
11. Working with Arrays/5. Two Dimensional Arrays.vtt	7.86 kB
11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.mp4	17.14 MB
11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.vtt	8.84 kB
11. Working with Arrays/7. Activity Create a New Worksheet per Company with Specific Information.html	915.00 B
11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.mp4	159.85 MB
11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.vtt	9.46 kB
11. Working with Arrays/9. Key Takeaways Arrays.html	425.00 B
12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.mp4	50.47 MB
12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.vtt	3.24 kB
12. Working with Files, Folders & Text Files/1.1 Test_data.xlsx.xlsx	9.12 kB
12. Working with Files, Folders & Text Files/1.2 S12_Folders_Files_Start.xlsx.xlsx	58.17 kB
12. Working with Files, Folders & Text Files/1.3 S12_Folders_Files.xlsm.xlsm	90.06 kB
12. Working with Files, Folders & Text Files/1.4 TestTextCSV.csv.csv	724.00 B
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/2. DIR Function Check if Files or Folders Exist.vtt	9.22 kB
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/3. GetOpenFileName Method User Selects a File.vtt	9.70 kB
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/4. FileDialog Property Loop Inside a Folder.vtt	17.46 kB
12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.mp4	90.51 MB
12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.vtt	7.42 kB
12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.mp4	44.55 MB
12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.vtt	7.35 kB
12. Working with Files, Folders & Text Files/7. Activity Export Data to Text file (fix Delimiter to Semicolon).html	741.00 B
12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4	224.90 MB
12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).vtt	13.06 kB
12. Working with Files, Folders & Text Files/9. Key Takeaways Files & Folders.html	413.00 B
13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.mp4	43.35 MB
13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.vtt	2.52 kB
13. Excel Tables, Formulas & Pivot Tables/1.1 S13_Formulas_Tables_Pivot_Start.xlsx.xlsx	59.36 kB
13. Excel Tables, Formulas & Pivot Tables/1.2 S13_Formulas_Tables_Pivot.xlsm.xlsm	86.09 kB
13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.mp4	165.49 MB
13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.vtt	14.78 kB
13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.mp4	190.36 MB
13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.vtt	14.94 kB
13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.mp4	226.63 MB
13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.vtt	20.62 kB
13. Excel Tables, Formulas & Pivot Tables/5. Activity Update Existing Formulas with VBA by Adding IFERROR.html	919.00 B
13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.mp4	138.48 MB
13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.vtt	7.83 kB
13. Excel Tables, Formulas & Pivot Tables/7. Key Takeaways (Pivot) Tables & Formula.html	415.00 B
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/1. What You'll Learn (& Should be Aware of..).vtt	4.47 kB
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/10. Key Takeaways & Tips for VBA based Excel Tools.vtt	2.91 kB
14. Main Project #2 Sales Regional Reporting Tool/10.1 Monthly_Sales_Reporting_Template_Tool.xlsm.xlsm	136.06 kB
14. Main Project #2 Sales Regional Reporting Tool/11. Second Milestone Completed!.html	553.00 B
14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.mp4	159.17 MB
14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.vtt	15.48 kB
14. Main Project #2 Sales Regional Reporting Tool/2.1 Sales_Document_MetaCreations.xlsx.xlsx	10.28 kB
14. Main Project #2 Sales Regional Reporting Tool/2.2 Sales_Document_BereKleid.xlsx.xlsx	10.82 kB
14. Main Project #2 Sales Regional Reporting Tool/2.3 Sales_Document_UrbanRight.xlsx.xlsx	10.93 kB
14. Main Project #2 Sales Regional Reporting Tool/2.4 Monthly_Sales_Reporting_Template_Tool_Start.xlsm.xlsm	38.17 kB
14. Main Project #2 Sales Regional Reporting Tool/2.5 Sales_Document_LucasBasics.xlsx.xlsx	10.73 kB
14. Main Project #2 Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect.mp4	208.53 MB
14. Main Project #2 Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect.vtt	10.13 kB
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/4. Setting up a Template as the Basis for Different Reports.vtt	27.22 kB
14. Main Project #2 Sales Regional Reporting Tool/4.1 VLOOKUP Explained.html	89.00 B
14. Main Project #2 Sales Regional Reporting Tool/4.2 Excel IF Function.html	89.00 B
14. Main Project #2 Sales Regional Reporting Tool/4.3 PivotTable with Pivot Chart & Slicers.html	89.00 B
14. Main Project #2 Sales Regional Reporting Tool/4.4 PivotTable with Slicers.html	89.00 B
14. Main Project #2 Sales Regional Reporting Tool/5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4	188.20 MB
14. Main Project #2 Sales Regional Reporting Tool/5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).vtt	17.61 kB
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/6. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).vtt	11.02 kB
14. Main Project #2 Sales Regional Reporting Tool/7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).mp4	95.59 MB
14. Main Project #2 Sales Regional Reporting Tool/7. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).vtt	8.37 kB
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/8. Track the List of Tasks Completed with VBA.vtt	10.86 kB
14. Main Project #2 Sales Regional Reporting Tool/9. Final Touches & Creating Interface to Hide Specific Tabs with a Password.mp4	112.40 MB
14. Main Project #2 Sales Regional Reporting Tool/9. Final Touches & Creating Interface to Hide Specific Tabs with a Password.vtt	11.24 kB
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.)/1. Overview & Important Concepts when Interacting with Other Applications.vtt	5.50 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/1.1 Letter_Word.docx.docx	58.76 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/1.2 S15_Other_Applications_Start.xlsx.xlsx	99.01 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/1.3 S15_Other_Applications.xlsm.xlsm	118.63 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/1.4 Regional Report PowerPoint.pptx.pptx	43.91 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/2. Project PDF Save Specific Sheets as a PDF File.mp4	135.47 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/2. Project PDF Save Specific Sheets as a PDF File.vtt	14.92 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/3. Project Email Automatically Create Personalized Emails with Attachments.mp4	87.00 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/3. Project Email Automatically Create Personalized Emails with Attachments.vtt	9.84 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4	169.72 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.vtt	15.85 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4	185.44 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.vtt	19.15 kB
15. Interacting with Other Applications (Word, PowerPoint etc.)/6. Key Takeaways when Working with other Applications.html	434.00 B
16. Workbook and Worksheet Events/1. Overview & What are Event Procedures.mp4	38.96 MB
16. Workbook and Worksheet Events/1. Overview & What are Event Procedures.vtt	3.59 kB
16. Workbook and Worksheet Events/1.1 S16_Events.xlsm.xlsm	89.45 kB
16. Workbook and Worksheet Events/1.2 S16_Events_Start.xlsx.xlsx	69.33 kB
16. Workbook and Worksheet Events/2. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).mp4	141.50 MB
16. Workbook and Worksheet Events/2. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).vtt	13.91 kB
16. Workbook and Worksheet Events/3. Worksheet Selection Change Dynamic Font Color of Selected Range.mp4	56.26 MB
16. Workbook and Worksheet Events/3. Worksheet Selection Change Dynamic Font Color of Selected Range.vtt	6.71 kB
16. Workbook and Worksheet Events/4. Refresh PivotTables Automatically & Concept of Range Intersection.mp4	154.86 MB
16. Workbook and Worksheet Events/4. Refresh PivotTables Automatically & Concept of Range Intersection.vtt	13.58 kB
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/5. Resetting a Dependent Drop-down when the first Drop-down is Changed.vtt	12.55 kB
16. Workbook and Worksheet Events/5.1 INDEX MATCH Basics video.html	89.00 B
16. Workbook and Worksheet Events/6. Activity Link Page Header to Cell Value (BeforePrint Event).html	803.00 B
16. Workbook and Worksheet Events/7. Project Link Page Header to Cell Value (BeforePrint Event).mp4	144.93 MB
16. Workbook and Worksheet Events/7. Project Link Page Header to Cell Value (BeforePrint Event).vtt	8.58 kB
16. Workbook and Worksheet Events/8. 2 Useful Tips when Working with Events & Key Takeaways.mp4	38.01 MB
16. Workbook and Worksheet Events/8. 2 Useful Tips when Working with Events & Key Takeaways.vtt	3.75 kB
17. Working with Userforms & ActiveX Controls/1. Overivew UserForms & ActiveX Controls.mp4	31.71 MB
17. Working with Userforms & ActiveX Controls/1. Overivew UserForms & ActiveX Controls.vtt	2.13 kB
17. Working with Userforms & ActiveX Controls/1.1 S17_UserForms_ActiveX_Start.xlsx.xlsx	71.79 kB
17. Working with Userforms & ActiveX Controls/1.2 S17_UserForms_ActiveX.xlsm.xlsm	124.77 kB
17. Working with Userforms & ActiveX Controls/1.3 S17_PictureClip.zip.zip	3.15 kB
17. Working with Userforms & ActiveX Controls/10. UserForm Checklist & Course Map Status.html	614.00 B
17. Working with Userforms & ActiveX Controls/2. ActiveX Controls What you Need to Know.mp4	59.52 MB
17. Working with Userforms & ActiveX Controls/2. ActiveX Controls What you Need to Know.vtt	8.08 kB
17. Working with Userforms & ActiveX Controls/3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.mp4	77.12 MB
17. Working with Userforms & ActiveX Controls/3. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.vtt	8.25 kB
17. Working with Userforms & ActiveX Controls/4. ActiveX to Show and Hide Help.mp4	56.74 MB
17. Working with Userforms & ActiveX Controls/4. ActiveX to Show and Hide Help.vtt	6.65 kB
17. Working with Userforms & ActiveX Controls/5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).mp4	92.51 MB
17. Working with Userforms & ActiveX Controls/5. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).vtt	10.85 kB
17. Working with Userforms & ActiveX Controls/6. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).mp4	132.38 MB
17. Working with Userforms & ActiveX Controls/6. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).vtt	13.91 kB
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/7. UserForm Basics What You Need to Get Started.vtt	22.07 kB
17. Working with Userforms & ActiveX Controls/8. UserForm for Data Entry (Input & Check Boxes).mp4	126.84 MB
17. Working with Userforms & ActiveX Controls/8. UserForm for Data Entry (Input & Check Boxes).vtt	14.38 kB
17. Working with Userforms & ActiveX Controls/9. UserForm to Document External Links & Comments (Combo Box & Option button).mp4	234.32 MB
17. Working with Userforms & ActiveX Controls/9. UserForm to Document External Links & Comments (Combo Box & Option button).vtt	22.57 kB
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/1. Tool Overview What You Will Learn.vtt	16.19 kB
18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.mp4	238.85 MB
18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.vtt	20.83 kB
18. Main Project #3 Invoice Generation Tool/10.1 Invoice_Generator.xlsm.xlsm	347.16 kB
18. Main Project #3 Invoice Generation Tool/11. Last Milestone Completed!.html	459.00 B
18. Main Project #3 Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data.mp4	178.15 MB
18. Main Project #3 Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data.vtt	18.16 kB
18. Main Project #3 Invoice Generation Tool/2.1 Invoice_Generator_Start.xlsm.xlsm	234.37 kB
18. Main Project #3 Invoice Generation Tool/3. Working with Multi-Column ListBoxes.mp4	130.49 MB
18. Main Project #3 Invoice Generation Tool/3. Working with Multi-Column ListBoxes.vtt	11.04 kB
18. Main Project #3 Invoice Generation Tool/4. Edit Master Data with UserForm.mp4	85.37 MB
18. Main Project #3 Invoice Generation Tool/4. Edit Master Data with UserForm.vtt	7.14 kB
18. Main Project #3 Invoice Generation Tool/5. Searchable ListBox (with Selection Change event).mp4	160.89 MB
18. Main Project #3 Invoice Generation Tool/5. Searchable ListBox (with Selection Change event).vtt	17.55 kB
18. Main Project #3 Invoice Generation Tool/6. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4	204.17 MB
18. Main Project #3 Invoice Generation Tool/6. Enhanced Searchable ListBox Write Selection back to Excel Table.vtt	16.66 kB
18. Main Project #3 Invoice Generation Tool/7. MultiPage UserForm to Create Invoices & Email (Setup).mp4	218.90 MB
18. Main Project #3 Invoice Generation Tool/7. MultiPage UserForm to Create Invoices & Email (Setup).vtt	19.39 kB
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/8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.vtt	25.59 kB
18. Main Project #3 Invoice Generation Tool/9. Create Email in Outlook & Attach PDF Invoice.mp4	175.59 MB
18. Main Project #3 Invoice Generation Tool/9. Create Email in Outlook & Attach PDF Invoice.vtt	14.47 kB
19. Create your own Custom Functions/1. Section Overview Function Procedures.mp4	32.27 MB
19. Create your own Custom Functions/1. Section Overview Function Procedures.vtt	2.28 kB
19. Create your own Custom Functions/1.1 S19_FunctionProcedures.xlsm.xlsm	70.33 kB
19. Create your own Custom Functions/1.2 S19_FunctionProcedures_Start.xlsx.xlsx	50.03 kB
19. Create your own Custom Functions/2. Setting up a Simple Function (including Optional Arguments).mp4	64.26 MB
19. Create your own Custom Functions/2. Setting up a Simple Function (including Optional Arguments).vtt	6.07 kB
19. Create your own Custom Functions/3. Function to Calculate Age (Result in Years & Months).mp4	76.28 MB
19. Create your own Custom Functions/3. Function to Calculate Age (Result in Years & Months).vtt	6.39 kB
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/4. Functions that Split Text and Numbers from Cell Value.vtt	9.32 kB
19. Create your own Custom Functions/5. Using Functions in Sub Procedures.mp4	82.21 MB
19. Create your own Custom Functions/5. Using Functions in Sub Procedures.vtt	6.61 kB
19. Create your own Custom Functions/6. Activity Function That Sums based on Cell Color.html	727.00 B
19. Create your own Custom Functions/7. Project Function That Sums based on Cell Color.mp4	182.02 MB
19. Create your own Custom Functions/7. Project Function That Sums based on Cell Color.vtt	11.75 kB
19. Create your own Custom Functions/8. Key Takeaways Function Procedures in VBA & Course Map Status.html	493.00 B
2. Your First Macro/1. Overview Macros & Visual Basic Editor (VBE).mp4	7.10 MB
2. Your First Macro/1. Overview Macros & Visual Basic Editor (VBE).vtt	1.96 kB
2. Your First Macro/1.1 S2_RecordMacros_Start.xlsx.xlsx	65.74 kB
2. Your First Macro/1.2 S2_RecordMacros.xlsm.xlsm	86.99 kB
2. Your First Macro/2. Steps to Your First Macro Recording.mp4	11.71 MB
2. Your First Macro/2. Steps to Your First Macro Recording.vtt	6.99 kB
2. Your First Macro/3. Visual Basic Editor What You Need to Know.mp4	101.93 MB
2. Your First Macro/3. Visual Basic Editor What You Need to Know.vtt	13.87 kB
2. Your First Macro/4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4	201.43 MB
2. Your First Macro/4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.vtt	11.71 kB
2. Your First Macro/5. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.mp4	47.24 MB
2. Your First Macro/5. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.vtt	10.56 kB
2. Your First Macro/6. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).mp4	23.91 MB
2. Your First Macro/6. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).vtt	13.53 kB
2. Your First Macro/6.1 IconSets.xlsx.xlsx	838.61 kB
2. Your First Macro/7. Activity Record a Macro that Deletes all Comments.html	1.28 kB
2. Your First Macro/8. What's the Difference Between Macros and VBA.html	1.79 kB
2. Your First Macro/9. Quiz Test Your Knowledge on Macros.html	134.00 B
20. Working with Charts/1. The Chart Object Library & Section Overview.mp4	32.29 MB
20. Working with Charts/1. The Chart Object Library & Section Overview.vtt	4.00 kB
20. Working with Charts/1.1 S20_Charts_Start.xlsx.xlsx	77.73 kB
20. Working with Charts/1.2 S20_Charts.xlsm.xlsm	124.40 kB
20. Working with Charts/2. Create and Modify a Chart with VBA.mp4	143.77 MB
20. Working with Charts/2. Create and Modify a Chart with VBA.vtt	13.80 kB
20. Working with Charts/3. Animated Charts Different Methods.mp4	121.17 MB
20. Working with Charts/3. Animated Charts Different Methods.vtt	13.12 kB
20. Working with Charts/4. Show Charts inside UserForms.mp4	149.64 MB
20. Working with Charts/4. Show Charts inside UserForms.vtt	13.77 kB
20. Working with Charts/5. Key Takeaways Charts.html	672.00 B
21. Summary & Final Words/1. Your Next Steps & more Learning.mp4	45.94 MB
21. Summary & Final Words/1. Your Next Steps & more Learning.vtt	3.03 kB
21. Summary & Final Words/2. BONUS Lecture More from Leila.html	4.69 kB
3. The Object Model/1. Overview VBA Object Model (What you need to become an expert in VBA).mp4	7.43 MB
3. The Object Model/1. Overview VBA Object Model (What you need to become an expert in VBA).vtt	1.97 kB
3. The Object Model/2. VBA's Code Reference Object Library.mp4	8.77 MB
3. The Object Model/2. VBA's Code Reference Object Library.vtt	4.66 kB
3. The Object Model/3. VB Color Guidelines & Keyboard Shortcuts.mp4	126.39 MB
3. The Object Model/3. VB Color Guidelines & Keyboard Shortcuts.vtt	13.72 kB
3. The Object Model/4. Excel VBA Object Model.mp4	11.33 MB
3. The Object Model/4. Excel VBA Object Model.vtt	7.12 kB
3. The Object Model/5. Object Properties.mp4	9.27 MB
3. The Object Model/5. Object Properties.vtt	5.16 kB
3. The Object Model/6. Object Methods.mp4	12.79 MB
3. The Object Model/6. Object Methods.vtt	6.83 kB
3. The Object Model/7. How to Find the Object, Property & Method.mp4	16.75 MB
3. The Object Model/7. How to Find the Object, Property & Method.vtt	8.99 kB
3. The Object Model/8. Test Your Knowledge about the Object Model.html	134.00 B
3. The Object Model/9. Conclusion Key Takeaways & Message from Me.mp4	7.07 MB
3. The Object Model/9. Conclusion Key Takeaways & Message from Me.vtt	3.16 kB
4. Referencing Ranges, Worksheets & Workbooks with VBA/1. Overview Referencing Ranges, Worksheets & Workbooks.mp4	5.01 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/1. Overview Referencing Ranges, Worksheets & Workbooks.vtt	1.37 kB
4. Referencing Ranges, Worksheets & Workbooks with VBA/1.1 S4_ReferencingRanges.xlsm.xlsm	88.14 kB
4. Referencing Ranges, Worksheets & Workbooks with VBA/1.2 S4_ReferencingRanges_Start.xlsx.xlsx	64.78 kB
4. Referencing Ranges, Worksheets & Workbooks with VBA/10. Key Takeaways for Referencing Ranges.mp4	8.56 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/10. Key Takeaways for Referencing Ranges.vtt	3.29 kB
4. Referencing Ranges, Worksheets & Workbooks with VBA/2. Referring to Ranges & Writing to Cells in VBA.mp4	24.34 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/2. Referring to Ranges & Writing to Cells in VBA.vtt	16.90 kB
4. Referencing Ranges, Worksheets & Workbooks with VBA/3. Most Useful Range Properties & Methods.mp4	34.45 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/3. Most Useful Range Properties & Methods.vtt	15.12 kB
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/4. 4 Methods to Find the Last Row of your Range.vtt	16.34 kB
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/5. Copying & resizing a variably sized range.vtt	10.49 kB
4. Referencing Ranges, Worksheets & Workbooks with VBA/6. Properly Referencing Worksheets.mp4	48.67 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/6. Properly Referencing Worksheets.vtt	16.38 kB
4. Referencing Ranges, Worksheets & Workbooks with VBA/7. Properly Referencing Workbooks.mp4	27.65 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/7. Properly Referencing Workbooks.vtt	11.62 kB
4. Referencing Ranges, Worksheets & Workbooks with VBA/8. Activity Save a Hard-coded Copy of Workbook.html	1.73 kB
4. Referencing Ranges, Worksheets & Workbooks with VBA/9. Project Save Hard-coded Copy & Macro-free version of workbook.mp4	55.32 MB
4. Referencing Ranges, Worksheets & Workbooks with VBA/9. Project Save Hard-coded Copy & Macro-free version of workbook.vtt	13.06 kB
5. Working with Variables/1. Overview Role of Assignment & Variables.mp4	9.62 MB
5. Working with Variables/1. Overview Role of Assignment & Variables.vtt	3.26 kB
5. Working with Variables/1.1 S5_Variables.xlsm.xlsm	63.51 kB
5. Working with Variables/1.2 S5_Variables_Start.xlsx.xlsx	49.13 kB
5. Working with Variables/2. Data Types for Better Performance.mp4	7.42 MB
5. Working with Variables/2. Data Types for Better Performance.vtt	3.74 kB
5. Working with Variables/3. Declaring Variables, Arrays & Constants (Role of Option Explicit).mp4	90.15 MB
5. Working with Variables/3. Declaring Variables, Arrays & Constants (Role of Option Explicit).vtt	14.53 kB
5. Working with Variables/4. Using Object Variables (Set statement).mp4	65.16 MB
5. Working with Variables/4. Using Object Variables (Set statement).vtt	7.41 kB
5. Working with Variables/5. Scoping Variables.mp4	12.08 MB
5. Working with Variables/5. Scoping Variables.vtt	6.98 kB
5. Working with Variables/6. Activity Revisit Hard-coded Workbook Project & Use Variable Assignment.html	1.24 kB
5. Working with Variables/7. Test Your Knowledge on Variables and data types.html	134.00 B
5. Working with Variables/8. Key Takeaways for Working with Variables.mp4	23.38 MB
5. Working with Variables/8. Key Takeaways for Working with Variables.vtt	2.43 kB
6. Looping through Collections & Making Decisions/1. Overview Why Collections are a VBA Essential.mp4	29.42 MB
6. Looping through Collections & Making Decisions/1. Overview Why Collections are a VBA Essential.vtt	1.54 kB
6. Looping through Collections & Making Decisions/1.1 S6_Collections_With_IF.xlsm.xlsm	93.27 kB
6. Looping through Collections & Making Decisions/1.2 S6_Collections_With_IF_Start.xlsx.xlsx	60.05 kB
6. Looping through Collections & Making Decisions/10. Key Takeaways for Collections & Decision Making in VBA.html	450.00 B
6. Looping through Collections & Making Decisions/2. With & End With for Easier Code Writing.mp4	16.92 MB
6. Looping through Collections & Making Decisions/2. With & End With for Easier Code Writing.vtt	6.84 kB
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/3. For Each to Loop Through Collections (sheets, ranges etc.) in one go.vtt	10.75 kB
6. Looping through Collections & Making Decisions/4. IF Then (Else, ElseIF) for Conditional Outcomes.mp4	25.67 MB
6. Looping through Collections & Making Decisions/4. IF Then (Else, ElseIF) for Conditional Outcomes.vtt	10.84 kB
6. Looping through Collections & Making Decisions/5. Select Case as Alternative for Many IF Statements.mp4	10.88 MB
6. Looping through Collections & Making Decisions/5. Select Case as Alternative for Many IF Statements.vtt	5.56 kB
6. Looping through Collections & Making Decisions/6. Goto Statement to Change Program Flow.mp4	17.94 MB
6. Looping through Collections & Making Decisions/6. Goto Statement to Change Program Flow.vtt	8.27 kB
6. Looping through Collections & Making Decisions/7. Activity Get the Number of Formulas on the worksheet.html	674.00 B
6. Looping through Collections & Making Decisions/8. Project Get the Number of Formulas on the Worksheet.mp4	122.07 MB
6. Looping through Collections & Making Decisions/8. Project Get the Number of Formulas on the Worksheet.vtt	7.85 kB
6. Looping through Collections & Making Decisions/9. Bonus Unhide All Sheets in One Go.mp4	91.58 MB
6. Looping through Collections & Making Decisions/9. Bonus Unhide All Sheets in One Go.vtt	12.00 kB
7. Useful Built-in Functions/1. Overview VBA versus Worksheet Functions.mp4	44.17 MB
7. Useful Built-in Functions/1. Overview VBA versus Worksheet Functions.vtt	14.10 kB
7. Useful Built-in Functions/1.1 S7_BuiltinFunctions.xlsm.xlsm	126.04 kB
7. Useful Built-in Functions/1.2 S7_BuiltinFunctions_Start.xlsx.xlsx	106.30 kB
7. Useful Built-in Functions/2. Most Useful VBA Functions.mp4	83.95 MB
7. Useful Built-in Functions/2. Most Useful VBA Functions.vtt	11.41 kB
7. Useful Built-in Functions/3. Message Box (also with Yes, No buttons).mp4	20.57 MB
7. Useful Built-in Functions/3. Message Box (also with Yes, No buttons).vtt	9.19 kB
7. Useful Built-in Functions/4. Input Box (VBA InputBox Function).mp4	17.97 MB
7. Useful Built-in Functions/4. Input Box (VBA InputBox Function).vtt	7.38 kB
7. Useful Built-in Functions/5. Input Box that can Select Ranges (Excel InputBox Method).mp4	112.08 MB
7. Useful Built-in Functions/5. Input Box that can Select Ranges (Excel InputBox Method).vtt	12.71 kB
7. Useful Built-in Functions/6. Activity Show Top 3 Values in a Message Box Based on Range Selected.html	1.16 kB
7. Useful Built-in Functions/7. Project Show Top 3 Values in a Message box based on Range Selected.mp4	189.43 MB
7. Useful Built-in Functions/7. Project Show Top 3 Values in a Message box based on Range Selected.vtt	10.99 kB
7. Useful Built-in Functions/8. Key Takeaways Built-in Functions.html	386.00 B
8. Debugging, Error Handling & Procedure Scope/1. Overview Debugging, Handling Errors & Procedure Scope.mp4	12.37 MB
8. Debugging, Error Handling & Procedure Scope/1. Overview Debugging, Handling Errors & Procedure Scope.vtt	2.24 kB
8. Debugging, Error Handling & Procedure Scope/1.1 S8_ErrorHandling_Start.xlsm.xlsm	78.94 kB
8. Debugging, Error Handling & Procedure Scope/1.2 S8_ErrorHandling.xlsm.xlsm	89.08 kB
8. Debugging, Error Handling & Procedure Scope/2. Debugging Options Watch, Locals, Immediate Windows & More.mp4	140.08 MB
8. Debugging, Error Handling & Procedure Scope/2. Debugging Options Watch, Locals, Immediate Windows & More.vtt	14.73 kB
8. Debugging, Error Handling & Procedure Scope/3. Error Handling Different Methods.mp4	111.83 MB
8. Debugging, Error Handling & Procedure Scope/3. Error Handling Different Methods.vtt	11.73 kB
8. Debugging, Error Handling & Procedure Scope/4. Faster Code by Suppressing Pop-ups & Flickering Screen.mp4	28.20 MB
8. Debugging, Error Handling & Procedure Scope/4. Faster Code by Suppressing Pop-ups & Flickering Screen.vtt	11.67 kB
8. Debugging, Error Handling & Procedure Scope/5. Procedure Scope & Running one Sub from Another.mp4	15.02 MB
8. Debugging, Error Handling & Procedure Scope/5. Procedure Scope & Running one Sub from Another.vtt	6.28 kB
8. Debugging, Error Handling & Procedure Scope/6. Passing Arguments to Sub Procedures (By Ref, By Val).mp4	24.13 MB
8. Debugging, Error Handling & Procedure Scope/6. Passing Arguments to Sub Procedures (By Ref, By Val).vtt	9.55 kB
8. Debugging, Error Handling & Procedure Scope/7. Activity Get the Total Number of Formulas (or Comments) Used in a Workbook.html	959.00 B
8. Debugging, Error Handling & Procedure Scope/8. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.mp4	29.00 MB
8. Debugging, Error Handling & Procedure Scope/8. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.vtt	10.96 kB
8. Debugging, Error Handling & Procedure Scope/9. Key Takeaways Debugging, Error Handling & Course Map Status.mp4	22.72 MB
8. Debugging, Error Handling & Procedure Scope/9. Key Takeaways Debugging, Error Handling & Course Map Status.vtt	2.30 kB
9. Main Project #1 Create a Tool to Automate Table of Contents/1. Project overivew Table of Contents (TOC) with one click.mp4	31.42 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/1. Project overivew Table of Contents (TOC) with one click.vtt	2.40 kB
9. Main Project #1 Create a Tool to Automate Table of Contents/2. TOC Project The Basics.mp4	82.32 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/2. TOC Project The Basics.vtt	11.03 kB
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/3. TOC Project Adding Hyperlinks.vtt	6.70 kB
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/4. TOC Project Testing the VBA Code.vtt	4.66 kB
9. Main Project #1 Create a Tool to Automate Table of Contents/5. TOC Project Adding Error Handling & More Checks.mp4	159.18 MB
9. Main Project #1 Create a Tool to Automate Table of Contents/5. TOC Project Adding Error Handling & More Checks.vtt	13.79 kB
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
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).vtt	7.70 kB
9. Main Project #1 Create a Tool to Automate Table of Contents/6.1 Project_Automatic_TableOfContent.xlsm.xlsm	22.15 kB
9. Main Project #1 Create a Tool to Automate Table of Contents/7. First Milestone Completed!.html	544.00 B
[FreeCourseLab.com].url	126.00 B

Comments
无可奉告，仍将过帐

电影

电视

软件 / 应用程序

音乐

游戏

书

动漫

移动应用程序 / 游戏

视频

图片

电视 / 电影包

Udemy - Unlock Excel VBA and Excel Macros