In this course – We are taking a deep dive into Loops and IF Functions with Select Case statements. You will not need to look back on Loops topic ever if you finish this course till end.
Detailed discussion on For Next loops – their use and significance . How to mold them in different ways and use in your projects.
Discussion on Do –While & Until loops from very basic level to advance.
Which loop is better or how about making a choice in loops over each other.
Learn loops using the basic and complex patterns in order to get mastery.
Detailed discussion on IF functions and their different syntax’s. For example, Single IFs, IF AND, IF OR and Nested IFs.
Use of Else–IF and when to use it , How it is different from IFs without Else–IF blocks. With real time examples.
How to handle hundreds of conditions in one go using IFs.
What is the syntax of writing them. How they are used in Loops. How to write Loops and IF together to make awesome projects.
What is a Case Select statement– How it can be an alternate to IF conditions in VBA.
Why we should not run loops on F5 mode and prefer F8 – Let us understand this by using a practical code.
Courses : 8
Specification: Excel VBA LOOPS & IF – VBA Analytics Series2
2 reviews for Excel VBA LOOPS & IF – VBA Analytics Series2