Microsoft Excel for Data Analysis | Data Science | Business Analyst
The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. This video will help you understand how to perform Data Analytics using Excel.
In this video, you will learn how to perform data analysis using Excel's most popular features in four steps:
0:00 - Intro
1:55 - Import Data
Import data from CSV
Text to Columns
Autofill
Basic & Conditional Formatting & Excel shortcuts Tips
14:13 - Clean Data
Remove Duplicates & Spaces
Data Sorting
Find & Replace
Spell Check
Proper Fonts
Replace Missing Values
23:19 - Transforming & Compiling Data
-Some Basic Math & Stats Functions in Excel
IF Function
Create Drop down list (Data Validation)
Vlookup & Hlookup
Index-Match
Data Transpose
Flash Fill
46:40 - Analyze
Filter
Consolidate
Pivot
🔹Computer Vision Playlist:
https://bit.ly/31FUV6C
🔹Numpy Video:
https://bit.ly/3cewPnq
🔹Python Tutorial Playlist:
https://bit.ly/31nOjsM
🔹Pandas Video:
https://bit.ly/3cZnu3r
🔹Pandas Playlist:
https://bit.ly/2OWAThn
🔹Auto ML Playlist:
https://bit.ly/3gxl7WC
Subscribe my Channel : https://bit.ly/2DA3vuv
*** Connect with me on below Channels ***
LinkedIn: / preeti-sondhi-963b5649
Email : [email protected]
If you find any difficulty or have any query then do COMMENT below. PLEASE help our channel by SUBSCRIBING and LIKE our video if you found it helpful.
Thank You.
Happy Learning.
#Excel #dataanalytics #datascience
Watch video Microsoft Excel for Data Analysis | Data Science | Business Analyst online without registration, duration hours minute second in high quality. This video was added by user Preeti Sondhi 23 December 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,089 once and liked it 45 people.