Details for: Udemy - Learn Microsoft Excel VBA Macros for Beginners

Udemy - Learn Microsoft Excel VBA Macros for Beginners

Type:

Video > Movies

Files:

129

Size:

1.68 GB (1809166599 Bytes)

Uploaded:

2021-01-23

By:

tuts756  

Seeders:

0

Leechers:

1

Info Hash:

76271AD2122BA970F3EBB70255348E1551DF94C1

Get This Torrent

Description By the end of this course, you will go from knowing nothing about VBA Macros to knowing how to do the most common functions…all within 3.5 hours! Any version of Excel is supported. Excel VBA Macros are one of the most powerful features in Excel. Why? Because Macros can help you automate almost any routine task, saving you hours and hours of time. During this course, we start with the very foundations of VBA Macros and slowly build your quiver of knowledge. We only teach you the most important functions, functions that can help you accomplish almost any task in VBA. Our instructors have years of experience working with leading companies (like Puma) and universities (like Harvard) to help them automate their spreadsheets. We’ve also taught hundreds of professionals around the U.S. these amazing skills. After all of this, we know what you need to know to get started. Absolutely ZERO background in VBA or programming is necessary! Some key things you’ll learn:​ Learn the structure of VBA code and best practices Create sub routines to segment your code​ Declare and call variables​ Create For /Next loops​ Create If/Then and If/Then/Else logical tests​ What makes our course so awesome? Real world application: In depth, real-world case studies Fun: Light-hearted, fun, and enjoyable course (we never take ourselves too seriously) Knowledgeable instructor:Nate has spent his entire career mastering Excel, consulting companies in Excel, and teaching Excel. No fluff: We don’t teach theory or waste your time with useless information. Everything we teach you can start applying TODAY Let’s start learning! Who this course is for: Anyone who uses Excel regularly Financial analysts Data analysts Accountants & CPAs Requirements You should have an intermediate knowledge of Excel (VLOOKUPs, IFs) ZERO background in VBA or coding required Supports all versions of Excel (PC & Mac) Last Updated 1/2021

Get This Torrent

1. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/06 Recording and Manipulating a Macro/033 Manipulating a recorded macro pt. II.mp468.57 MB
2. TutsNode.com.txt63 bytes
3. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/023 If statements pt. I.en.srt11.11 KB
4. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/06 Recording and Manipulating a Macro/030 3 suggestions for learning VBA code.en.srt10.18 KB
5. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/01 Welcome/002 Course materials.html973 bytes
6. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/05 For_Next Loops & Making Our Code Dynamic/027 Making our code dynamic pt. I.en.srt9.99 KB
7. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/035 Creating a Yes_No message box.en.srt9.56 KB
8. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/005 VBA project view.en.srt9.48 KB
9. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/009 Referencing a worksheet.en.srt9.30 KB
10. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/05 For_Next Loops & Making Our Code Dynamic/029 Making our code dynamic pt. III.en.srt9.09 KB
11. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/022 Offset.en.srt8.81 KB
12. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/020 Finding the last row of data pt. I.en.srt8.55 KB
13. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/012 Copy and paste method #1.en.srt8.41 KB
14. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/037 Adding For_Next loops w_ an If statement.en.srt8.31 KB
15. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/034 Introduction to the case study.en.srt8.28 KB
16. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/008 Code formatting.en.srt8.17 KB
17. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/05 For_Next Loops & Making Our Code Dynamic/025 For_Next loops pt. I.en.srt8.13 KB
18. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/06 Recording and Manipulating a Macro/031 Recording a macro.en.srt7.98 KB
19. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/06 Recording and Manipulating a Macro/033 Manipulating a recorded macro pt. II.en.srt7.95 KB
20. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/006 Code syntax pt. I.en.srt7.85 KB
21. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/014 Declaring a variable pt. I.en.srt7.57 KB
22. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/007 Code syntax pt. II.en.srt7.14 KB
23. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/038 Making our macro more dynamic.en.srt7.14 KB
24. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/040 Repurposing our code pt. II.en.srt7.01 KB
25. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/015 Declaring a variable pt. II.en.srt6.94 KB
26. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/017 Message boxes pt. II.en.srt6.87 KB
27. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/019 Setting a range as a variable.en.srt6.81 KB
28. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/018 Naming & referencing a named range.en.srt6.78 KB
29. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/05 For_Next Loops & Making Our Code Dynamic/026 For_Next loops pt. II.en.srt6.51 KB
30. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/039 Repurposing our code pt. I.en.srt6.44 KB
31. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/016 Message boxes pt. I.en.srt6.31 KB
32. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/05 For_Next Loops & Making Our Code Dynamic/028 Making our code dynamic pt. II.en.srt6.17 KB
33. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/024 If statements pt. II.en.srt6.10 KB
34. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/06 Recording and Manipulating a Macro/032 Manipulating a recorded macro pt. I.en.srt5.95 KB
35. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/036 Finding the first and last rows.en.srt5.66 KB
36. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/010 Referencing a range.en.srt5.53 KB
37. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/003 Preparing your workbook for macros.en.srt5.33 KB
38. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/004 The Developer tab.en.srt4.78 KB
39. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/013 Copy and paste method #2.en.srt4.83 KB
40. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/011 Clearing a cell's contents.en.srt4.35 KB
41. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/041 Reviewing what we've learned.en.srt4.30 KB
42. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/021 Finding the last row of data pt. II.en.srt3.33 KB
43. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/01 Welcome/001 Welcome to the course!.en.srt3.23 KB
44. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/08 Conclusion/042 Wrapping up!.en.srt2.93 KB
45. [TGx]Downloaded from torrentgalaxy.to .txt585 bytes
46. .pad/0148.10 KB
47. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/037 Adding For_Next loops w_ an If statement.mp462.64 MB
48. .pad/1368.20 KB
49. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/05 For_Next Loops & Making Our Code Dynamic/027 Making our code dynamic pt. I.mp458.28 MB
50. .pad/2228.78 KB
51. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/06 Recording and Manipulating a Macro/032 Manipulating a recorded macro pt. I.mp457.84 MB
52. .pad/3166.04 KB
53. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/022 Offset.mp455.58 MB
54. .pad/4431.20 KB
55. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/05 For_Next Loops & Making Our Code Dynamic/029 Making our code dynamic pt. III.mp452.89 MB
56. .pad/5107.80 KB
57. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/023 If statements pt. I.mp452.51 MB
58. .pad/6506.30 KB
59. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/035 Creating a Yes_No message box.mp452.43 MB
60. .pad/770.90 KB
61. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/020 Finding the last row of data pt. I.mp450.50 MB
62. .pad/8507.92 KB
63. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/040 Repurposing our code pt. II.mp449.14 MB
64. .pad/9373.65 KB
65. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/006 Code syntax pt. I.mp448.88 MB
66. .pad/10120.01 KB
67. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/06 Recording and Manipulating a Macro/030 3 suggestions for learning VBA code.mp448.78 MB
68. .pad/11225.67 KB
69. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/007 Code syntax pt. II.mp447.25 MB
70. .pad/12255.37 KB
71. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/01 Welcome/001 Welcome to the course!.mp446.99 MB
72. .pad/1313.19 KB
73. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/005 VBA project view.mp446.72 MB
74. .pad/14283.69 KB
75. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/019 Setting a range as a variable.mp446.38 MB
76. .pad/15125.61 KB
77. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/008 Code formatting.mp444.48 MB
78. .pad/1617.54 KB
79. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/05 For_Next Loops & Making Our Code Dynamic/026 For_Next loops pt. II.mp443.37 MB
80. .pad/17132.46 KB
81. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/06 Recording and Manipulating a Macro/031 Recording a macro.mp442.88 MB
82. .pad/18120.29 KB
83. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/017 Message boxes pt. II.mp442.43 MB
84. .pad/1966.98 KB
85. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/009 Referencing a worksheet.mp441.77 MB
86. .pad/20232.14 KB
87. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/039 Repurposing our code pt. I.mp441.77 MB
88. .pad/21238.79 KB
89. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/08 Conclusion/042 Wrapping up!.mp440.54 MB
90. .pad/22469.71 KB
91. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/012 Copy and paste method #1.mp440.34 MB
92. .pad/23161.07 KB
93. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/018 Naming & referencing a named range.mp439.67 MB
94. .pad/24341.64 KB
95. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/034 Introduction to the case study.mp439.55 MB
96. .pad/25461.49 KB
97. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/015 Declaring a variable pt. II.mp438.96 MB
98. .pad/2641.98 KB
99. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/024 If statements pt. II.mp436.51 MB
100. .pad/27501.14 KB
101. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/036 Finding the first and last rows.mp436.31 MB
102. .pad/28193.35 KB
103. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/038 Making our macro more dynamic.mp436.10 MB
104. .pad/29407.55 KB
105. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/05 For_Next Loops & Making Our Code Dynamic/028 Making our code dynamic pt. II.mp434.69 MB
106. .pad/30321.45 KB
107. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/016 Message boxes pt. I.mp432.67 MB
108. .pad/31342.49 KB
109. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/014 Declaring a variable pt. I.mp432.28 MB
110. .pad/32227.72 KB
111. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/07 Real-World Case Study/041 Reviewing what we've learned.mp430.74 MB
112. .pad/33264.61 KB
113. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/04 Named Ranges & If Statements/021 Finding the last row of data pt. II.mp429.15 MB
114. .pad/34358.91 KB
115. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/05 For_Next Loops & Making Our Code Dynamic/025 For_Next loops pt. I.mp428.53 MB
116. .pad/35482.98 KB
117. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/013 Copy and paste method #2.mp427.04 MB
118. .pad/36471.68 KB
119. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/010 Referencing a range.mp426.71 MB
120. .pad/37299.79 KB
121. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/003 Preparing your workbook for macros.mp424.05 MB
122. .pad/38464.88 KB
123. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/03 VBA Code Basics/011 Clearing a cell's contents.mp420.52 MB
124. .pad/39494.73 KB
125. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/02 Intro to VBA Coding/004 The Developer tab.mp413.93 MB
126. .pad/4073.45 KB
127. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/01 Welcome/002 Microsoft-Excel-VBA-Macros-Solution.xlsm1.88 MB
128. .pad/41117.95 KB
129. [TutsNode.com] - Learn Microsoft Excel VBA Macros for Beginners/01 Welcome/002 Microsoft-Excel-VBA-Macros.xlsx1.86 MB