Your audiobook is waiting…

Excel VBA & Excel Macros

Mastering Excel VBA, Tips and Tricks of VBA Programming and Mastering Excel Macros
Narrated by: William Bahl
Length: 4 hrs and 27 mins
5 out of 5 stars (74 ratings)

$14.95/month after 30 days. Cancel anytime.

OR
In Cart

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 members say

Average Customer Ratings

Overall

  • 5 out of 5 stars
  • 5 Stars
    69
  • 4 Stars
    5
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0

Performance

  • 5 out of 5 stars
  • 5 Stars
    68
  • 4 Stars
    6
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0

Story

  • 5 out of 5 stars
  • 5 Stars
    67
  • 4 Stars
    7
  • 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!

38 of 38 people found this review 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 of 37 people found this review 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.

37 of 37 people found this review 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.

33 of 33 people found this review 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 of 33 people found this review 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!

31 of 31 people found this review 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 of 31 people found this review 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.

30 of 30 people found this review 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!!!

30 of 30 people found this review 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!

27 of 27 people found this review 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 Larry Dickerson
  • Larry Dickerson
  • 09-24-19

simply amazing

The way this book is structured and the way topics are explained it is simply amazing. I have gone through many VBA related videos/eBooks in the past but this audiobook is the best when it comes to explaining the topics. So far each topic has been explained in a very simple way that even a new user can understand it after putting some effort. Amazing experience so far.

45 of 45 people found this review helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Thomas  Buchanan
  • Thomas Buchanan
  • 09-24-19

Ideas for process improvement.

Its given me lots of ideas for process improvement. I will be going back and revisiting the various sections as I begin to create macros to use for my own tasks and datasets. Thanks, I know so much more now then when I started.

44 of 44 people found this review helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Stephen Diggs
  • Stephen Diggs
  • 09-24-19

Thank you Hein Smith and SJ Publication.

The course is good to understand and use VBA for projects.
However, in comparison to some other courses I have taken with Smith.
I will definitely need to retake this course and listen more to improve my VBA skills.
Nonetheless, it was a very useful audio book. Thank you Hein Smith and SJ Publication.

44 of 44 people found this review helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Contreras
  • Contreras
  • 09-24-19

Programmers of all levels

This audiobook is great for programmers of all levels - don't be scared if you have no experience. The ramp up is smooth and consistent and Smith starts with the basics making it applicable for all levels. All assignments are tied into real world projects and applications for added utility. 100% worth your time and money to become a more efficient power excel user

39 of 39 people found this review helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Shelley
  • Shelley
  • 09-24-19

Learned so much from

The material takes you above and beyond and you actually dabble in getting Excel to output to other applications which is great! Smith's instruction also frequently anticipate your questions and addresses them within the lecture. I have learned so much from this course. Really great value!

39 of 39 people found this review helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Natasha Palmieri
  • Natasha Palmieri
  • 09-24-19

Value for money

Really liked the way, Bahl, the instructor explained the structure and set up the instruction. It was really meaningful and help set the right expectation.
This audible is really good and intense. I loved it and it is value for money.
If you are looking forward to learn Advance VBA skills just go for this course and you will not regret it.

39 of 39 people found this review helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Angel Fisher
  • Angel Fisher
  • 09-24-19

2 create very helpful & powerful macros.

You know how to record a Macro?
You can imagine what you could do with VBA but do not understand what all those recorded lines mean in VBE?
This audio book gives you all the necessary knowledge to understand what you recorded and what VBA can do, and most important, how to write those lines in an efficient way.
A 100-line recorded macro can be written in less than 20 lines (from far!)
As usual Bahl's explanations are more than clear.
Logical statements are very well explained and demonstrated by putting them in practice.
I highly recommend this course if, just like me, you want to be able to create very helpful and powerful macros.
Thank you Hein Smith for the course!

38 of 38 people found this review helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for John
  • John
  • 09-24-19

Excellent step by step explanations

Very professional and knowledgeable, by far the best online VBA course I have seen (and I have tried quite a few...). Excellent step by step explanations, professional materials, I am really impressed. Thanks!

38 of 38 people found this review helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Mathew
  • Mathew
  • 09-24-19

It really helps

This course was highly recommended on this website, and it met / exceeded my expectations. I was familiar with VBA and programming techniques and considered myself to be intermediate/advanced in Excel. I became very comfortable in writing VBA code and even learned new Excel techniques. Would recommend to anyone interested in gaining VBA and Excel skills.

36 of 36 people found this review helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Dorothy
  • Dorothy
  • 09-24-19

Smith makes it easy

I always wanted to know how to properly use macros, but the courses are usually made by people with low teaching skills. Hein Smith makes it look easy to write macros!

34 of 34 people found this review helpful