Excel VBA Collection Loops with Sheets Handling Data - Series4

Goals

• Do you not want to compile data from different worksheets and workbooks? How to go to different workbooks pull the data from there and compile it in one place. 
• How to work with so many sheets without bothering about things - what name they have, if they will get deleted in future or if more sheets get added. These collection loops make you a great programmer. If you do not know this you can never be a great coder. Come and fall in love with them. Immensely helpful, interesting and powerful. So much fun.

• Learn how to work with workbooks and worksheets.

• How to open the workbooks, how to close one workbook, a specific workbook or all opened workbooks.

• Learn how to delete or add workbooks, and how to jump from one workbook to another. From activating files to editing them -we are covering all.

• How to select or delete protect rename or add the worksheets in Excel.

• How to define the workbooks and worksheets in a professional manner using the "Set" Keyword. What is the advantage of declaring objects as classes?

• What happens if we declare set statements anywhere in the code? Is it allowed in VBA? Detailed discussion on the proper mentioning of dim and set statements while dealing with objects and classes.

• How VBA works when it comes to writing syntaxes. Discussion on the object hierarchy and its methods and properties.

• Questioning rounds in a live session to students to practice more on set keywords.

• What are collection loops and their basic syntaxes - their practical use?

• Loop through worksheets in a workbook.

• Loop through workbooks one by one when they are opened.

• Hoop through cells in range and see the use of those collection loops in projects.

• How to work with multiple sheets like hiding or unhiding them.

• How to copy and paste the data from each of the sheets in a workbook.

• What if you want to copy the data from multiple workbooks, going to each of the worksheets copying the data and pasting it in one single workbook? This is going to be done using a collection loop.

• What is a dot operator and how objects are classified in VBA? Learn about object methods and properties - What are these and what is the difference between them? Their significance in VBA.

• Amazing projects for students.

• Online assistance is always there for students to clear their doubts and questions.

Prerequisites

• You should know for next and do while loops.
• You should know how to declare variables and how to record and edit macros in VBA.
• You should know IF statements as well to fully benefit from this course.