| Connect us with          
|now www.excelbasics.in is moved to www.basictutorials.in | Learn excel,word,powerpoint,html tutorials..etc in Kannada | ಕನ್ನಡದಲ್ಲಿ ಕಲಿಯಿರಿ excel,word,power point,html ಮತ್ತು ಎಲ್ಲಾ tech updates ಗಾಗಿ ನಮ್ಮ ಚಾನೆಲ್ ನ್ನು subscribe ಮಾಡಿ.


Note:-Before starting any Formula or Function you need to add (=)

PIVOTTABLE is a power full tool in Excel,it is used to Summarize the data.using PivotTable we can summarize, analyze, explore, and present our data.in this Turorial i explain only basic of PivotTable,in future videos i will explain it in detail. below we provided downlodable sample sheet & video for your understanding.

Syntax:- GETPIVOTDATA(data_field,pivot_table,[field1,item1, ...)

After watching video you can download below sample sheet. & it helps you to do practice more.please subscribe for more videos in our youtube channel.if you like our tutorial please share it on facebook & youtube below.
please leave your comments & suggestion in below form for better posts.