Field Settings in Pivot Table in MS Excel Subtotals & Filters, Layout & Print | Be A Computer Expert

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

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

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

    Show Me ♥ By Like Share & Comment
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 (◕‿◕)
    ⏱TIME STAMPS⏱
    =================
    00:00 Introduction to Field Settings
    04:07 Format cells
    05:05 Refresh pivot table
    07:30 Subtotal Row Label / Column label
    09:48 Expand and Collapse options
    12:17 Group and Ungroup field in pivot table
    13:32 Move to Beginning, up, down, end, right, left etc.
    17:05 Remove any field from pivot table
    17:24 Field settings
    17:35 Classic layout of pivot table
    19:25 How to open field settings
    20:18 Custom name in field settings
    21:06 Subtotals & filters
    25:53 Include new items in manual filter
    28:58 Layout & print
    29:08 Show item labels in tabular form
    29:27 Show item labels in outline form
    30:18 Display subtotals at the top of each group
    31:07 Display labels from the next field in the same column ( compact form)
    32:16 Insert blank line after each item label
    33:25 Show items with no data
    36:20 Insert page break after each item

    • @som8760-y7f
      @som8760-y7f ปีที่แล้ว +2

      Sir ji aaj ayega kya koi video?

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

    sir tutorial hume accha laga hai aise hi tutorial bante rahiye aur hamare skills main improvement hoga

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

    Hello sir powerpoint ke bhi videos banaye

  • @Tapashi-pw1zx
    @Tapashi-pw1zx ปีที่แล้ว +2

    Next part sir. Try to upload videos fast sir. It's a request to you.

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

      Yes I appreciate your patience. Will uploaded this week

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

    sir thank you pivotal table thoda confussion hai lekin aap ke video dekhkar har option ke sath interest aagya 👍👍👍👍👍💙💙💙💙💙

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

      Yes this week next part will be uploaded. I have been sick for few days and then festival arrived. So I was busy..but now I will make continuously. Thank you 😊

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

      @@BeAComputerExpert get well soon I will prey for you sir next option thode excel main insert se asli dekhna hai thoda practice ki jarrot hai

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

    Thanks for this video 🙏

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

    👍🏻

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

    Thank you so much for this video. I literally learn so many things in your every video. You don't miss any option. You go in detail which makes your channel a unique one.💛

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

    Nice keep it up

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

    Sir please make a detail video on group option in pivot table and also teach us customs grouping upload a video on this topic as soon as possible

  • @Tapashi-pw1zx
    @Tapashi-pw1zx ปีที่แล้ว +2

    Sir when you will upload the video. You told tomorrow a video will be uploaded but 2 days have already passed but you haven't uploaded any video.
    Furthermore, you don't also update when will you upload the video or their will be some delay to upload due to some reason.
    I daily use to go and see your community post to check for your updates on upcoming video.
    We are highly dependent on you sir, please maintain consistency and finish the course soon . It's a sincere request 🙏🏻.

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

      Now I uploaded please check.. now videos will come on regular basis.. thank you for your support and patience 💗🙏🏻

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

    Sir ms word ka video aana tha na??

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

      Coming soon. 1-2 option confusion hai wo clear krke then I will upload.

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

    Sir koi paid batch bheee hai kya aapka...???

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

    Will be eagerly waiting for the 3rd part🫸🫷. Kindly reduce the gap between your videos. As my patience commit suicide.

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

      Yes this week next part will be uploaded. I have been sick for few days and then festival arrived. So I was busy..but now I will make continuously. Thank you 😊

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

    Sir agli video kab tak ayegi

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

      Yes this week next part will be uploaded. I have been sick for few days and then festival arrived. So I was busy..but now I will make continuously.

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

    Bring videos on time😢. If you take so much time in posting videos then it will take too much time to explain all topics.
    Sir your first video on Excel was 5 years ago😮. Till now it's not finished.
    Writing this is not to demotivate you Sir but to tell you the fact 😢.
    No problem in your teaching but you need to make videos fast.
    Kindly try to understand 🙏🏻🙏🏻🙏🏻

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

      Yes I got your point but I had different situation back then which you don't know my dear. But i appreciate your patience. Now I will make videos continuously. This week next part will be uploaded. I have been sick for few days and then festival arrived. So I was busy..but now I will make continuously. Thanks 👍🏼