Lynnette Mann demonstrates how Consolidation works with Microsoft Excel 2010. Data from separate worksheets can be consolidated on a master worksheet. This makes it easier to update and aggregate it on a regular or ad hoc basis.