Sobre o curso
Aprenda Excel Tutorials for Data Analysts gratuitamente com 7 vídeo(s). Curso online grátis de Microsoft Excel | YouCourse.
Aulas do Curso (7 vídeos)
Descrição da aula 0: Pivot Tables in Excel | Excel Tutorials for Beginners
Take my Full Excel for Data Analytics Course! https://www.analystbuilder.com/courses/excel-for-data-analytics 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. Bike Dataset: https://www.kaggle.com/sadiqshah/bike-store-sales-in-europe/data Udemy Excel Courses: Pivot Tables in Excel: https://bit.ly/3GEeYoc Visualizations and Charts in Excel: https://bit.ly/3DPwRhK All Excel Essentials: https://bit.ly/31Y2I2Q ____________________________________________ 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: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN *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 - https://www.patreon.com/AlexTheAnalyst Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst 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*
Descrição da aula 1: Formulas in Excel | Excel Tutorials for Beginners
Take my Full Excel for Data Analytics Course! https://www.analystbuilder.com/courses/excel-for-data-analytics 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: https://github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Formula%20Excel%20Template.xlsx Udemy Excel Courses: Pivot Tables in Excel: https://bit.ly/3peELgG Visualizations and Charts in Excel: https://bit.ly/30MU9HT All Excel Essentials: https://bit.ly/3Fdk6iG 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: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN *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 - https://www.patreon.com/AlexTheAnalyst Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst 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*
Descrição da aula 2: XLOOKUP in Excel | Excel Tutorials for Beginners
Take my Full Excel for Data Analytics Course! https://www.analystbuilder.com/courses/excel-for-data-analytics 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 XLOOKUP Template: https://bit.ly/314BWFV Microsoft XLOOKUP Documentation: https://bit.ly/3mF3dGx Udemy Excel Courses: Pivot Tables in Excel: https://bit.ly/3peELgG Visualizations and Charts in Excel: https://bit.ly/30MU9HT All Excel Essentials: https://bit.ly/3Fdk6iG ____________________________________________ 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: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN *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 - https://www.patreon.com/AlexTheAnalyst Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst Instagram: @Alex_The_Analyst ____________________________________________ 0:00 Intro 0:59 XLOOKUP Overview 4:14 XLOOKUP w Multiple Rows 6:16 XLOOKUP Exact Match 9:29 XLOOKUP Search Order 12:12 XLOOKUP Horizontal Search 12:55 XLOOKUP w SUM() 14:51 XLOOKUP vs VLOOKUP *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*
Descrição da aula 3: Conditional Formatting in Excel | Excel Tutorials for Beginners
Take my Full Excel for Data Analytics Course! https://www.analystbuilder.com/courses/excel-for-data-analytics 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 Conditional Formatting Template: https://github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Conditional%20Formatting%20Excel%20Tutorial%20File.xlsx Udemy Excel Courses: Pivot Tables in Excel: https://bit.ly/3JXCq28 Visualizations and Charts in Excel: https://bit.ly/3HOyij9 All Excel Essentials: https://bit.ly/3tf6XCK ____________________________________________ 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: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN *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 - https://www.patreon.com/AlexTheAnalyst Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst 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*
Descrição da aula 4: Charts in Excel | Excel Tutorials for Beginners
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 Charts Template: https://github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Excel%20Charts%20Tutorial%20File.xlsx Udemy Excel Courses: Pivot Tables in Excel: https://bit.ly/3ffIxk1 Visualizations and Charts in Excel: https://bit.ly/3qesfyu All Excel Essentials: https://bit.ly/3JRlJ8B ____________________________________________ 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: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN *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 - https://www.patreon.com/AlexTheAnalyst Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst 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*
Descrição da aula 5: Cleaning Data in Excel | Excel Tutorials for Beginners
Take my Full Excel for Data Analytics Course! https://www.analystbuilder.com/courses/excel-for-data-analytics 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 Data Cleaning File: https://github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Data%20Cleaning%20Excel%20Tutorial.xlsx Unlocked by Z by HP: Click this link (https://www.clkmg.com/learnmedia/alexfreberg) to participate in the data challenges and have a chance to win the prizes! And don't forget to RSVP for the hackathon on Saturday, March 12th from 7am PST/8:30am IST until 1pm PST/2:30am IST: https://hopin.com/events/hp-hackathon (Spots limited) "No purchase necessary. Ends April 30, 2022. See official rules at www.hp.com/us-en/workstations/industries/data-science/unlocked-with-z/rules.html for how to enter, eligibility, odds, prize details, and restrictions. " ____________________________________________ 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: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN *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 - https://www.patreon.com/AlexTheAnalyst Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst 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*
Descrição da aula 6: Full Project in Excel | Excel Tutorials for Beginners
Take my Full Excel for Data Analytics Course! https://www.analystbuilder.com/courses/excel-for-data-analytics In this video we walk through the data cleaning process and dashboard creation in Excel. Excel Dataset: https://github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Excel%20Project%20Dataset.xlsx ____________________________________________ 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: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN *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 - https://www.patreon.com/AlexTheAnalyst Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst 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*
Sobre o Canal
Alex The Analyst
My name is Alex Freberg and on this channel I'll teach you everything you need to know to be a great Data Analyst. If you are wanting to make a career change or learn the skills needed to become a Data Analyst, be sure to subscribe to stay up to date on all my latest content. LinkedIn: https://www.linkedin.com/in/alex-freberg/ Take my Full Courses on: https://www.analystbuilder.com Discord Channel: https://discord.gg/rxZUjNvRzR X: @Alex_TheAnalyst
Mais cursos do Canal
GRATUITO
Cursos relacionados
Prévia do curso
