2/1/16

Basic Consolidate in Excel by Using Category And Labels.

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.

8 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
  5. Free Design Setup - Converting an art file (a logo image) to an embroidery file called embroidery digitizing. We do not charge to digitize a logo for embroidered patches. The actual value for this service is around USD $30 for the small logos and USD $150 for jacket back logos, but we do it for free! Custom Iron On Patches

    ReplyDelete
  6. private label products Merchantshowroom.com is a global wholesale marketplace connecting wholesale buyers and manufacturers and wholesale distributors. Buy private label and white label products from suppliers around the world and pay for them conveniently online.

    ReplyDelete
  7. For instance, a business engaged with printing on paper ought to pick between a laser print machine and counterbalance print machine. this article

    ReplyDelete
  8. Major Thanks for the post. Really looking forward to read more. Awesome.
    stickers online

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Mad About Computer. Powered by Blogger.