Consolidate Data In Excel (Bring Everything Into One Place)
Discover how Excel's Consolidate feature is quick and easy and eliminates the need to write lots of formulas. Consolidation allows you to collect data from different places, bring it all into one location and produce all the totals (or another function of your choice) in one hit.
You can consolidate by position or consolidate by category (or label) and either create links to the source data or not.
Each approach has pros and cons.
😃 TIME CODES (click the link to go directly to that spot in the video)
(0:00) Intro to colsolidation
(0:23) The setup
(0:24) Consolidate by position (with no links to source data)
(1:58) Consolidate by position (with links to source data)
(2:32) Consolidate by category (or label)
I trust you found this video useful. What ONE thing resonated with you the most? Let me know by adding a quick comment below and click the thumbs up button under the video! Oh, and subscribe if you'd like to see more content like this. Go get 'em.
😃 USEFUL LINKS:
Share this Video:
• Consolidate Data In Excel (Bring Everythin...
😃 SUBSCRIBE if you want to see more content like this
https://www.youtube.com/c/JasonMorrel...
😃 HIRE JASON to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching
https://trst.com.au/microsoft-trouble...
😃 ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.
😃 LET'S CONNECT!
https://officemastery.com (free training on the blog)
/ officemastery
/ jkmorrell
/ jasonmorrell
Have a fantastic day!