Summary: In this video, Mr. Raj Singh Sir will teach you how to use CONSOLIDATE Formula. We will learn how to take data from two different sheets and post it on a single main sheet. Any changes made in the other sheets will be reflected in the main sheets.
Process: Click on the DATA TAB > then go on CONSOLIDATE (FUNCTION, REFERENCE, AND ALL REFERENCE)
Tick all the checkboxes below
Conclusion: In this video, you learned how to make a Master sheet out of many sheets.
Join the most demanding and futuristic program- Data Analytics