14. Main Project #2 Sales Regional Reporting Tool/4. Setting up a Template as the Basis for Different Reports.mp4 325.5 MB
18. Main Project #3 Invoice Generation Tool/8. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.mp4 294.1 MB
18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.mp4 250.4 MB
17. Working with Userforms & ActiveX Controls/9. UserForm to Document External Links & Comments (Combo Box & Option button).mp4 245.7 MB
13. Excel Tables, Formulas & Pivot Tables/4. Pivot Tables & VBA What you Need to Know.mp4 237.6 MB
12. Working with Files, Folders & Text Files/8. Project Export Data to Text file (fix Delimiter to Semicolon).mp4 235.8 MB
18. Main Project #3 Invoice Generation Tool/7. MultiPage UserForm to Create Invoices & Email (Setup).mp4 229.5 MB
14. Main Project #2 Sales Regional Reporting Tool/3. Importing Data from Multiple Files using MultiSelect.mp4 218.7 MB
10. Looping in VBA (Controlling the Flow of Code)/3. For Next Nested Loop (Loop through Text & Cells).mp4 218.4 MB
18. Main Project #3 Invoice Generation Tool/6. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4 214.1 MB
2. Your First Macro/4. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4 211.2 MB
17. Working with Userforms & ActiveX Controls/7. UserForm Basics What You Need to Get Started.mp4 202.5 MB
13. Excel Tables, Formulas & Pivot Tables/3. Excel Tables Use the Right Syntax.mp4 199.6 MB
7. Useful Built-in Functions/7. Project Show Top 3 Values in a Message box based on Range Selected.mp4 198.6 MB
14. Main Project #2 Sales Regional Reporting Tool/5. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4 197.3 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/5. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4 194.4 MB
19. Create your own Custom Functions/7. Project Function That Sums based on Cell Color.mp4 190.9 MB
18. Main Project #3 Invoice Generation Tool/2. Setting up an Input UserForm to Collect Master Data.mp4 186.8 MB
15. Interacting with Other Applications (Word, PowerPoint etc.)/4. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4 178.0 MB
12. Working with Files, Folders & Text Files/4. FileDialog Property Loop Inside a Folder.mp4 174.1 MB