Consolidating data in excel 2016

To ensure that every year’s workbook has a similar appearance, you can create a workbook with the characteristics you want, and save it as a pattern, or template, for similar workbooks you will create in the future.A consequence of organizing your data into different workbooks and worksheets is that you need ways to manage, combine, and summarize data from more than one Excel document.

Excel creates a new workbook (an workbook file, not an template file) with the template’s formatting and contents in place.There is a quick and easy way to do this – using the Data Consolidation tool.In this blog, Edmund, one of our Excel experts, shares his top tips.You can leave the workbook’s labels to aid in data entry, but you should remove any existing data from a workbook that you save as a template, both to avoid data entry errors and to remove any confusion as to whether the workbook is a template.You can also remove any worksheets you and your colleagues won’t need by right-clicking the tab of an unneeded worksheet and, on the shortcut menu that appears, clicking Delete.

Leave a Reply