Take my Full Excel for Data Analytics Course! [ Ссылка ]
Excel is one of the most used skills in the data world. In this series we will be walking through all of the most important topics that Data Analysts need to know in order to be proficient in Excel.
Excel Formula Template:
[ Ссылка ]
Udemy Excel Courses:
Pivot Tables in Excel: [ Ссылка ]
Visualizations and Charts in Excel: [ Ссылка ]
All Excel Essentials: [ Ссылка ]
Outline:
0:00 Intro
2:25 Max/Min
4:33 IF/IFS
8:46 Len
10:30 Left/Right
13:29 Date to Text
17:02 Trim
18:27 Concatenate
20:45 Substitute
24:42 Sum/SumIF/SumIFS
28:02 Count/CountIF/CountIFS
30:36 Days/NetworkDays
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
Google Data Analyst Certification: [ Ссылка ]
Data Analysis with Python - [ Ссылка ]
IBM Data Analysis Specialization - [ Ссылка ]
Tableau Data Visualization - [ Ссылка ]
Udemy Courses:
Python for Data Analysis and Visualization- [ Ссылка ]
Statistics for Data Science - [ Ссылка ]
SQL for Data Analysts (SSMS) - [ Ссылка ]
Tableau A-Z - [ Ссылка ]
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
SUPPORT MY CHANNEL - PATREON/MERCH
Patreon Page - [ Ссылка ]
Alex The Analyst Shop - [ Ссылка ]
____________________________________________
Websites:
GitHub: [ Ссылка ]
Instagram: @Alex_The_Analyst
____________________________________________
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
![](https://i.ytimg.com/vi/XRPyj7cKVsQ/maxresdefault.jpg)