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: %20Excel% 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*