Discover How to Quickly Summarise Data using consolidate
To utilize the ‘consolidate’ feature in Excel, begin by selecting a cell in a new sheet where you wish the consolidated data to appear. Navigate to the ‘Data’ tab and click on ‘Consolidate’. Choose the function that suits your data analysis needs, such as ‘Sum’ for totalling numbers. Then, add the range of the data from the sheets you’re consolidating by clicking ‘Add’ after selecting the range. Ensure that each range includes the label rows and columns if they are consistent across all sheets. You can also choose to use labels from the top row or left column by checking the respective boxes under ‘Use labels in’. After setting up, press ‘OK’ to execute the consolidation. Excel will then combine the data into your chosen location, summarising it according to the selected function. Microsoft Excel tutorial. Discover How to Quickly Summarise Data using consolidate.

Join this channel to get access to perks:

If you want to support me, check this out:

Online training courses:

Word course:

Excel Introduction Course for basic users:
Excel Intermediate Course:

Excel Advanced Course:

Microsoft Project Master Class:

Microsoft Visio Essentials:

Access for beginners course:

Access Master Class:

Classroom based courses can be arranged at

Courses are available through Microsoft Teams, Online and Face to face in the UK

Udemy Courses

Training Guide Books

Excel for New Managers

Microsoft Project Overview

Microsoft Visio Basic

Very cheap E_books are here:
Excel For New Managers
Microsoft Project Overview
Microsoft Visio Basics
Microsoft Access Introduction
A PowerPoint Overview

Leave a Reply

You must be logged in to post a comment.


“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group

“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services

“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA

“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd