Premium Only Content

EXCEL TUTORIAL: HOW TO CONSOLIDATE DATA WITH KEYBOARD SHORTCUT
This video features an excel function that is used to consolidate data from one workbook, or from different open workbooks. You can simply click ALT-A-N and you will be directed to the consolidate window. You can also find it under the data tab.
To consolidate data from 1 sheet, click the keyboard shortcut ALT-A-N. Use the default function sum, but you can change it if you want to do other functions from the drop-down list like count, average, max, min and many others. Then input the reference. Below that says, use labels in, and choose left column. And you will have the consolidated figures.
If you do consolidation of data from different sheets, you still have to click the same keys, Alt-A-N, click the reference box and select the amounts in Sheet 1 as the first reference. Click add, and the first reference is added to all references box. Put the cursor back to the reference box and choose the numbers from sheet 2 as the 2nd reference, then click add again and it’s transferred to all references. Then repeat the process for the 3rd reference and do the same for the succeeding references if any.
There’s more. If you want to show the links or the sources of the data, you can tick “create links to source data”.
Title: How to Consolidate Data in Excel
#exceltipsandtricks
#exceltipsandtricks
#exceltips
#tricksandshortcuts
#excelshortcuts
#excel
#microsoftexcel
#advancedexceltricks
#excelonlinecourse
#exceltipstricksandshortcuts
#exceltutorial
#bestexcelshortcuts
#learnexcel
#exceltraining
#excelformulasandfunctions
#microsoftexceltips
#keyboardshortcuts
#excelfunctions
#consolidatedatainexcel
#consolidate
#howtoconsolidatedatainexcel
#bestexcelformulas
#consolidateexcelfunction
-
8:06:32
Phyxicx
16 hours agoStar Wars: Movie Battles II Community Event hosted by ReaperAF95 - 10/4/2025
37.4K1 -
4:40:13
ABNERDAGREAT
5 hours ago🔴ZELDA MARATHON LETS FINISH THE FIGHT LOFI COPYRIGHT FREE MUSIC🔴
341 -
1:43:56
Tundra Tactical
14 hours ago $44.44 earned🛑LIVE NOW!! FBI Gets Caught LYING About Good Guys With Guns For 10 YEARS!!!!
70.3K11 -
LIVE
LethalPnda
1 hour agoK-Pop Demon Hunters x Fortnite | Use code LETHALPNDA in the Item Shop!
48 watching -
2:12:01
BlackDiamondGunsandGear
2 days agoAFTER HOURS ARMORY / Antifa / Lies/ Prison time
42.5K3 -
2:12:00
DLDAfterDark
13 hours ago $19.25 earnedThe After Hours Armory! Tonight is The Chat's Chat! God, Guns, and Gear!
57.1K6 -
3:32:18
Mally_Mouse
16 hours ago🌶️ 🥵Spicy BITE Saturday!! 🥵🌶️- Let's Play: Phasmophobia
61.4K6 -
1:13:19
iCkEdMeL
12 hours ago $27.87 earnedChaos Explodes in Chicago & Portland | Feds Clash with Protesters!
65.7K38 -
21:54
Exploring With Nug
1 day ago $11.33 earnedScuba Diving Missing Person Search Leads to Discovery of Classic Cars!
75.9K20 -
1:19:51
World2Briggs
15 hours ago $2.86 earnedThe US This Week
39.9K8