Hi. My name is Tayo Solagbade.
This is the introduction to the Home Study Video version of my Microsoft Excel Heaven Visual Basic Programming Coaching.
Now, typically in order for you to get access to this series of videos, you would actually have become a member of my Excel Heaven Visual Basic Club – which is available for access on the web. You would have access to a private closed group on Facebook, and also to a password protected members-only section of my website.
This video series is the equivalent, or kind of alternative to the on-demand 4 day Practical Excel VB Programming Coaching Workshop that I offer.
I’ve offered this for years, since 2006, and it’s been something that has enabled me to share my expertise with a few people who saw the need to improve their abilities, in terms of how they could be productive using MS Excel.
No matter how much you think you know MS Excel, in term of using excel if you are not automating MS Excel using visual basic you are really really undercutting your self. I’ll tell you that. It doesn’t matter how much expertise you think you have, for as long as you are not using visual basic to automat MS Excel, you are not doing as much as you are capable of.
In fact you’re really, really, really crawling instead of flying. And there’s no exaggeration. All you have to do us go to ExcelHeaven.biz to look at some of the applications I have showcased there through my Youtube channel.
Now, in this video series which is like I said the Home Study equivalent of the 4-day practical coaching workshop.
You will learn first of all how to design your worksheets using best practice techniques. Best practice techniques in the sense that there is what you call an approach to designing your worksheets, setting up your tables, posting your data, that will enhance your ability to get the best possible results using Microsoft Excel.
Now if you do not observe those rules, guideline and practice those techniques, what will happen is tat you would make your use of MS Excel needlessly burdensome, cumbersome, full of drudgery and you know when you’re using an application like MS Excel which is the best reporting application on the planet, it would be a shame if you then begin to struggle as if you don’t have it.
Somebody said you lie on your bed the way you make it.
The way you design your worksheets and the way you setup your workbooks to function, ultimately determines how productive you can be in your data analysis, data recording, trending and report generation.
Now, the other thing you’re going to learn is how to use range names to make your formulas more powerful. This is not exactly part of automation, in terms of the fact that you don’t really do coding to do range name creation. But your understanding of how to use range names will make your ability to do your coding in terms of using MS Excel Visual Basic code to control Excel so much more effective.
So it would save you a lot of time in making references to different parts of your workbook and worksheet, in your coding. So much so that you won’t even have to stress yourself remembering the areas of the spreadsheet you want to refer to.
I know you may not understand that now…but if you’re a reasonably experienced user of MS Excel, you will know what I mean by this. But even if you don’t. don’t worry – it will be explained to you.
One of the opportunities you have with this home study version is that I’ll be providing little tips to help you quickly kind of catch up in terms of your understanding of certain important aspects of normal Excel.use that we need to ensure you have before you can appreciate the advanced concepts in Excel Visual Basic Programming.