Udemy - Unlock Excel VBA and Excel Macros (12.2024)

File Name

Size

01. Introduction & Scope/01. Course Structure & Content.mp4

14 MB

01. Introduction & Scope/01. Course Structure & Content.vtt

5.2 kB

01. Introduction & Scope/02. Important Compatibility & Setup Information.mp4

10 MB

01. Introduction & Scope/02. Important Compatibility & Setup Information.vtt

4.6 kB

01. Introduction & Scope/03. Course Resources Download Course Project Files.mp4

5.5 MB

01. Introduction & Scope/03. Course Resources Download Course Project Files.vtt

2.3 kB

01. Introduction & Scope/04. Course Expectations.mp4

49 MB

01. Introduction & Scope/04. Course Expectations.vtt

3.5 kB

01. Introduction & Scope/05. Course Outline for Quick Reference.html

490 B

01. Introduction & Scope/assets/03. ALL-VBA-Section-Milestone-Files-In-One-Place.zip

3.3 MB

01. Introduction & Scope/assets/03. Excel-VBA-Course-Slides.pdf

1.8 MB

01. Introduction & Scope/assets/03. How-to-Ask-Questions.pdf

230 kB

01. Introduction & Scope/assets/03. IconSets.xlsx

839 kB

01. Introduction & Scope/assets/03. VBA-Project-Guide.pdf

184 kB

01. Introduction & Scope/assets/05. Detailed-VBA-Course-Outline.xlsx

23 kB

02. Your First Macro/01. Overview Macros & Visual Basic Editor (VBE).mp4

5.3 MB

02. Your First Macro/01. Overview Macros & Visual Basic Editor (VBE).vtt

2.2 kB

02. Your First Macro/02. Steps to Your First Macro Recording.mp4

33 MB

02. Your First Macro/02. Steps to Your First Macro Recording.vtt

7.8 kB

02. Your First Macro/03. Visual Basic Editor What You Need to Know.mp4

73 MB

02. Your First Macro/03. Visual Basic Editor What You Need to Know.vtt

15 kB

02. Your First Macro/04. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.mp4

132 MB

02. Your First Macro/04. Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros.vtt

13 kB

02. Your First Macro/05. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.mp4

128 MB

02. Your First Macro/05. Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording.vtt

12 kB

02. Your First Macro/06. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).mp4

35 MB

02. Your First Macro/06. 7 Ways to Run Macros VBA code (incl. creative & modern buttons).vtt

15 kB

02. Your First Macro/07. OFFICE 365 Update Change from Excel Comments to Notes.html

1.3 kB

02. Your First Macro/08. Activity Record a Macro that Deletes all Comments.html

1.3 kB

02. Your First Macro/09. What's the Difference Between Macros and VBA.html

1.8 kB

02. Your First Macro/010 Quiz Test Your Knowledge on Macros.html

23 kB

02. Your First Macro/assets/01. S2-RecordMacros.xlsm

87 kB

02. Your First Macro/assets/01. S2-RecordMacros-Start.xlsx

66 kB

02. Your First Macro/assets/06. IconSets.xlsx

839 kB

03. The Object Model/01. Overview VBA Object Model (What you need to become an expert in VBA).mp4

5.3 MB

03. The Object Model/01. Overview VBA Object Model (What you need to become an expert in VBA).vtt

2.0 kB

03. The Object Model/02. VBA's Code Reference Object Library.mp4

16 MB

03. The Object Model/02. VBA's Code Reference Object Library.vtt

5.1 kB

03. The Object Model/03. VB Color Guidelines & Keyboard Shortcuts.mp4

51 MB

03. The Object Model/03. VB Color Guidelines & Keyboard Shortcuts.vtt

15 kB

03. The Object Model/04. Excel VBA Object Model.mp4

13 MB

03. The Object Model/04. Excel VBA Object Model.vtt

7.9 kB

03. The Object Model/05. Object Properties.mp4

11 MB

03. The Object Model/05. Object Properties.vtt

5.8 kB

03. The Object Model/06. Object Methods.mp4

15 MB

03. The Object Model/06. Object Methods.vtt

7.6 kB

03. The Object Model/07. How to Find the Object, Property & Method.mp4

47 MB

03. The Object Model/07. How to Find the Object, Property & Method.vtt

9.9 kB

03. The Object Model/008 Test Your Knowledge about the Object Model.html

22 kB

03. The Object Model/08. Conclusion Key Takeaways & Message from Me.mp4

24 MB

03. The Object Model/08. Conclusion Key Takeaways & Message from Me.vtt

3.5 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/01. Overview Referencing Ranges, Worksheets & Workbooks.mp4

3.8 MB

04. Referencing Ranges, Worksheets & Workbooks with VBA/01. Overview Referencing Ranges, Worksheets & Workbooks.vtt

1.5 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/02. Referring to Ranges & Writing to Cells in VBA.mp4

54 MB

04. Referencing Ranges, Worksheets & Workbooks with VBA/02. Referring to Ranges & Writing to Cells in VBA.vtt

19 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/03. Most Useful Range Properties & Methods.mp4

103 MB

04. Referencing Ranges, Worksheets & Workbooks with VBA/03. Most Useful Range Properties & Methods.vtt

17 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/04. 4 Methods to Find the Last Row of your Range.mp4

147 MB

04. Referencing Ranges, Worksheets & Workbooks with VBA/04. 4 Methods to Find the Last Row of your Range.vtt

18 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/05. Copying & resizing a variably sized range.mp4

71 MB

04. Referencing Ranges, Worksheets & Workbooks with VBA/05. Copying & resizing a variably sized range.vtt

12 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/06. Properly Referencing Worksheets.mp4

57 MB

04. Referencing Ranges, Worksheets & Workbooks with VBA/06. Properly Referencing Worksheets.vtt

18 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/07. Properly Referencing Workbooks.mp4

74 MB

04. Referencing Ranges, Worksheets & Workbooks with VBA/07. Properly Referencing Workbooks.vtt

13 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/08. Activity Save a Hard-coded Copy of Workbook.html

1.7 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/09. Project Save Hard-coded Copy & Macro-free version of workbook.mp4

133 MB

04. Referencing Ranges, Worksheets & Workbooks with VBA/09. Project Save Hard-coded Copy & Macro-free version of workbook.vtt

14 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/10. Key Takeaways for Referencing Ranges.mp4

8.9 MB

04. Referencing Ranges, Worksheets & Workbooks with VBA/10. Key Takeaways for Referencing Ranges.vtt

3.6 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/assets/01. S4-ReferencingRanges.xlsm

88 kB

04. Referencing Ranges, Worksheets & Workbooks with VBA/assets/01. S4-ReferencingRanges-Start.xlsx

65 kB

05. Working with Variables/01. Overview Role of Assignment & Variables.mp4

7.5 MB

05. Working with Variables/01. Overview Role of Assignment & Variables.vtt

3.6 kB

05. Working with Variables/02. Data Types for Better Performance.mp4

8.6 MB

05. Working with Variables/02. Data Types for Better Performance.vtt

4.1 kB

05. Working with Variables/03. Declaring Variables, Arrays & Constants (Role of Option Explicit).mp4

37 MB

05. Working with Variables/03. Declaring Variables, Arrays & Constants (Role of Option Explicit).vtt

16 kB

05. Working with Variables/04. Using Object Variables (Set statement).mp4

37 MB

05. Working with Variables/04. Using Object Variables (Set statement).vtt

8.2 kB

05. Working with Variables/05. Scoping Variables.mp4

22 MB

05. Working with Variables/05. Scoping Variables.vtt

7.7 kB

05. Working with Variables/06. Activity Revisit Hard-coded Workbook Project & Use Variable Assignment.html

1.3 kB

05. Working with Variables/007 Test Your Knowledge on Variables and data types.html

23 kB

05. Working with Variables/07. Key Takeaways for Working with Variables.mp4

6.9 MB

05. Working with Variables/07. Key Takeaways for Working with Variables.vtt

2.7 kB

05. Working with Variables/assets/01. S5-Variables.xlsm

64 kB

05. Working with Variables/assets/01. S5-Variables-Start.xlsx

49 kB

06. Looping through Collections & Making Decisions/01. Overview Why Collections are a VBA Essential.mp4

4.4 MB

06. Looping through Collections & Making Decisions/01. Overview Why Collections are a VBA Essential.vtt

1.7 kB

06. Looping through Collections & Making Decisions/02. With & End With for Easier Code Writing.mp4

26 MB

06. Looping through Collections & Making Decisions/02. With & End With for Easier Code Writing.vtt

7.5 kB

06. Looping through Collections & Making Decisions/03. For Each to Loop Through Collections (sheets, ranges etc.) in one go.mp4

58 MB

06. Looping through Collections & Making Decisions/03. For Each to Loop Through Collections (sheets, ranges etc.) in one go.vtt

12 kB

06. Looping through Collections & Making Decisions/04. IF Then (Else, ElseIF) for Conditional Outcomes.mp4

41 MB

06. Looping through Collections & Making Decisions/04. IF Then (Else, ElseIF) for Conditional Outcomes.vtt

12 kB

06. Looping through Collections & Making Decisions/05. Select Case as Alternative for Many IF Statements.mp4

19 MB

06. Looping through Collections & Making Decisions/05. Select Case as Alternative for Many IF Statements.vtt

6.2 kB

06. Looping through Collections & Making Decisions/06. Goto Statement to Change Program Flow.mp4

37 MB

06. Looping through Collections & Making Decisions/06. Goto Statement to Change Program Flow.vtt

9.1 kB

06. Looping through Collections & Making Decisions/07. Activity Get the Number of Formulas on the worksheet.html

659 B

06. Looping through Collections & Making Decisions/08. Project Get the Number of Formulas on the Worksheet.mp4

47 MB

06. Looping through Collections & Making Decisions/08. Project Get the Number of Formulas on the Worksheet.vtt

8.6 kB

06. Looping through Collections & Making Decisions/09. Bonus Unhide All Sheets in One Go.mp4

81 MB

06. Looping through Collections & Making Decisions/09. Bonus Unhide All Sheets in One Go.vtt

13 kB

06. Looping through Collections & Making Decisions/10. Key Takeaways for Collections & Decision Making in VBA.html

432 B

06. Looping through Collections & Making Decisions/assets/01. S6-Collections-With-IF.xlsm

93 kB

06. Looping through Collections & Making Decisions/assets/01. S6-Collections-With-IF-Start.xlsx

60 kB

07. Useful Built-in Functions/01. Overview VBA versus Worksheet Functions.mp4

112 MB

07. Useful Built-in Functions/01. Overview VBA versus Worksheet Functions.vtt

16 kB

07. Useful Built-in Functions/02. Most Useful VBA Functions.mp4

59 MB

07. Useful Built-in Functions/02. Most Useful VBA Functions.vtt

13 kB

07. Useful Built-in Functions/03. Message Box (also with Yes, No buttons).mp4

44 MB

07. Useful Built-in Functions/03. Message Box (also with Yes, No buttons).vtt

10 kB

07. Useful Built-in Functions/04. Input Box (VBA InputBox Function).mp4

26 MB

07. Useful Built-in Functions/04. Input Box (VBA InputBox Function).vtt

8.2 kB

07. Useful Built-in Functions/05. Input Box that can Select Ranges (Excel InputBox Method).mp4

78 MB

07. Useful Built-in Functions/05. Input Box that can Select Ranges (Excel InputBox Method).vtt

14 kB

07. Useful Built-in Functions/06. Activity Show Top 3 Values in a Message Box Based on Range Selected.html

1.1 kB

07. Useful Built-in Functions/07. Project Show Top 3 Values in a Message box based on Range Selected.mp4

86 MB

07. Useful Built-in Functions/07. Project Show Top 3 Values in a Message box based on Range Selected.vtt

12 kB

07. Useful Built-in Functions/08. Key Takeaways Built-in Functions.html

356 B

07. Useful Built-in Functions/assets/01. S7-BuiltinFunctions.xlsm

126 kB

07. Useful Built-in Functions/assets/01. S7-BuiltinFunctions-Start.xlsx

106 kB

08. Debugging, Error Handling & Procedure Scope/01. Overview Debugging, Handling Errors & Procedure Scope.mp4

6.0 MB

08. Debugging, Error Handling & Procedure Scope/01. Overview Debugging, Handling Errors & Procedure Scope.vtt

2.5 kB

08. Debugging, Error Handling & Procedure Scope/02. Debugging Options Watch, Locals, Immediate Windows & More.mp4

79 MB

08. Debugging, Error Handling & Procedure Scope/02. Debugging Options Watch, Locals, Immediate Windows & More.vtt

16 kB

08. Debugging, Error Handling & Procedure Scope/03. Error Handling Different Methods.mp4

64 MB

08. Debugging, Error Handling & Procedure Scope/03. Error Handling Different Methods.vtt

13 kB

08. Debugging, Error Handling & Procedure Scope/04. Faster Code by Suppressing Pop-ups & Flickering Screen.mp4

60 MB

08. Debugging, Error Handling & Procedure Scope/04. Faster Code by Suppressing Pop-ups & Flickering Screen.vtt

13 kB

08. Debugging, Error Handling & Procedure Scope/05. Procedure Scope & Running one Sub from Another.mp4

26 MB

08. Debugging, Error Handling & Procedure Scope/05. Procedure Scope & Running one Sub from Another.vtt

7.0 kB

08. Debugging, Error Handling & Procedure Scope/06. Passing Arguments to Sub Procedures (By Ref, By Val).mp4

42 MB

08. Debugging, Error Handling & Procedure Scope/06. Passing Arguments to Sub Procedures (By Ref, By Val).vtt

11 kB

08. Debugging, Error Handling & Procedure Scope/07. Activity Get the Total Number of Formulas (or Comments) Used in a Workbook.html

1003 B

08. Debugging, Error Handling & Procedure Scope/08. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.mp4

45 MB

08. Debugging, Error Handling & Procedure Scope/08. Project Get the Total Number of Formulas (or Comments) Used in a Workbook.vtt

12 kB

08. Debugging, Error Handling & Procedure Scope/09. Key Takeaways Debugging, Error Handling & Course Map Status.mp4

4.9 MB

08. Debugging, Error Handling & Procedure Scope/09. Key Takeaways Debugging, Error Handling & Course Map Status.vtt

2.6 kB

08. Debugging, Error Handling & Procedure Scope/assets/01. S8-ErrorHandling.xlsm

89 kB

08. Debugging, Error Handling & Procedure Scope/assets/01. S8-ErrorHandling-Start.xlsm

79 kB

09. Main Project #1 Create a Tool to Automate Table of Contents/01. Project overview Table of Contents (TOC) with one click.mp4

9.6 MB

09. Main Project #1 Create a Tool to Automate Table of Contents/01. Project overview Table of Contents (TOC) with one click.vtt

2.7 kB

09. Main Project #1 Create a Tool to Automate Table of Contents/02. TOC Project The Basics.mp4

36 MB

09. Main Project #1 Create a Tool to Automate Table of Contents/02. TOC Project The Basics.vtt

12 kB

09. Main Project #1 Create a Tool to Automate Table of Contents/03. TOC Project Adding Hyperlinks.mp4

35 MB

09. Main Project #1 Create a Tool to Automate Table of Contents/03. TOC Project Adding Hyperlinks.vtt

7.5 kB

09. Main Project #1 Create a Tool to Automate Table of Contents/04. TOC Project Testing the VBA Code.mp4

27 MB

09. Main Project #1 Create a Tool to Automate Table of Contents/04. TOC Project Testing the VBA Code.vtt

5.3 kB

09. Main Project #1 Create a Tool to Automate Table of Contents/05. TOC Project Adding Error Handling & More Checks.mp4

92 MB

09. Main Project #1 Create a Tool to Automate Table of Contents/05. TOC Project Adding Error Handling & More Checks.vtt

15 kB

09. Main Project #1 Create a Tool to Automate Table of Contents/06. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).mp4

55 MB

09. Main Project #1 Create a Tool to Automate Table of Contents/06. TOC Project Adding to Personal Macro Workbook (Make it Available to all Files).vtt

8.6 kB

09. Main Project #1 Create a Tool to Automate Table of Contents/07. First Milestone Completed!.html

540 B

09. Main Project #1 Create a Tool to Automate Table of Contents/assets/06. Project-Automatic-TableOfContent.xlsm

22 kB

10. Looping in VBA (Controlling the Flow of Code)/01. Section Overview Looping in VBA.mp4

10 MB

10. Looping in VBA (Controlling the Flow of Code)/01. Section Overview Looping in VBA.vtt

3.0 kB

10. Looping in VBA (Controlling the Flow of Code)/02. For Next Counter Loops (Simple Example).mp4

53 MB

10. Looping in VBA (Controlling the Flow of Code)/02. For Next Counter Loops (Simple Example).vtt

9.9 kB

10. Looping in VBA (Controlling the Flow of Code)/03. For Next Nested Loop (Loop through Text & Cells).mp4

149 MB

10. Looping in VBA (Controlling the Flow of Code)/03. For Next Nested Loop (Loop through Text & Cells).vtt

18 kB

10. Looping in VBA (Controlling the Flow of Code)/04. For Next Reverse Loop (Delete FilteredHidden Rows).mp4

82 MB

10. Looping in VBA (Controlling the Flow of Code)/04. For Next Reverse Loop (Delete FilteredHidden Rows).vtt

10 kB

10. Looping in VBA (Controlling the Flow of Code)/05. Do Until & Do While Loop.mp4

57 MB

10. Looping in VBA (Controlling the Flow of Code)/05. Do Until & Do While Loop.vtt

12 kB

10. Looping in VBA (Controlling the Flow of Code)/06. Practical Example of Do Loop (with Inputbox).mp4

20 MB

10. Looping in VBA (Controlling the Flow of Code)/06. Practical Example of Do Loop (with Inputbox).vtt

3.9 kB

10. Looping in VBA (Controlling the Flow of Code)/07. Find Method for Quicker Lookup Results.mp4

57 MB

10. Looping in VBA (Controlling the Flow of Code)/07. Find Method for Quicker Lookup Results.vtt

11 kB

10. Looping in VBA (Controlling the Flow of Code)/08. Find Method with Do Loop - Multiple Matches.mp4

45 MB

10. Looping in VBA (Controlling the Flow of Code)/08. Find Method with Do Loop - Multiple Matches.vtt

7.6 kB

10. Looping in VBA (Controlling the Flow of Code)/09. Add a Timer to Test & Speech to Inform.mp4

33 MB

10. Looping in VBA (Controlling the Flow of Code)/09. Add a Timer to Test & Speech to Inform.vtt

9.7 kB

10. Looping in VBA (Controlling the Flow of Code)/10. Activity Document all Comments in Workbook in a Sheet.html

1.2 kB

10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.mp4

94 MB

10. Looping in VBA (Controlling the Flow of Code)/11. Project Document all Comments in Workbook in a Sheet.vtt

13 kB

10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.mp4

12 MB

10. Looping in VBA (Controlling the Flow of Code)/12. Useful VBA Statements & Key takeaways for Looping in VBA.vtt

4.6 kB

10. Looping in VBA (Controlling the Flow of Code)/assets/01. S10-Looping.xlsm

333 kB

10. Looping in VBA (Controlling the Flow of Code)/assets/01. S10-Looping-Start.xlsx

314 kB

11. Working with Arrays/01. Overview Working with Arrays in VBA.mp4

23 MB

11. Working with Arrays/01. Overview Working with Arrays in VBA.vtt

2.0 kB

11. Working with Arrays/02. One Dimensional Arrays (and transferring back to sheet).mp4

81 MB

11. Working with Arrays/02. One Dimensional Arrays (and transferring back to sheet).vtt

16 kB

11. Working with Arrays/03. Dynamic Arrays (size adjusts depending on a condition).mp4

46 MB

11. Working with Arrays/03. Dynamic Arrays (size adjusts depending on a condition).vtt

7.7 kB

11. Working with Arrays/04. Preserving Dynamic Arrays (adding more elements to the existing array).mp4

26 MB

11. Working with Arrays/04. Preserving Dynamic Arrays (adding more elements to the existing array).vtt

4.6 kB

11. Working with Arrays/05. Two Dimensional Arrays.mp4

20 MB

11. Working with Arrays/05. Two Dimensional Arrays.vtt

8.6 kB

11. Working with Arrays/06. Variant Arrays Quick Method to Write to Cells.mp4

72 MB

11. Working with Arrays/06. Variant Arrays Quick Method to Write to Cells.vtt

9.7 kB

11. Working with Arrays/07. Activity Create a New Worksheet per Company with Specific Information.html

908 B

11. Working with Arrays/08. Project Create a New Worksheet per Company with Specific Information.mp4

72 MB

11. Working with Arrays/08. Project Create a New Worksheet per Company with Specific Information.vtt

10 kB

11. Working with Arrays/09. Key Takeaways Arrays.html

401 B

11. Working with Arrays/assets/01. S11-Arrays.xlsm

77 kB

11. Working with Arrays/assets/01. S11-Arrays-Start.xlsx

55 kB

12. Working with Files, Folders & Text Files/01. Overview Working with Folders & Files.mp4

25 MB

12. Working with Files, Folders & Text Files/01. Overview Working with Folders & Files.vtt

3.6 kB

12. Working with Files, Folders & Text Files/02. DIR Function Check if Files or Folders Exist.mp4

53 MB

12. Working with Files, Folders & Text Files/02. DIR Function Check if Files or Folders Exist.vtt

10 kB

12. Working with Files, Folders & Text Files/03. GetOpenFileName Method User Selects a File.mp4

71 MB

12. Working with Files, Folders & Text Files/03. GetOpenFileName Method User Selects a File.vtt

11 kB

12. Working with Files, Folders & Text Files/04. FileDialog Property Loop Inside a Folder.mp4

117 MB

12. Working with Files, Folders & Text Files/04. FileDialog Property Loop Inside a Folder.vtt

19 kB

12. Working with Files, Folders & Text Files/05. Create CSV File from Data in Excel.mp4

70 MB

12. Working with Files, Folders & Text Files/05. Create CSV File from Data in Excel.vtt

8.2 kB

12. Working with Files, Folders & Text Files/06. Printing & Writing to Text Files for More Control.mp4

33 MB

12. Working with Files, Folders & Text Files/06. Printing & Writing to Text Files for More Control.vtt

8.1 kB

12. Working with Files, Folders & Text Files/07. Activity Export Data to Text file (fix Delimiter to Semicolon).html

739 B

12. Working with Files, Folders & Text Files/08. Project Export Data to Text file (fix Delimiter to Semicolon).mp4

146 MB

12. Working with Files, Folders & Text Files/08. Project Export Data to Text file (fix Delimiter to Semicolon).vtt

14 kB

12. Working with Files, Folders & Text Files/09. Key Takeaways Files & Folders.html

387 B

12. Working with Files, Folders & Text Files/assets/01. S12-Folders-Files.xlsm

90 kB

12. Working with Files, Folders & Text Files/assets/01. S12-Folders-Files-Start.xlsx

58 kB

12. Working with Files, Folders & Text Files/assets/01. Test-data.xlsx

9.1 kB

12. Working with Files, Folders & Text Files/assets/01. TestTextCSV.csv

724 B

13. Excel Tables, Formulas & Pivot Tables/01. Overview (Pivot) Tables & Formulas.mp4

30 MB

13. Excel Tables, Formulas & Pivot Tables/01. Overview (Pivot) Tables & Formulas.vtt

2.8 kB

13. Excel Tables, Formulas & Pivot Tables/02. Using Excel Formulas in VBA.mp4

94 MB

13. Excel Tables, Formulas & Pivot Tables/02. Using Excel Formulas in VBA.vtt

16 kB

13. Excel Tables, Formulas & Pivot Tables/03. Excel Tables Use the Right Syntax.mp4

58 MB

13. Excel Tables, Formulas & Pivot Tables/03. Excel Tables Use the Right Syntax.vtt

16 kB

13. Excel Tables, Formulas & Pivot Tables/04. Pivot Tables & VBA What you Need to Know.mp4

126 MB

13. Excel Tables, Formulas & Pivot Tables/04. Pivot Tables & VBA What you Need to Know.vtt

22 kB

13. Excel Tables, Formulas & Pivot Tables/05. Activity Update Existing Formulas with VBA by Adding IFERROR.html

936 B

13. Excel Tables, Formulas & Pivot Tables/06. Project Update Existing Formulas with VBA by Adding IFERROR.mp4

67 MB

13. Excel Tables, Formulas & Pivot Tables/06. Project Update Existing Formulas with VBA by Adding IFERROR.vtt

8.6 kB

13. Excel Tables, Formulas & Pivot Tables/07. Key Takeaways (Pivot) Tables & Formula.html

391 B

13. Excel Tables, Formulas & Pivot Tables/assets/01. S13-Formulas-Tables-Pivot.xlsm

86 kB

13. Excel Tables, Formulas & Pivot Tables/assets/01. S13-Formulas-Tables-Pivot-Start.xlsx

59 kB

14. Main Project #2 Sales Regional Reporting Tool/01. What You'll Learn (& Should be Aware of..).mp4

14 MB

14. Main Project #2 Sales Regional Reporting Tool/01. What You'll Learn (& Should be Aware of..).vtt

4.9 kB

14. Main Project #2 Sales Regional Reporting Tool/02. Project Overview Regional Sales Reporting Tool.mp4

119 MB

14. Main Project #2 Sales Regional Reporting Tool/02. Project Overview Regional Sales Reporting Tool.vtt

17 kB

14. Main Project #2 Sales Regional Reporting Tool/03. Importing Data from Multiple Files using MultiSelect.mp4

162 MB

14. Main Project #2 Sales Regional Reporting Tool/03. Importing Data from Multiple Files using MultiSelect.vtt

11 kB

14. Main Project #2 Sales Regional Reporting Tool/04. Setting up a Template as the Basis for Different Reports.mp4

246 MB

14. Main Project #2 Sales Regional Reporting Tool/04. Setting up a Template as the Basis for Different Reports.vtt

30 kB

14. Main Project #2 Sales Regional Reporting Tool/05. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).mp4

147 MB

14. Main Project #2 Sales Regional Reporting Tool/05. Exporting Reports as Excel files (Pivot Table & Hard Coded Reports).vtt

19 kB

14. Main Project #2 Sales Regional Reporting Tool/06. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).mp4

69 MB

14. Main Project #2 Sales Regional Reporting Tool/06. Fine-tuning Report Export Procedure (Double-check if user wants to overwrite).vtt

12 kB

14. Main Project #2 Sales Regional Reporting Tool/07. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).mp4

31 MB

14. Main Project #2 Sales Regional Reporting Tool/07. Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon).vtt

9.2 kB

14. Main Project #2 Sales Regional Reporting Tool/08. Track the List of Tasks Completed with VBA.mp4

68 MB

14. Main Project #2 Sales Regional Reporting Tool/08. Track the List of Tasks Completed with VBA.vtt

12 kB

14. Main Project #2 Sales Regional Reporting Tool/09. Final Touches & Creating Interface to Hide Specific Tabs with a Password.mp4

85 MB

14. Main Project #2 Sales Regional Reporting Tool/09. Final Touches & Creating Interface to Hide Specific Tabs with a Password.vtt

12 kB

14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.mp4

23 MB

14. Main Project #2 Sales Regional Reporting Tool/10. Key Takeaways & Tips for VBA based Excel Tools.vtt

3.2 kB

14. Main Project #2 Sales Regional Reporting Tool/11. Second Milestone Completed!.html

561 B

14. Main Project #2 Sales Regional Reporting Tool/assets/02. Monthly-Sales-Reporting-Template-Tool-Start.xlsm

38 kB

14. Main Project #2 Sales Regional Reporting Tool/assets/02. Sales-Document-BereKleid.xlsx

11 kB

14. Main Project #2 Sales Regional Reporting Tool/assets/02. Sales-Document-LucasBasics.xlsx

11 kB

14. Main Project #2 Sales Regional Reporting Tool/assets/02. Sales-Document-MetaCreations.xlsx

10 kB

14. Main Project #2 Sales Regional Reporting Tool/assets/02. Sales-Document-UrbanRight.xlsx

11 kB

14. Main Project #2 Sales Regional Reporting Tool/assets/10. Monthly-Sales-Reporting-Template-Tool.xlsm

136 kB

14. Main Project #2 Sales Regional Reporting Tool/external-links/04. Excel-IF-Function.url

54 B

14. Main Project #2 Sales Regional Reporting Tool/external-links/04. PivotTable-with-Pivot-Chart-Slicers.url

54 B

14. Main Project #2 Sales Regional Reporting Tool/external-links/04. PivotTable-with-Slicers.url

54 B

14. Main Project #2 Sales Regional Reporting Tool/external-links/04. VLOOKUP-Explained.url

54 B

15. Interacting with Other Applications (Word, PowerPoint etc.)/01. Overview & Important Concepts when Interacting with Other Applications.mp4

15 MB

15. Interacting with Other Applications (Word, PowerPoint etc.)/01. Overview & Important Concepts when Interacting with Other Applications.vtt

6.0 kB

15. Interacting with Other Applications (Word, PowerPoint etc.)/02. Project PDF Save Specific Sheets as a PDF File.mp4

83 MB

15. Interacting with Other Applications (Word, PowerPoint etc.)/02. Project PDF Save Specific Sheets as a PDF File.vtt

16 kB

15. Interacting with Other Applications (Word, PowerPoint etc.)/03. Project Email Automatically Create Personalized Emails with Attachments.mp4

54 MB

15. Interacting with Other Applications (Word, PowerPoint etc.)/03. Project Email Automatically Create Personalized Emails with Attachments.vtt

11 kB

15. Interacting with Other Applications (Word, PowerPoint etc.)/04. Project Microsoft Word Create Personalized Letters in Word from Excel.mp4

134 MB

15. Interacting with Other Applications (Word, PowerPoint etc.)/04. Project Microsoft Word Create Personalized Letters in Word from Excel.vtt

18 kB

15. Interacting with Other Applications (Word, PowerPoint etc.)/05. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.mp4

110 MB

15. Interacting with Other Applications (Word, PowerPoint etc.)/05. Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation.vtt

21 kB

15. Interacting with Other Applications (Word, PowerPoint etc.)/06. Key Takeaways when Working with other Applications.html

388 B

15. Interacting with Other Applications (Word, PowerPoint etc.)/assets/01. Letter-Word.docx

59 kB

15. Interacting with Other Applications (Word, PowerPoint etc.)/assets/01. Regional-Report-PowerPoint.pptx

44 kB

15. Interacting with Other Applications (Word, PowerPoint etc.)/assets/01. S15-Other-Applications.xlsm

119 kB

15. Interacting with Other Applications (Word, PowerPoint etc.)/assets/01. S15-Other-Applications-Start.xlsx

99 kB

16. Workbook and Worksheet Events/01. Overview & What are Event Procedures.mp4

9.2 MB

16. Workbook and Worksheet Events/01. Overview & What are Event Procedures.vtt

4.0 kB

16. Workbook and Worksheet Events/02. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).mp4

108 MB

16. Workbook and Worksheet Events/02. Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close).vtt

15 kB

16. Workbook and Worksheet Events/03. Worksheet Selection Change Dynamic Font Color of Selected Range.mp4

39 MB

16. Workbook and Worksheet Events/03. Worksheet Selection Change Dynamic Font Color of Selected Range.vtt

7.4 kB

16. Workbook and Worksheet Events/04. Refresh PivotTables Automatically & Concept of Range Intersection.mp4

117 MB

16. Workbook and Worksheet Events/04. Refresh PivotTables Automatically & Concept of Range Intersection.vtt

15 kB

16. Workbook and Worksheet Events/05. Resetting a Dependent Drop-down when the first Drop-down is Changed.mp4

67 MB

16. Workbook and Worksheet Events/05. Resetting a Dependent Drop-down when the first Drop-down is Changed.vtt

14 kB

16. Workbook and Worksheet Events/06. Activity Link Page Header to Cell Value (BeforePrint Event).html

790 B

16. Workbook and Worksheet Events/07. Project Link Page Header to Cell Value (BeforePrint Event).mp4

64 MB

16. Workbook and Worksheet Events/07. Project Link Page Header to Cell Value (BeforePrint Event).vtt

9.5 kB

16. Workbook and Worksheet Events/08. 2 Useful Tips when Working with Events & Key Takeaways.mp4

20 MB

16. Workbook and Worksheet Events/08. 2 Useful Tips when Working with Events & Key Takeaways.vtt

4.1 kB

16. Workbook and Worksheet Events/assets/01. S16-Events.xlsm

90 kB

16. Workbook and Worksheet Events/assets/01. S16-Events-Start.xlsx

69 kB

16. Workbook and Worksheet Events/external-links/05. INDEX-MATCH-Basics-video.url

54 B

17. Working with Userforms & ActiveX Controls/01. Overview UserForms & ActiveX Controls.mp4

7.1 MB

17. Working with Userforms & ActiveX Controls/01. Overview UserForms & ActiveX Controls.vtt

2.4 kB

17. Working with Userforms & ActiveX Controls/02. ActiveX Controls What you Need to Know.mp4

45 MB

17. Working with Userforms & ActiveX Controls/02. ActiveX Controls What you Need to Know.vtt

8.8 kB

17. Working with Userforms & ActiveX Controls/03. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.mp4

46 MB

17. Working with Userforms & ActiveX Controls/03. ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings.vtt

9.0 kB

17. Working with Userforms & ActiveX Controls/04. ActiveX to Show and Hide Help.mp4

34 MB

17. Working with Userforms & ActiveX Controls/04. ActiveX to Show and Hide Help.vtt

7.3 kB

17. Working with Userforms & ActiveX Controls/05. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).mp4

70 MB

17. Working with Userforms & ActiveX Controls/05. ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks).vtt

12 kB

17. Working with Userforms & ActiveX Controls/06. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).mp4

98 MB

17. Working with Userforms & ActiveX Controls/06. ActiveX to Show or Hide Other ActiveX controls (eg. Actual & Budget reporting).vtt

15 kB

17. Working with Userforms & ActiveX Controls/07. UserForm Basics What You Need to Get Started.mp4

118 MB

17. Working with Userforms & ActiveX Controls/07. UserForm Basics What You Need to Get Started.vtt

24 kB

17. Working with Userforms & ActiveX Controls/08. UserForm for Data Entry (Input & Check Boxes).mp4

77 MB

17. Working with Userforms & ActiveX Controls/08. UserForm for Data Entry (Input & Check Boxes).vtt

16 kB

17. Working with Userforms & ActiveX Controls/09. UserForm to Document External Links & Comments (Combo Box & Option button).mp4

166 MB

17. Working with Userforms & ActiveX Controls/09. UserForm to Document External Links & Comments (Combo Box & Option button).vtt

25 kB

17. Working with Userforms & ActiveX Controls/10. Bonus ListBox to Print Multiple Pages in ONE GO.mp4

39 MB

17. Working with Userforms & ActiveX Controls/10. Bonus ListBox to Print Multiple Pages in ONE GO.vtt

15 kB

17. Working with Userforms & ActiveX Controls/11. UserForm Checklist & Course Map Status.html

568 B

17. Working with Userforms & ActiveX Controls/assets/01. S17-PictureClip.zip

3.1 kB

17. Working with Userforms & ActiveX Controls/assets/01. S17-UserForms-ActiveX.xlsm

125 kB

17. Working with Userforms & ActiveX Controls/assets/01. S17-UserForms-ActiveX-Start.xlsx

72 kB

17. Working with Userforms & ActiveX Controls/assets/10. S17-Bonus-ListBox-PrintOut.xlsm

76 kB

17. Working with Userforms & ActiveX Controls/assets/10. S17-Bonus-ListBox-PrintOut-Start.xlsx

50 kB

18. Main Project #3 Invoice Generation Tool/01. Tool Overview What You Will Learn.mp4

78 MB

18. Main Project #3 Invoice Generation Tool/01. Tool Overview What You Will Learn.vtt

18 kB

18. Main Project #3 Invoice Generation Tool/02. Setting up an Input UserForm to Collect Master Data.mp4

139 MB

18. Main Project #3 Invoice Generation Tool/02. Setting up an Input UserForm to Collect Master Data.vtt

20 kB

18. Main Project #3 Invoice Generation Tool/03. Working with Multi-Column ListBoxes.mp4

105 MB

18. Main Project #3 Invoice Generation Tool/03. Working with Multi-Column ListBoxes.vtt

12 kB

18. Main Project #3 Invoice Generation Tool/04. Edit Master Data with UserForm.mp4

67 MB

18. Main Project #3 Invoice Generation Tool/04. Edit Master Data with UserForm.vtt

7.8 kB

18. Main Project #3 Invoice Generation Tool/05. Searchable ListBox (with Selection Change event).mp4

110 MB

18. Main Project #3 Invoice Generation Tool/05. Searchable ListBox (with Selection Change event).vtt

19 kB

18. Main Project #3 Invoice Generation Tool/06. Enhanced Searchable ListBox Write Selection back to Excel Table.mp4

157 MB

18. Main Project #3 Invoice Generation Tool/06. Enhanced Searchable ListBox Write Selection back to Excel Table.vtt

18 kB

18. Main Project #3 Invoice Generation Tool/07. MultiPage UserForm to Create Invoices & Email (Setup).mp4

70 MB

18. Main Project #3 Invoice Generation Tool/07. MultiPage UserForm to Create Invoices & Email (Setup).vtt

21 kB

18. Main Project #3 Invoice Generation Tool/08. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.mp4

222 MB

18. Main Project #3 Invoice Generation Tool/08. Export PDF & Excel Workbook for Each Invoice based on ListBox Selection.vtt

28 kB

18. Main Project #3 Invoice Generation Tool/09. Create Email in Outlook & Attach PDF Invoice.mp4

136 MB

18. Main Project #3 Invoice Generation Tool/09. Create Email in Outlook & Attach PDF Invoice.vtt

17 kB

18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.mp4

193 MB

18. Main Project #3 Invoice Generation Tool/10. Final Updates & Debugging.vtt

23 kB

18. Main Project #3 Invoice Generation Tool/11. Last Milestone Completed!.html

455 B

18. Main Project #3 Invoice Generation Tool/assets/02. Invoice-Generator-Start.xlsm

234 kB

18. Main Project #3 Invoice Generation Tool/assets/10. Invoice-Generator.xlsm

347 kB

19. Create your own Custom Functions/01. Section Overview Function Procedures.mp4

30 MB

19. Create your own Custom Functions/01. Section Overview Function Procedures.vtt

2.5 kB

19. Create your own Custom Functions/02. Setting up a Simple Function (including Optional Arguments).mp4

38 MB

19. Create your own Custom Functions/02. Setting up a Simple Function (including Optional Arguments).vtt

6.8 kB

19. Create your own Custom Functions/03. Function to Calculate Age (Result in Years & Months).mp4

58 MB

19. Create your own Custom Functions/03. Function to Calculate Age (Result in Years & Months).vtt

7.1 kB

19. Create your own Custom Functions/04. Functions that Split Text and Numbers from Cell Value.mp4

72 MB

19. Create your own Custom Functions/04. Functions that Split Text and Numbers from Cell Value.vtt

10 kB

19. Create your own Custom Functions/05. Using Functions in Sub Procedures.mp4

46 MB

19. Create your own Custom Functions/05. Using Functions in Sub Procedures.vtt

7.4 kB

19. Create your own Custom Functions/06. Activity Function That Sums based on Cell Color.html

718 B

19. Create your own Custom Functions/07. Project Function That Sums based on Cell Color.mp4

80 MB

19. Create your own Custom Functions/07. Project Function That Sums based on Cell Color.vtt

13 kB

19. Create your own Custom Functions/08. Key Takeaways Function Procedures in VBA & Course Map Status.html

471 B

19. Create your own Custom Functions/assets/01. S19-FunctionProcedures.xlsm

70 kB

19. Create your own Custom Functions/assets/01. S19-FunctionProcedures-Start.xlsx

50 kB

20. Working with Charts/01. The Chart Object Library & Section Overview.mp4

10 MB

20. Working with Charts/01. The Chart Object Library & Section Overview.vtt

4.4 kB

20. Working with Charts/02. Create and Modify a Chart with VBA.mp4

85 MB

20. Working with Charts/02. Create and Modify a Chart with VBA.vtt

15 kB

20. Working with Charts/03. Animated Charts Different Methods.mp4

53 MB

20. Working with Charts/03. Animated Charts Different Methods.vtt

14 kB

20. Working with Charts/04. Show Charts inside UserForms.mp4

105 MB

20. Working with Charts/04. Show Charts inside UserForms.vtt

15 kB

20. Working with Charts/05. Key Takeaways Charts.html

652 B

20. Working with Charts/assets/01. S20-Charts.xlsm

124 kB

20. Working with Charts/assets/01. S20-Charts-Start.xlsx

78 kB

21. Summary & Final Words/01. Your Next Steps & more Learning.mp4

42 MB

21. Summary & Final Words/01. Your Next Steps & more Learning.vtt

3.1 kB

21. Summary & Final Words/02. SPECIAL BONUS Discover Exciting Offers!.html

2.2 kB