Latest Courses
Python programming Bible - From Beginner to AdvancedCheck course
Learn Pro Advanced Python ProgrammingCheck course
Javascript Certification practice using HTML5 , HTML, CSS3Check course
JavaScript for BeginnersCheck course
Data Science, Deep Learning and Machine Learning with PythonCheck course
Learning Path: Java: Natural Language Processing with JavaCheck course
Cloud Migration on AWS and Microsoft AzureCheck course
Cyber Security: Mastering Linux SecurityCheck course
Data Science:Hands-on Covid-19 Data Analysis & VisualizationCheck course
Learn Node.JS from Beginning to Mastery 2020Check course
Python programming Bible - From Beginner to AdvancedCheck course
Learn Pro Advanced Python ProgrammingCheck course
Javascript Certification practice using HTML5 , HTML, CSS3Check course
JavaScript for BeginnersCheck course
Data Science, Deep Learning and Machine Learning with PythonCheck course
- 78% Become an Excel VBA Troubleshooter: Save Time and Earn More

Become an Excel VBA Troubleshooter: Save Time and Earn More

$49.99 $10.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.9/10 (Our Score)
Product is rated as #9 in category Excel

*** Course last updated on 29th August 2019 ***

This course is designed to take your basic VBA skills and quickly move you into the intermediate category.  You can probably already put together most of the way there programs.  These will usually have some form of problem (even if you don t realise it).  They might have calculation errors, be a bit slow or break under specific use cases.  This course will teach you to track down and fix these problems and then how to restructure your code to prevent such problems and handle run time errors in an effective way.    

A VBA Troubleshooter is a valuable team member.  You will quickly find people coming to you for help and advice.  Your CV will look much better and it will put in a great position to negotiate a pay rise or even use this as the first step in a new career. 

Some assumptions about you

Let s agree that you are highly motivated, want to learn new skills and want to get ahead in life.  Maybe you want to earn more in your current role, maybe you want to enhance your CV or maybe you want to switch careers.  Let s also agree you are willing to put in the time and effort to learn new skills yet want to do so in an efficient and effective way.  Finally, let s agree you believe in getting what you pay for.

Instructor Details

Hi Everyone! My name is Paul and I'm a Udemy learning junkie. I found Udemy in late 2015 and by mid 2016 created my very first Udemy course and officially became a Udemy instructor. I'm a total Geek and find it hard to sit around and do nothing - building Udemy courses is just one of the various projects I find myself doing in my spare time. It takes a lot more work than I expected to build a course but I have found I really do enjoy it. My goal on Udemy is to rank among the top instructors within the first 3 years. This is ambitious and will take a lot of work. It's also something I can't do on my own: only with the feedback and support of my students will I stand any chance of making this happen. Academic Background My undergrad degree was in Aerospace Engineering (MEng). During this I found I was far more interested in the mathematics and programming than Engineering so I did a masters degree in Pure Mathematics (MSc) and a PhD in Computer Science (Cryptography). After finishing my PhD I started working as an Actuary and I have just finished the UK Institute and Faculty of Actuaries (IFoA) fellowship qualification (FIA). Coding and Teaching Related Experience My first encounter with coding was when I learnt Fortran as an engineering undergrad. Later when working on undergrad and MSc projects I learnt to code in Matlab (using m-files) and then in C. My coding skills only really took off though when I working on my PhD. The computer science department I was in only used Linux - I quickly had to learn use Linux operating systems, shell scripting and teach myself C++. It was here where I learn object orientated coding techniques and built some very complex and fast code (mostly for integer factorization). When working in Actuarial related roles I have had to master Microsoft Excel, Visual Basic for Applications (VBA) and C#. In my current role as Actuarial Systems Technical Lead for a major UK Insurer I mainly deal in VBA and C# code. In addition I take care of the Actuarial Infrastructure and various modelling platforms. I started out teaching when some work friends noticed me coding in VBA and asked me to teach them. I said okay and my first attempt was a series of informal emails with links, a list of topics to cover and exercises to enforce the concepts. This gradually grew into a website of it's own and later into full blown Udemy courses. In addition I provide actuarial system training internally as part of my day job (it's wide and varied!). Outside of Work For a number of years I have spent my free time studying for the IFoA fellowship exams. Now that these are done I find myself spending more time learning other things (coding, foreign languages - learning German at the moment). I keep myself in shape with regular trips to the gym to lift weights and running.

Specification: Become an Excel VBA Troubleshooter: Save Time and Earn More

Duration 4.5 hours
Year 2019
Level All
Certificate Yes
Quizzes Yes

8 reviews for Become an Excel VBA Troubleshooter: Save Time and Earn More

4.8 out of 5
6
2
0
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Azian Mohd Azhar

    An eye opener Instructor’s delivery is very clear, made simple and straight to the point during walk through of the work examples. It is as good as having a 1 2 1 class on how to troubleshoot. I can tell how passionate the instructor is on the subject by his generous tips and short cuts on how to use create an easy to understand, clean code, as well as the various debugging/error handling tools available, which I have not realized are present in VBA environment before, and will prove useful in my daily practice. This is definitely one of the best practical lessons I’ve had on troubleshooting in VBA, and is value for money! I recommend going through these lessons as a beginner attempting to code in VBA, so you can get into good habits or even as an intermediate level coder.

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Matthew

    Half way through this course, I have tried to construct a macro module to aid my daily Excel task. I was able to complete the work promptly thanks to the tools and methods introduced, such as add watch and immediate window, throughout the lectures. Having seen the benefit, I am now highly motivated to carry on and will definitely recommend this course to everyone who wants to improve their debugging skills!

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Will Xue

    Paul, the instructor, is very active in helping every learner, at least me, to resolve all the potential problems which can be either technical support or content specialization.

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Mike Sedelmeyer

    Great content and great approach to teaching the content. This course does a great job showing how to apply coding best practices to (1) make your VBA code and syntax more efficient, more readable (to yourself and others), and easier to debug; and (2) test and debug VBA code methodically and professionally using all of Excel’s debugging tools.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Robert Elliott

    Extremely clear at explaining difficult subject matter

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Paul Adamczak

    Verbal and visual instruction was very clear. Nicely paced. Great sound quality. Answers to quiz questions included additional information about the selected answer (right or wrong), which was also helpful. What I did not like was the use of a quadratic equation as a main example. At times I found it distracting to both stay focused on the calculation (to some extent, like knowing what value/variable is in play) and to be learning the teacher’s main concepts. A more general example would have been better for me, and definitely more memorable letting me more easily recall the lesson ideas long after finishing the class. I also found the use of text box overlays at times distracting. Since they often repeated spoken details, I assume they are meant to reinforce ideas. But I had to frequently hit pause or rewind in order to confirm text was merely repetition because a few times this text was additional info. Maybe pausing briefly when such boxes appear would be better? Currently, it seems like by by not pausing for student the suggestion is to overlook them. One minor suggestion is to mentioned that the IMMEDIATE window box can be positioned below the CODE window so user can see both simultaneously, which makes actual work quicker sometimes. Again, it’s a preference. (I understand for training purposes you might want to constantly open and close the IMMEDIATE window instead.) I disagree slightly with the teacher’s somewhat absolute opinion that comments should only be included to answer Why not What (is being done by code). Yes, properly naming variables, methods, etc. does help. But we have extensive code and limited coders so it’s much easier to first skim the WHAT comments throughout to quickly visualize an outline of the intent and where these steps (possibly discussed in a summary at the top of method) happen vs. seeing only the summary and having to scroll around constantly. (Yes, keeping each method as short as possible is good. And yes, such additional commenting is a preference.) For us, the risk of being distracted by over commenting may exist, but being confused by naming and lack of comments (one coders clearly named variable is another coder’s head scratcher) is a real time waster. We error on the cautious side. Finally, including What comments at appropriate places in the code also helps our understaffed team satisfy a general contract obligation for legitimately providing ample code documentation. So it’s a two for. This is a great course and I recommend it.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Nadia Maguire

    lecturing is clear and concise I’m able to understand and follow what is going on.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    TomFox

    A great reminder of some basic essentials of developing in VBA.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Become an Excel VBA Troubleshooter: Save Time and Earn More
    Become an Excel VBA Troubleshooter: Save Time and Earn More

    $49.99 $10.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare