Completed
Consolidating Data
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2016 Advanced Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Named Ranges
- 3 Creating Named Ranges from Selection
- 4 Named Ranges Continued
- 5 IF Functions
- 6 Formula Auditing Tools
- 7 IF Functions Continued
- 8 Nesting Functions
- 9 VLOOKUP
- 10 Autofill VLOOKUP & IFERROR
- 11 VLOOKUP Range
- 12 VLOOKUP Range with Nested Functions
- 13 HLOOKUP
- 14 SUMIF
- 15 AVERAGEIF
- 16 SUMIFS
- 17 Date Functions
- 18 Text Functions
- 19 Consolidating Data
- 20 Consolidating Data Without Structure
- 21 Complex Solver Tool
- 22 Solver Tool
- 23 Scenario Manager
- 24 Data Table
- 25 Turning on the Developer Tab
- 26 Recording Macros
- 27 Editing Macros in VBA & Recording a Second Macro
- 28 Adding Macros to the QA Toolbar
- 29 Adding Macro Buttons to the Worksheet
- 30 Conclusion
