Altaf Karimi

Dear Geetanjali, the actual purpose of the immediate window is to test a line of code and check its result. Some time in VBA we apply a line of code based on logic/past experience but not sure of its outcome. In that case, I will not write a sub procedure to test that code rather I will use immediate window. Ctrl G is a shortcut key to open it, hope you get some idea. All the best and take care :)

Dear Geet, these are 2 most useful functions of MS Excel. V is vertical and H is horizontal. The purpose of the function is to extract the value based on common data from any other data - that data may reside in the same sheet, any other sheet or any other workbook. Hope you get some idea about it :) All the bestt

Dear Sirish, your questions is without any specification of student type. I have observed that people prefer classroom training instead of the video but at the same time, I have learned complete MS Power BI online. It depends on person to person and their absorbing capabilities. I am sure online learning is not a bad idea :) hope my answer will give you some confidence and clarity. All the best

Dear Krishna, all these products are part of the MS Office suite. MS Word is used to prepare letters, text-based data management, and long documents.  MS  Excel is used for data storage, calculations, and analysis. MS PowerPoint is used for presentation purpose, you can share your ideas and message using animation and other tools like smart art, shapes, images, audio, video through the slide. Hope my answer will help you to get some clarity. All the best