Completed
Database Functions
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Full Course Tutorial - From Basics to Advanced (4+ Hours)
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 What is Excel?
- 4 Excel Interface Overview
- 5 Search and Help
- 6 Navigating and Selecting Cells
- 7 Entering, Replacing, and Deleting Data
- 8 Adjusting Cells
- 9 Calculations, Formulas, and Functions
- 10 Basic Functions
- 11 AutoFill
- 12 Relative and Absolute Cell Reference
- 13 Saving and Sharing Workbooks
- 14 Comments
- 15 Inserting Rows and Columns
- 16 Cut, Copy, and Paste
- 17 Formatting Data with Cell Styles
- 18 Managing Worksheets
- 19 Hiding Row and Columns
- 20 Creating Custom Views
- 21 Reviewing Worksheets
- 22 Printing Worksheets
- 23 Conclusion
- 24 Introduction
- 25 Creating Tables
- 26 Flash Fill
- 27 Introduction to Sorting Data
- 28 SORT Function
- 29 SORTBY Function
- 30 UNIQUE Function
- 31 Filters
- 32 Slicers
- 33 Subtotals
- 34 Quick Analysis Tool
- 35 Inserting Charts
- 36 Formatting Charts
- 37 Creating Chart Templates
- 38 Printing Charts
- 39 Using Sparklines
- 40 Introduction to Pivot Tables
- 41 Pivot Charts
- 42 Using Slicers with Pivot Tables
- 43 Data Validation
- 44 Conditional Formatting
- 45 Custom Conditional Formatting
- 46 Linking Data
- 47 Conclusion
- 48 Introduction
- 49 Named Ranges
- 50 Multiple Named Ranges
- 51 XLOOKUP
- 52 Data Mining with XLOOKUP
- 53 IF Function
- 54 Database Functions
- 55 Goal Seek
- 56 PMT Data Tables
- 57 Macros
- 58 IF-THEN Statements
- 59 Do Until Loops
- 60 Creating Games with Excel VBA Code
- 61 Conclusion
