Overview
This course teaches basic Excel skills essential for aspiring Data Analysts or Data Scientists. Students will learn about Excel layout, data types, aggregate functions, lookups, IF functions, string functions, formatting, data importing, and more. The course covers topics such as Pivot Tables, Goal Seek, Excel Solver, and Macros. The teaching method includes video lectures and practical demonstrations. This course is intended for beginners interested in data analysis or data science.
Syllabus
- Introduction
- DataCamp Sponsorship
- Excel Layout
- Excel for Mac vs PC
- My Opinion on VBA
- Google Sheets
- Excel File Formats
- Data Types
- Aggregate Functions SUM, MEDIAN, MIN, MAX
- Lookups VLOOKUP, HLOOKUP, INDEX + MATCH + MATCH
- IF Functions
- String Functions CONCAT, TRIM
- Formatting
- Importing CSVs Correctly
- Remove Duplicates
- Text to Columns
- Filters
- Tables
- Pivot Tables
- Goal Seek
- Excel Solver
- Macros
- Final Thoughts on Excel
Taught by
Shashank Kalanithi