Completed
- INDEX and MATCH
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2021-365 Beginners & Intermediate Training
Automatically move to the next video in the Classroom when playback concludes
- 1 - Introduction
- 2 - Course Intro
- 3 - Excel 2021 vs Excel 365
- 4 - Launching Excel
- 5 - The Start Screen
- 6 - Exploring the Interface
- 7 - Ribbons, Tabs and Menus
- 8 - Backstage Area
- 9 - Quick Access Toolbar
- 10 - Useful Keyboard Shortcuts
- 11 - Getting Help
- 12 - Exercise 01
- 13 - Working with Templates
- 14 - Workbooks and Worksheets
- 15 - Saving Workbooks
- 16 - Entering and Editing Data
- 17 - Navigating and Selecting Cells, Rows and Columns
- 18 - Exercise 02
- 19 - Formulas and Functions Explained
- 20 - SUM Function
- 21 - COUNT Function
- 22 - AVERAGE Function
- 23 - MIN and MAX Function
- 24 - Handling Errors in Calculations
- 25 - Absolute vs Relative Referencing
- 26 - Autosum and Autofill Options
- 27 - Flash Fill
- 28 - Exercise 03
- 29 - What are Named Ranges
- 30 - Managing Named Ranges
- 31 - Using Named Ranges
- 32 - Exercise 04
- 33 - Applying Number Formats
- 34 - Applying Date and Time Formats
- 35 - Formatting Cells, Rows and Columns
- 36 - Format Painter
- 37 - Exercise 05
- 38 - Working with Rows and Columns
- 39 - Deleting and Clearing Cells
- 40 - Aligning Text and Numbers
- 41 - Applying Themes and Styles
- 42 - Course Introduction
- 43 - Improve Readability with Cell Styles
- 44 - Controlling Data Input
- 45 - Adding Navigation Buttons
- 46 - Logical Functions
- 47 - The IF Function
- 48 - Nested IFs
- 49 - The IFs Function
- 50 - Conditional IFs
- 51 - Multiple Criteria
- 52 - Error Handling
- 53 - Exercise 01
- 54 - VLookup Exact Match
- 55 - VLookup Approximate Match
- 56 - HLookup
- 57 - INDEX and MATCH
- 58 - XLookup and XMatch
- 59 - OFFSET Function
- 60 - INDIRECT Function
- 61 - Exercise 02
- 62 - Sorting on Multiple Columns
- 63 - Soring Using a Custom List
- 64 - SORT and SORTBY Functions
- 65 - Advanced Filter
- 66 - UNIQUE Function
- 67 - FILTER Function
- 68 - Exercise 03
- 69 - How Date and Times are Stored
- 70 - Custom Data and Time Formats
- 71 - Time and Date Functions
- 72 - WORKDAY and WORKDAY.INTL Functions
- 73 - NETWORKDAYS and NETWORKDAYS.INTL Functions
- 74 - DATEDIF
- 75 - EDATE and EOMONTH
- 76 - Exercise 04
- 77 - Importing Data into Excel
- 78 - Removing Blank Rows, Cells and Duplicate Entries
- 79 - Changing Case and Removing Spaces
- 80 - Splitting Up Data Using Text to Columns
- 81 - Splitting Up Data Using Text Functions
- 82 - Flash Fill
- 83 - CONCAT
- 84 - Formatting Data as Table
