Excel 2010 Part 3: Consolidate Data
Interactive

Excel 2010 Part 3: Consolidate Data

Biz Library
Updated Dec 31, 2018
Book a demoGet it for free
If you want to bring together the contents of multiple tables or spreadsheets together on a new spreadsheet, it would be pretty time-consuming to have to perform this manually. With the "consolidate data" function, Excel 2010 gives you the ability to automate this and summarizes values from multiple fields in a new area. The following video shows you how much time you save as a result.
Related learning
Preparing Data and Creating Pivot Tables in Excel 2016: Create a PivotTable From Multiple Local Data SourcesInteractive ⋅ 7 mins
Working With Multiple Worksheets and Workbooks in Excel 2016: Consolidate DataInteractive ⋅ 5 mins
Excel 2013 Part 2: Create and Modify TablesInteractive ⋅ 5 mins
Working With Multiple Worksheets and Workbooks in Excel 2016: Use 3D ReferencesInteractive ⋅ 4 mins

Explore more technology skills

IT Software
IT Software
Web Design and Development
Web Design and Development
Data & Analytics
Data & Analytics
Design and Animation
Design and Animation
Gaming and Games Development
Gaming and Games Development
Devops, Networking and Security
Devops, Networking and Security
Programming and Web Development
Programming and Web Development
Computer Science and Engineering
Computer Science and Engineering