Completed
Start
Class Central Classrooms beta
YouTube playlists 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
