Monday, February 1, 2016

Basic Consolidate in Excel by Using Category And Label

In this last you will learn about basic consolidate in excel (by position). In this tutorial you will learn about Basic consolidate in excel by using category and label. Before starting this tutorial we must have the knowledge of consolidate. Click here to get the knowledge of consolidate in excel. I hope that will you really enjoy this.

How to use consolidate in excel by using category and label?
It is the simple process to consolidate our data by using category and label. For example, First create a three sheet and create your data for example see images. Suppose you create Electronic sales data on January, February, March 2016 and you want to consolidate your data of master worksheet.

Above Image shows that 3 different sheet I will show how to consolidate the data in our master worksheet.
First create a new sheet. On this sheet go to data tab, in data tools option you see consolidate option click on it. Go to first sheet and select the range of the data and click on add Button then go to second sheet and select the range of the data and click on add button, Go to third sheet, select the range of the data and click on add button. When you add both sheet which you want to show your data in our master worksheet press ok. Below image shows that what happen when you both sheet are added.

Through this video you can better understand to given all description about this tutorial.

In this article you have studied about  Basic consolidate in excel by using category and label. If you like this tutorial doesn’t forget to like us on Facebook and also follow me on twitter. And if you find anything missing than let me know through your commenting.

People also read: Consolidate in excel.
People also read : Conditional formating based on another cell.

4 comments:

  1. Hello mahesh, thanks to giving the info its really helpful for us.

    ReplyDelete
  2. I have two sheets in excel, in both of them, I have a column a as ID but ID in both sheets are not the same. both of them have some ID number that does not exist in another. there are several column else in both sheets. by the way, I want to merge and combine these two sheets. Till now I Used some Add-ins like DIGdb or ablebits as trial. I can not buy these add-ins or software from my country. It is your kind to help me.

    Thanks a lot mahesh

    ReplyDelete
  3. Very informative and a much needed article as I see so many people struggling with Microsoft Excel. Thank you for explaining the job so well.

    ReplyDelete
  4. We have sell some products of different custom boxes.it is very useful and very low price please visits this site thanks and please share this post with your friends. CBD Gummies

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Contact Form

Name

Email *

Message *

Mad About Computer. Powered by Blogger.