Who else wants to learn about
Macros and VBA in Excel 2010
with this effective training course?
No matter what industry you’re in or what form of business you do, what I’m about to share with you can skyrocket your ability to learn, launch you onto the next stage of your career and increase your productivity and income!
As an Excel user, how would you like to:
- Eliminate boring, repetitive, time-consuming tasks
- Get things done much faster with Macros in Excel 2010
- Stand out from your peers who do not know about Macros
- Create your own macros using VBA (Visual Basic for Applications)
Why should I learn macros in Excel?
Here are some great reasons why you should learn macros in Excel.
- They increase your impact – get things done faster
- They boost your productivity as your efficiency increases and you free up time to be more effective personally.
- Once you create a macro it will run tirelessly and consistently, the same thing time and time again.
Macros make you super fast!
When you do repetitive tasks in Excel it’s a bit like writing out everything by hand. Imagine how long it would take for you to write out a report that was 50 pages long that included graphs and tables. I imagine it would take a mighty long time to write out by hand, not to mention all those mistakes you’d make as you went along.
But when you do repetitive tasks in Excel with macros, it’s like having a modern laser printer in your office. Now instead of writing out every single line and graph by hand, you can sit at your desk and press the print button and the printer will churn out 50 pages in almost no time at all. Of course the printer can still run out of ink but that’s a different story!
What’s the difference between Macros and VBA?
Now, you may also have heard about VBA and in brief here’s the difference between Macros and VBA:
- A macro is a series of actions that you record, and you can repeat these actions as many times as you want by asking Excel to replay the macro.
- VBA is the programming language that macros are recorded in (remember, VBA = “Visual Basic for Applications”). With VBA you can add some brains to your macros and turn them into intelligent programs, for example you can ask the user to type in their name and store that in your program.
“Excel 2010: Macros in Depth”
My hand-picked course “Excel 2010: Macros in Depth” will help you learn both macros and VBA from the ground up. If you are new to macros and VBA this course will easily save you months of stumbling around searching for scattered bits of information about macros and VBA on the web.
In my recommended course you will learn about:
- creating macros by recording keystrokes
- expanding macros for more than one task
- making macros available to all Excel workbooks
- launching macros with shortcuts and buttons
- editing VBA code and making sense of the VBA environment
- how to debug and test macros via Step Mode and Split Screen
- how to expand the power of macros with DO loops and IF commands
Plus: Step-by-step Macro Project
Your course instructor Dennis Taylor will take you step-by-step through a Macro Project, at the end of which you will have macros that will convert a mailing list into a database list.
You will see how it’s possible to record partial code, how to use loop structures in a real-life context, how to test your macros in Step Mode, how to pull data together, how to join two macros and how to streamline macros.
Get access to this Course
Q: How do you get access to my recommended course on macros and VBA in Excel 2010?
Simple – subscribe to Lynda.com, a leading interactive learning platform. A lot of people in the creative industries love Lynda.com as it provides an amazing range of training courses covering Photography, Video and Web Design but Lynda.com also has great learning material for business users.
Subscribe to “Lynda.com”
You see, the “Excel 2010: Macros in Depth” course is one of more than 200 business courses available on Lynda.com. When you subscribe to Lynda.com you will get access to over 100 Microsoft training courses covering:
- Microsoft Access
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Word
- and more
… all included in one great value subscription. These courses are created by competent trainers who have years of experience, and are supported by the great online learning system that Lynda.com provides.
The reason a Lynda.com subscription is great value for many people is that there are over 1,000 other training courses available. Obviously you won’t be interested in all of these, but they are available to you if you subscribe.
Perhaps you have an interest in Photography, or want to learn more about Home Computing, or are interested in some of the Productivity, Project Management or Business Skills courses.
With a Lynda.com subscription you’ll be spoilt for choice like a kid in a candy store. The last time I checked in December 2011, there were 1,194 courses available on Lynda.com and of course lots being added every month.
Note: The catalog is free to browse and you can check out my recommended macros course by clicking here right now, and you get free sample videos to watch so you can assess all the courses on Lynda.com before committing to a subscription.
Lynda.com Customer Testimonials
Q: What are other people saying about Lynda.com?
You don’t have to take my word for it. Listed below are numerous testimonials from people who have benefited from subscribing to Lynda.com:
Learning to love spreadsheets
I never thought I would learn to love spreadsheets and databases, but your courses are so clear and do not assume prior knowledge. I also like that in each chapter/topic there is a short summing-up of the previous topic so that there is continuity after a break.
Perfect for me
These tutorials were perfect for me. Very easy to use. Very easy-to-follow directions that were laid out in a step-by-step format. I am not a network administrator but I do have a heavy computer background and servers have always been a mystery to me. I can’t thank you guys enough for these excellent video tutorials.
I look forward to “school” each day”
I want to thank you for your excellent product. I am currently building my own business again (after 10 years in corporate settings) and part of each day is dedicated to adding new skills and polishing familiar ones. Lynda.com is the best value around! I look forward to “school” each day. Thank you from one very happy customer.
The finest available today
Lynda.com—including staff and phone support services—is a completely wonderful site. The online library of tutorial-style videos is the finest available today. Thank you for providing the highest quality in product and customer service.
I want to learn it all
I just have to write you all! I love Lynda.com! My only regret is that you have so much great training that I don’t have enough time to view everything I want to. I want to learn it all and now you’ve added time management training. That will have to be next so I can find more time to view more training I want! Keep up the good work and the communication about your team. Love to hear what is going on.
Your educational value is excellent. I’ve remained a subscriber because I appreciate the quality of your service, and I’ve recommended you to several people.
I love all the tips and tricks
Lynda.com ROCKS! It’s saving me so much time from scouring YouTube for tutorial videos!! YAY! I love all the tips and tricks from the instructors. And they make everything easy to understand… Just wanted to express my gratitude. Thank you all at Lynda.com!
SUBSCRIBE to Lynda.com
Q: How much does it cost to subscribe to Lynda.com?
The standard monthly subscription is only $25.00, which gives you access to all 1,000+ courses on Lynda.com for one month. There’s no joining fee and you can decide to stop your subscription after one month with no obligation to continue subscribing.
And if you want to resume your membership, Lynda.com will remember your account for the next time you want to subscribe – with records of what courses you’ve looked at so far and which videos you’ve watched so you don’t need to worry that you’ll forget what you learnt.
Q: What is the Premium plan?
For only $37.50 per month, you can become a premium subscriber which gives you access to course files that are used by the instructor. This means you can download the same documents used in every training course and follow along doing exactly as the instructor does.
This represents extra value and will help you learn faster. So that’s the premium monthly subscription at $37.50 per month. Again you can stop your membership after one month with no obligation to continue subscribing, and also pick up again where you left off if you decide to resume your account. All for the low price of $37.50 per month.
Q: What is the Annual plan?
There are annual subscriptions where you get 12 months membership for the price of 10 months. The basic annual subscription is $250.00 and the premium subscription is $375.00.
If you’re lucky enough to have your company pay for your training then this might be a great way to save money over the course of a year. With the annual subscription you save $50 over one year, and with the annual premium subscription you save $75 over one year.
Great features of Lynda.com
- Get access to over 100 Microsoft training courses – learn about Access, Excel, PowerPoint, Word and more… all included in your subscription.
- Get access to over 1,000 other training courses – Lynda.com offers a staggering choice of online training courses and you’ll probably find lots of things you’re interested in. The catalog is free to browse and you also get free sample videos to watch.
- Control the pace at which you watch videos – Pause, rewind, play at half speed and twice speed. Watch as many times as you want or skip topics you don’t want to watch.
- Instructors words are transcribed – Get word-for-word transcribed captions for every video, nice if English isn’t your first language or you didn’t catch a bit of terminology.
- Benefits of premium membership – Download course files to follow along with the videos. These are the exact files used by the instructor in their videos.
YES – I want to subscribe now
I think you’ll agree that this represents incredible value for money. Not only will you learn about Macros from a very experienced instructor, you will also get access to over 1,000 other training courses at no extra cost!
So if you’re ready to take this opportunity please click this link and use the subscribe button. Note that this is an affiliate link, and if you buy a subscription on Lynda.com after clicking on this link I will get a commission from Lynda.com. I appreciate your time in considering this course and hope you find the free videos useful.
If you’re mainly interested in the Macros course I would recommend joining on a monthly premium subscription, where you pay one month at a time and have no long term commitment beyond a single month. The premium package gives you access to the same files that the instructor uses in the Macros course, which is great for following along on your own computer.
Cost saving of annual membership
If you’re keen to training in other programs such as Word, Access and Powerpoint I would recommend having a look at the annual subscription plans. Remember you get 12 months access for an up-front payment of 10 months, saving you the cost of 2 months membership fees – very good value!
- This saves you either $50 a year (standard) or $75 a year (premium)
- Get smart cost savings with the Annual membership for $250 a year
- Get best training value with the Annual Premium membership for $375 a year
Ready to take this opportunity and start saving with an annual plan? Click this link, use the subscribe button and choose the annual plan of your choice. Note that this is an affiliate link, and if you buy a subscription on Lynda.com after clicking on this link I will get a commission from Lynda.com. I’d like to thank you in advance for considering Lynda.com and stopping by at Launch Excel.
P.S. Remember you can get 12 months for the price of 10 if you subscribe to an annual membership. Go check out Lynda.com now by clicking here.