Excel VBA LOOPS & IF function Series 2

Course

Online

£ 10 + VAT

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

Online

Start date

Different dates availableEnrolment now open

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

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

LOOPS AND IF Functions 9 lectures 04:51:13 Chapte1 Chapter2 chapter3 chapter4 chapter5 chapter6 chapter7 chapter8 chapter9 LOOPS AND IF Functions 9 lectures 04:51:13 Chapte1 Chapter2 chapter3 chapter4 chapter5 chapter6 chapter7 chapter8 chapter9 Chapte1 Chapte1 Chapte1 Chapte1 Chapter2 Chapter2 Chapter2 Chapter2 chapter3 chapter3 chapter3 chapter3 chapter4 chapter4 chapter4 chapter4 chapter5 chapter5 chapter5 chapter5 chapter6 chapter6 chapter6 chapter6 chapter7 chapter7 chapter7 chapter7 chapter8 chapter8 chapter8 chapter8 chapter9 chapter9 chapter9 chapter9 Collection LOOPS & Handle Worksheets/Workbooks 7 lectures 04:07:36 A Quick demo- What are we going to learn? Chapter 1 Chapter 2 chapter 3 Chapter 4 chapter 5 Excel Files for you Collection LOOPS & Handle Worksheets/Workbooks 7 lectures 04:07:36 A Quick demo- What are we going to learn? Chapter 1 Chapter 2 chapter 3 Chapter 4 chapter 5 Excel Files for you A Quick demo- What are we going to learn? A Quick demo- What are we going to learn? A Quick demo- What are we going to learn? A Quick demo- What are we going to learn? Chapter 1 Chapter 1 Chapter 1 Chapter 1 Chapter 2 Chapter 2 Chapter 2 Chapter 2 chapter 3 chapter 3 chapter 3 chapter 3 Chapter 4 Chapter 4 Chapter 4 Chapter 4 chapter 5 chapter 5 chapter 5 chapter 5 Excel Files for you Excel Files for you Excel Files for you Excel Files for you

Additional information

Students should be knowing the macro editor, basic range and cells commands Knowledge of variable is also required. Only basic knowledge is required however if you know each and everything about variables it is going to be an added advantage

Excel VBA LOOPS & IF function Series 2

£ 10 + VAT