Pivot Tables in Excel | Excel Tutorials for Beginners

แชร์
ฝัง
  • เผยแพร่เมื่อ 6 ก.ย. 2024

ความคิดเห็น • 383

  • @brandonvillanueva7575
    @brandonvillanueva7575 ปีที่แล้ว +159

    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
      @oluwadamilolao ปีที่แล้ว +6

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

    • @gabrielasie5369
      @gabrielasie5369 5 หลายเดือนก่อน

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

    • @monicahkaranja4291
      @monicahkaranja4291 5 หลายเดือนก่อน

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

    • @brandonvillanueva7575
      @brandonvillanueva7575 5 หลายเดือนก่อน

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

    • @ishdeepkaur8439
      @ishdeepkaur8439 5 หลายเดือนก่อน +1

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

  • @fabienneramon6316
    @fabienneramon6316 ปีที่แล้ว +30

    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

    • @AbutalhaSheikh-dy1dw
      @AbutalhaSheikh-dy1dw หลายเดือนก่อน +2

      How are you Fabienne? I hope you bagged a job as a DA

  • @uchindamiphiri1381
    @uchindamiphiri1381 10 หลายเดือนก่อน +26

    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

    • @sanjana406
      @sanjana406 หลายเดือนก่อน

      please share an update

  • @user-pv1uq6ch5j
    @user-pv1uq6ch5j ปีที่แล้ว +41

    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
      @Jules-69lol ปีที่แล้ว +4

      how did it go?

    • @Karma666__
      @Karma666__ 10 หลายเดือนก่อน

      did you get it fam?

    • @Jules-69lol
      @Jules-69lol 10 หลายเดือนก่อน

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

    • @Alien-cr1zb
      @Alien-cr1zb 10 หลายเดือนก่อน

      How did it go

    • @MadeForD
      @MadeForD 8 หลายเดือนก่อน +1

      man we need an update

  • @R3DD_TTV
    @R3DD_TTV ปีที่แล้ว +30

    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 TH-cam journey.

    • @R3DD_TTV
      @R3DD_TTV ปีที่แล้ว +5

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

    • @abdalarockstar915
      @abdalarockstar915 ปีที่แล้ว

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

    • @ShowBizJunkie
      @ShowBizJunkie 7 หลายเดือนก่อน

      @@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.

  • @victor_peral
    @victor_peral 2 ปีที่แล้ว +62

    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
      @adamsleuis7794 ปีที่แล้ว +4

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

  • @farazahmed1668
    @farazahmed1668 2 ปีที่แล้ว +154

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

  • @JennyHartzog-yc2em
    @JennyHartzog-yc2em ปีที่แล้ว +9

    I have been pulling my hair out trying to learn excel, I've tried so many different courses, TH-cam, 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!

  • @AkporHari
    @AkporHari 2 ปีที่แล้ว +22

    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
      @AlexTheAnalyst  ปีที่แล้ว +4

      Honored to hear that! Thank you for watching!

    • @mr.legrandzeh3577
      @mr.legrandzeh3577 ปีที่แล้ว

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

  • @jerushajosine3182
    @jerushajosine3182 ปีที่แล้ว +25

    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
      @Kavi-learn ปีที่แล้ว +1

      Hey, how's your learning going?

    • @aamirrather-ee8le
      @aamirrather-ee8le ปีที่แล้ว

      @@Kavi-learn hows your

    • @Kavi-learn
      @Kavi-learn ปีที่แล้ว

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

    • @youknowwhatlol6628
      @youknowwhatlol6628 ปีที่แล้ว +3

      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
      @1689JeffChavez ปีที่แล้ว +1

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

  • @hamedhelisaz5226
    @hamedhelisaz5226 2 ปีที่แล้ว +32

    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
      @AlexTheAnalyst  2 ปีที่แล้ว +7

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

  • @Chiller31916
    @Chiller31916 8 หลายเดือนก่อน +13

    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 TH-cam to at least have a good foundation.
    Thank you so much for your help!

  • @azad5932
    @azad5932 2 ปีที่แล้ว +21

    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
      @hanifahwalidah229 10 หลายเดือนก่อน +1

      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.

  • @Mandelbrot567
    @Mandelbrot567 2 ปีที่แล้ว +38

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

  • @mehakkamran3929
    @mehakkamran3929 8 หลายเดือนก่อน +1

    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

  • @polokomonama6526
    @polokomonama6526 ปีที่แล้ว +24

    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!

  • @Dean-ui3wl
    @Dean-ui3wl 2 ปีที่แล้ว +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
      @AlexTheAnalyst  2 ปีที่แล้ว +1

      Hope it helps! Good luck tomorrow!!

    • @Dean-ui3wl
      @Dean-ui3wl 2 ปีที่แล้ว +7

      @@AlexTheAnalyst I got the job!

    • @doreenodhiambo2293
      @doreenodhiambo2293 2 ปีที่แล้ว +1

      @Dean do you mind sharing your interview questions and experience

  • @Realdarasimi
    @Realdarasimi 2 ปีที่แล้ว +1

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

  • @nerisac637
    @nerisac637 2 ปีที่แล้ว +8

    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
      @AlexTheAnalyst  2 ปีที่แล้ว +2

      Haha I appreciate it! Thanks for watching :)

  • @joemcginnis3296
    @joemcginnis3296 2 ปีที่แล้ว +2

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

  • @Ckm_lover
    @Ckm_lover 7 หลายเดือนก่อน +1

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

  • @angelmoonie
    @angelmoonie 11 หลายเดือนก่อน +1

    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!

  • @roshanjitmahanta6946
    @roshanjitmahanta6946 ปีที่แล้ว +1

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

  • @manikantkaushik4003
    @manikantkaushik4003 18 วันที่ผ่านมา

    00:01 The excel tutorial series will cover concrete and nuanced things used in data analysis such as pivot tables, charts, vlookups, dealing with missing and dirty data.
    01:46 Using pivot tables in Excel for data analysis
    03:49 Introduction to using pivot tables in Excel
    05:45 Pivot tables in Excel allow for easy expansion and collapse of grouped data.
    07:48 Using pivot tables to analyze revenue data by country and state
    09:54 Sorting and analyzing data in Excel
    12:00 Creating calculated fields in Pivot Tables
    13:58 Filters in Pivot Tables allow for detailed data filtering.
    16:07 Pivot tables in Excel allow for easy data analysis

  • @dragoneer121
    @dragoneer121 ปีที่แล้ว +2

    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!

  • @danielbruck3103
    @danielbruck3103 2 ปีที่แล้ว +13

    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

  • @kibesamuel697
    @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!!

  • @CanYaman92
    @CanYaman92 2 ปีที่แล้ว +7

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

  • @amandam480
    @amandam480 7 หลายเดือนก่อน +1

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

  • @bellawahyudi1489
    @bellawahyudi1489 ปีที่แล้ว +1

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

  • @ona7574
    @ona7574 4 หลายเดือนก่อน

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

  • @aftabmehdi3460
    @aftabmehdi3460 2 ปีที่แล้ว +4

    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
      @AlexTheAnalyst  2 ปีที่แล้ว

      Thanks man - thanks for watching!

  • @user-my7lk6cu8e
    @user-my7lk6cu8e 6 หลายเดือนก่อน

    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.

  • @paryanatahiri3433
    @paryanatahiri3433 5 หลายเดือนก่อน

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

  • @agnesmsc
    @agnesmsc ปีที่แล้ว +2

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

  • @sevararavshanova3863
    @sevararavshanova3863 2 ปีที่แล้ว +4

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

  • @afatdaily
    @afatdaily 7 หลายเดือนก่อน

    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

  • @omarnayfeh8070
    @omarnayfeh8070 2 ปีที่แล้ว +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
      @AlexTheAnalyst  2 ปีที่แล้ว +1

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

  • @Xilent1
    @Xilent1 2 ปีที่แล้ว +1

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

  • @Hildreim
    @Hildreim 2 ปีที่แล้ว +3

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

  • @myne_r
    @myne_r 5 หลายเดือนก่อน

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

  • @darlenecapulong579
    @darlenecapulong579 2 ปีที่แล้ว +1

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

  • @eugenekiriago7361
    @eugenekiriago7361 หลายเดือนก่อน

    just started the course and hoping to land a data analyst job by next year

  • @ElijahErureh
    @ElijahErureh 11 หลายเดือนก่อน

    I have been deeply blessed by this boot camp.

  • @prasannakarkhanis9431
    @prasannakarkhanis9431 2 ปีที่แล้ว +1

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

  • @ashfaqulislam7762
    @ashfaqulislam7762 ปีที่แล้ว

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

  • @onyinyeihemtuge6223
    @onyinyeihemtuge6223 ปีที่แล้ว +1

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

  • @user-wn4vi3mz9w
    @user-wn4vi3mz9w 3 หลายเดือนก่อน

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

  • @willymwangi3865
    @willymwangi3865 ปีที่แล้ว +1

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

  • @imme6372
    @imme6372 10 หลายเดือนก่อน

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

  • @kelthekonqrr
    @kelthekonqrr ปีที่แล้ว

    This was the first video I actually watched in the series... And I'm here again!!! But now, I'm like the character in an RPG game who has advanced armor but is sweeping through lower levels for easter eggs hahaa

  • @hendmohamed851
    @hendmohamed851 ปีที่แล้ว

    Thank you so much for Simplifying my DA journey 🙏

  • @erisiabatto
    @erisiabatto 4 หลายเดือนก่อน

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

  • @femifasusi453
    @femifasusi453 ปีที่แล้ว

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

  • @1689JeffChavez
    @1689JeffChavez ปีที่แล้ว

    On my journey through the boot camp...
    Pivot tables are awesome!

  • @1440MAP
    @1440MAP 9 หลายเดือนก่อน

    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!

  • @brand1974
    @brand1974 2 ปีที่แล้ว +1

    Really glad to see a series like this.

  • @tech_guruLG
    @tech_guruLG 2 ปีที่แล้ว

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

  • @amritade4442
    @amritade4442 2 ปีที่แล้ว +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
      @aamirrather-ee8le ปีที่แล้ว

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

  • @SashikantNayak
    @SashikantNayak หลายเดือนก่อน

    Hey Alex, Im not able to download the excel sheet from the link that you have shared!!! It says 502 bad gateway

  • @derekborabo2668
    @derekborabo2668 ปีที่แล้ว

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

  • @adebayosoliu9772
    @adebayosoliu9772 11 หลายเดือนก่อน +1

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

  • @LifestyleofMasina
    @LifestyleofMasina 7 หลายเดือนก่อน

    Take your flowers and lots of beer Alex!! You are so good at teaching and its so refreshing 😊
    By the way, does anyone on here have a few platforms they can suggest to me to build my portfolio so i can show/direct them to potential employers?

  • @MuhammadQasim-rr4cm
    @MuhammadQasim-rr4cm 9 หลายเดือนก่อน

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

  • @farzanmalik_7815
    @farzanmalik_7815 2 ปีที่แล้ว +1

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

  • @ItsGibb
    @ItsGibb 7 หลายเดือนก่อน

    I appreciate how you make it simple. Thank you

  • @yasfarfan
    @yasfarfan 2 ปีที่แล้ว +1

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

    • @AlexTheAnalyst
      @AlexTheAnalyst  2 ปีที่แล้ว +1

      Glad I still put out decent content 😂

  • @jacksonnjiiri2078
    @jacksonnjiiri2078 10 หลายเดือนก่อน

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

  • @fung5157
    @fung5157 11 หลายเดือนก่อน +1

    Amazing ! Thanks Alex for such an amazing series .

  • @mimz7621
    @mimz7621 ปีที่แล้ว +2

    Hi guys the data I I downloaded is not organized anyone else with the issue

  • @oluwademiladebademosi9484
    @oluwademiladebademosi9484 10 หลายเดือนก่อน +1

    Hey Alex. What if I come across a column with text and number lumped together without delimiters? How do I split them into separate columns?

  • @avi8016
    @avi8016 2 ปีที่แล้ว +1

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

  • @deniztunakarasu4803
    @deniztunakarasu4803 หลายเดือนก่อน

    simple, understandable, clear thank you !

  • @oluwatoyinagbetoye5008
    @oluwatoyinagbetoye5008 11 หลายเดือนก่อน

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

  • @mv8167
    @mv8167 ปีที่แล้ว

    Thank you for all of your hard work. My only thought is to make your cursor bigger. It sometimes takes some effort to track what you are doing as you are fast in your mouse usage. Thx again

  • @mdsajadulislamdipu7395
    @mdsajadulislamdipu7395 ปีที่แล้ว

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

  • @nyekobrian3325
    @nyekobrian3325 3 หลายเดือนก่อน

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

  • @krishnathanki999
    @krishnathanki999 25 วันที่ผ่านมา

    Thank you so much for your videos and content 🙏

  • @ademhuseinovic
    @ademhuseinovic 2 ปีที่แล้ว +1

    Thank you bro, this might be the best into to pivot tables video I've seen. Would you say they're the same, more or less, on google sheets?

  • @user-mq1xp5qk8d
    @user-mq1xp5qk8d 4 หลายเดือนก่อน

    The best presentation so far

  • @RichardOnopa
    @RichardOnopa ปีที่แล้ว +1

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

  • @gianlucrobinson467
    @gianlucrobinson467 2 ปีที่แล้ว +3

    Hi Alex, I completed the Google Data Analytics certificate to start off like you recommended and I'm going through your tutorial videos to get an even greater understanding of all these concepts. the way you present information is incredible and has helped me a lot! Speaking from all the way from the Caribbean. I'm hoping to transition into this field soon by refining skills, building a portfolio and reaching out to a mentor. I was wondering though, because I'm not based in the US, are remote data analyst jobs available or would I need to do more freelancing to work with companies there ?

    • @AlexTheAnalyst
      @AlexTheAnalyst  2 ปีที่แล้ว +1

      I think trying to work through a contracting company is a great idea - freelancing is possible, but can be challenging to get your own clients.

    • @gianlucrobinson467
      @gianlucrobinson467 2 ปีที่แล้ว +1

      @@AlexTheAnalyst Thanks for the tip and all the content you provide. It's truly changing my life for the better.

  • @yewandealakija-banjo4944
    @yewandealakija-banjo4944 ปีที่แล้ว

    very insightful for a first timer. thanks Alex

  • @mrchewey
    @mrchewey ปีที่แล้ว

    11 pm on a Sunday. This bootcamp is great

  • @AwanievaStudios
    @AwanievaStudios ปีที่แล้ว +1

    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?

  • @tommybelgum8504
    @tommybelgum8504 2 ปีที่แล้ว +7

    Thanks Alex for this tutorial! Something I have been having a hard time with is using the calculated field function in a pivot table for more advanced calculations. Is it possible to use functions (such as IF statements) in the calculated field? Are there specific limitations you are aware of in pivot tables? Thanks!

    • @candylici0us117
      @candylici0us117 ปีที่แล้ว

      i know this is super late, but i believe you could create a new column in your original data set using your IF statement, and then from there using that new column in the pivot table. i think it would depend on your desired outcome/data if this would work or not!

  • @vigneshwarangurusamy1808
    @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.

  • @ribumom9474
    @ribumom9474 9 หลายเดือนก่อน

    Thank you sir, your teaching is really helpful for my journey

  • @meatpopsicle650
    @meatpopsicle650 2 ปีที่แล้ว

    Can already tell this will be a good course, spotted the brave browser in the toolbar.

  • @thuhuongdoi
    @thuhuongdoi 2 ปีที่แล้ว +1

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

  • @DCh-ks6ug
    @DCh-ks6ug 4 หลายเดือนก่อน

    Now i have serious question , what is the deffrince between the piviot table in excel and the sql ?? ecpecially ecpecially when we use both case statment and aggrigate function at the same time ??

  • @haovan5273
    @haovan5273 ปีที่แล้ว

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

  • @yhangcreates
    @yhangcreates ปีที่แล้ว

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

  • @ParthRatnakarGadewar
    @ParthRatnakarGadewar 17 วันที่ผ่านมา +1

    Hii alex saw this course on your website also. Is the free version on the websire the whole course? or do I have to purchase the course in order to complete the entire course with perfection.

  • @Putjans
    @Putjans 11 หลายเดือนก่อน

    Alex, thank you so much for PIVOT VIDEO IT IS AMAZING. I have some additional ideas for videos. Could you create content covering the following topics:
    Slicer
    Sumif
    Countif
    IF Function
    Text Functions (Trim, Proper, Upper, Lower)
    Creating Graphics
    Thank you :)

  • @shokoofehheidari5345
    @shokoofehheidari5345 ปีที่แล้ว

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

  • @vivekmalaviya5777
    @vivekmalaviya5777 28 วันที่ผ่านมา

    Very nice explanation. Thankyou

  • @kuroageha1836
    @kuroageha1836 2 ปีที่แล้ว

    What a didactic video. Thank you so much for this helpful information. I'm from Vietnam♥.

  • @mohammed-hananothman5558
    @mohammed-hananothman5558 6 วันที่ผ่านมา

    With displaying the revenue per year, is there a quick way of finding a percentage increase as per a base year or a previous year in the same pivot table instead of the actual revenue values?
    Here's is what I mean
    2013| 2014|
    13.2%| 10.2%|
    To mean that revenue increased by 13.2% from 2012 to 2013, and then from 2013 to 2014 it increased by 10.2%.
    I am new to Excel, I don't know how I am going to do this

  • @Nerdzin93
    @Nerdzin93 ปีที่แล้ว +1

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