Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Excel VBA and Macros with MrExcel 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who bought this item also bought
About the Author
Bill Jelen is the host of MrExcel.com and the author of 24 books on Microsoft Excel, including
Special Edition Using Microsoft Office Excel 2007, Pivot Table Data Crunching for Microsoft
Office Excel 2007, VBA and Macros for Microsoft Excel, Excel Gurus Gone Wild, Excel for
Marketing Managers, and Guerilla Data Analysis Using Microsoft Excel. He has made more than
60 guest appearances on TechTV with Leo Laporte and was voted guest of the year on the
Computer America radio show. He has produced more than 900 episodes of his daily video podcast
“Learn Excel from MrExcel.” Bill will entertain you while showing you the powerful tricks in
Excel. Before founding MrExcel.com in 1998, Jelen spent 12 years in the trenches as a financial
analyst for the accounting, finance, marketing, and operations departments of a publicly held company.
Since then, his company has automated Excel reports for hundreds of clients around the
world. The website answers more than 30,000 questions a year–for free–for readers all over the
world. Jelen joins us from Akron, Ohio.
Excerpt. © Reprinted by permission. All rights reserved.
Excel VBA and Macros with MrExcel
If you are holding this booklet, you love Excel. You use Excel every work day for a variety of tasks, and you want to take your Excel skills to the next level by adding some VBA macros to your skill set. This is an excellent move.
Excel VBA enables you to automate mundane processes. Whether you want some code to produce a report for every department from a data set, or simply want a quick routine to make an ugly 40-minute process disappear into a few button clicks, Excel VBA is up to the task.
Unfortunately, the Excel Macro recorder often fails to deliver usable code. To succeed, you need to learn five critical concepts. You can then combine these concepts with recorded code to produce stellar results.
The lessons on this DVD come directly from the current version of my Power Macros seminar. My assumption is that you already use Excel 20–40 hours per week. You might have taken a class in BASIC or COBOL somewhere along the way, although this is not a prerequisite. You’ve also probably turned on the macro recorder and had varying degrees of frustration with it. If that sounds like you, I can get you up to speed with writing your own macros.
© Copyright Pearson Education. All rights reserved.