7 Zabardast Pivot Table Tricks 🤯🔥

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 - [e-mail]
===== 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!

[@desigoodly]

Power BI Ke 7 Gazab Tricks 🤯 - th-cam.com/video/K5XF_WvCek0/w-d-xo.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

[@A.O.Siddiqui]

"Your tutorials are a game-changer! The way you break down complex concepts into simple, easy-to-follow steps has truly enhanced my Excel skills. I can already see how much more efficient I’ll be in my work. Thank you for sharing your expertise and making learning so enjoyable! Keep up the amazing work-your content is incredibly valuable and motivating!"

[@Harish.Prasad.Semwal]

We not only learn data analytics skills but also presentation skills. We love Chandeep Paji's cute hindi also.

[@altafhussainbakhwani3847]

Wonderful tips. Sir, Waiting for new video.

[@shashikkantlohar1163]

The first trick was awesome.

[@HarpreetSingh-di4mu]

All are awesome tricks

[@A.O.Siddiqui]

Thanks!

[@Harish.Prasad.Semwal]

Last one we learned first time.

[@MBD2903]

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

[@brajsharma]

First two and the last one trick was incredible. Thanks

[@sujirpinna]

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

[@chetanrai4912]

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

[@canirmalchoudhary8173]

Unpivot and Dax formula is mindblowing

[@tanveerabbas3271]

your cute urdu or hindi!!❤

[@chetanrai4912]

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

[@rukkyneel2174]

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

[@ImranSadiqTaji]

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

[@Office_Tech_Solutions]

Unpivot, grouping and names in reports are incredible

[@ruchikakhanna9672]

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

[@arbazahmad7177]

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

[@syedaneesdurez8766]

All tricks incredible. Amazing

[@azmatmalikLTU]

Unpivoting trick is awesome ❤

[@caa22]

First one, unpivot was really cool

[@deepakved]

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

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

[@maheswarmahakud3384]

Simply Great.

[@ganeshkhadke3277]

Concat wali trick, i just used awesome

[@pratapcabm123]

SalesMan DAX trick is Awesome

[@Pankaj-Verma-]

That was a valuable video, thanks.

[@desigoodly]

😄

[@Rahul.parmar8439]

Nice 👍👍👍👍👍

[@Excelwithavi]

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

[@desigoodly]

Zoomit

[@riteshvishwakarma9595]

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?

[@sherbaz8425]

amazing trick

[@vishaldongare2457]

Amazing

[@muhammaddilshadshad2658]

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

[@bangerriya]

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

[@KuldeepSingh-nq1vi]

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

[@riteshvishwakarma9595]

FY & Dax ❤

[@riteshvishwakarma9595]

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?

[@aloknidan4063]

Good Job

[@ajaym2016]

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

[@vijaykumarchauhan1692]

Found this gem channel

[@sunilkumar-uo8so]

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

[@Kiyansh_Shaha]

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

[@PowerMacro]

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 ❤

[@KamranMumtazAhmed]

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

[@desigoodly]

😁😉

[@nikitadhamal8927]

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?

[@Nitinpaste-k5l]

7th the last one is too goodly

[@abhishekmaurya8298]

So so so so Wonderful tricks, thanks

[@abhishekkaushal6564]

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

[@desigoodly]

Thanks Abhishek :)

[@beautifulthoughts1775]

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

[@thakurkarthik2546]

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

[@NomanKhan-ii9oo]

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

[@FullOfSkills4you]

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

[@yogeshlx2580]

How to auto delete blank columns in power query ?

[@jayffgaming2267]

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

[@krisssh0097]

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

[@sanjeevgupta7177]

You need to learn Hindi then😂

[@ankeshankesh]

He is flawless in hindi as well

[@akshayy9324]

Power pivot table

[@Aditya00775]

Trick no. 6

[@SinghalPrateek]

side by side Pivot

[@shaikhjaved5536]

Subscribe karna to Banta hai Boss 😘

[@desigoodly]

😉

[@siyadoll]

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

[@best4you524]

You can change filter select

[@dilbagshrivastav]

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]

Use the sort function on a table

[@renupal7349]

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

[@dilbagshrivastav]

Hello bro

[@pratapkeshavpawar9689]

🕉️🕉️🇮🇳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]

Trick 6

[@idhukaful]

FY & FQ It was new to me

[@LearnValue]

6

[@pareshvaghela1196]

First trick is not know to me

[@parvejmahmud1740]

6th

[@HaithamEmad]

what happened to the English ?!

[@rajchandan7551]

Amazing