7 Zabardast Pivot Table Tricks 🤯🔥

Поделиться
HTML-код
  • Опубликовано: 7 сен 2024
  • Excel Pivot Table Tips & Tricks in Hindi
    Is video mein, hum lekar aaye hain Excel Pivot Table ke 7 zabardast tricks jo aapke data analysis aur report creation ke skills ko ek naye level par le jayenge. Aisi aur informative videos ke liye, Goodly Hindi ko subscribe karna na bhulein. #Excel #pivottable #exceltipsandtricks
    ===== ONLINE COURSES =====
    ✔️ Mastering DAX in Power BI -
    goodly.co.in/l...
    ✔️ Power Query Course-
    goodly.co.in/l...
    ✔️ Master Excel Step by Step-
    goodly.co.in/l...
    ✔️ Business Intelligence Dashboards-
    goodly.co.in/l...
    ===== LINKS 🔗 =====
    Blog 📰 - www.goodly.co....
    Corporate Training 👨‍🏫 - www.goodly.co....
    Need my help on a Project 💻- www.goodly.co....
    Download File ⬇️ - goodly.co.in/w...
    ===== CONTACT 🌐 =====
    Twitter - / chandeep2786
    LinkedIn - / chandeepchhabra
    Email - goodly.wordpress@gmail.com
    ===== WHO AM I? =====
    A lot of people think that my name is Goodly, it's NOT ;)
    My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
    Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

Комментарии • 74

  • @desigoodly
    @desigoodly  6 месяцев назад

    Power BI Ke 7 Gazab Tricks 🤯 - ruclips.net/video/K5XF_WvCek0/видео.html
    Download the file ⬇ - goodly.co.in/wp-content/uploads/2024/02/PT-Tricks.xlsx
    Also check out my courses on Excel, Power Query, DAX & Data Modeling - goodly.co.in/products

  • @altafhussainbakhwani3847
    @altafhussainbakhwani3847 4 месяца назад

    Wonderful tips. Sir, Waiting for new video.

  • @HarpreetSingh-di4mu
    @HarpreetSingh-di4mu 3 месяца назад

    All are awesome tricks

  • @shashikkantlohar1163
    @shashikkantlohar1163 6 месяцев назад +1

    The first trick was awesome.

  • @sujirpinna
    @sujirpinna 6 месяцев назад

    Blown away by the Simple Yet extremely powerful hacks .. Pls keep posting such great and to the point content

  • @chetanrai4912
    @chetanrai4912 6 месяцев назад

    I really liked this new version of yours. I have been a fan of your work for a long time now.

  • @ImranSadiqTaji
    @ImranSadiqTaji 6 месяцев назад

    Thank you for sharing! Your channel is filled with amazing tricks, yet it's so underrated!

  • @rukkyneel2174
    @rukkyneel2174 6 месяцев назад

    Great buddy!...i am learning a lot from these videos. Thanks.

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

    Can you provide tips to get accumulated balances very much like Balance sheet balances?

  • @chetanrai4912
    @chetanrai4912 6 месяцев назад

    I really liked the last trick which is , getting the employee names as values.

  • @brajsharma
    @brajsharma 6 месяцев назад

    First two and the last one trick was incredible. Thanks

  • @ruchikakhanna9672
    @ruchikakhanna9672 6 месяцев назад

    Thanks for uploading this video.I don't know these tricks

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

    Concat wali trick, i just used awesome

  • @MBD2903
    @MBD2903 6 месяцев назад

    Sir ji...The first one is awesome... specially for not user of power query

  • @Rahul.parmar8439
    @Rahul.parmar8439 3 месяца назад

    Nice 👍👍👍👍👍

  • @arbazahmad7177
    @arbazahmad7177 6 месяцев назад

    Excellent 🎉tips .. thanks for sharing....

  • @syedaneesdurez8766
    @syedaneesdurez8766 6 месяцев назад

    All tricks incredible. Amazing

  • @vijaykumarchauhan1692
    @vijaykumarchauhan1692 6 месяцев назад

    Found this gem channel

  • @maheswarmahakud3384
    @maheswarmahakud3384 6 месяцев назад

    Simply Great.

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

    The Dax Formula was awesome 👍
    Can you tell which tools do you use to highlight range ( that red cursor)

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

    Unpivot and Dax formula is mindblowing

  • @muhammaddilshadshad2658
    @muhammaddilshadshad2658 6 месяцев назад

    Awesome janab power query mn trial balance closing from journal entries and balance farward to next year plz ek vedio bana dyn plz

  • @Office_Tech_Solutions
    @Office_Tech_Solutions 6 месяцев назад

    Unpivot, grouping and names in reports are incredible

  • @Pankaj-Verma-
    @Pankaj-Verma- 6 месяцев назад

    That was a valuable video, thanks.

  • @azmatmalikLTU
    @azmatmalikLTU 6 месяцев назад

    Unpivoting trick is awesome ❤

  • @deepakved
    @deepakved 6 месяцев назад

    @Chandeep. You are amazing man. I knew a couple of tricks but the first trick to unpivot the table I never knew. This is amazing. Thank you for sharing.
    Also I highly recommend the people out there to see the course you have created on M language. I am highly benefitted from that course
    PS: most likely your marketing team is gonna respond to this comment but nonetheless I am an avid follower and promoter for the channel.
    An Indian fan.

    • @desigoodly
      @desigoodly  6 месяцев назад

      Thank you so much. This is me (Chandeep) responding to your message. 😀😀

  • @caa22
    @caa22 6 месяцев назад

    First one, unpivot was really cool

  • @Kiyansh_Shaha
    @Kiyansh_Shaha 4 месяца назад

    issues of Pivot table 1) When data changes then header remain the same of old data 2) No auto refresh as data changes

  • @sherbaz8425
    @sherbaz8425 6 месяцев назад

    amazing trick

  • @vishaldongare2457
    @vishaldongare2457 6 месяцев назад

    Amazing

  • @bangerriya
    @bangerriya 6 месяцев назад

    All tricks are very good but i like the last trick concatenate of all salesman .

  • @riteshvishwakarma9595
    @riteshvishwakarma9595 6 месяцев назад

    Also, can you help create a VBA in PowerPivot to move fields in rows according to the requirement from the object name as the data header?

  • @KuldeepSingh-nq1vi
    @KuldeepSingh-nq1vi 6 месяцев назад

    Hi Bro, please make videos on power pivot and DAX from scratch in Hindi.. ❤

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

    SalesMan DAX trick is Awesome

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

    Power pivot table

  • @beautifulthoughts1775
    @beautifulthoughts1775 6 месяцев назад

    I like dax Formula..
    My boss given 1 task. Click on 1 cell in formulated table then auto populate another sheet related data. Like pivot table click on double click then related data reflect new sheet. ( Work on also google sheet)
    any idea on my question please create video

  • @KamranMumtazAhmed
    @KamranMumtazAhmed 6 месяцев назад

    For the first time, I heard you speaking Hindi...

  • @sunilkumar-uo8so
    @sunilkumar-uo8so 6 месяцев назад

    Last one is fantastic
    Except last 7 I know all the tricks
    But my question is how to create file instead of create sheets to used filter.
    2. Can i put single column into two places like filter or Row.
    thankyou

  • @jayffgaming2267
    @jayffgaming2267 6 месяцев назад

    unpivoting data i.e. 1 and adding name in value i.e. last.

  • @nikitadhamal8927
    @nikitadhamal8927 6 месяцев назад

    In the pivot table , we apply filters at the top . So , my customer has requested me to hide those filters from the sheet . Only pivot table should be visible , I mean how to lock those filters? Will you please suggest?

  • @aloknidan4063
    @aloknidan4063 6 месяцев назад

    Good Job

  • @riteshvishwakarma9595
    @riteshvishwakarma9595 6 месяцев назад

    FY & Dax ❤

    • @riteshvishwakarma9595
      @riteshvishwakarma9595 6 месяцев назад

      Also, can you help create a VBA in PowerPivot to move fields in rows according to the requirement from the object name as the data header?

  • @NomanKhan-ii9oo
    @NomanKhan-ii9oo 5 месяцев назад

    Sir FY wala formula share in file.. in Pakistan we use july to june fy thanks

  • @SinghalPrateek
    @SinghalPrateek 6 месяцев назад

    side by side Pivot

  • @abhishekkaushal6564
    @abhishekkaushal6564 6 месяцев назад

    Grouping wali trick yeh toh first time dekhi or FY change karne wali trick yeh toh kamal thi 😅

    • @desigoodly
      @desigoodly  6 месяцев назад

      Thanks Abhishek :)

  • @FullOfSkills4you
    @FullOfSkills4you 6 месяцев назад

    How to add Calculated item/Field in Power Pivot tables.

  • @PowerMacro
    @PowerMacro 6 месяцев назад

    Dear Chand deep Sir, need a favor. Need help in building an organization chart in Power BI. I have seen several videos with unsatisfactory results. With lots of ❤

  • @krisssh0097
    @krisssh0097 6 месяцев назад +5

    It feels strange because I have been hearing English for a couple of years and now there's a change.

    • @sanjeevgupta7177
      @sanjeevgupta7177 6 месяцев назад

      You need to learn Hindi then😂

    • @ankeshankesh
      @ankeshankesh 6 месяцев назад

      He is flawless in hindi as well

  • @yogeshlx2580
    @yogeshlx2580 6 месяцев назад

    How to auto delete blank columns in power query ?

  • @Nitinpaste-k5l
    @Nitinpaste-k5l 6 месяцев назад

    7th the last one is too goodly

  • @pratapkeshavpawar9689
    @pratapkeshavpawar9689 6 месяцев назад

    🕉️🕉️🇮🇳Res Bro 🙏 please guide,PAN,NAME, ASSESSMENT YEAR, SECTION,DATE, DEMAND IDENT NUMBER, TOTAL DEMAND OUTSTANDING.7 columns this I want to know how to apply but with all like table in year, din, etc Just similar

  • @Hafiz_Ibrahim
    @Hafiz_Ibrahim 6 месяцев назад

    Trick 6

  • @Aditya00775
    @Aditya00775 6 месяцев назад

    Trick no. 6

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

    m boht din 1 problem m hn please solve krna meny apny dashboard pe 4 slicer add kea hn on hr slicer ka option tick kea hai hide item with no data but jo 4th slicer hai jb m uska top sy filter clear krti hn to baki sary slicer pe blank button show hojaty hn aisa ku ho rha hai please guide me

  • @thakurkarthik2546
    @thakurkarthik2546 6 месяцев назад

    Hi
    i tried the first trick that is related to pivot ALT d p but it is not working abb kya karna

  • @LearnValue
    @LearnValue 6 месяцев назад

    6

  • @idhukaful
    @idhukaful 6 месяцев назад

    FY & FQ It was new to me

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

    Excal / google me type krne k bad data niche wali line. Me aa jaye yani k hamara data niche jata rahe fresh data hamesha uper rahe old niche jata rahe
    Ye possible h kya
    H to plz batao

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

      Use the sort function on a table

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

    Hello bro

  • @shaikhjaved5536
    @shaikhjaved5536 6 месяцев назад

    Subscribe karna to Banta hai Boss 😘

  • @parvejmahmud1740
    @parvejmahmud1740 6 месяцев назад

    6th

  • @renupal7349
    @renupal7349 6 месяцев назад

    Second trick m field setting k option hi nhi aa rha hai

  • @pareshvaghela1196
    @pareshvaghela1196 6 месяцев назад

    First trick is not know to me

  • @HaithamEmad
    @HaithamEmad 6 месяцев назад

    what happened to the English ?!