Completed
- Lookups VLOOKUP, HLOOKUP, INDEX + MATCH + MATCH
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Beginner's Excel Tutorial - Data Science-Analysis and Beyond
Automatically move to the next video in the Classroom when playback concludes
- 1 - Introduction
- 2 - DataCamp Sponsorship
- 3 - Excel Layout
- 4 - Excel for Mac vs PC
- 5 - My Opinion on VBA
- 6 - Google Sheets
- 7 - Excel File Formats
- 8 - Data Types
- 9 - Aggregate Functions SUM, MEDIAN, MIN, MAX
- 10 - Lookups VLOOKUP, HLOOKUP, INDEX + MATCH + MATCH
- 11 - IF Functions
- 12 - String Functions CONCAT, TRIM
- 13 - Formatting
- 14 - Importing CSVs Correctly
- 15 - Remove Duplicates
- 16 - Text to Columns
- 17 - Filters
- 18 - Tables
- 19 - Pivot Tables
- 20 - Goal Seek
- 21 - Excel Solver
- 22 - Macros
- 23 - Final Thoughts on Excel
