Pivot Tables in Excel | Excel Tutorials for Beginners

Подписаться 803 тыс.

Просмотров 607 тыс.

50% 1

Take my Full Excel for Data Analytics Course! www.analystbuilder.com/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.
Bike Dataset: www.kaggle.com/sadiqshah/bike...
Udemy Excel Courses:
Pivot Tables in Excel: bit.ly/3GEeYoc
Visualizations and Charts in Excel: bit.ly/3DPwRhK
All Excel Essentials: 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: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- bit.ly/3hhX4LX
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - 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 - / alextheanalyst
Alex The Analyst Shop - teespring.com/stores/alex-the...
____________________________________________
Websites:
GitHub: 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

Опубликовано:

27 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 341

@uchindamiphiri1381 7 месяцев назад

I can not thank you enough for whatever you are doing Alex. Am learning and I am confident that by next year I will have a job. I just hope that someone should like my comment next year April. I am giving myself time and room for internships

@brandonvillanueva7575 Год назад

Completed the Coursera Data analytics course and worked my way through this bootcamp to learn more on my own. I just signed my first offer for a job as a DA after searching for 5 months. Thanks Alex

@oluwadamilolao Год назад

awww Congrats! I have a similar journey. Mind if I ask if you reside in the US?

@gabrielasie5369 3 месяца назад

Yo how its going? Did u keep working as a DA? id just started this excel series

@monicahkaranja4291 3 месяца назад

@@gabrielasie5369 Hii can we link up? Just started too

@brandonvillanueva7575 3 месяца назад

@@gabrielasie5369 I still work and got promoted to be their engineer. Pay rose dramatically and it’s going good

@ishdeepkaur8439 2 месяца назад

I wanna ask one question, are six months enough for learning data analytics course or should I go for 11 months course?

@fabienneramon6316 Год назад

Hi Alex, I have what may be a dumb questions, but i'll ask it anyway! I am a 45 year old mum of two living in the UK, who was diagnosed with terminal cancer 10 years ago and who hasn't worked for 10 years. Long story short i'm still not dead and don't plan to be any time soon contrary to what I was told, sooooo.......I will be returning to work this year and hopefully thanks to your amazing channel going back as a Data Analyst (I was previously an IT Project Manager in to financial services (a pretty clueless one at that)). My strategy for completeness is to watch all your videos through once (check), then once more making notes to embed (just finished the excel series), then to go through them all and do the practical aspect and practice the skills, then get online certifications in these areas and then volunteer to work for free for a month or so in any local organisations who may need someone to tidy up their data etc to get some practical in house experience and then go through the interview job searching aspect. So firstly thank you so much for giving me hope there is an after children career for me that I can grow and build on over the next 20 years of employability. So after my long preamble to show you what kinds of different lives of the people you are reaching out to. Is there a reason there is not intermediate or advanced video's for Excel in the toolkit? Thank you in advance for your reply and again, thank you very much for you kindness of spirit and generosity as I could never afford to pay for these courses myself and would therefore still be stumped and scratching around for bit's and bob's here and there. Fabienne

@Chiller31916 5 месяцев назад

Hello Alex, I am starting your course from scratch, starting off with Microsoft Excel as I have the most experience. I am excited to learn your course & hope to complete this course soon. As much as I would like to pay for your Analyst Builder course online, money is very tight right now, so I will be starting with your free offerings on RU-vid to at least have a good foundation. Thank you so much for your help!

@polokomonama6526 Год назад

Hands down the best tutorial on Pivot tables. Thank you so much for your time and effort in making this. Really hope more people will see this so you can get all the exposure you deserve!

@victor_peral 2 года назад

Man you are doing the most, I finished your SQL series after watching plenty others you just have a way of making complex things easy and understandable. You and Sal khan share somethings in common 😁😁

@adamsleuis7794 Год назад

This comment encoouraged me to watch... Alex should thank you.

@JennyHartzog-yc2em Год назад

I have been pulling my hair out trying to learn excel, I've tried so many different courses, RU-vid, etc but they are all akin to watching paint dry. I not only learned something in an engaged way, but I actually enjoyed myself. So excited for more!

@R3DD_TTV Год назад

Hey Alex, I want to thank you from the bottom of my heart. I began actively pursuing my job search in Data Analysis around 5-6 months ago. I just completed my first round of a 2 round interview for my first analyst role. Your series has helped me not only showcase my use of SQL in a portfolio, but you've also helped me make the transition from Google Sheets to MS Excel. Through it all, I'm well on my way to start my first data job and you've helped me more than any resource I utilized during my journey. I wish you nothing but success as you continue your RU-vid journey.

@R3DD_TTV Год назад

*Update* I’ve made it too round 2 for my interview! Hoping this will be my break into the industry.👍🏽

@abdalarockstar915 Год назад

@@R3DD_TTV yo im fresh data analyst can we talk?

@ShowBizJunkie 5 месяцев назад

@@R3DD_TTV Thanks for sharing your success story. I just need your suggestion. I have done Tableau projects of Alex, I have done google data analytics certificate but I still don't feel confidence in my skills. May be theere is something wrong with my learning approach. How did you learn his tutorials? Did you watch them once and performed the exercises as you go and you left it there? This question is directed to everyone who watch his videos. Just tell me your approach to learning. I am having hard times there.

@Mandelbrot567 2 года назад

Excellent introduction to pivot tables. Looking forward to the data cleansing tutorials.

@sevararavshanova3863 2 года назад

Thank you Alex for your straightforward and clear explanation about the Pivot table. Great tutorial. Look forward to the next excel tutorial.

@joemcginnis3296 2 года назад

Alex -- I had been wresting with Pivot Tables for years! This training will impact my influence at my workplace!

@CanYaman92 2 года назад

This is what I was looking for as a Junior Data Analyst. Thank you Alex. Great job.

@AkporHari Год назад

Alex, my best teacher throughout my DA journey so far. The best and most practical explanation of pivot tables I have come across. Thank you Alex, thank you.

@AlexTheAnalyst Год назад

Honored to hear that! Thank you for watching!

@mr.legrandzeh3577 10 месяцев назад

@@AlexTheAnalyst greetings and thanks for all please the dataset is completely mixed up when i open it. What should I do?

@user-pv1uq6ch5j 10 месяцев назад

I cannot believe how easy this was to grasp. I am using this and the formula video to teach myself concepts for an upcoming interview on Tuesday for an Operations Analyst position. I am truly blown away by how passionate Alex is and how easy he broke it down! THANK YOU SO MUCH!

@Jules-69lol 9 месяцев назад

how did it go?

@Karma666__ 7 месяцев назад

did you get it fam?

@Jules-69lol 7 месяцев назад

@@Karma666__ I'm hoping yes since hasn't come back

@Alien-cr1zb 7 месяцев назад

How did it go

@MadeForD 5 месяцев назад

man we need an update

@hamedhelisaz5226 2 года назад

Hi Alex my comment is not specifically about this video but your channel overall. You are providing great content and to be honest, you are one of the reasons I got to know data and understood how much I like the field. Thanks!

@AlexTheAnalyst 2 года назад

So awesome to hear and I’m so glad the channel has been useful! Thanks for watching and supporting the channel 😁

@amandam480 4 месяца назад

omg you are a lifesaver. I paid for a course and can bearly understand it. Thanks so much

@Xilent1 2 года назад

The only person who taught me this. Thanks bro. Great tutorials. Love ‘em all

@roshanjitmahanta6946 9 месяцев назад

This is one of the best Data Analyst Channel in the world! Code Basic and Alex The Analyst my Fav!

@prasannakarkhanis9431 2 года назад

Thank you for this tutorial Alex. For some reasons I was avoiding learning Excel but knew I need to learn it.

@shokoofehheidari5345 Год назад

Thanks Alex for this tutorial! Simple and easy to follow!

@azad5932 2 года назад

Man, I was planning to start the google certification but I feel that this series on Excel is something I should do first in order to be in good shape for the next venture, that google one or otherwise. Thanks for everything you are doing on your channel.

@hanifahwalidah229 7 месяцев назад

I found Google is good for theory and problem-solving within teams but not so much with hardcore skills. That's why I too am taking Alex's bootcamp and supplementing it with Google Certificate. But at the end of the day, the skills, project building, and networking will get you a job not a certificate.

@nerisac637 2 года назад

Thank you for your tutorials and life as an analyst content. Your calm disposition and voice are also soothing and makes me think all analysts are just that - cool and composed hehe. Keep those videos coming, Alex!

@AlexTheAnalyst 2 года назад

Haha I appreciate it! Thanks for watching :)

@ona7574 Месяц назад

Amazing! I'm currently studying Data Analysis, but I find that watching this channel helps me organize my thoughts better. Thanks!!!

@myne_r 2 месяца назад

Currently learning excel here, your videos help me so much. Thank you, Alex!

@1440MAP 6 месяцев назад

Yet another great video. This is something that for some reason looked like it was really difficult to do (pivot tables), but understand them much better now, and can definitely use this when I'm trying to organize my data from SQL queries that I write. Well done, again!

@RichardOnopa 10 месяцев назад

This is awesome. Excellent work, Alex. Very easy to follow!

@angelmoonie 9 месяцев назад

You either dumbed it down enough for me or it really was this easy the whole time and I overcomplicated it. Both are likely. Thanks, Alex!

@jerushajosine3182 Год назад

Thank you Alex, I started self learning from scratch to become a data analyst in 2023and I was surfing through internet for a complete guide and I found your channel. You are doing an awesome job by proving all the information and educating us for free. Thank you so much.

@Kavi-learn Год назад

Hey, how's your learning going?

@aamirrather-ee8le Год назад

@@Kavi-learn hows your

@Kavi-learn Год назад

@@aamirrather-ee8le I'm currently learning SQL. Previously I learnt MS Excel. What about you?

@youknowwhatlol6628 11 месяцев назад

hey guys does anyone want to do some Excel/SQL/Python/Data Analysis/Data Engineering/Machine Learning projects together? I've recently started learning Excel and SQL + Python, so if you have some ideas and most importanly, the DESIRE to do this, i am happy to collaborating!!!! Discord, Instagram? Anyone?????!!?!

@1689JeffChavez 11 месяцев назад

@@youknowwhatlol6628 I am a beginner. But I am interested.

@brand1974 2 года назад

Really glad to see a series like this.

@Structuredmessylife 2 года назад

I will def be adding this to my portfolio and it was such great practice-thank you!

@Hildreim 2 года назад

Definitely a good starter for pivot tables, thank you sir!

@aftabmehdi3460 2 года назад

You are such a great person Alex. I am totally following you to start my journey to learn data analytics and get a good job. Thanks for all these efforts

@AlexTheAnalyst 2 года назад

Thanks man - thanks for watching!

@mehakkamran3929 5 месяцев назад

Today I have just finished the SQL series which is very beneficial for me as a computer science student , and that I have never understood sql in uni or college but all thanks to you , and now I'm just starting this excel series and of course the SQL project is for my weekend

@ItsGibb 5 месяцев назад

I appreciate how you make it simple. Thank you

@darlenecapulong579 2 года назад

Thank you Alex! You’ve been a big help to my journey of becoming a Data Analyst!

@AlexTheAnalyst 2 года назад

So glad to hear that! 😁

@user-my7lk6cu8e 4 месяца назад

Hello Sir, I am starting this data analysis course. I have watch your first lecture and I learn more new things. This is very helpful course for me to learn data analysis in excel. I am very excited to learn more. So, it is very good course.

@afatdaily 4 месяца назад

Thanks Alex. I want to see your excel playlist but somehow I don't have enough time to watch. But Now! I finished this video and understood everything. Thanks

@kibesamuel697 Год назад

From LinkedIn to here thanks a lot Alex, on this day Nov 20TH, the year of our lord 2022, I sharpen my excel skills using your seven tutorials you are the best ALEX. God bless!!

@ElijahErureh 8 месяцев назад

I have been deeply blessed by this boot camp.

@danielbruck3103 2 года назад

A beginner macros video would be amazing (I’m basically self teaching myself data science during working hours in the name of learning macros and automating process for the team) it would help a lot

@fung5157 9 месяцев назад

Amazing ! Thanks Alex for such an amazing series .

@haovan5273 Год назад

Thank you very much Alex. You did a great job explaining it!

@carymayes1083 11 месяцев назад

Love your channel! Absolutely fantastic teaching!

@mattakinss 2 года назад

Thank you, Alex. Really insightful.

@Ckm_lover 4 месяца назад

I'm doing this bootcamp I'm learning a lot thank you for free resources I'm forever grateful to learn new skills ❤

@femifasusi453 10 месяцев назад

Great learning. Good teaching. Simple and very direct approach. Makes the subject much easier to understand.

@Realdarasimi 2 года назад

I feel like praying massively for you Alex! From the bottom of my heart, I pray that the Good Lord bless you. Thanks 🤗

@AlexTheAnalyst 2 года назад

Thank you! Very kind :)

@paryanatahiri3433 2 месяца назад

Wonderful you cant believe how much this 18mins video helps you to learn

@derekborabo2668 9 месяцев назад

Thanks Alex! Biggest thanks from the bottome of my heart. Really, really, really helpful.

@onyinyeihemtuge6223 10 месяцев назад

You make Excel so interesting. Thanks for all your effort.

@farazahmed1668 2 года назад

Mr.Alex you are Wonderful may allah bless you with Iman (Islam).

@michaelokonkwo5141 Год назад

Disgusting human... You must bring religion everywhere

@ajibadeabdulateef2818 Год назад

Amen akhi

@farazahmed1668 10 месяцев назад

@@anigilajeyusuf8201 no i am not but feel free to ask any any questions

@abdelrahmanmalekgenedy8751 5 месяцев назад

Ameen

@user-gx4dw9op1r 3 месяца назад

Ameen ❤❤

@book_tudee Год назад

Thanks so much I'm such a huge fan! I have a huge understanding of pivot tables because of the tutorial keep them coming!

@avi8016 2 года назад

Great tutorial Alex, I learned something new about pivot today. Thankyou

@bellawahyudi1489 Год назад

Finally i find the best content to be Data Analyst. BIG THANKS Alex. God Bless You :)

@AlexTheAnalyst Год назад

Glad it was helpful!

@imme6372 8 месяцев назад

Thank u so much Alex for sharing your precious knowledge for free. I love you.

@ashfaqulislam7762 Год назад

You are my mentor these days. Thank you. Take love from Bangladesh

@jacksonnjiiri2078 8 месяцев назад

Thank you Alex. Just like that i understand Pivot tables.

@fakhrudinhanif4198 Год назад

your explanations are understandable, thanks for it, Alex

@dragoneer121 Год назад

Oh my god both the intro to statistics and intro to data science classes at my university made pivot tables sound so difficult. Wish I had these videos all those years ago!

@omarnayfeh8070 2 года назад

Thx man! Your efforts are appreciated. All your videos are great and helpful. I really try to watch every one of them more than once. Thx again.

@AlexTheAnalyst 2 года назад

I’m so glad to hear that! Thanks for watching my friend 😁

@willymwangi3865 Год назад

Great work Alex. I have learnt something new today. Thank you very much.

@swastiktripathy8412 2 года назад

Very well explained. Thanks Alex.

@nyekobrian3325 Месяц назад

Thank for the knowledge sharing. This was indeed helpful for me. I appreciate!

@user-wn4vi3mz9w 21 день назад

Alex,Sir Great Contribution From Your Side About This Pivot Table ,I Really Liked It Thank You ❤

@hendmohamed851 10 месяцев назад

Thank you so much for Simplifying my DA journey 🙏

@HashimZaman360 4 месяца назад

Thank you so much mate! You are amazing!

@TemiAnData Год назад

This is amazing Alex. Thank you so much

@agnesmsc Год назад

I learned more from you than from my module leader ... Thank you :)

@Dean-ui3wl 2 года назад

I have a Data Analyst interview assessment tomorrow using Pivot Tables. I can't believe my luck that you have uploaded this today! Thank you!

@AlexTheAnalyst 2 года назад

Hope it helps! Good luck tomorrow!!

@Dean-ui3wl 2 года назад

@@AlexTheAnalyst I got the job!

@doreenodhiambo2293 2 года назад

@Dean do you mind sharing your interview questions and experience

@vs9108 2 года назад

Thank you Alex! that was easy to understand☺️

@yewandealakija-banjo4944 Год назад

very insightful for a first timer. thanks Alex

@user-mq1xp5qk8d Месяц назад

The best presentation so far

@MrPolyalert 2 года назад

This is excellent! Thank you alex

@silviacatarino 2 года назад

Thank you so much for your videos and content!

@amritade4442 2 года назад

Thank you so much Alex for this tutorial. I would request you if possible please cover basic power queries and macros. Thanks!

@aamirrather-ee8le Год назад

Hii did you completed analytics and. Get the job share your experiences

@ifyihesie4287 Год назад

VERY HELPFUL.THANK YOU ALEX

@MuhammadQasim-rr4cm 6 месяцев назад

Every second full of Information. Lot of respect for you, Sir❤

@thuhuongdoi 2 года назад

Thank you for this tutorial, Alex. Ahaha, I have been waiting for it for long

@ravsingh1576 2 года назад

Hey Alex, great videos. Thanks for all your helpful tips and videos.

@AlexTheAnalyst 2 года назад

You're most welcome - thanks for watching!

@yasfarfan 2 года назад

Hey Alex you never stop surprising us with such a great videos

@AlexTheAnalyst 2 года назад

Glad I still put out decent content 😂

@Nerdzin93 Год назад

I'm really enjoying your channel! Thanks for the awesome content

@erisiabatto Месяц назад

This is great! very easy to follow for excel noobs like myself!

@chineduekechukwu1089 Год назад

Thank you Alex! Great content indeed (5-star)

@oluwatoyinagbetoye5008 9 месяцев назад

Thank you so much for this. You explained well and made it easy to understand.

@jeromefuentes2060 3 месяца назад

Thank you so much, Alex!

@zakariaabdikadir9296 Год назад

Excellent One Alex, Thanks.

@Blenderjutsu 2 года назад

Thank you. Waiting for the next one

@farzanmalik_7815 2 года назад

Your content and presentation is top notch...have become a fan

@studywithziafat7276 9 месяцев назад

Lost for words............ just amazing

@ThanhNguyen-ip9xb 2 года назад

thanks you Alex!

@AwanievaStudios Год назад

Hello Alex Thank you for taking your time to explain all of this. I watched your video on cleaning data in Excel and I was wondering why you didn't filter and remove duplicate in the data set we used in this video. Was there any particular reason?

@yhangcreates Год назад

Glad I followed you on Linkedin. I'm an aspiring Analyst and your video is so helpful :)

@user-xk8en2fz9s 2 месяца назад

thanks for releasing this video so helpful

@comicvietnam2598 9 месяцев назад

Thank you for lesson.

@adebayosoliu9772 8 месяцев назад

❤ This is so beautiful God bless you Thanks so much ❤️

@AntoniLopezDev Месяц назад

I love it, thanks!

@badiraslan 2 года назад

wonderful awesome, thank you Alex I really appreciate what are you doing ,amazing and the best what I see

@mdsajadulislamdipu7395 Год назад

What a Insightful tutorial it was about pivot table ! I am really grateful to you dear

@vigneshwarangurusamy1808 2 года назад

first of all thank you for making this video Alex . Your Content is very good and it's good for beginners . But it's very rudimentary in nature . I expect a intermediate level of video as well as real data analytics project that your conduct in data analysis using Excel.