Excel VBA LOOPS & IF function Series 2
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
In first section of this course - we are taking a deep dive into:Loops and IF Functions.
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 loops from a very basic level.
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 syntaxes. For example, Single IFs, IF AND, IF OR and Nested IFs.
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?
Things can be asked from a VBA interview perspective- detail discussion on the preparation of interview as well with live projects.
Whether it is a combination of IF with For next or Do Loops - we are discussing everything here taking great examples.
How to write sub-loops in loops- you will find all relevant information here.
SubLoops can be of multiple levels. SubLoops can be of For Next or Do while loops and we learn not only how to write loops of the same type but also a combination of for next and do while.
Assignments for your practice and to monitor the self-performance as to how well we understood the series and use of Loops along-with IF Functions.
To help you in growing faster and be able to the assignments, questions prepared for you, Online assistance to students is also given personally by me. Students can ask questions related to the loops series and get their doubts cleared on an immediate basis.In second section of this course you will:Learn how to work with workbooks and worksheets.
Facilities
Location
Start date
Start date
About this course
Students will be able to use the loops in projects.
We will be able to make conditional statements and use them in loops efficiently.
VBA can never be imaged without IF conditions and Loops. So, you can imagine what are you going to gain after this series.
Data compilation from hundreds of sheets and workbooks will not be a challenge anymore.
Not just data compilation but any kind of work if we want to do on multiple sheets or workbooks can be easily achieved now.
Learn how to open, add, delete, close, copy or rename the sheets and workbooks and many more things.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 4 years
Subjects
- MS Excel
- Excel
Course programme
Additional information
Excel VBA LOOPS & IF function Series 2