Working With Multiple Worksheets and Workbooks in Excel 2016: Consolidate Data
Interactive

Working With Multiple Worksheets and Workbooks in Excel 2016: Consolidate Data

Biz Library
Updated Feb 12, 2019
Book a demoGet it for free
Microsoft Office Excel 2016: Part 3 (Advanced) - Excel 2016 enables you to consolidate data based on either relative cell positions in the various source datasets or by categories, which are based on row and column labels. (Data Consolidation)
Related learning
Working With Multiple Worksheets and Workbooks in Excel 2016: Use 3D ReferencesInteractive ⋅ 4 mins
Preparing Data and Creating Pivot Tables in Excel 2016: Create a PivotTable From Multiple Local Data SourcesInteractive ⋅ 7 mins
Excel Office 365: Referencing DataInteractive ⋅ 48 mins
Working With Multiple Worksheets and Workbooks in Excel 2016: Use Links and External ReferencesInteractive ⋅ 6 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