• Excel VBA & Excel Macros

  • Mastering Excel VBA, Tips and Tricks of VBA Programming and Mastering Excel Macros
  • By: Hein Smith
  • Narrated by: William Bahl
  • Length: 4 hrs and 27 mins
  • Unabridged Audiobook
  • Categories: Computers & Technology
  • 4.9 out of 5 stars (100 ratings)
adbl_ms_membershipImage_includedwith_altText_B076FLV3HT
adbl_ms_membershipImage_includedwith_altText_B076FLV3HT

1 audiobook of your choice.
Stream or download thousands of included titles.
$14.95 a month after 30 day trial. Cancel anytime.
Buy for $14.95

Buy for $14.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

Trying to Learn Excel VBA without instruction is like trying to learn to read without instruction.

Do you want to become an expert in Microsoft Excel? Is your dream to become an advanced Excel Macro specialist? Whatever your answer may be, I am sure you wouldn’t pass up the opportunity to find out more about the subject. With Excel VBA & Excel Macros, you can take your Excel skills to a whole new level. This book will help you win at your daily work with some absolutely smart tricks to use.

This Excel VBA & Excel Macros book contains everything you need to know about Excel VBA and Macro programming and has the following guides:

  • A Step-by-Step Guide to Learn and Master Excel VBAs
  • A Step-by-Step Guide to Learn and Master Excel Macros
  • Top Tips, Tricks, Timesavers, and Common Mistakes in VBA Programming

Topics Covered in This Book Include:

Guide 1) A Step-by-Step Guide to Learn and Master Excel VBAs

Whether you have never created a program with Visual Basic Application or looking to learn some new tricks, then this book is for you! Containing 15 chapters full of information, definitions, and step-by-step instructions to create your own programs, this book will help you master VBA Programming. 

Here are just a few of the things you will find inside: 

  • Chapters on conditional logic, string functions, and recording macros
  • Step-by-step instructions for how to program Loops and Arrays
  • Step-by-step instructions for how to program loops and arrays
  • Instructions on how to write subs and functions
  • Written out sample codes for many of the programs you will learn how to create
  • How to diagnose and correct your own coding errors
  • A step-by-step process on how to connect the Visual Basic Editor with external data

Guide 2) A Step-by-Step Guide to Learn and Master Excel Macros

If you want to save time and increase your productivity rate, this book will help you develop the skills and knowledge necessary to navigate Excel Macros. The goal is to provide you with a step-by-step instruction and guide you on how you can create VBA macros. Aside from that, this book will help you learn how to customize your applications so that they can look and function exactly the way you want.

Inside, you are going to find topics that include:

  • Getting started with Excel Macros
  • Improving the security of your Macros
  • Learning how you can send an email in Excel Macros through the touch of a button       
  • Debugging common problems with a featured macros
  • Using VBA user forms and controls
  • And many more! 

Guide 3) Top Tips, Tricks, Timesavers, and Common Mistakes in VBA Programming

Do you use Excel VBA often? Have you been looking for a way to up your Excel skills? Well, look no further. This book is exactly what you need! People get caught up in the technicality of Excel VBA and waste time. This book will help prevent that.

Throughout this book, you will learn the following:

  • Tips, tricks, and timesavers
  • Most common mistakes
  • And much more!

So, what are you waiting for? Stop dreaming about improving your Excel VBA performance and start taking steps to make this dream a reality.

Scroll up and click the "Buy" Button!

©2019 Hein Smith (P)2019 SJ PUBLISHING

What listeners say about Excel VBA & Excel Macros

Average Customer Ratings
Overall
  • 5 out of 5 stars
  • 5 Stars
    93
  • 4 Stars
    7
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Performance
  • 5 out of 5 stars
  • 5 Stars
    92
  • 4 Stars
    8
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Story
  • 5 out of 5 stars
  • 5 Stars
    91
  • 4 Stars
    9
  • 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

Landed me a new job ;)

This audiobook is so good that it landed me a new job! Before I knew who Hein Smith was, I signed up to this audible in order to bolster my VBA skills (I had signed up to other VBA courses on Audible so I had a decent amount of understanding when it came to VBA and macros). From the start, Bahl does a fantastic job of explaining basic VBA concepts with examples.
This audible is very detailed and in depth in the world of VBA programming. It starts off simple but shifts into increasing levels of difficulty towards the middle and especially towards the last milestone project (which can seem very tedious and complicated if you are new to VBA). This course is also very intensive and can be a challenge to finish it but once completed, you will have a very good understanding of VBA.
I have done a few courses of VBA in Audible and this has to be the best VBA course, hands down! Thank you Smith for creating amazing content!

39 people found this helpful

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

Simple and Comprehensible

Took the course so I could automate daily Excel-based tasks at my job. Bahl's done a fantastic job explaining Excel and VBA whys and hows in a simple and comprehensible manner.

38 people found this helpful

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

Increased my learning expectations

Excellent audiobook, the resources increased my learning expectations. I am now far more confident to apply VBA and research its topics . In summary I have upskilled from a VBA learner to including the skill in my resume.

37 people found this helpful

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

Everything was understandable

It was an amazing audible, even if it went through a lot of topics everything was understandable. It was a very completed course, with I will definitely be consulting many times in the future.

34 people found this helpful

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

I like the content and examples.

This is definitely a great audio book. I like the content and examples. On a limited number of instances I thought a little more details/explanations could have been helpful. Overall this a very useful course and I think I have learned a lot.

33 people found this helpful

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

Covering everything

A really great course! Smith does an incredible job of covering everything in VBA from the very basic to the guru level. I learned so much from the course. The theory component was great to give a clear overview of everything you need to know to fully understand VBA codes when you see them in the wild. The more advanced sections were a breeze thanks to the strong foundation he builds up lecture-by-lecture. The 3 milestone projects were all incredibly relevant and lots of fun. Now I feel like I can tackle any VBA project. Thanks for another great course, Smith!

32 people found this helpful

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

Learning VBA

Smith provides highly applicable content which you can take away and morph into your own. The lesson on the object browser was especially helpful as much of coding is trying to figure stuff out. I hesitate to say that he should explain more in-depth as there is only so much you can explain with VBA. In a nutshell this course provides you the tools to introduce yourself to VBA as well as advanced code segments; yet you must be willing to go explore and think on your own to be successful in writing VBA code from scratch.
His team is also super knowledgeable, They don't just take your money and say bye. They help even when the question is out of the scope of a lesson.
I highly recommend this course and learning VBA as it opens up a whole new world of possibilities, and impresses those in your professional circle.

31 people found this helpful

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

Amazing Audible!!

Complete, from basic foundations to more advanced topics, and very well explained letting you understand what you are doing. I started as a newbie and have been able to automate several real tasks from my work, saving valuable time. Thank you very much Hein Smith!!!

31 people found this helpful

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

Absolute hit.

I recommend this course 100%.
A lot of learning ahead of me still, but it gave me a great base.
I was already able to create few macros in my workplace to quicken our day to day tasks.
Everything was passed in structured and understandable way.

31 people found this helpful

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

Excellent learning tool!

This was an excellent learning tool! I'm experienced with other programming languages, but not at all familiar with VBA, so this was very helpful in teaching me the unique way things work in VBA!

28 people found this helpful

Sort by:
Filter by:
  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Roxanne C.
  • Roxanne C.
  • 11-01-19

Well laid out, well thought out, & well organized.

The book is well laid out, well thought out, and well organized. Each chapter introduces new topics that builds on previous chapters. The technical details are accurate, and the code works!

9 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Jilliane Dee
  • Jilliane Dee
  • 11-01-19

You'll learn about working with the VBA

The book starts out with the very basics of VBA (Visual Basics for Applications) and recording macros. You'll learn about working with the VBA editor, ranges, loops, VBA and worksheet functions, error handling, debugging, objects, methods, properties, events, etc. By the time you've finished the book you've learned UserForms, creating custom functions, creating add-ins, and more.

9 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Jacob Ferrer
  • Jacob Ferrer
  • 11-01-19

I like the content

Very informative book. I like the content, very informative and very easy to comprehend. It was discussed and explained very well.

9 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Carl James
  • Carl James
  • 11-06-19

Good foundation and understanding of VBA

It provides a good foundation and understanding of VBA so you can move on to further hone your skills. Oh, and there are a lot of code examples in the book.

3 people found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Savanna
  • Savanna
  • 11-06-19

This book set describes in detail

Here there are step-by-step instructions for creating Macro, instructions for learning a programming language, IF Statement, power point information.This book set describes in detail the updated Excel VBA and basic features of this program. In this book, I have found a description of how to use the VBA.

1 person found this helpful

  • Overall
    4 out of 5 stars
  • Performance
    4 out of 5 stars
  • Story
    4 out of 5 stars
Profile Image for Efren Bright
  • Efren Bright
  • 07-02-20

Outstanding Value

A course that is very well structured & easy to follow. Good for people who are looking to brush up their excel VBA!

  • Overall
    4 out of 5 stars
  • Performance
    4 out of 5 stars
  • Story
    4 out of 5 stars
Profile Image for Sylvia  Livingston
  • Sylvia Livingston
  • 06-27-20

Nerd Alert!

In most cases, VBA and object-oriented language share similarity based on the objects and tools used to change the objects. The tools consist of events, methods, and properties. In other languages, these tools have different names, but they are essentially the same things.

  • Overall
    4 out of 5 stars
  • Performance
    4 out of 5 stars
  • Story
    4 out of 5 stars
Profile Image for Bruin.a
  • Bruin.a
  • 10-01-19

effective book

I found the course simple but effective. I would like to recommend this book to all my friends.

  • Overall
    4 out of 5 stars
  • Performance
    4 out of 5 stars
  • Story
    4 out of 5 stars
Profile Image for Tiger
  • Tiger
  • 09-26-19

GOOD

I found this book very helpful. I have a good working knowledge of how Excel works but needed to expand on that knowledge with learning to write Macros in VBA.

  • Overall
    4 out of 5 stars
  • Performance
    4 out of 5 stars
  • Story
    4 out of 5 stars
Profile Image for Veer Singh
  • Veer Singh
  • 09-26-19

Informative book

The information in these books was useful for me and allowed me to better understand the principles of working with Excel VBA and Excel Macros.