1 title per month from Audible’s entire catalog of best sellers, and new releases.
Access a growing selection of included Audible Originals, audiobooks and podcasts.
You will get an email reminder before your trial ends.
Your Premium Plus plan is $14.95 a month after 30 day trial. Cancel anytime.
Buy for $6.95

Buy for $6.95

Pay using card ending in
By confirming your purchase, you agree to Audible's Conditions of Use and Amazon's Privacy Notice. Taxes where applicable.

Publisher's Summary

Do you use Excel VBA often? Have you been looking for a way to up your Excel skills? Well, look no further. This audiobook is exactly what you need! 

People get caught up in the technicality of Excel VBA and waste time. This audiobook will help prevent that.

Throughout this audiobook, you will learn the following:

Tips, tricks, and time-savers such as:

  • How to use immediate window
  • How to bypass workbook_open
  • How to choose every third row
  • How to pick 500 cells or rows with just one click
  • How to use InStr function
  • How to change Excel to a PDF
  • How to undo a VBA subroutine
  • How to determine if you have a range that is held inside another range

Most common mistakes such as:

  • Qualifying your range references
  • Using .Select/ .Activate
  • ActiveWorkbook versus ThisWorkbook
  • Using variable definition
  • How to delete rows or columns in a loop properly
  • And much more!

When it comes to Excel VBA, you want to be sure of what you're doing and confident in how it will turn out. Don't continue stumbling through - get this audiobook today and improve your Excel skills!

©2018 Hein Smith (P)2018 Hein Smith

What listeners say about Excel VBA: Top Tips, Tricks, Timesavers, and Common Mistakes in VBA Programming

Average Customer Ratings
Overall
  • 5 out of 5 stars
  • 5 Stars
    53
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Performance
  • 5 out of 5 stars
  • 5 Stars
    53
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Story
  • 5 out of 5 stars
  • 5 Stars
    53
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0

Reviews - Please select the tabs below to change the source of reviews.

Sort by:
Filter by:
  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Pretty cool

Thank you very much, Sir Smith, for sharing this book with us. I'm from the commerce field and I want to learn more about Excel VBA and I found this guide very useful. I was thankful because I learned from the mistakes I've done. A solid five-star.

7 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Loved Excel VBA

Terrific lesson. I have built several Excel applications during the past few years and thought I had good techniques and habits, but this lesson identified things I should do to make them better. I appreciate the instruction very much.

7 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Fabulous

This audiobook is great for programmers of all levels. Whether you're new to Excel or totally a novice, Mr. Hein Smith provides different techniques and tips to master this course.

In it, you'll learn how to use the immediate window, how bypass to workbook_open, how to change Excel to a PDF, how to undo a VBA subroutine, and how to determine if you have a range that is held inside another range, among others.

If you are looking forward to learning Advance VBA skills just go for this course and you will not regret it.

7 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Excellent guide to follow

This book was exactly what I needed. I have programming experience so this primer was perfect. The real-life examples of problems and solutions where really fantastic as most of them I'm facing in my current projects. A good introduction and easy to understand.

I can say that Mr. Smith has the ability to explain how everything works, focusing on the most important parts, so that you not only know how to do something but also why you do it that way. This book is excellent and very professional. The content is clearly explained, well-structured, and covers many things.

I do suggest this guide to anyone interested in learning Excel VBA. Don't miss this guide even if you're a novice. Get yours as well.

7 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Well-detailed guidebook

I would say that this is a must-have book if you want to learn Excel VBA. This book is packed with some advice on the different techniques that you can use to develop custom toolbars, menus, and dialog boxes. You can, therefore, create an application in Excel that will fit your needs.

7 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Always a good choice

A friend of mine told me about this book and I could not wait to dive in. This book didn't disappoint me in any way. It helped me understand the principles of VBA and how to approach this programming language. I learned quite a lot from your Excel tricks to achieve a task. The book covers a wide variety of great tips and also provides some of the nuances for context.

Mr. Smith did a great job of explaining the subjects in a very simple way. He provides tips and tricks on how to overcome common problems. He also laid out the most common mistakes in executing VBA Excel. A comprehensive guide with a clear explanation of the VBA language and macros in Excel.

I do recommend this guide to anyone who would like to start their journey to start building excel programs. I was so glad to found it. Lots of thanks to the author.

6 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Refreshing

Very helpful and easy to understand. The author’s tips help my productivity. Highly recommended for excel lovers. If there would be 10 stars I would hit it like crazy. This is so valuable guide and helps productivity to the next level! Thank you!

6 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Good content

This book provides a good foundation and understanding of VBA so you can move on to further hone your skills. Good introduction, easy to follow and understand. Highly recommended!

6 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Awesome

Trying to figure out Excel as a complete novice was very confusing. When I listened to this book made me I feel like a pro. This book is easy to follow and understand with some actual examples of applications that helped me grasp the concepts. I was so blessed and glad to have this.

6 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Good pace to adjust

This guidebook offers tips, tricks and practical examples with all the code and sample templates you need to start your journey from humble data analyst to Excel programming pro. Take your Excel skills to the next level by harnessing the power of the VBA language. Hurry up! Get it now!

6 people found this helpful