How to use the consolidate function in Excel

About this tutorial:

Video duration: 3:4
How to use the consolidate function in Excel.
Combine data from different sheets. Combine data from different files.
For more help visit my website or email me at

I can customize this Excel application for your exact needs for a fixed price of $50. The work is normally returned within 24hrs.

I am able to provide online help on your computer at a reasonable rate.

MY videos are all created on Camtasia.

Follow me on…

Incoming search terms:

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

6 thoughts on “How to use the consolidate function in Excel

    mehmet kaya

    (August 15, 2019 - 3:40 am)

    Thank you!

    Jafari Hamisi

    (August 15, 2019 - 3:40 am)

    wow i love you!!!


    (August 15, 2019 - 3:40 am)

    how to sum the amount with multiple duplicate orders? Example; duplicate orders and has different total and would like to sum it so the duplicate order can be delete.

    Kyle scott

    (August 15, 2019 - 3:40 am)

    Or how do I collect data that is in a column with blank cells between them? To go from a column with blank spaces to a new column identical data with no spaces

    Kyle scott

    (August 15, 2019 - 3:40 am)

    I have a question about figuring out average trip times. I have a spreadsheet with a bunch of trucks and there begin and end journey times are in same column and I want to find a way to auto calc the average time. I could send you my sheet

    Automation Guide

    (August 15, 2019 - 3:40 am)

    Thank You !!

Leave a Reply

Your email address will not be published. Required fields are marked *