Contact Us

Comments

New comments are not allowed.

Popular posts from this blog

PIVOT TABLE IN MS EXCEL

Image
PIVOT TABLE IN MS EXCEL Pivot Table with Detailed Explanation: https://youtu.be/52xH2t9IGiQ  Follow this link to get workbook used in the video: https://drive.google.com/file/d/1Q2FCcojb3BoU-nyA55DXBiJpwDWdFIry/view?usp=sharing Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them. GROUP OR UNGROUP IN PIVOT TABLE: Learn how to group products and how to group dates by quarters, months or years. Group selected items 1 Hold CTRL key and select two or more values 2 Right click of mouse and select group Ungroup selected items 1 Right click any item that is in that group 2 Select Ungroup Watch the video till the end to learn everything in d...
Read more

Multiple Dependent Drop-down list in Excel

Image
Multiple Dependent Drop-down list in Excel Multiple Drop-down list in Ms Excel means that if you create a drop-down list then the other drop-down list will be dependent on the first drop-down list. Let's understand with the help of an example, I have different brands of Mobiles and their different models. So if I select any mobile from my first drop-down list then in second drop-down list which is of different Model of all the brands of Mobiles, I can see only the models of that particular mobile. If I select SAMSUNG in first drop-down list then in second drop-down list i will see only the models of SAMSUNG Mobile. Let's learn everything about Multiple dependent drop-down list in Excel step by step. Watch the video till the end to learn everything about Multiple dependent drop-down list in Ms Excel. We will learn step by step, how to create drop-down lists. Today we are going to learn 2 ways of creating Multiple dependent drop-down lists. It would be very helpful for you.  I...
Read more

Vlookup function in Ms Excel

Image
 Vlookup function in Ms Excel VLOOKUP FUNCTION IN MICROSOFT EXCEL VLOOKUP FUNCTION STANDS FOR VERTICAL LOOKUP. It looks for a value in the leftmost column of a table. It has four components: 1. VALUE - The value you want to lookup from your table. 2. RANGE- The range in which you want to find the value. 3. COLUMN NUMBER- The number of column within your defined range, that contains the return value. 4. TRUE or FALSE- False or 0 means Exact match and True or 1 means approximate match Follow this link to get Worksheet used in the video - https://drive.google.com/file/d/1KhigpxV9AnNVEd9dr3SVOPuDwIO6ON7O/view?usp=sharing Watch the video till the end to learn everything in detail.If you have any doubts regarding this video or any other video, do let me know in the comment section. Please LIKE 👍🏻 SHARE 🤞🏻 & SUBSCRIBE 👆🏻MY CHANNEL to get notifications of all latest videos ❤️❤️ Follow me at:...
Read more