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!
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
Wonderful tips. Sir, Waiting for new video.
All are awesome tricks
The first trick was awesome.
Blown away by the Simple Yet extremely powerful hacks .. Pls keep posting such great and to the point content
I really liked this new version of yours. I have been a fan of your work for a long time now.
Thank you for sharing! Your channel is filled with amazing tricks, yet it's so underrated!
Great buddy!...i am learning a lot from these videos. Thanks.
Can you provide tips to get accumulated balances very much like Balance sheet balances?
I really liked the last trick which is , getting the employee names as values.
First two and the last one trick was incredible. Thanks
Thanks for uploading this video.I don't know these tricks
Concat wali trick, i just used awesome
Sir ji...The first one is awesome... specially for not user of power query
Nice 👍👍👍👍👍
Excellent 🎉tips .. thanks for sharing....
All tricks incredible. Amazing
Found this gem channel
Simply Great.
The Dax Formula was awesome 👍
Can you tell which tools do you use to highlight range ( that red cursor)
Zoomit
Unpivot and Dax formula is mindblowing
Awesome janab power query mn trial balance closing from journal entries and balance farward to next year plz ek vedio bana dyn plz
Unpivot, grouping and names in reports are incredible
That was a valuable video, thanks.
😄
Unpivoting trick is awesome ❤
@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.
Thank you so much. This is me (Chandeep) responding to your message. 😀😀
First one, unpivot was really cool
issues of Pivot table 1) When data changes then header remain the same of old data 2) No auto refresh as data changes
amazing trick
Amazing
All tricks are very good but i like the last trick concatenate of all salesman .
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?
Hi Bro, please make videos on power pivot and DAX from scratch in Hindi.. ❤
SalesMan DAX trick is Awesome
Power pivot table
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
For the first time, I heard you speaking Hindi...
😁😉
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
unpivoting data i.e. 1 and adding name in value i.e. last.
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?
Good Job
FY & Dax ❤
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?
Sir FY wala formula share in file.. in Pakistan we use july to june fy thanks
side by side Pivot
Grouping wali trick yeh toh first time dekhi or FY change karne wali trick yeh toh kamal thi 😅
Thanks Abhishek :)
How to add Calculated item/Field in Power Pivot tables.
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 ❤
It feels strange because I have been hearing English for a couple of years and now there's a change.
You need to learn Hindi then😂
He is flawless in hindi as well
How to auto delete blank columns in power query ?
7th the last one is too goodly
🕉️🕉️🇮🇳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
Trick 6
Trick no. 6
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
Hi
i tried the first trick that is related to pivot ALT d p but it is not working abb kya karna
6
FY & FQ It was new to me
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
Use the sort function on a table
Hello bro
Subscribe karna to Banta hai Boss 😘
😉
6th
Second trick m field setting k option hi nhi aa rha hai
First trick is not know to me
what happened to the English ?!