Skip to content

[FreeCourseLab com] Udemy - Unlock Excel VBA and Excel Macros

Unverified source. This magnet is from an unverified source. The content may be unsafe or mislabeled. Proceed with caution.
Title: UdemyGroup: NOGRPSource: Udemy
Info Hash
DBD35546098F1C707D96105E0548BF19493EE42B
Source
Unverified
Total Size
11.67 GB
Total Files
100
Seeders
0
Leechers
2
Health
Score
2
Type
Bookware

File List

FileSize
1. Introduction & Scope/1. Course Structure & Content.mp470.59 MB
1. Introduction & Scope/1. Course Structure & Content.vtt5 KB
1. Introduction & Scope/2. Important Compatibility & Setup Information.mp451.38 MB
1. Introduction & Scope/2. Important Compatibility & Setup Information.vtt4.48 KB
1. Introduction & Scope/3. Download Course Project Files.mp434.38 MB
1. Introduction & Scope/3. Download Course Project Files.vtt2.19 KB
1. Introduction & Scope/3.1 Excel_VBA_Course_Slides.pdf.pdf2.53 MB
1. Introduction & Scope/3.2 ALL_VBA_Section_Milestone_Files_In_One_Place.zip.zip3.32 MB
1. Introduction & Scope/3.3 VBA_Project_Guide.pdf.pdf553.96 KB
1. Introduction & Scope/3.4 How_to_Ask_Questions.pdf.pdf864.93 KB
1. Introduction & Scope/3.5 IconSets.xlsx.xlsx838.61 KB
1. Introduction & Scope/4. Course Expectations.mp452.54 MB
1. Introduction & Scope/4. Course Expectations.vtt3.37 KB
10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.mp418.03 MB
10. Looping in VBA (Controlling the Flow of Code)/1. Section Overview Looping in VBA.vtt2.72 KB
10. Looping in VBA (Controlling the Flow of Code)/1.1 S10_Looping_Start.xlsx.xlsx313.49 KB
10. Looping in VBA (Controlling the Flow of Code)/1.2 S10_Looping.xlsm.xlsm333.28 KB
10. Looping in VBA (Controlling the Flow of Code)/10. Activity Document all Comments in Workbook in a Sheet.html1.14 KB
10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.mp451.05 MB
10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.vtt11.91 KB
10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.mp433.26 MB
10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.vtt4.13 KB
10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).mp416.31 MB
10. Looping in VBA (Controlling the Flow of Code)/2. For Next Counter Loops (Simple Example).vtt9.03 KB
10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).mp4208.31 MB
10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).vtt16.14 KB
10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).mp425.88 MB
10. Looping in VBA (Controlling the Flow of Code)/4. For Next Reverse Loop (Delete FilteredHidden Rows).vtt9.39 KB
10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.mp498.12 MB
10. Looping in VBA (Controlling the Flow of Code)/5. Do Until & Do While Loop.vtt10.28 KB
10. Looping in VBA (Controlling the Flow of Code)/6. Practical Example of Do Loop (with Inputbox).mp46.58 MB
10. Looping in VBA (Controlling the Flow of Code)/6. Practical Example of Do Loop (with Inputbox).vtt3.41 KB
10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.mp420.32 MB
10. Looping in VBA (Controlling the Flow of Code)/7. Find Method for Quicker Lookup Results.vtt9.75 KB
10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.mp414.45 MB
10. Looping in VBA (Controlling the Flow of Code)/8. Find Method with Do Loop - Multiple Matches.vtt6.86 KB
10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.mp414.65 MB
10. Looping in VBA (Controlling the Flow of Code)/9. Add a Timer to Test & Speech to Inform.vtt8.78 KB
11. Working with Arrays/1. Overview Working with Arrays in VBA.mp46.24 MB
11. Working with Arrays/1. Overview Working with Arrays in VBA.vtt1.82 KB
11. Working with Arrays/1.1 S11_Arrays_Start.xlsx.xlsx54.58 KB
11. Working with Arrays/1.2 S11_Arrays.xlsm.xlsm77.22 KB
11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).mp4138.82 MB
11. Working with Arrays/2. One Dimensional Arrays (and transferring back to sheet).vtt14.45 KB
11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).mp413.04 MB
11. Working with Arrays/3. Dynamic Arrays (size adjusts depending on a condition).vtt7.12 KB
11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).mp444.67 MB
11. Working with Arrays/4. Preserving Dynamic Arrays (adding more elements to the existing array).vtt4.23 KB
11. Working with Arrays/5. Two Dimensional Arrays.mp475.64 MB
11. Working with Arrays/5. Two Dimensional Arrays.vtt7.86 KB
11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.mp417.14 MB
11. Working with Arrays/6. Variant Arrays Quick Method to Write to Cells.vtt8.84 KB
11. Working with Arrays/7. Activity Create a New Worksheet per Company with Specific Information.html915 B
11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.mp4159.85 MB
11. Working with Arrays/8. Project Create a New Worksheet per Company with Specific Information.vtt9.46 KB
11. Working with Arrays/9. Key Takeaways Arrays.html425 B
12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.mp450.47 MB
12. Working with Files, Folders & Text Files/1. Overview Working with Folders & Files.vtt3.24 KB
12. Working with Files, Folders & Text Files/1.1 Test_data.xlsx.xlsx9.12 KB
12. Working with Files, Folders & Text Files/1.2 S12_Folders_Files_Start.xlsx.xlsx58.17 KB
12. Working with Files, Folders & Text Files/1.3 S12_Folders_Files.xlsm.xlsm90.06 KB
12. Working with Files, Folders & Text Files/1.4 TestTextCSV.csv.csv724 B
12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.mp476.44 MB
12. Working with Files, Folders & Text Files/2. DIR Function Check if Files or Folders Exist.vtt9.22 KB
12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.mp495.86 MB
12. Working with Files, Folders & Text Files/3. GetOpenFileName Method User Selects a File.vtt9.7 KB
12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.mp4166.08 MB
12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.vtt17.46 KB
12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.mp490.51 MB
12. Working with Files, Folders & Text Files/5. Create CSV File from Data in Excel.vtt7.42 KB
12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.mp444.55 MB
12. Working with Files, Folders & Text Files/6. Printing & Writing to Text Files for More Control.vtt7.35 KB
12. Working with Files, Folders & Text Files/7. Activity Export Data to Text file (fix Delimiter to Semicolon).html741 B
12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4224.9 MB
12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).vtt13.06 KB
12. Working with Files, Folders & Text Files/9. Key Takeaways Files & Folders.html413 B
13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.mp443.35 MB
13. Excel Tables, Formulas & Pivot Tables/1. Overview (Pivot) Tables & Formulas.vtt2.52 KB
13. Excel Tables, Formulas & Pivot Tables/1.1 S13_Formulas_Tables_Pivot_Start.xlsx.xlsx59.36 KB
13. Excel Tables, Formulas & Pivot Tables/1.2 S13_Formulas_Tables_Pivot.xlsm.xlsm86.09 KB
13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.mp4165.49 MB
13. Excel Tables, Formulas & Pivot Tables/2. Using Excel Formulas in VBA.vtt14.78 KB
13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.mp4190.36 MB
13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.vtt14.94 KB
13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.mp4226.63 MB
13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.vtt20.62 KB
13. Excel Tables, Formulas & Pivot Tables/5. Activity Update Existing Formulas with VBA by Adding IFERROR.html919 B
13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.mp4138.48 MB
13. Excel Tables, Formulas & Pivot Tables/6. Project Update Existing Formulas with VBA by Adding IFERROR.vtt7.83 KB
13. Excel Tables, Formulas & Pivot Tables/7. Key Takeaways (Pivot) Tables & Formula.html415 B
14. Main Project #2 Sales Regional Reporting Tool/1. What You'll Learn (& Should be Aware of..).mp441.41 MB
14. Main Project #2 Sales Regional Reporting Tool/1. What You'll Learn (& Should be Aware of..).vtt4.47 KB
14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.mp444.35 MB
14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.vtt2.91 KB
14. Main Project #2 Sales Regional Reporting Tool/10.1 Monthly_Sales_Reporting_Template_Tool.xlsm.xlsm136.06 KB
14. Main Project #2 Sales Regional Reporting Tool/11. Second Milestone Completed!.html553 B
14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.mp4159.17 MB
14. Main Project #2 Sales Regional Reporting Tool/2. Project Overview Regional Sales Reporting Tool.vtt15.48 KB
14. Main Project #2 Sales Regional Reporting Tool/2.1 Sales_Document_MetaCreations.xlsx.xlsx10.28 KB
14. Main Project #2 Sales Regional Reporting Tool/2.2 Sales_Document_BereKleid.xlsx.xlsx10.82 KB

Trackers

No trackers found.