COURSE NOTES: bit.ly/ShashankExcelCourse
Excel File for Course: drive.google.com/drive/folder...
This course goes over the basic skills in Excel that you'll need if you want to become a Data Analyst or Data Scientist. Excel is a very useful skill in the toolbelt of an analyst but not the end all be all.
My FREE Courses:
🐍 Python 🐍. : • Python for Data Analys...
⌭ SQL ⌭ : • SQL for Data Analysts ...
📊 Tableau📊 : • Tableau Beginner Cours...
📈 Statistics 📈 : • Practical Statistics f...
🤖 Machine Learning 🤖 : • Machine Learning for B...
Patreon: / shashankkalanithi
MX Master 3 amzn.to/3sTroBW
LG 35in Curved Monitor: amzn.to/39pPzR3
USB-C Hub: amzn.to/31Ip8Sl
MacBook Pro Retina 16 Inch: amzn.to/2PSwZde
Twitter: / kalamari95
LinkedIn: / shashankkalanithi
00:00:00 - Introduction
00:01:33 - DataCamp Sponsorship
00:03:16 - Excel Layout
00:05:56 - Excel for Mac vs PC
00:07:13 - My Opinion on VBA
00:08:50 - Google Sheets
00:09:46 - Excel File Formats
00:11:20 - Data Types
00:21:05 - Aggregate Functions (SUM, MEDIAN, MIN, MAX)
00:27:29 - Lookups (VLOOKUP, HLOOKUP, INDEX + MATCH + MATCH)
00:41:02 - IF Functions
00:47:07 - String Functions (CONCAT, TRIM)
00:50:23 - Formatting
00:57:22 - Importing CSVs Correctly
00:59:40 - Remove Duplicates
01:00:58 - Text to Columns
01:02:02 - Filters
01:02:32 - Tables
01:03:30 - Pivot Tables
01:05:39 - Goal Seek
01:09:10 - Excel Solver
01:10:14 - Macros
01:11:09 - Final Thoughts on Excel
This video was sponsored by DataCamp
Негізгі бет Beginner's Excel Tutorial - Data Science/Analysis and Beyond
Пікірлер: 99