Completed
- Controlling Data Input
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft Excel Intermediate Training - Excel Tutorial Class
Automatically move to the next video in the Classroom when playback concludes
- 1 - Introduction
- 2 - Improve Readability with Cell Styles
- 3 - Controlling Data Input
- 4 - Adding Navigation Buttons
- 5 - Logical Functions
- 6 - The IF Function
- 7 - Nested IFs
- 8 - The IFs Function
- 9 - Conditional IFs
- 10 - Multiple Criteria
- 11 - Error Handling
- 12 - Exercise 01
- 13 - VLOOKUP Exact Match
- 14 - VLOOKUP Approximate Match
- 15 - HLOOKUP Function
- 16 - INDEX and MATCH
- 17 - XLookup and XMatch
- 18 - OFFSET Function
- 19 - INDIRECT Function
- 20 - Exercise 02
- 21 - Sorting on Multiple Columns
- 22 - Sorting Using a Custom List
- 23 - SORT and SORTBY Functions
- 24 - Advanced Filter
- 25 - UNIQUE Function
- 26 - FILTER Function
- 27 - Exercise 03
- 28 - How Dates and Times are Stored
- 29 - Custom Date and Time Formats
- 30 - Time and Date Functions
- 31 - WORKDAY and WORKDAY.INT Functions
- 32 - NETWORKDAYS and NETWORKDAYS.INT Functions
- 33 - DATEDIF Function
- 34 - EDATE and EOMONTH Functions
- 35 - Exercise 04
- 36 - Importing Data into Excel
- 37 - Removing Blank Rows, Cells, and Duplicate Entries
- 38 - Changing Case and Removing Spaces
- 39 - Splitting Up Data Using Text to Columns
- 40 - Splitting Up Data Using Text Functions
- 41 - Using Flash Fill
- 42 - CONCAT Function
- 43 - Formatting Data as Table
