Consolidating workbooks in excel
This master worksheet might also contain sales totals and averages, current inventory levels, and highest selling products for the entire enterprise.Tip: If you frequently consolidate data, it might help to base your worksheets on a worksheet template that uses a consistent layout.Intermediate: Use advanced formulas; Present data using charts; Analyse data using pivot tables; Customise and enhance workbooks.Advanced: Collaborate with others using workbooks; Audit worksheets; Work with multiple workbooks; Import & export data; Use Excel with the web; Structure workbooks with XML.To learn more about Templates, see: Create a template.
For example, if you have an expense worksheet for each of your regional offices, you might use consolidation to roll these figures into a master corporate expense worksheet.By using conditional formatting, you can tell Excel to highlight portions of your data that meet any given condition.For example: highlighting top 10 customers, below average performing employees etc.Selecting a Cell Selecting a Range of Connecting Cells Selecting a Range of Non-Connecting Cells Selecting the Entire Worksheet Selecting a Row Selecting a Range of Connecting Rows Selecting a Range of Non-Connected Rows Selecting a Column Selecting a Range of Connecting Columns Selecting a Range of Non-Connecting Columns Recommended Techniques When Creating or Editing Lists Manipulating Rows and Columns within Excel 2013 Inserting Rows into a Worksheet Inserting Columns into a Worksheet Deleting Rows within a Worksheet Deleting Columns within a Worksheet Modifying Column Widths Modifying Column Widths Using 'Drag and Drop' Automatically Resizing the Column Width to Fit Contents Modifying Row Heights Manipulating Cells and Cell Content within Excel 2013 Copying a Cell or Range Contents within a Workbook Deleting Cell Contents Moving the Contents of a Cell or Range within a Workbook Editing Cell Content Undo and Redo Copying Data between Worksheets (Within the Same Workbook) Moving Data between Worksheets (Within the Same Workbook) Moving Data Worksheets (Between Different Workbooks) Copying Data between Worksheets (In Different Workbooks) Auto Fill Copying a Data Range Using Auto Fill Sorting a Cell Range Searching and Replacing Data Excel 2013 Worksheets Switching between Worksheets Renaming a Worksheet Recommended Techniques with Naming Worksheets Inserting a New Worksheet Deleting a Worksheet Copying a Worksheet within a Workbook Moving a Worksheet within a Workbook Copying or Moving Worksheets between Workbooks Font Formatting within Excel 2013 Font Formatting Options Font Type Font Size Bold, Italic, Underline Formatting Cell Border Formatting Formatting the Background Colour Formatting the Font Colour Alignment Formatting within Excel 2013 Horizontally Aligning Contents in a Cell Range Centring a Title over a Cell Range Cell Orientation Text Wrapping within a Cell Aligning Cell Contents Vertically Format Painter Number Formatting within Excel 2013 Number Formatting Decimal Point Display Applying and Removing Comma Style Formatting (To Indicate Thousands) Currency Symbol Date Styles Percentages Freezing Row and Column Titles Freezing Row and Column Titles Excel 2013 Formulas Creating Formulas The Easy Way to Create Formulas Copying Formulas Operators Using Operators in Formulas Formula Error Messages Relative Cell Referencing within Formulas Absolute Cell Referencing within Formulas Excel 2013 Functions What Are Functions?
Common Functions Sum Function Average Function Max Function Min Function Count Function The Counta Function The Countblank Function What Are 'If Functions'?
To summarize and report results from separate worksheets, you can consolidate data from each into a master worksheet.