Excel Data Combination and Consolidation Webinar

Upon completing this course, you should be able to:

Differentiate the advantages and disadvantages of using the SUM function to produce sum-through formulas as compared to simple arithmetic formulas
Implement dummy end-point worksheets or columns to simplify the data consolidation process and reduce errors
Identify situations where wild-card characters may be used effectively in combining data from multiple worksheets
Differentiate between using Data Consolidation by position and by category
Use consolidation PivotTables to combine data from multiple worksheets and/or multiple workbooks

Highlights

Using Excel's SUM function to simplify the sum-through formula building process

Adding or removing worksheets from a sum-through total

Working with Excel's Data Consolidate function to consolidate data by position or category

Building sum-through formulas with wildcard characters

Using PivotTables to consolidate data in the same workbook or multiple workbooks