ENTREPRENEURSHIP

Detailed explanation-1: -Click Data>Consolidate (in the Data Tools group). In the Function box, click the summary function that you want Excel to use to consolidate the data. The default function is SUM.

Detailed explanation-2: -Excel has a built-in tool for consolidating multiple worksheets or multiple workbooks. If you need to total various worksheets that might have differing rows or columns, the Consolidate command uses the labels in the first row and first column to line up the data and combine it onto one worksheet.

Detailed explanation-3: -Combine multiple workbooks Into one workbook with Move or Copy function.

Detailed explanation-4: -Data consolidation is the corralling, combining, and storing of varied data in a single place. It lets users manipulate different types of data from one point of access and helps turn raw data into insights that drive better, faster decision-making. The term sometimes is used interchangeably with data integration.