Completed
ABS, REF, and AutoFill Functions
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Excel 2021 Full Course Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Start Screen
- 4 Excel Interface
- 5 Zooming, Navigating, and Shortcuts
- 6 Performing Excel Calculations
- 7 Simple Excel Functions
- 8 ABS, REF, and AutoFill Functions
- 9 Checking Compatibility
- 10 Inserting, Moving, and Cutting
- 11 Cell Styles
- 12 Themes
- 13 Showing and Hiding Worksheets
- 14 Grouping Worksheets
- 15 Freeze Panes
- 16 Custom Views
- 17 Saving Templates
- 18 Spell Check
- 19 Print Preview
- 20 Conclusion
- 21 Introduction
- 22 Formatting Lists as Tables
- 23 Flash Fill
- 24 Custom Sorting
- 25 Subtotals
- 26 QA Tool
- 27 Data Charts
- 28 Sparklines
- 29 Introduction to Pivot Tables
- 30 Advanced Pivot Tables Options
- 31 Data Validation
- 32 Conditional Formats
- 33 Comments and Notes
- 34 Linking Data
- 35 Privacy and Protection
- 36 Conclusion
- 37 Introduction
- 38 Nesting Functions
- 39 Database Functions
- 40 XLOOKUP
- 41 UNIQUE
- 42 SORT and SORTBY
- 43 FILTER
- 44 LET
- 45 Consolidate
- 46 Introduction to Macros
- 47 Recording and Playing Macros
- 48 Conclusion
