Power Pivot in Excel in Tamil with example using Power Query | How to use power pivot in excel 2016
ฝัง
- เผยแพร่เมื่อ 18 ต.ค. 2024
- A Commonly asked question : How to save more than 1 million or 10 lakh records in an Excel sheet? Well that's solved now, you can store millions and millions of data in a single Excel sheet using power query and power pivot in excel. Normal Excel sheet only has 1million rows whereas using power query you can import data from various location / sources into a single worksheet and do analysis quickly. Excel usually hangs when we use large data, using power query & power pivot , size of your data gets reduced considerably and excel wont hang.
How to enable power pivot in excel 2016 :
1. Go to File - Options - Add-Ins.
2. In the manage box, click COM Add-ins - Go.
3. Check the Microsoft Office Power Pivot box, and then click OK.
Thank you.
P.s : If you like the video please subscribe to our channel & if you have any doubts pl post in the comments section.
#msexcel #PowerPivot #PowerQuery #advancedexcel #exceldigest
சூப்பர் ஆஹா எஸ்பிளான் பண்ணுறீங்க. தேங்க்ஸ்
Nice explanation. Much needed
Thank you
nice explanation ....good
Thank you 😊😊😊
In this I got some clarification thank you!!!!
Nandri 😁😁😁
Extremely useful
Yes Power Pivot is a life saver 😀
Super explain 👍
Thank you 😁😁😁 Good to see you back after a long time!
all sheets having same data or different data
It's useful 👍
Thank you 😁😁😁
@@exceldigest6767 Please explain the Pivot chart option also
Enaku custom formatla advance highlights pandrathu vediova podunga
Hi sorry currently can't upload videos. I have videos about conditional formatting pl do check if required 😁😁😁 thanks for watching
mam, plz excel pivot calculated field podunga...
Wow awesome
Yesss it saves tons of your time 😁😁😁
@@exceldigest6767 thank you so much
@@umapathisp2163 Most welcome. Have a look at relationships video also. It's part 2 video of power pivot
I am watching this after a year, it's good learning
Thank you 😁😁😁
Mam Desktop la Iruka backup matum work agum ah illa Common File la Iruka Dataum open aguma
It should work, try and say me :D
Need to know db connection through ms Excel. Can you explain ?
Go to data tab - from other sources - from SQL server- enter your server name - use windows authentication and proceed. If this is not the one you are asking for explain your query propely, will try to make a video on that.
Thanks.
What are the applications ?
Please upload Excel Power Query
Sorry ! Currently not possible ☺️
Mammm ivlo nal enga mam irundiga
😂😂😂
I does not have power pivot option in my excel ,why?
It is available in 2013 and later versions only. If you have latest version you need to enable that, check out the description to see how to enable power pivot
No I am using spreadsheets via wps office but how to do this on that ?
@@exceldigest6767 because in my lap if I need to use excel , need to pay for Microsoft 365. So I am using wps office ! For learning purpose only
@@exceldigest6767 can u say is there this option in spreadsheets which are in wps office?
@@exceldigest6767??