Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names

แชร์
ฝัง
  • เผยแพร่เมื่อ 13 ธ.ค. 2024

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

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

    Struggling to manage your data? Learn Pivot Tables and save hours every week! 👉 link.xelplus.com/yt-g-weekday-pivottable
    Want to follow along? Download the exact file I used here: pages.xelplus.com/weekday-slicer-file

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

    Leila....2.5M subscribers? Wow! And the content is fantastic. I consider myself an expert in Excel, but I've just never had a reason to use pivot tables. This is just what the doctor ordered. Thanks

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

    I can't stop watching Leila's videos! They are so interesting!

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

    It's easier to use the TEXT function than it is to use the WEEKDAY function. Just type =TEXT(A2,"DDDD"), that will populate the fully spelled out day "TUESDAY", or type =TEXT(A2,"DDD") will give you the 3 letter abbreviation of the day, ie. "Tue"... That will save you from having to navigate the WEEKDAY function. This also works with months by typing "MMM" or "MMMM".

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

      @F yes, but the Pivot table doesn't seem to like the =A2 option.

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

    Finding your videos was the best thing ever!!! I've learned so much about excel and over the last two weeks that I've actually applied what I learned to some projects at work!!! Not only am I happy but my Leadership team at work is also happy!!!

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      That's GREAT! I'm really happy to hear that! Thanks for sharing :) You've done the difficult part which is applying what you learnt to your own work.

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

    I always look specifically to you, Leila. Great explanations, Easy to understand, Concise! Thank you, Thank you, Thank you!

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

    Just found you - you are amazing and the examples/lessons you give are the easiest to follow and you give the best explanations - thank you

  • @2808drw
    @2808drw 4 ปีที่แล้ว +1

    I love her way talking 👍
    Her language so easy to understand and explantion is clear 👏👏👏

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

    To tell the truth , your explanation is 100% times better than my school teacher.
    Thanks a lot this is really gonna help me in my exams tomorrow ☺😊

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

    Excel-lent video and this slicer format I was searching for a while finally it came to me! Thank you so much Leila!!

  • @MIRZA1515
    @MIRZA1515 5 ปีที่แล้ว

    I'm grateful for your tutorials. As an old-school guy, I have been learned a lot thanks to you.

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Thanks for the kind words Erhan!

  • @puranyashkapoor7468
    @puranyashkapoor7468 4 ปีที่แล้ว

    I am really blown away by the beauty of what you can create in excel. Keep it up !

  • @asiflangha
    @asiflangha 5 ปีที่แล้ว

    You are superb. your examples are super easy to understand and likely to engage the viewer. Excellent job.

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Thank you for the kind feedback.

  • @torgal786
    @torgal786 4 ปีที่แล้ว

    You are a wonderful and Excel Google for all of us...

  • @gautierlaurent2476
    @gautierlaurent2476 5 ปีที่แล้ว

    Just discover your channel a few days ago, yours videos are awesome. Simple and precise explanations to get what you want to do. Thank you very much for your teaching... and for us!

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      My pleasure. Glad to have you here!

  • @archanamuppidi14
    @archanamuppidi14 6 ปีที่แล้ว

    Your videos provide so much to learn... I hv subscribed to so many other excel videos... but your videos provide every detail and huge information and clarity.... thank u so much for your help...

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      Thank you so much for subscribing! I’m glad you find the videos helpful.

  • @rickfuqua
    @rickfuqua 3 ปีที่แล้ว

    I love all the info I learn from you. You make it easy to understand. Thanks!!!

    • @LeilaGharani
      @LeilaGharani  3 ปีที่แล้ว

      You are so welcome, Rick!

  • @patriceairoldi
    @patriceairoldi 4 ปีที่แล้ว

    Very good explanations, now I know better how to create a pivot chart. Thanks for this very good video Leila !

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

      Happy to hear that Patrice!

  • @luisguillermoperezmejia7907
    @luisguillermoperezmejia7907 4 ปีที่แล้ว

    Excelente aporte. Quedó suscrito. Cordiales saludos desde Medellín Colombia.

  • @michaeldiamond2726
    @michaeldiamond2726 7 ปีที่แล้ว

    Great Video Leila - like your explanation on some of the in's and outs of how to manipulate a slicer. Keep them coming!

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว

      Glad to hear that Michael. You're very welcome.

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

    OMG you are brilliant... Thanks I really need it as I am creating a dashboard now. Wish for your happiness and success in life!

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว

      Glad you can apply it to your dashboard :) You're very welcome Sasaraka.

  • @sadavies2906
    @sadavies2906 5 ปีที่แล้ว

    Love the videos Leila very easy to follow and results are great. In this example is it easy to include all week days in the pivot table and subsequent chart if there isn’t and data for the day in the table. Obviously as you use the slider the chart changes based on the data but would like to have 7 days showing all the time with blanks if nothing was on a Monday for example

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

    Your tutorials are amazing! Concise and straight to the point

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

    Thanks Leila. Very happy with this video.

  • @1970mariano
    @1970mariano 5 ปีที่แล้ว +1

    Leila, your videos are excellents and addictive. Thanks for sharing

  • @jrobinson8898
    @jrobinson8898 4 ปีที่แล้ว

    Leila you never cease to amaze me!! Thank you for your easy to follow yet super informative vids!♥️

  • @Rascalini19
    @Rascalini19 4 ปีที่แล้ว

    You are so Awesome! Very easy to follow along...
    Thank you so much!!!

  • @Zabikhan14
    @Zabikhan14 3 ปีที่แล้ว

    Thank you so much.. ur video's not only motivate but also a way of solution.... thanks alot

  • @gjeess1
    @gjeess1 4 ปีที่แล้ว

    Another excellent video, that provides clear instructions for the end-user. Thank you.

  • @craigvoss1468
    @craigvoss1468 7 ปีที่แล้ว

    I like how you take a simple chart and slicer, and turn it into something that looks so nice.

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว

      what is that quote? "simplicity is the ultimate sophistication" :)

  • @veebee3969
    @veebee3969 4 ปีที่แล้ว

    Very helpful. Great video.

  • @tamimsajid
    @tamimsajid 5 ปีที่แล้ว

    a beautiful video from a beautiful soul. Thanks a lot.

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      You're very welcome. Glad you like the video 😊

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

    Your videos are really awesome! Excellent demos/examples that you present offers us a great learning experience.

  • @irviantantohadiprasetyo689
    @irviantantohadiprasetyo689 5 ปีที่แล้ว

    It's very useful. Thanks, Leila

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      My pleasure. I'm glad the video is useful.

  • @rnjy20
    @rnjy20 5 ปีที่แล้ว

    it wouldn't be a problem if i tell someone that you invented the Excel, as its totally believable :D you know the options so well

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

    Wow, I'm glad I subscribed, your channel is a gold mine, thank you!

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      I'm glad to hear that :)

  • @yanmike5212
    @yanmike5212 4 ปีที่แล้ว

    Thank you so much for imparting the knowledge

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

    New sub! Wow! Blown away with the content. Such quality, beauty, and knowledge all jam packed in each video! (Thank you, TH-cam!)

  • @uningeniero3343
    @uningeniero3343 4 ปีที่แล้ว

    Oro, puro oro por estos rumbos.

  • @tristangeoffroy9286
    @tristangeoffroy9286 4 ปีที่แล้ว

    Thank you for the explanation on how customising slicer, .. very stylish as always with your tutorials, ...and a very sweet voice. thank you

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

    I regular learn from your videos, request you to make an end to end video on pivot tables from basics to extremely advanced (A-Z)

  • @tsauraiketiwa1086
    @tsauraiketiwa1086 4 ปีที่แล้ว

    You are just good in this.

  • @nickybanya3206
    @nickybanya3206 4 ปีที่แล้ว

    Hi Leila, your excel skills are excellent and very much effective in workforce management. This slicer is really nice. Can you please help with one click dashboard skills please.

  • @nsanch0181
    @nsanch0181 5 ปีที่แล้ว

    You've helped me so much with charts and graphs. Thanks Leila!

  • @Rice0987
    @Rice0987 5 ปีที่แล้ว

    Like for Leila as always!
    I'm using pivots and slicers for a long time, but some moments was interesting for me.
    So, thank you!

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

      Glad you found something useful John. Thanks for your support.

    • @Rice0987
      @Rice0987 5 ปีที่แล้ว

      @@LeilaGharani Thank you! Please, dont stop to explore of excel magic and share with us. 😊

  • @resrussia
    @resrussia 7 ปีที่แล้ว

    Good explanation and suggestion for adding days of week to a pivot chart. I would have never thought of using the format to convert a date to the day of week. My solution was use the TEXT function.
    Keep up the excellent work.

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว

      Thanks Training Research. Glad you found it useful :)

  • @BayuHendra-qe7kg
    @BayuHendra-qe7kg ปีที่แล้ว

    Excel is opened, Barbara, thanks for my solution

  • @amrelmashwady
    @amrelmashwady 7 ปีที่แล้ว +4

    thank you so much , each lecture I learn thing new in" excel "from you

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว

      That's great to hear Amr! You're very welcome.

    • @charlesjames5965
      @charlesjames5965 3 ปีที่แล้ว

      Leila can you please share your email for us to have those lectures even if it costs no matter

  • @travelwithwings9674
    @travelwithwings9674 3 ปีที่แล้ว

    You are amazing.. What a great way of explaining this concept 👏

  • @norulzanamohamedsamuri1364
    @norulzanamohamedsamuri1364 3 ปีที่แล้ว

    thanks. great help. nice tutorial

  • @javelpalmer
    @javelpalmer 4 ปีที่แล้ว

    Perfect! What's the easiest way to Import Data from the stock market Website to Excel?
    With this Pivot style.

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

    شكرا ميس ليلى

  • @adighose
    @adighose 6 ปีที่แล้ว

    Excellent video Leila

  • @sandeepchoudhary5860
    @sandeepchoudhary5860 4 ปีที่แล้ว

    Stellar Leila..!

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

    BE BLESSED

  • @mans0011
    @mans0011 4 ปีที่แล้ว

    Thanks again for another great video. How would you force the chart to show empty weekdays? Don’t want to see Sunday then Tuesday, for example.

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

    I liked it very much. It's just what I'm looking for. Thanks!

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

    I am big fan your video's I am learning and learnt a lot from your video's. one word to describe Excellent

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว

      Very happy to hear that YoTech :)

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

    I have created my team dashboard through the slice be blessed

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

    Thank you Leila, can you do a calendar dashboard using this slicer please ..

  • @ckokse
    @ckokse 5 ปีที่แล้ว

    Yet another great video! Thank You!

  • @Ardhyatripathi9
    @Ardhyatripathi9 4 ปีที่แล้ว

    Very Nice Video... Thank you Leila

  • @jitendragupta78
    @jitendragupta78 4 ปีที่แล้ว

    I learnt so many things like how to have multiple columns in slicers, how to make charts much more presentable..

  • @r.i.4259
    @r.i.4259 6 ปีที่แล้ว

    Thank you very much for your tutorials !!

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      You're very welcome Rustam. Thanks for your support.

  • @sulaimansait864
    @sulaimansait864 4 ปีที่แล้ว

    Super mam you are explain so more update video for the excel sheet
    I small douit mam you can explain daily for the payroll excel sheet

  • @s.miller7444
    @s.miller7444 4 ปีที่แล้ว

    You make it seem so easy and effortless. Thanks Do you have any lessoons with data to practice with?

  • @thexaamir7
    @thexaamir7 5 ปีที่แล้ว

    Awesome... 👍

  • @sheenaachyuthan428
    @sheenaachyuthan428 5 ปีที่แล้ว

    Awesome, thank you so much for showing the slicer function along with pivot chart.

  • @iziaurrahman
    @iziaurrahman 6 ปีที่แล้ว

    Learnt so much from this tutorial. Excellent stuff!

  • @AndreaUK1973
    @AndreaUK1973 3 ปีที่แล้ว

    Hi Leila! Hope you’re well! Do you have a tutorial for building a Dynamic Employee’s Annual Leave spreadsheet ? I can’t find one in your channel!

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

    thanks for your examples, but how do you do that: date and automatically weekday, months, etc. Frits from Holland

  • @douglaszulu6281
    @douglaszulu6281 7 ปีที่แล้ว

    Great video on dashboards

  • @jubileelifeinsurance5991
    @jubileelifeinsurance5991 5 ปีที่แล้ว

    ma'm you have very wonderful knowledge.

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Thank you for your support Sohail. I'm still learning all the time :)

  • @lathikapreethi9276
    @lathikapreethi9276 4 ปีที่แล้ว

    Leila, your lessons are amazing, simple and to the point!love it! One thing that I want to bring to your notice is that you have given a link to access and download the workbook you use in the course. The link really doesn't download it and I cannot find it on my PC as well. Can you pls check on that?

    • @LeilaGharani
      @LeilaGharani  4 ปีที่แล้ว

      The link will bring you to the blog post. When you scroll down to the bottom of the post you'll find the workbook to download.

  • @Pecintakebenaran
    @Pecintakebenaran 5 ปีที่แล้ว

    Very nice tutorial...very helpfull...how to analyze data with merge colom few subheader, please guide us on that

  • @iloveyoumadhuri
    @iloveyoumadhuri 5 ปีที่แล้ว

    Hi Leila! I had difficulty getting the Months slicer into my pivot table for my Mac. At the 6:30 part, where I had to remove my original slicer, I could not get months by clicking on the dates in the Pivot Chart Fields like you. Is it possible to get help from you?

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Sorry, I don't have Mac in the office. Maybe someone else from the community can help out.

  • @vokisek
    @vokisek 3 ปีที่แล้ว

    With custom formating you can format the date directly. You do not need it convert it with the weekday function. :)

  • @remcovankempen422
    @remcovankempen422 6 ปีที่แล้ว

    Again a perfect explanation !!

  • @FarhanKhan-hu2er
    @FarhanKhan-hu2er 4 ปีที่แล้ว

    Excel is Magic...

  • @ravibopara3559
    @ravibopara3559 4 ปีที่แล้ว

    Firstly, many thanks to your tutorials on TH-cam and on your website. Those helped me to boot my productivity levels in using Excel.
    Here is my requirement:
    1. I want to create a excel like interface with rows and columns in SharePoint with borders as my team members are familiar with excel.
    2. When adding a new item in list, most of the columns need to be updated from auto-populated list for each column.
    3. This list of options for each column will change on weekly basis and that is captured in an excel workbook which I want to connect to this SharePoint list.
    If this can be achieved, please guide me.
    If this requirement can be achieved with other set of office apps in a better way, please suggest.

  • @smile4saravanan
    @smile4saravanan 5 ปีที่แล้ว

    Many Thanks!

  • @g.oliveira1184
    @g.oliveira1184 3 ปีที่แล้ว

    Muito obrigado! Parabéns pelo vídeo!

  • @waleethmohamedismail4543
    @waleethmohamedismail4543 6 ปีที่แล้ว

    Hi Leila, Greetings! Actually, I learned new things.

  • @technicalafghan-8564
    @technicalafghan-8564 5 ปีที่แล้ว

    brilliant job thanks i am your previous subscriber and i also subscribe on this channel because your video give me many thinks . thanks

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      It's great to have you here.

  • @rajamanikamr4779
    @rajamanikamr4779 5 ปีที่แล้ว

    Thank you for you excel training, since I have developed Excel knowledge.from your videos

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      You're very welcome! I'm glad you enjoy the tutorials.

  • @mykidwholovesminecraft7092
    @mykidwholovesminecraft7092 3 ปีที่แล้ว

    I like your Excel video. Very informative. But if i have a pivot slicer how can i retrieve information using count

  • @wout_s
    @wout_s 3 ปีที่แล้ว

    Thanks very much, especially for the formatting of the slicer! I have one problem though: when I click on the slicer, the cursor always jumps to the pivot chart. Is there any way to stop this from happening? I don't see it in your video!

  • @rankingacademy
    @rankingacademy 7 ปีที่แล้ว

    awesome and so clear

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

    Hey there, thanks for the great vid, one question how can i use pivot charts with a table of data which expands every month. So the amount of data just gets larger and larger every day can pivot handle that ?
    Kind Regards

  • @peterivarsson9267
    @peterivarsson9267 5 ปีที่แล้ว

    Very interesting tutorial!,

  • @muhammadmudassirhussainsid407
    @muhammadmudassirhussainsid407 4 ปีที่แล้ว

    Thanks its very useful to help me alot but I request u please increase your video quality its show me blur.

  • @atiaabdelkader1905
    @atiaabdelkader1905 5 ปีที่แล้ว

    Very nice video thank you very much I love 😍 it

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      I'm very happy to hear that!

  • @stephengibson100
    @stephengibson100 6 ปีที่แล้ว

    These are wonderful. I'm learning so much, and building my own file of templates. Thanks so much.

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      I'm glad you find these useful Stephen.

  • @zagros367
    @zagros367 5 ปีที่แล้ว

    excellent

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

    For Weekday, you can also use =text(B2,"mmmm").. Sorted!!

  • @englishbobshousemusic
    @englishbobshousemusic 4 ปีที่แล้ว

    Hi Leila. I am trying to make a dashboard. It has multiple slicers controlling a pivot table. I want to stop the automatic sorting that happens to the slicers when selecting something. Do you have a solution for this. Great channel.

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

    Hi Liela, For Excel 2010 ,Just found out that to get Slicer for the Months - we can add a column containing the month name.TEXT(A2,"MMMM"). Then we do not have to go through the process of grouping as the Pivot Table field does not reflect the Month option like it is for your excel. Further the Slicer setting does not have the option of "Hide blank data".

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

      Hi, alternatively, one can after selecting "Date" in the PivotTable fields at video 06:25 right click on the newly created date, select the line after the day, i.e Select 6-Mar or 13-Mar or 20-Mar which is found within the Sunday group. So I repeat, right click on any one date, Select Group, Select Starting date 9/2/2016 and ENding at 8/8/2016 (This is automatically selected - depending on the dates you have in your data, it is on auto), Select next "By Months" and "By Days". And we can proceed to add slicer as per in the video 07:30 . Thanks.

  • @tall_bradda224
    @tall_bradda224 7 ปีที่แล้ว

    your videos are so helpful thanks

    • @LeilaGharani
      @LeilaGharani  7 ปีที่แล้ว

      Very happy to hear that Chris :)

  • @trivikramsrinivas1997
    @trivikramsrinivas1997 5 ปีที่แล้ว

    Thank you so much

  • @RaviKumar-nd5fc
    @RaviKumar-nd5fc 6 ปีที่แล้ว

    your explanation is too good mam iam als fan of you

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      Thank you & thanks for your support.