Course Description
If your really want to harness the full power of Excel, then learning how to program in VBA is ESSENTIAL!
____________________________________________________________
161 Students enrolled in the first day...find out why!
____________________________________________________________
My guess is you're reading this because:
- You want to join the Excel elite, and program your own solutions?
- Maybe you want to automate most of your work, do more in less time with less effort?
- Could be you want to earn more money?
- Perhaps you may even fancy a career change?
If you answered yes to any of the above, I want you in my student community!
In this course you will learn everything you need to know about coding in VBA, even if you've never looked at a line of code before!
____________________________________________________________
"This is a great course! ...I
can't wait to start using it. I will certainly be using the emailing
program! And reports. My mind is reeling!" - Nickie Student!
____________________________________________________________
Introducing Visual Basic For Applications
Visual Basic for Applications, or VBA, is included with Excel, so
there's nothing more to buy. If you have Excel, you already have access
to VBA.
VBA is the powerhouse. It's the code that lives under the hood where the magic happens.
A lot of people can record a Macro, but being able to program in VBA is quite a different thing. It separates the good from the truly amazing, and I want you to be amazing!
Now, one of those words in "Visual Basic for Applications" carries
more weight that the others. And no, it's not "Basic" (though coding the
way I will teach you is simple!).
No, it's "Applications". In fact, it's the "s" at the very end. The significance is that VBA works across ALL MICROSOFT APPLICATIONS! Word, Outlook, Access, Internet Explorer, and even WINDOWS ITSELF!
Course Details
1. Section 2 Quiz
1. Why Should I Learn How To Code?
10 lectures 1 hour 1 quiz
10. A Little Privacy Please
100. Putting It All Together
101. Introduction To Web Query Section
102. Pulling Data From The Internet - Capturing The Data For Rome
103. Getting To Cancun And London From Rome
104. Data Clean Up
105. A Simple Find And Replace
106. Getting Our Formulas Right
107. Streamlining The Formulas Code
108. Displaying Messages In The Status Bar (Cool)
109. Putting It All Together
11. Keyboard Shortcuts, And Why I Don't Use Them
12. Why You Can't Get By With Just Recording Macros
13. Introduction To The Coding Section
14. Getting All The Code For This Section
15. Changing Your VBE Settings
16. Protecting Your Code
17. Objects, Methods And Properties
18. Understanding The Hierarchy
19. The Range Object
2 lectures 17 mins
2. Let's See How You're Doing...
2. The 15 Golden Rules Of Coding
20. The Cells Object
21 lectures 1.5 hours
21. The ActiveCell Property
22. The Offset Property
23. The End Property
24. Dynamic Range Selection
25. The CurrentRegion Property
26. ACTIVATE vs. SELECT
27. Between The Sheets
28. Calling A Sheet By Its VB Name
29. Sheets Vs. Worksheets
3. Introducing The Visual Basic Editor, & Recording Our First Macro
3. Time For A Quick Test...
30 lectures 1.5 hours 1 quiz
30. Getting Around The Workbooks
31. The Value Property - Writing Data
32. The Value Property - Reading And Writing Data
33. Commonly Used Properties
34. Coding Exercise: The Rainbow
35. The Address Property
36. The Row and Column Properties
37 lectures 2.5 hours 1 quiz
37. Capturing The Column Letter
38. More Useful Properties
39. Even More Useful Properties
4. Saving Macro-Enabled Workbooks, And Security Settings
40. Opening Another Workbook Programmatically
41. Closing Workbooks Programmatically
42. Coding Exercise: Open/Write/Close
43. Introduction To The Programmers Toolbox
44. Variables - Local Variables
45. Variables - Local Variables With A Twist
46. Variables - Module Level Variables
47. Variables - Project Level Variables
48. A Neat Trick To Force Variable Declaration
49. Variables - All The Techie Bits
5. Moving Code Around
50. An Introduction To Looping
51. Looping With Do...Loop
52. Looping With For...Next
53. Looping With A Stepped For...Next
54. Looping With While...Wend
55. An Introduction To Logical Testing
56. Logical Testing - A Simple If Test
57. Logical Testing - A Simple If Test Using Cells
58. Logical Testing - If Then Else
59. Logical Testing - If Then Else Using Cells
6. Stepping Out. Well, In Actually! - Debugging Made Easy :)
60. Logical Testing - Testing Multiple Criteria
61. Logical Testing - Testing If One Is True, And One Is False
62. Logical Testing - Testing If Either Value Is True
63. Logical Testing - Select Case
64. Maths - Doing Simple Maths In Code
65. Maths - Writing Formulas To Single Cells
66. Maths - Writing Formulas To Ranges Of Cells
67. Maths - Using Excel's Built-in Functions
68. Maths - Built-in Functions With Defined Ranges
69. InputBox - Getting User Input Using The InputBox Function
7. With And End With
70. Manipulating The User Input With Casing
71. InputBox - Getting User Input Using The InputBox Method
72. Message Boxes - Simple Message Boxes
73. Message Boxes - Testing Which Button Was Pressed
74. Arrays - An Introduction
75. Arrays - A Simple One Dimensional Static Array
76. Arrays - A Simple One Dimensional Dynamic Array
77. Arrays - A Simple Two Dimensional Static Array
78. Arrays - The Most Efficient Way To Capture An Array
79. Arrays - Extracting Useful Data Based On User Input
8. Streamlining You Code, Or, Get Rid Of What You Don't Need
80. Introduction To Report Automation Section
81. Recording The Bones Of The Code
82. Streamlining The "Add New Sheet Code"
83. Deconstructing The "Profit By Day" Code
84. Building Source Data Strings Dynamically At Runtime
85. Creating The Run Order and Data Capture Subs
86. Solving That Naming Problem
87. Sizing Your Charts Precisely
88. Changing The Chart Title (And Why We Do It Separately)
89. Deconstructing The Pivot Tables (It's Slightly Different)
9 lectures 31 mins
9. Combining Your Code
90. Titles, Money And Sorting
91. Butchering One Table, To Create Another
92. Adding The Commentary - Building Strings Dynamically At Runtime
93. Adding The Comentary Using Data From The Sheet We're On
94. How DO You Make Specific Words Bold
95. INSTR...A Very Useful Function
96. INSTR And Paying Attention To Detail
97. Tidy Up The Title
98. Easy As Pie (Chart)
99. Pretty Up Our Pie Chart
Section: 1 What's It All About, Alan?
Section: 2 Introducing Your Personal Built In Translator...the Macro...
Section: 3 The Building Blocks Of Coding...Your Dictionary & Phrase ...
Section: 4 The Programmers Toolbox...The Techie Stuff, Made Easy (Ho...
Section: 5 Automating All Your Reports!
Section: 6 The Data Is Out There...On The Internet, That Is
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
No comments:
Post a Comment
Note: only a member of this blog may post a comment.