View all results
0
View all results
0
View all results
0
View all results
0
Your Cart
Loading

Microsoft Excel VBA - Solving Complex Problems Using Basics

Learn VBA concepts that will boost your coding skills and give you the ability to solve complex problems

Course Preview

Get a clear picture of how this course is structured. Find out if you qualify to enroll in this course.

How are you going to study VBA?

Who should take this course?

What will you get from this course?

  • Learn Excel VBA (Visual Basic for Applications) programming language,
  • System Functions and User-Defined Functions.
  • Get a profound knowledge about Event Procedures,
  • Named Memory - Variables and Constants.
  • Learn the technique of looping through arrays
  • Learn how to work with conditional statements (the If Statement)
  • Separation of concerns
  • Learn how to write clean and easy-to-maintain code
  • Understand your program, perfect your debugging skills
  • Learn the strategy of breaking down a complex problem into solvable pieces. And much more!

Who Should Take This Course?

  • If you aspire to become a Microsoft Excel VBA coder, this is the right course for you.
  • If all you know is to record Excel macros to automate your spreadsheet, this course will help you learn how to write the code yourself.
  • If you have tried VBA coding before and it seemed too complicated for you, this course will set you on the right path.
  • Anyone interested in taking part in building a Microsoft Excel date picker.
  • It is for those who have taken and finished the Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills course.

Course Description

This course is entitled with emphasis: Solving Complex Problems Using Basics, it is designed to make you a skilled and fluent VBA programmer.


In this course, you will learn Excel VBA programming concepts that will boost your coding skills and allow you to solve complex problems thrown at you. I will teach you the art of writing complex code piece by piece using basic techniques.


This course aims to accomplish the following:

Sending clear commands to the application

  • You will learn about direct and indirect referencing of objects.
  • Learn how to achieve more results with indirect referencing of objects
  • Learn the VBA coding principle and send clear commands to the system.
  • Know the VBA language fluently,
  • understand every piece of your code.

String Manipulation

  • String manipulation is an important skill in solving complex problems.
  • With this skill, you can drastically reduce the size of your code, and target objects with precision.
  • I will teach you how to create dynamic strings with the objective of solving complex queries.
  • I will teach you how, when is it necessary, and why you should manipulate strings.

Code Management

  • If you want to be a fluent Excel VBA programmer, code management must rank first in your priorities.
  • Without this skill, your code is likely to be a heavyweight, too long, with too many duplicates, clustered and confusing

Therefore, I will teach you:

  • several ways of debugging your code,
  • the principle of separation of concerns,
  • and how to search and eliminate redundancy.

Strategies of writing an intelligent VBA code

Complex problems are won through strategy and not through sophisticated coding.

  • This means you win before you write the code. Yes, you win before you start.

In this course, I will teach you how-to strategies. This includes:

  • the naming conversation used in the programme.
  • Studying the programme and anticipating its move as if it's your opponent.
  • Choosing the best move because, in VBA, there are many solutions to a single problem. However, not every solution is perfect in all circumstances; some come with consequences.

System Function

  • We will dive into numerous built-in system functions and learn how to use them to achieve the task at hand.

User-defined Functions

  • You will learn why, when, and how to create your own functions
  • You will learn the difference between sub-procedures and functions
  • Learn how to lighten your code by teaming a variable with a function and learn why that is important.
  • Avoid common coder mistakes; use of functions where variables are the best choice.
  • Understand that not everything that works is as efficient as it seems.

Solving conditional-based problems

  • Conditional problems are solved by manipulating the execution of the code itself.
  • Learn code manipulation techniques like looping and various kinds of if statements.
  • Learn how, why, and when to use each or a combination of both.

System memory

  • Learn how to create system memories e.g., Variables, Constants
  • Learn the difference and understand when to use a variable and a constant.
  • Learn how to group related constants using an Enum

Events and Sub procedures

  • You will learn what event procedures are, and how are they different from user-defined sub-procedures.
  • You will get an in-depth understanding of the Initialize event and the click event.


I put a lot of planning into this course so that you will learn with understanding, and without overwhelming yourself. Your learning will be practical, and there is a clear step-by-step guide.


If you have tried Microsoft Excel VBA before and it seemed too complicated for you, you can try it with me. Learn the skills of writing a clean Excel VBA code, sending clear commands that can be easily decoded by the system and executed to your expectations.


So, what are you waiting for? Sign up now and I will gracefully guide you, and you will become a fluent coder in no time.


Thank you

Course Prerequisites

This is what is required from you to start this course:

  • Completion of the course entitled Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills. THIS IS A "MUST-REQUIREMENT", if you did not finish the Beginners Guide Part1, please DO NOT take this course
  • Basic understanding of Microsoft Excel VBA
  • You must be using Microsoft Excel 2010 to 365 on a Windows environment.

Checkout Options

Depending on which country you come from, you may fail at checkout. For this reason, I have added 2 alternative checkouts.


So, don't leave your product behind, try all the below checkout options.

Study here at Pundit Excel (Checkout Option 1)

Learn the secret of the best at work – sweat and stress when building and automating your project, then relax and enjoy the rest of your employment. Let your programs work for you.

LIMIITED TIME OFFER

$75
Once-off Payment: this course will be available to you for 2 years from the day of your purchase.
Show more

Study at Udemy (Checkout Option 2)

Manage all your courses in one place, this course is also available on Udemy.

Sign up now on Udemy
  • Maestro
  • Mastercard
  • PayPal
  • Visa
  • Discover

By using this website, you agree to our use of cookies. We use cookies to provide necessary site functionality and provide you with a great experience.