VBA Classes > FAQs
VBA Classes FAQs
-
FAQs on VBA Classes Methodology
- Do I need to be online at any specific time?
- What do I need to enjoy the lessons?
- I am an absolute newbie, can I join VBA Classes?
- What version of Excel do we use in this program?
- Can I ask questions or doubts?
- What happens if I am busy and cannot log-in for a while?
- How does VBA Classes Work?
- How much time does it take to finish the lessons?
- Will I get a certificate when I finish the course?
- What happens if I finish viewing all the lessons?
- What is the difference between various options?
- What do I need to sign up?
- How can I get my company pay for this program?
- Can I get a payment receipt?
- Can I upgrade to some other option after joining?
- Or there any other payments or hidden costs?
- Do I have Money Back Guarantee?
- Are there any team discounts? I want to sign up my entire team.
- VBA Classes is pricey…
- Will there be any home work?
- What are the topics covered in VBA Classes?
- Will we be discussing about Dashboards, Advanced Excel?
- Will we be advanced topics like add-in development, Windows API, Complex Macros?
- What happens in Open Week?
- Can I share the lessons or example files with colleagues or friends?
FAQs on Options, Pricing, Payments & Discounts
FAQs on Topics & Content
Other FAQs
Do I need to be online at any specific time?No. You can watch the lessons at leisure. Each week, we will be releasing new lessons. You can log-in and go thru the lessons at your own pace and comfort. You can even download the lessons and watch them offline (if you purchase the download option).
What is the difference between various options?VBA Classes come in 4 options.
- VBA Classes – ONLINE Option: In this option, you can view all the VBA lessons online, in our classroom area. You can download example workbooks and play with the code too.
- VBA Classes – DOWNLOAD Option: In this option, you can view all lessons online and also download HD quality lesson videos for later viewing. You can download example workbooks and play with the code too.
- Excel School + VBA Classes Option: In this option, you get everything in “VBA Classes – DOWNLOAD” + you also get 24 hours of Excel training (with downloadalbe videos + Excel files).
- Excel School + Dashboards + VBA Classes Option: This one has it all. Excel, Dashboards & VBA Classes – a total of 50 hours of training and more than 75 example workbooks for you to download.
What do I need to sign up?You need a credit card to purchase VBA Classes membership. You can also make payment thru Bank Transfer & check. In certain countries, you may use your checking account to make the payment too. Optionally, if you have PayPal account, you can use that too purchase VBA Classes membership. But in any case, having PayPal account is not necessary.
What do I need to enjoy the lessons?
- A computer with a modern browser (IE, Firefox or Chrome)
- Excel 2007+ (Excel 2003 is fine too, but some lessons are suited for Excel 2007)
- Speakers or ear phones that can give you good quality output
- Time and zeal to learn
How can I get my company pay for this program?I have prepared a simple document explaining this program. Download [pdf link] and send it your boss. Since $97 (or $397) is not a big amount, your boss should be happy to invest in your skills.
Can I get a payment receipt?Yes. As soon as you make the payment, I will send you a receipt. You can use this to claim reimbursement at work. Let me know if you need any additional documents, I can provide you them. Write to me at chandoo.d @ gmail.com.
I am an absolute newbie, can I join VBA Classes?The answer to this is mixed. If you don’t know much about excel, then you should watch Excel Tutorials for Beginners series. These are 10 free videos and they should help you appreciate various features of Excel. Ideally, you should join Excel School + VBA Classes combination if you do not know much Excel.
What version of Excel do we use in this program?Excel 2007. For all the demos and videos, we use Excel 2007. Whenever we discuss an incompatible feature, We will provide some alternatives for Excel 2003. But this is not always possible. But most examples and ideas can be implemented rightaway in Excel 2003 or above.
Will there be any home work?Yes, we will have home work once every 1-2 weeks. Each home work file comes with a set of questions and an answer sheet. You can use the answer sheet to verify your answers. You can also post a comment to discuss a particular aspect of home-work assignment.
Can I ask questions or doubts?Absolutely. The VBA Classes website is similar to Chandoo.org. You can go thru the lesson and ask questions using comments feature. We will answer them as soon as possible. Not just a faculty member, any one in the class can answer the questions. If we get good questions, we may as well convert the answer to a fresh lesson and post it online. (Pls. note that we cannot answer specific questions related to your work or not related to the topic under discussion).
What happens if I am busy and cannot log-in for a while?No worries, just log-in when you have time and go thru all the pending lessons. You can read / watch them in any order too.
Can I upgrade to some other option after joining?Sure you can. You will find upgrade details & links in VBA Classes website.
Or there any other payments or hidden costs?No, there are no other payments or hidden costs other than what is stated here. You either pay $397 or $297 or $197 or $97 ONETIME. That is all.
Do I have Money Back Guarantee?Yes. Your membership comes with 30 day money-back guarantee. If you dont like the program, please email me asking for refund and I will refund the money and cancel your membership. No questions asked. And the beauty is, we are still cool.
How does VBA Classes Work?Once you pay the course fees and sign up for VBA Classes,
- You will be given a userid and password to access VBA Classes classroom
- Once you login to VBA Classes, you can go thru lessons, week by week.
- You can download example excel files, home work and videos (if you sign up for download option) for further learning
- You can ask questions or discuss topics with other classmates thru comments
- Once every week, we will send you a news-letter with information, links and discuss course progress
Learn more about VBA Classes from this guide [PDF].
What are the topics covered in VBA Classes?The following excel topics are covered in-depth in VBA Classes:
| VBA Topics | |||
| Introduction to VBA | Working with Visual Basic Editor | Writing & Recording Macros | Working with Cells & Ranges |
| Worksheets & Workbooks | Pivot Tables, Charts & More | Form Controls & Active-x Controls on Excel | User Forms – Basics |
| User Forms – Advanced | Integration with other Office Apps | Class Project | Open Week |
| Bonus Module #1: Introduction to Programming | |||
| Bonus Module #2: Debugging your Code | |||
| Bonus Module #3: Working with Databases | |||
| VBA Classes – Course Details & Brochure. | |||
How much time does it take to finish the lessons?Most lessons in VBA Classes are for 20-30 minutes. However, there will be some lessons that go on for 60 minutes. This is because some topics take more time to explain. It should take you 12 weeks to complete this program, if you spend 1-2 hours everyweek, following the lessons.
Are there any team discounts? I want to sign up my entire team.Thank you. And of course yes. If you sign up 3 or more people in one shot, you get 25% off the price, for all the students.
Please specify the quantity in order form and your discount will be applied automatically.
If you need further help, just send me an email – chandoo.d @ gmail.com or call me at +1 206 792 9480.
Will we be discussing about Dashboards, Advanced Excel?Yes. To learn Excel, go for Excel School + VBA option. To learn Dashboards, go for Excel School + Dashboards + VBA option.
Will we be advanced topics like add-in development, Windows API, Complex Macros?No. This course is aimed at beginner and intermediate level users of Excel and helps them become very good in various areas of Excel. We have deliberately avoided topics like Windows API integration, Add-in development, Complex macros so that we can focus on other important and basic concepts.
Will I get a certificate when I finish the course?You can request for a certificate when you are done going thru lessons. Around week 12, you will see a “request certificate” button. Use it to get your certificate.
What happens in Open Week?During weeks 4,5 & 6 we will ask students to suggest a few more topics to be added to the course. Based on student suggestions, we will add 3 more lessons and share them during Week 12 – Open Week.
What happens if I finish viewing all the lessons?Your VBA Classes membership is valid for 6 months from the date of joining. You are free to repeat any lessons or ask questions if you have finished all of them.
VBA Classes is pricey…$97 (or $147 or $247 or $347) is what you will earn in a few days in most countries around the world. Investing this amount to boost your career skills is a very good move. However if you are finding this as an expensive option, I can totally understand to you. Here is what I suggest. Don’t join the program. Instead, just sign up Chandoo.org newsletter or RSS Feeds. Read the blog archives in the last 3 years. There are tons of excellent articles, downloads, demos, tutorials covering practically every topic of Excel. They all are FREE. So go ahead and become awesome.
Can I share the lessons or example files with colleagues or friends?You cannot share lessons or videos with anyone. You cannot also share the bonus content (free ebooks etc.) with anyone. You can, however, share the example files with colleagues purely for work reasons (ie, if you use the example workbook to prepare a chart, you can share that).
Please note that VBA Classes content is copy-righted and protected by international laws. You are allowed one license for viewing, repeating, learning from the content. You are not given any rights to reproduce or share the content with out my explicit authorization.
You are also not allowed to share your login id / password with anyone.
We hope to see you in VBA Classes.
Email: chandoo.d @ gmail.com
US: +1 206 792 9480
India: +91 814 262 1090
About Your Teacher – Chandoo:
At Chandoo,org, I have one goal – “to make you awesome in Excel”. I have started writing about Excel in year 2007. To date, I have authored more than 350 tutorials, articles and how-to guides and trained 900 students and made them awesome in Excel. I have received prestigious MVP award from Microsoft in years 200, 2010 & 2011.
About Your Teacher – Vijay:
Vijay has been working with Excel & VBA for last 7 years. He has a wealth of VBA knowledge and very eager to share it with us. He is a regular member at chandoo.org forums. He will be teaching various VBA concepts, examples etc in the VBA Class.
About Your Teacher – Hui:
Hui works as an executive in a mining company in Australia. He is very passionate about scheduling, budgeting & simulation. He will be posting about these topics and answering your questions at our VBA Class.
We hope to see you in our VBA Class.
Links & Downloads
| VBA Classes – Join Today |
| Pricing & Payment Option – for Indians |
| Frequently Asked Questions about VBA Classes |
| VBA Class Brochure [PDF] |
Testimonials from Past Students
Fantastic! I looked high and low for courses to physically go to here in Aussieland and there were none. Books are great but nothing like seeing and doing. I really wanted to learn VBA progamming so I could develop applications for our business and do some consulting on the side.
– John Hackwood
I never expected to cover so much useful material in 12 weeks. Based on prior experience with Excel and VBA, I realize that even after the course I know only a small percentage of what there is to know. But I have a wealth of knowledge that I can put to immediate use, and that’s all I can ask at this point.
I have seen samples of other courses that were slicker, but I’ve never seen one that was as effective in conveying so much material. In summary, your course was worth every penny I paid for it. Thank you.
– Daryl Fagala
In one word: AWESOME. The videos for the most part have been really easy to follow and understand. I think the ‘practical tracks’ were extremely beneficial as they gave us a real world application of the concepts. The homework assignments were priceless – VBA is a language best learnt by doing. I think the pace of it has been quite good as well, and the discussion amongst students are useful.
– Prem Sivakanthan
The lessons so far are clear, direct and straight to the point. The lessons are practical, covering topics and areas that are/ may be to handy in work environment. I now have a much better and clearer understanding of VBA. Best investment I ever made!
– Hui Lee Phua
11 Responses
Ciao Hui,
Collecting Excel tricks under the title “Notable Excel Websites (Non-MVP) Edition” is a brilliant idea…
Thank you in the name of all The FrankensTeam.
On our site there is a box with a picture and text highlighting:
This is a no-MVP site
we think ourselves “bad boys” a bit 🙂
For those who would like to know why our site is a no-MVP site, enough to click on the link:
http://goo.gl/lxDszY
Thank you again!
Thanks a lot
I really enjoyed this (newsletter). I must admit that I rarely read an Excel newsletter (and I subscribe to quite a few) all the way though, but this grabbed my attention and before I realized it, I was engrossed in it. I must also admit that most of this I don’t understand, yet. But, it excites me when I do learn something new in Excel. I can’t wait to see how much of this I can implement into my (constantly-evolving) ‘House Budget’ & ‘Family Medical’ worksheets that I have developed over the past few years! I sure hope to see more of these type of newsletters in the future! Thanks!
Thanks for doing this Hui! I appreciate being included.
I like Tom’s tip a lot. I posted about a tool I wrote to automate this at http://yoursumbuddy.com/tables-edit-query-dialog/
EXCELLENT !
Hui, This post is Superb! More over I have always been a fan of Roberto’s work and have learnt a lot from him.
Here are some of my recent contributions
1. Customising markers in a chart – http://www.goodly.co.in/customize-markers-in-a-chart/
2. Charting Hacks to work faster – http://www.goodly.co.in/5-charting-hacks-to-help-you-work-faster/
3. 7 Date formulas to make life easy – http://www.goodly.co.in/date-formulas-in-excel/
4. Customised scrollbar using VBA – http://www.goodly.co.in/customized-scroll-bar-in-excel/
5. Adding Direct Legends – http://www.goodly.co.in/customized-scroll-bar-in-excel/
Hope everyone enjoys!
I like the Excel Ninja Menus.
1. Select a cell or range then move till the 4-way cross appears. Right-Click and drag the selection to another place in the worksheet then, like a ninja, a menu full of skills and throwing stars pops up allowing me to do all kinds of awesomeness.
2. When you click the fill box on a Date and right click and drag it down, a lot of amazing Date options pop up.
I also brand my Excel to remind myself that I’m awesome. In my personal macro workbook I place the following code.
Private Sub Workbook_Open()
Application.Caption = “SuperKrishna’s Awesomeness”
End Sub
My favorite tip goes along with #17. If you try to copy subtotaled data (and in earlier Excel versions filtered data),when you paste it all the data displays instead of just the summarized data.
To get around this, select your summarized data, click on Find and Select tab and then select Go to Special. Click Visible cells Only and click OK. Now paste and you will see that only the summarized data has been copied.
You can also go CTRL+G and then click the Special icon at the bottom of the dialog box.
What a great idea, Chandoo! I’d love to be included in your next edition:) Perhaps a VBA exclusive version?
@Ryan
I will review this concept about 6 months out from the original post and be sure to keep your site in mind
Hui…
That sounds great, Hui:) I just realized I gave credit to Chandoo for the idea and I should have attributed it to you.
Sorry about that!