Course Details:
Unleash the Full Power of Excel From Helper Programs to Compete Business Solutions With Visual Basics For Applications
Course Requirements:
- All you need is a PC, a copy of Excel 2007, 2010, 2013 or 2016, and a willingness to learn!
- Ideally you will need to have completed Level 1 & 2 of this series
- You will have a good understanding of the basics of Excel
Course Description:
The BIGGEST And HIGHEST RATED VBA Course Available on UDEMY (As Voted For By Students)!Over 43,000 students in 190 countries are becoming Excel masters with THIS series! Check out the FREE PREVIEW LECTURES and SEE WHY!The No.1 Excel VBA Programming Course on Udemy!If you really want to harness the full power of Excel, then learning how to program in VBA (Visual Basic for Applications) is ESSENTIAL!
Over 500 Students enrolled in the first 2 weeks…find out why!
Over 36,000 Students in 182 countries are mastering Excel with THIS series
Average minutes viewed over triple that of similar similar courses on Udemy!
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!
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 than 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, PowerPoint, Internet Explorer, and even WINDOWS ITSELF!
In this course I will not only teach you how tocode for Excel, there are even THREE, no…FOURBonus Sections:
Contolling Word
Contolling Outlook
Yes, even controlling Windows
and now…Automating PowerPoint!
What Makes Me Qualified To Teach You?
Well, I’m a regular guy. I don’t have a University degree, but what I do have is the drive to learn new things and never be beaten by a problem…a lot like you, I guess.
What I also have is over 20 years of experience in using Excel, and programming solutions with VBA.
I have built simple helper systems to make life easier for my colleagues. I’ve programmed complete MRP systems to run the procurement division of a £1.3b company, and everything in between.
So, I can do it, does that mean I can teach you?
You bet! I have taught hundreds of students one on one, and even more in groups. Many of my students have gone on to better paying jobs, start their own businesses, or at the very least made their work lives less stressful! One of my most recent students got a promotion and a 15% pay risejust 16 weeks after learning how to code! Not bad, hey?
Why Is Your Course Different, Alan?
I’m glad you asked!
If you got this far, you already know you get:
Over 13.5 hours of HD video lectures
Tons of downloadable resources
Quizes
All the source code for the course + more!
Programming projects
There are lots of great courses on coding in VBA. There are even lots of free videos on YouTube. Many of them show you all the basics in kind of a “little bit of everything” approach. I looked at what was available, and I knew I had to create something different. Of course I still cover all the basics, just like the other courses, but we will go beyond the basics, and cover in depth the “missing bits”.
In addition, I will teach you my step-by-step process, the actual methods I use to build powerful solutions easily and quickly. I’m sure programming can be difficult, but not the way I do it!
You will learn how streamline your code for efficiency (and make it execute faster!) from the beginning. After we’ve covered all the basics, we will go on to create 6 separate projects using those very tools and techniques, where we will pull together all of your earlier learning, and give you the confidence to program your own solutions as soon as you finish the course!
With So Much Power, What Will You Create?
With the skills you will learn in this course you will be limited only by your imagination.
If you can describe it, you can most likely code it. What will YOU create?
Let’s see. Enrol now, and let’s get started!
Who this course is for:
- No programming or coding experience needed!
- This course for those who want to harness the full power of Excel
- Anyone who wants to develop their career
Course Content:
- 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
| Language | English | Instructor | Alan Jarvis |
|---|---|---|---|
| Duration | 9.5 Hours | Lectures | 137 |
| File Size | 2.8 GB |
0 Comments
Post a Comment