Udemy - Excel Macros and Vba For Excel Report Automation

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Macro Recording Running Starting with Codings
• 1 - Recording and Running Macro English.vtt (13.6 KB)
• 1 - Recording and Running Macro.mp4 (150.7 MB)
• 10 - Adding Renaming Sheet Macro Code English.vtt (6.6 KB)
• 10 - Adding Renaming Sheet Macro Code.mp4 (19.8 MB)
• 11 - Debugging Macro English.vtt (6.5 KB)
• 11 - Debugging Macro.mp4 (21.4 MB)
• 12 - Breakpoints in Macro English.vtt (5.4 KB)
• 12 - Breakpoints in Macro.mp4 (15.8 MB)
• 13 - Creating New File and Pasting Data English.vtt (5.5 KB)
• 13 - Creating New File and Pasting Data.mp4 (16.1 MB)
• 14 - Thisworkbook Activate Concept English.vtt (16.0 KB)
• 14 - Thisworkbook Activate Concept.mp4 (54.6 MB)
• 15 - Filtering Macro Code Use for Report Automation English.vtt (16.8 KB)
• 15 - Filtering Macro Code Use for Report Automation.mp4 (53.1 MB)
• 16 - For Looping Project English.vtt (17.2 KB)
• 16 - For Looping Project.mp4 (69.5 MB)
• 17 - Revision of all above 15 Videos in just 17 Mins English.vtt (20.7 KB)
• 17 - Revision of all above 15 Videos in just 17 Mins.mp4 (66.0 MB)
• 2 - 1-Macro-Recording.xlsx (217.5 KB)
• 2 - Download Practice File.html (0.1 KB)
• 3 - MacroRecording-Video-1.xlsx (80.1 KB)
• 3 - Recording Macro Practice English.vtt (13.7 KB)
• 3 - Recording Macro Practice.mp4 (41.2 MB)
• 4 - Creating Button to Run the Macro English.vtt (15.2 KB)
• 4 - Creating Button to Run the Macro.mp4 (42.7 MB)
• 5 - Macro Query Solution on Relative Reference by Participant English.vtt (7.5 KB)
• 5 - Macro Query Solution on Relative Reference by Participant.mp4 (26.2 MB)
• 6 - Starting Basic Editing in Macro English.vtt (17.2 KB)
• 6 - Starting Basic Editing in Macro.mp4 (46.8 MB)
• 7 - Commenting Code and adding Module English.vtt (13.1 KB)
• 7 - Commenting Code and adding Module.mp4 (33.8 MB)
• 8 - Creating Copy Paste Macro English.vtt (20.9 KB)
• 8 - Creating Copy Paste Macro.mp4 (61.3 MB)
• 9 - Deleting data before pasting Macro English.vtt (9.6 KB)
• 9 - Deleting data before pasting Macro.mp4 (33.1 MB)
2 - Project
• 18 - Project Filter Part 1 English.vtt (17.0 KB)
• 18 - Project Filter Part 1.mp4 (51.1 MB)
• 19 - Project Filter Part 2 English.vtt (9.7 KB)
• 19 - Project Filter Part 2.mp4 (34.8 MB)
• 20 - Using Formula in Excel VBA English.vtt (6.7 KB)
• 20 - Using Formula in Excel VBA.mp4 (24.9 MB)
• 21 - Pulling name from Seperate Sheet Making Dynamic English.vtt (1.3 KB)
• 21 - Pulling name from Seperate Sheet Making Dynamic.mp4 (3.9 MB)
• 22 - Creating Seperate Sheet in New File for each City English.vtt (13.9 KB)
• 22 - Creating Seperate Sheet in New File for each City.mp4 (65.0 MB)
• 23 - Creating Separate File for each city English.vtt (13.2 KB)
• 23 - Creating Separate File for each city.mp4 (62.4 MB)
3 - IF Condition
• 24 - Using IF Condition English.vtt (6.2 KB)
• 24 - Using IF Condition.mp4 (21.7 MB)
• 25 - Participant Query in IF Condition for Deleting Column English.vtt (1.3 KB)
• 25 - Participant Query in IF Condition for Deleting Column.mp4 (4.5 MB)
• 26 - Using ElseIF in Macro VBA English.vtt (2.6 KB)
• 26 - Using ElseIF in Macro VBA.mp4 (10.5 MB)
4 - Consolidation Macro Project
• 27 - CityData-For-Practice-Without-Code.xlsx (240.4 KB)
• 27 - CityData-with-Macro-Code.xlsm (478.2 KB)
• 27 - Creating Consolidation Macro Part 1 Step by Step English.vtt (11.5 KB)
• 27 - Creating Consolidation Macro Part 1 Step by Step.mp4 (37.2 MB)
• 28 - Creating Consolidation Macro Part 2 English.vtt (7.8 KB)
• 28 - Creating Consolidation Macro Part 2.mp4 (31.1 MB)
• 29 - Creating Consolidation Macro Part 3 English.vtt (9.4 KB)
• 29 - Creating Consolidation Macro Part 3.mp4 (34.8 MB)
• 30 - Macro Consolidation from Multiple Files Part 1 Step by Step English.vtt (12.6 KB)
• 30 - Macro Consolidation from Multiple Files Part 1 Step by Step.mp4 (47.5 MB)
• 31 - Macro Consolidation from Multiple Files Part 2 English.vtt (7.1 KB)
• 31 - Macro Consolidation from Multiple Files Part 2.mp4 (30.4 MB)
• 32 - Macro Consolidation from Multiple Files Part 3 English.vtt (6.8 KB)
• 32 - Macro Consolidation from Multiple Files Part 3.mp4 (28.4 MB)
5 - Extra Projects If you wish to Learn and get more ideas
• 33 - OnClickEvent.xlsm (16.9 KB)
• 33 - Vlookup with Cell Change Event English.vtt (9.9 KB)
• 33 - Vlookup with Cell Change Event.mp4 (95.9 MB)
• Bonus Resources.txt (0.1 KB)