Microsoft Excel VBA – Solving Complex Problems Using Basics
Become a fluent Excel VBA coder
What you’ll learn
-
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 a clean and easy to maintain code
-
Perfect your debugging skills
-
Learn the strategy of breaking down a complex problem into solvable pieces
Requirements
-
Basic understanding of Microsoft Excel
-
Completion of the course entitled Microsoft Excel VBA Fundamentals – Learn Basic Coding Skills
-
You must be using Microsoft Excel 2010 to 365
Who this course is for:
- 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
- If you have tried VBA coding before and it seemed too complicated for you
- Anyone interested in building a Microsoft Excel date picker