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
- 	
				 1:01:45 1:01:45Playback Request Live1 hour agoPRL LIVE @ DREAMHACK!!10.3K1
- 	
				 LIVE LIVEDr Disrespect5 hours ago🔴LIVE - DR DISRESPECT - ARC RAIDERS - DANGEROUS ADVENTURES (LEVEL 12)1,446 watching
- 	
				 14:15 14:15Tactical Advisor5 days agoEverything You Need To Know About PSA Mixtape Vol 1. (FIRST LOOK)2.82K3
- 	
				 LIVE LIVEJeff Ahern1 hour agoFriday Freak out with Jeff Ahern110 watching
- 	
				 14:54 14:54The Kevin Trudeau Show Limitless2 days agoThe Hidden Force Running Your Life54.4K8
- 	
				 1:03:55 1:03:55Sean Unpaved3 hours agoRavens' Resurrection Night: Lamar Buries Miami, NFL/CFB Spooky HC Shifts, & Kalshi's Week 9/10 Odds!26.5K
- 	
				 2:16:48 2:16:48Film Threat1 day agoHALLOWEEN HORROR + BACK TO THE FUTURE RERELEASE + MORE REVIEWS | Film Threat Livecast7.99K
- 	
				 1:21:16 1:21:16Steven Crowder6 hours ago10th Annual Halloween Spooktacular: Reacting to the 69 Gayest Horror Movies of All Time258K164
- 	
				 57:39 57:39The Rubin Report4 hours agoKamala Gets Visibly Angry as Her Disaster Interview Ends Her 2028 Election Chances49.1K61
- 	
				 LIVE LIVELFA TV18 hours agoLIVE & BREAKING NEWS! | FRIDAY 10/31/251,583 watching