Listen free for 30 days

£7.99/month after 30 days. Cancel anytime

Summary

The programming language known as Visual Basic for Applications operates using Visual Basic 6, a simple type of programming language, which, once you get the hang of it, can be used throughout the Microsoft Office Suite of products. From this audiobook you will discover step-by-step instructions that will lead you through the process of creating your very first macro before expanding on that knowledge in a wide variety of ways to ensure that you will have the tools you need to create macros that will be able to handle a wide swath of commonly used tasks. It doesn’t matter what your current familiarity with Excel is, once you master VBA, you’ll have Excel purring like a kitten.

From this audiobook you will learn:

  • The easiest way to access the VBA potential hiding inside all of Microsoft Office’s products
  • Simple steps to associate macros with data pulled directly from Excel worksheets and cells
  • Tips for utilizing an identifying a wide variety of different key variables
  • Key points to consider when writing if/then statements
  • Simple ways to replicate a variety of process across multiple cells or worksheets
  • A variety of options when it comes to finding specific sections of data amongst complicate strings
  • Common mistakes that novice VBA programmers make and how to avoid them
  • Debugging and error solving tips 
  • And more…

It doesn’t matter if your business has three employees or 300, you are likely generating far more information that you may realize, and certainly far more than you are likely tracking effectively. Understanding what this data truly means starts with managing it successfully which is where the process of data analytics comes into play. 

On average, there are roughly two quintillion bytes worth of new data created each and every day which means that knowing what to do with it is easily a full-time job. Luckily, there are a wide variety of options out there when it comes to focusing in on the data that you want to use and using it in the most effective way possible. This audiobook will teach you to find all the tools you are going to need in order to do just that, regardless if you are part of multinational conglomerate or are running your own startup. 

Having the right data means being able to make the right decisions about your future because you know what your customers want, often before they do. Making the right decision in the moment means understanding the potential that this bundle of 10 audiobooks is offering and making the choice to go ahead and buy this audiobook! Your future, more successful business will thank you. 

So, what are you waiting for? Buy this audiobook bundle that teaches you everything about Excel programming and data analytics.

©2018 Daniel Jones (P)2018 K.M. Kassi

What listeners say about Programming for Beginners: 10 Books in 1- 5 Books of Excel Programming+ 5 Books of Data Analytics

Average customer ratings
Overall
  • 5 out of 5 stars
  • 5 Stars
    47
  • 4 Stars
    2
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Performance
  • 5 out of 5 stars
  • 5 Stars
    47
  • 4 Stars
    2
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Story
  • 5 out of 5 stars
  • 5 Stars
    47
  • 4 Stars
    2
  • 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

Easy read for planning your next analytics project

Big Data analytics let us predict and monitor how disease outbreaks and epidemics are developed. Getting data from medical records by using social media analytics allows us to monitor outbreaks of the flu just be watching what people are saying like: “Not feeling well. I feel feverish.”

Many sports have embraced Big Data. There is the IBM SlamTracker tool that is used for tennis. Video analytics are used to track all players’ performances in baseball and football games. Sensor technology is being put on equipment like golf clubs or basketballs gives feedback on how to improve our game. Many teams will track their athletes outside of the arena by using smart technology see how well they sleep and what they eat. They also use social media to watch their emotional wellbeing.

The NFL has created a platform of applications to help all the teams to make better decisions from one player’s performance, the weather, or the grass on the field. This is the help with strategies and helping to lessen player injuries.

24 people found this helpful

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

Innovative treatment.

One big difference that you will find between the modules and a word processor is that the will complain about all the words that you type, regardless of whether the words are right or not. This is because the module checks for the accuracy of the commands that you type in, rather than the syntax and grammar of your sentences. This can be handy when you are first getting started with programming, and you are more likely to make mistakes.

It is also important to look at the underscores that are placed at the end of some of your lines. This is used to ensure that the program will read the two lines of the code together. This is important if you end up splitting the command, so it is on two lines. You should know that underscores are one of the characters known as continuation characters and it indicates that a given instruction doesn’t end on one line. You will find that the module will read the code whether you add the underscore or not, it is easier to do this because it breaks up the lines to make the code easier to read.

This may seem like a lot of information to keep track of, but you may not need to use all of it in the code. It depends on the type of data that you are looking for inside of the code. Sometimes you will need to have all of these parts and other times you may only need to have one or two parts to make the code work.

22 people found this helpful

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

A great Excel macros course for beginners!

I'm more of an auditory learner so the voice is extremely important to me. This narrator has a very pleasant,clear and steady voice. I'm also liked the thoughts of " It doesn’t matter if your business has three employees or 300". It's well structured. I think this is very good for people with really long term attention span. You can listen anytime anywhere in mobile phone, practice the immediate learning point, then move on within minutes. It also convey a quick feeling of accomplishment and progression as apposed to a lengthier, beefier lecture.

20 people found this helpful

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

Excellent for beginners - though some information

This is fairly straightforward to start, but quickly becomes more and more complicated due to the fact that objects can also have other objects as properties. As an example, if you are looking at Application as an object then it can have numerous different workbooks as objects of its own as some of its associated properties. These workbooks, then, could have numerous different worksheets as objects of its own and these would all then have cells that are considered property objects as well.

This nested functionality is known as the object hierarchy with the application at the top, followed by the workbook, followed by the worksheet and then followed by the cell range. Each cell could then have objects associated with its various properties as well, though you will rarely need to get that granular.

When it comes to using VBA with Excel, the system is likely to seem cumbersome at first. Perseverance is key, however, as once you get a better feel for the arrangement of various objects your speed will increase. VBA also features an object browser that will allow you to view your modules hierarchy and choose objects from the list directly. This will, for example, all you to press F2 when looking at a worksheet and see its specific Range.

19 people found this helpful

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

Instructor easy to listen to. Good pace.

I really enjoyed this course. I think it's a very good course for beginners. I have to admit that I didn't like any coding in the past. When every time I needed to use some coding, I felt like I totally got stuck. But somehow I think it'd be very convenient and efficient if I can have some coding skill. That's why I decided to learn VBA. This audiobook is very clear and easy to follow. At least it builds up beginner's confidence after taking this course. which is A+++. Many thanks for this course, which is very helpful.

18 people found this helpful

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

Well sequenced 10 book bundle

This is an completely new filed with zero knowledge on the concept. Now i am looking forward for other courses and start implementing them

17 people found this helpful

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

Finally it makes sense!

The language operates using Visual Basic 6, a programming language that was extremely popular for a time before Microsoft created the .NET languages. Currently, VBA is the last bastion of Basic that most people are going to encounter. Even better, once you get the hang of it, you will be able to easily automate a wide variety of different functions. The language struggles when things get to complicated, but as long as you don’t expect too much you will save yourself a serious amount of time in the long run. What’s more, a variation of the language is also found in other Microsoft Office products and you will be able to adapt what you learn here with little extra effort. It is also important to note that if you are using a newer version of Excel then you might have a harder time accessing the VBA functions as they have been mostly buried to keep them from intimidating newer users. If you followed these steps correctly you should now be able to find the ribbon of developer tools from the main screen. If you can’t both see the ribbon and run a program, then something hasn’t been configured correctly.

16 people found this helpful

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

Covered most of the things

The topics covered are quite comprehensive, explanations are clear and easy to follow, and also practical. I have an excellent background in programming and still have found the course very instructive and beneficial (I am half way through the course). I recommend this course to whoever wants to learn Excel VBA from zero.

16 people found this helpful

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

This lays a solid foundation

A very comprehensive introduction on getting started with world of Data. This lays a solid foundation for one to get started with other data aspects such as Data Analytics and Excel programming.

15 people found this helpful

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

Makes things easy

Great Course! Daniel makes things easy even for people who do not have any programming experience like me. There are many useful tips. I have applied many things to my daily routine. Good examples, good rythm... It's passion and good humour are contagious.

15 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 Dollie  Ring
  • Dollie Ring
  • 29-05-20

Analytics, all about achieving results

Big Data can be used by individuals. It isn't just for governments and companies. We can benefit from data we get from devices we wear like smart bracelets, watches, etc. Think about the Up band or a Fitbit. This armband collects our sleep patterns, activity levels, calorie consumption, and other data. It can give us insights and value. We can see this value when we look at the data it has collected.

This unlocks a huge realm of small data. Since Big Data is looking at huge amounts of information and then looking for patterns, small data is analyzing the data for just one product like a container of yogurt within large shipment and knowing if it will go bad before it hits the store.

This holds promise for improving anything from health care to logistics. We are just on the edge of understanding what this technology can actually do. Just like when electricity was only used for light bulbs.

24 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 Roberta
  • Roberta
  • 07-06-19

Logic explanations of what is happening

Daniel really delivers on what he says he will. He takes you through complete basics and slowly builds. It's not intimidating at all, and there are so many resources every step of the way. He's not just giving you information, He's explaining it, explaining it in context & giving you a way of working with the information so that it makes sense, so you walk away understanding why a concept is important and how to relate it to your own work. This was exactly what I needed. A great buy for $25. Thank you so much!

23 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 Darnell
  • Darnell
  • 07-06-19

Very professional

Bahl has a clear voice, pace and tone of the lecture is excellent. He command an absolute knowledge of the subject matter, and very professional, also excellent on debugging and error solving tips.

22 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 Sidney
  • Sidney
  • 01-06-20

Math Works

I have been wanting to learn VBA for years. This course made it simple and fast to learn it. This is easy to understand in the beginning, but it can become complicated because some objects will have other objects as their properties. An example of this is when you are looking at an Application as an object and that Application has numerous workbooks as objects of its own as some of its associated properties. These workbooks, in addition, could have their own worksheets as objects, and these would have cells that would be the worksheets properties as well.

Once you have a good handle on the object hierarchy, you can work to simplify the process of finding specific details that you need to use. To start, when you write out the reference for a specific set of properties, you will not need to write out the full name because some things will be filed as you go along. These default phrases will always relate to the object of the required type that is currently active.Once you have a good handle on the object hierarchy, you can work to simplify the process of finding specific details that you need to use. To start, when you write out the reference for a specific set of properties, you will not need to write out the full name because some things will be filed as you go along. These default phrases will always relate to the object of the required type that is currently active.

Big Data analytics allows us to decode a whole string of DNA in just minutes. This lets us find new cures to predict better and understand disease patterns. The data from wearable devices and smartwatches can be used to determine various diseases from millions of people. The future of clinical trials will not just be small groups but might include everyone.

21 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 Mandy Palmer
  • Mandy Palmer
  • 07-06-19

To make the right decisions

Great beginner's audiobook to understand how data really works. There are so many tools, to-do's, and what to learn next out there but this course really gives you a brief understanding of many general terms, how analyst go through their workflows and the main tools they use in their day to day work. The whole 10 book bundle audiobook also summarizes the people you'll be working with, the different functions in the data world, and related key functions of how you get your data and why it matters.

21 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 Marisol
  • Marisol
  • 07-06-19

Easiest way to access the VBA

Many courses I've either taken, or seen, try and teach you about VBA but fall short on practical application. This audiobook does both, and well. Each chapter within exact short time I've taken this course I've learned more than all the other courses combined!

20 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 Sean Johnson
  • Sean Johnson
  • 07-06-19

Buy this audiobook bundle

Absolutely brilliant Daniel! This is the best Excel course I have taken and I love that you provide and build real-world examples of using VBA! I have learned a lot from you and no matter your skill set in Excel or VBA, you will definitely learn something new!

19 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 Elizabeth
  • Elizabeth
  • 07-06-19

Everything about Excel programming & data..

This audiobook was just what I was looking for. I am a total newbie in regards to Excel VBA programming. This gave me a higher-level overview of all aspects of Excel VBA with just enough detail of each aspect to let me know what's available. Each parts that were more pertinent immediately for me, I could then go explore in more detail on my own.

18 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 Joyce Simmons
  • Joyce Simmons
  • 07-06-19

To know what your customers want

The information was clear and easy to understand. I learned a lot of valuable information! My only constructive feedback would be that I would have liked it to be a little bit more engaging as I caught my mind wandering a few times throughout the course. Even the narrator talking in the voice would have helped keep my attention focused.

17 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 Willie Garcia
  • Willie Garcia
  • 02-06-20

Guide to effective data strategy

Big Data can help devices and machines get more autonomous and smarter. Google’s car that can drive itself is powered by Big Data tools. There are cameras, sensors, computers, and GPS on the Toyota Prius that helps it drive safely without any intervention from humans. Big Data tools can also optimize how well computers and data warehouses work.

Big Data is helping to improve law enforcement and security. Big Data is being used by The NSA to look for and stop attacks on the United States by both foreign and domestic terrorists. They possibly use Big Data to spy on everybody. Big Data is being used in different offices to locate and put a stop to cyber-attacks. Big Data is being used by police to predict criminal activity and to catch criminals. Credit card companies use it to find fraudulent activity.

Big Data is used a lot in High-Frequency Trading. Algorithms are used in making decisions about trading. Data algorithms are being used in the trading business by utilizing news websites, and social media networks to sell, buy, and make decisions in just a matter of seconds. Complex algorithms are programmed into computers that scan the stock market for certain conditions and search for opportunities to trade. These programs are designed to work with or without humans. It all depends on the needs of their client.

It is fairly easy to become a data scientist. When you can get the art of data analysis right, you just need to practice your new skills so you can become proficient.

16 people found this helpful