Sunday, January 24, 2016

Basic Consolidate in Excel by Using Position



Before starting to know about basic consolidate in excel by using position, we must have the knowledge of what does consolidate means, In this tutorial you will go to learn consolidate, its work and when we use consolidate in excel. I hope that will you really enjoy this.

What is consolidate in excel?

If you want to combine your data from several worksheet into a single worksheet, in this situation you use consolidate option. In simple consolidate combine your data multiple into one.


How many ways to consolidate data?

There are two ways to consolidate your data by category or by Position, But you will learn about by position in this tutorial.

Consolidate by position- when the each range of the data in the list format and there are no blanks row and column within the list. Make sure all data separate on your worksheet, don’t put the range on the data where you think to select the consolidate, be sure each range of the data in same layout.
Select the range of the data which you want to consolidate on master worksheet, then go to consolidate option and click on it below image shows that how to use consolidate option.

                              Click on consolidate option, consolidate window front on your screen, you see reference option select the range of the data and click on add option, same process on second sheet, Go to second sheet and select the range of the data in reference option and click on add option and when you go to third sheet where you put your data, On third sheet check the mark of top row, left column and create link to source data and click ok. Below image show that the explanation to given above description in image step to step.
Step 1
  Step 2

 Step 3

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


If you have found any mistake or have any doubt related to above basic consolidate in excel by using position tutorial then comment below.


People Also Interested : How to make a pie chart in excel?  
People Also Interested : Basic consolidate in excel by using category and label.










115 comments:

  1. hlo mahesh, in types of consolidate you mentioned consolidate by position and you can't define consolidate by category please give me way to consolidate by category

    ReplyDelete
  2. You can also hire an Excel VBA expert to help you with your files. While this costs money it does allows you to get results much much faster, often within hours or the same day.excel dashboard software

    ReplyDelete
  3. Nice to read this article,.... Thanks for sharing this useful information.
    advanced excel training

    ReplyDelete
  4. your blog contain very useful information and good points were stated in the blog, Really very informative blog. Graphic Design Training in Chennai | Multimedia Training Institute in Chennai | Adobe Photoshop Training in Chennai

    ReplyDelete
  5. I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. 
    No.1 Software Testing Training Institute in Chennai | Best Selenium Training Institute in Chennai | Java Training in Chennai

    ReplyDelete
  6. Nice post. I have been reading a lot of stuff on this topic in the last few months, but this article stands out with its simplicity & authenticity. Every passage made profound sense. Thanks a lot for this.
    ME/M.Tech Project Center in Chennai | ME/M.Tech Project Center in Velachery

    ReplyDelete
  7. Nice blog.. The information you shared is very effective for learners I have got some important suggestions from it.. RPA Training Institute in Chennai | UI Path Training Institute in Chennai | Blue Prism Training Institute in Chennai

    ReplyDelete

  8. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.

    SELENIUM TRAINING IN CHENNAI

    ReplyDelete
  9. This comment has been removed by the author.

    ReplyDelete
  10. Extraordinary Blog..Thanks for posting this useful article with unique content.keep sharing..
    Power System Project Center in Chennai | Power System Project Center in Velachery

    ReplyDelete
  11. This comment has been removed by the author.

    ReplyDelete
  12. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    ME/M.Tech Project Center in Chennai | ME/M.Tech Project Center in Velachery

    ReplyDelete
  13. Those guidelines additionally worked to become a good way to
    recognize that other people online have the identical fervor like mine
    to grasp great deal more around this condition.


    white label website builder

    ReplyDelete
  14. The information your shared is very useful.Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
    uipath training in chennai

    ReplyDelete
  15. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.

    blue prism training in chennai

    ReplyDelete
  16. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.

    IBM BPM Online Training in Chennai
    IBM BPM Online Training

    ReplyDelete
  17. This article is well written and quite informative.
    More articles should be written and you have just found a follower.and more visit.
    Excel Training in Hyderabad

    ReplyDelete
  18. I wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.
    Ethical Hacking Course in Chennai 
    SEO Training in Chennai
    Ethical Hacking Training in Chennai 
    Certified Ethical Hacking Course in Chennai 
    Best SEO training in chennai
    SEO Training Center in Chennai

    ReplyDelete
  19. I am really enjoying reading your well-written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
    VMware Training in Chennai
    VMware Training
    Vmware cloud certification
    R Training in Chennai
    RPA Training in Chennai
    DevOps certification in Chennai
    VMWare Training in Anna Nagar
    VMWare Training in T Nagar
    VMWare Training in Adyar

    ReplyDelete

  20. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
    RPA using UI PATH Training in Electronic City

    ReplyDelete
  21. Very nice post here and thanks for it .I always like and such a super blog of these post.Excellent and very cool idea and great blog of different kinds of the valuable information's.
    Best Tally Erp 9.0 Course Training Institute in kanchipuram|

    ReplyDelete
  22. Interesting post!!! Thanks for posting such a useful information. I wish to read your upcoming post to enhance my skill set and keep blogging.
    Best Tally Erp 9.0 Course Training Institute in kanchipuram|

    ReplyDelete
  23. Thanks for your informative blog.Your post helped me to understand the future and career prospects. Keep on updating your blog with such awesome blog.
    No:1 IT Project Center in Kanchipuram



    ReplyDelete
  24. Really it was an awesome blog...very interesting to read..You have provided an nice information....Thanks for sharing..
    Best Hardware & Networking Course Training Institute in kanchipuram|

    ReplyDelete
  25. Thanks for sharing in this blog...its very useful for us...keep on going...
    Best MS Office Course Training Institute in kanchipuram|

    ReplyDelete
  26. Nice blog. Thank you for sharing. The information you shared is very effective for learners I have got some important suggestions from it.
    Best PCB (Printed Circuit Board) Course Training Institute in kanchipuram|

    ReplyDelete
  27. Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
    Best PCB (Printed Circuit Board) Course Training Institute in kanchipuram|

    ReplyDelete
  28. Nice blog. Thank you for sharing. The information you shared is very effective for

    learners I have got some important suggestions from it.
    No:1 CCNA Training Academy in

    Kanchipuram


    ReplyDelete
  29. Awesome post. Really you are shared very informative information... Thank you for sharing. Keep on updating...
    Best AWS (Advanced Amazon Web Services) Course Training Institute in kanchipuram|

    ReplyDelete
  30. I think this is the best article today. Thanks for taking your own time to discuss this topic, I feel happy about that curiosity has increased to learn more about this topic. Keep sharing your information regularly for my future reference.No:1 Azure Training Academy in Kanchipuram


    ReplyDelete
  31. Good job! Fruitful article. I like this very much. It is very useful for my research. It shows your interest in this topic very well. I hope you will post some more information about the software. Please keep sharing!!
    SEO Training in Chennai
    SEO Training in Bangalore
    SEO Training in Coimbatore
    SEO Training in Madurai
    SEO Course in Chennai
    SEO Course in Chennai
    SEO Course in Bangalore
    SEO Course in Coimbatore

    ReplyDelete
  32. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
    Cyber Security Projects for Final Year

    JavaScript Training in Chennai

    Project Centers in Chennai

    JavaScript Training in Chennai

    ReplyDelete
  33. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    Best Cloud Computing Course Training Institute in kanchipuram|

    ReplyDelete
  34. Nice..You have clearly explained about the conept..Its very useful for me to
    undertand..Keep on sharing..

    No:1Tally Training Academy in Kanchipuram







    ReplyDelete
  35. I found some useful information in your blog, it was awesome to read, thanks for sharing this great information to my vision, keep sharing.
    Best Graphic Designing Course Training Institute in kanchipuram|

    ReplyDelete
  36. Marvelous and fascinating information.Thanks for this greatful blog. keep your blog updated.
    Best Hardware & Networking Course Training Institute in kanchipuram|

    ReplyDelete
  37. Nice..You have clearly explained about the conept..Its very useful for me to
    undertand..Keep on sharing..

    No:1 CCNA Training Academy in Kanchipuram







    ReplyDelete
  38. https://www.madaboutcomputer.com/2016/01/basic-consolidate-in-excel.html?showComment=1571565154585#c4137402029733287409

    ReplyDelete
  39. I’m sincerely suggesting your blog.nice and really helpful information to everyone... thanks for sharing
    Best Python Course Training Institute in kanchipuram|

    ReplyDelete
  40. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    No:1 Best EEE Project Center in kanchipuram|

    ReplyDelete
  41. really you have posted an informative blog. it will be really helpful to many peoples. thank you for sharing this blog. so keep on sharing such kind of useful blogs.
    No:1 Best NS2 (Network Simulator) Project Center in kanchipuram|

    ReplyDelete
  42. very usefull informatation.and iam expecting more posts like this please keep updating us....
    No:1 Best Android Project Center in kanchipuram|

    ReplyDelete
  43. Thanks for this greatful information. all this information is very important to all the users and can be used good at all this process.please keep on updating..
    No:1 Best ECE ( Electronics & Communications Engineering) Project Center in kanchipuram|

    ReplyDelete
  44. You post explain everything in detail and it was very interesting to read.Thank you for Sharing.
    No:1 Best Dotnet Project Center in kanchipuram|

    ReplyDelete
  45. After I see your blog it was so impressive and informative content. thanks for sharing such a lovely blog.
    No:1 Best Software Testing Training Center in kanchipuram|

    ReplyDelete
  46. It is really a great and useful piece of information. I am glad that you shared this helpful info with us. Please keep us up to date like this. Thank you for sharing.
    Basic Computer Course in kanchipuram

    ReplyDelete
  47. This was a worthy blog. I enjoyed reading this blog and got an idea about it. Keep sharing more like this.
    No:1 Best Selenium Automation Training Center in kanchipuram|

    ReplyDelete
  48. this is really too useful and have more ideas from yours. keep sharing many
    techniques.

    No:1TCA training Center in Kanchipuram









    ReplyDelete
  49. After reading your blog, I was quite interested to learn more about this information. Thanks for sharing.
    No:1 Best PGDCA Training Center in kanchipuram|

    ReplyDelete
  50. Wow it is really wonderful and awesome thus it is very much useful for me to understand many information and helped me a lot. it is really explainable very well and i got more information from your blog.
    No:1 Best Tally Training Center in kanchipuram|

    ReplyDelete
  51. this is really too useful and have more ideas from yours. keep sharing many
    techniques.

    No:1 CCNA training Center in Kanchipuram









    ReplyDelete

  52. Nice post... Really you are done a wonderful job. Thanks for sharing such wonderful information with us. Please keep on updating...No:1 CCNA Exam Center In Chennai|

    ReplyDelete
  53. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information, this is useful to me…
    No:1 Best Tally Training Center in kanchipuram|

    ReplyDelete

  54. Thanks for sharing these niche piece of coding to our knowledge. Here, I had a solution for my inconclusive problems & it’s really helps me a lot keep updates…No:1 CCNP Exam Center in Chennai|

    ReplyDelete
  55. The best thing is that your blog really informative thanks for your great information!No:1 ISTQB Exam Center in Chennai|

    ReplyDelete
  56. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharng this information,this is useful to me..No: 1 ITB Exam Center in Chennai|

    ReplyDelete
  57. Your blog is awesome..You have clearly explained about it ...Its very useful for me to know about new things..Keep on blogging…No: 1 ECE Project Center in Chennai|

    ReplyDelete
  58. I just see the post i am so happy the post of information's.So I have really enjoyed and reading your blogs for these posts. No: 1 BCS Exam Center in Chennai

    ReplyDelete
  59. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.No: 1 PMP Exam Center in Chennai|

    ReplyDelete
  60. It is really a great and useful piece of information. I am glad that you shared this helpful info with us. Please keep us up to date like this. Thank you for sharing.
    IT Project Center in Chennai

    ReplyDelete
  61. It is really a great and useful piece of information. I am glad that you shared this helpful info with us. Please keep us up to date like this. Thank you for sharing.
    IT Project Center in Chennai

    ReplyDelete
  62. Good one, it is very useful for me to learn and understand, thanks for sharing your information and ideas.. keep rocks..No: 1 AWS Exam Center in Chennai|

    ReplyDelete
  63. It is really a great and useful piece of information. I am glad that you shared this helpful info with us. Please keep us up to date like this. Thank you for sharing.
    IT Project Center in Chennai

    ReplyDelete

  64. I am really happy with your blog because your blog is very unique and powerful for new reader.No: 1 Microsoft Exam Center in Chennai|

    ReplyDelete
  65. I have completely read your post and the content is crisp and clear.Thank you for posting such an informative article, I have decided to follow your blog so that I can myself updated.
    Robotics Project Center in Chennai

    ReplyDelete

  66. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly. 
No: 1 AZURE Exam Center in Chennai|

    ReplyDelete
  67. It is really a great and useful piece of information. I am glad that you shared this helpful info

    with us. Please keep us up to date like this. Thank you for sharing.
    ISTQB

    Exam Center in Chennai

    ReplyDelete
  68. This information is impressive..I am inspired with your

    post writing style & how continuously you describe this

    topic. After reading your post, thanks for taking the time

    to discuss this, I feel happy about it and I love learning

    more about this topic
    AWS Certification in

    Chennai

    ReplyDelete
  69. Thanks for posting this useful content, Good to know about new things here, Keep updating your blog...No: 1 Blue Prium Certification in Chennai|

    ReplyDelete
  70. Hi, am a big follower of your blog. The best thing is that your blog really informative thanks for your great information!No: 1 NS 2 Project Center in Chennai|

    ReplyDelete
  71. Its really an Excellent post. I just stumbled upon your blog and wanted to say that I

    have really enjoyed reading your blog. Thanks for sharing.
    No:1PHP Project Center in chennai










    ReplyDelete
  72. This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic
    AWS Certification in Chennai

    ReplyDelete
  73. Hello , Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep updating your blog.No: 1 JAVA Application Center in Chennai|

    ReplyDelete
  74. Nice blog. Thank you for sharing. The information you shared is very effective for learners I have got some important suggestions from it.No: 1 JAVA Application Center in Chennai|

    ReplyDelete
  75. Great and useful article.Thanks for taking time to share this post
    Android Project Center in Chennai

    ReplyDelete
  76. These provided information was really so nice,thanks for giving that post and the more skills to develop after refer that post. Your bolg really impressed for me,because of all information so nice.No: 1 NS 2 Project Center in Chennai|

    ReplyDelete
  77. Great and useful article.Thanks for taking time to share this post
    Android Project Center in Chennai

    ReplyDelete
  78. I found a lot of interesting information here. A really good post. keep updating.No: 1 MBA Project Center in Chennai|

    ReplyDelete
  79. I have read your blog. Good and more

    informationuseful for me, Thanks for sharing this

    information keep it up....

    No.1 Python Project Center in Chennai







    ReplyDelete
  80. Quite Interesting post!!! Thanks for posting such a useful post. I wish to read your upcoming post to enhance my skill set, keep blogging.No: 1 BBA Project Center in Chennai|

    ReplyDelete
  81. I am very happy after find this post and really helpful. Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog. your site really helps me for searching the new and great stuff.
    ECE Project Center in Chennai

    ReplyDelete
  82. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    Embedded Training Center in Kanchipuram

    ReplyDelete
  83. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    Embedded Training Center in Kanchipuram

    ReplyDelete
  84. Nice Post! It is really interesting to read from the beginning & I would like to share your blog to my circles, keep your blog as updated.
    No.1 CCNA Training Center In Kanchipuram

    ReplyDelete
  85. I found a lot of interesting information here. A really good post. keep updating.
    MBA Project Center in Kanchipuram

    ReplyDelete
  86. Great post. Wonderful information and really very much useful. Thanks for sharing and keep updating.No: 1 MBA Project Center in Chennai|

    ReplyDelete
  87. Very nice blog. It is very useful for me. I read your blog completely. I gather lot of information in this post. Thanks for sharing. No: 1 BBA Project Center in Chennai |

    ReplyDelete
  88. Wonderful post with great piece of information. I'm learning a lot from your blog. Keep sharing. No: 1 CCNA Training Center in Kanchipuram|

    ReplyDelete
  89. This was a worthy blog. I enjoyed reading this blog and got an idea about it. Keep sharing more like this.
    JAVA Training Center in Kanchipuram

    ReplyDelete
  90. Thanks for giving great kind of information. Thanks for your excellent blog, nice work keep it up thanks for sharing the knowledge. No: 1 Graphic Designing Course in Kanchipuram|

    ReplyDelete
  91. Nice Post! It is really interesting to read from the beginning & I would like to share your blog to my circles, keep your blog as updated.
    No.1 Android Training Institute In Kanchipuram








    ReplyDelete
  92. Thanks for making me this Blog. You have done a great job by sharing this content here. Keep writing blog like this
    MBA Project Center in Kanchipuram

    ReplyDelete
  93. Very nice post here and thanks for it .I always like and such a super blog of these post.Excellent and very cool idea and great blog of different kinds of the valuable information's. No: 1 IOS Training Center in Kanchipuram|

    ReplyDelete
  94. You post explain everything in detail and it was very interesting to read.Thank you for Sharing.
    IEEE Project Center in Kanchipuram

    ReplyDelete
  95. What a fantastic blog you should written in well manner.Iam really happy to read this
    blog.Thanks for sharing.keep sharing more blogs.
    No.1 Tally Training Institute In Kanchipuram

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Contact Form

Name

Email *

Message *

Mad About Computer. Powered by Blogger.