Dynamic Pivot Table | Dynamic Range for a Pivot Table using the Offset Function

[@SylvesterMarshallPune]

I conduct Corporate and personal Excel and VBA Training classes but MUST appreciate your style of teaching which is very simple yet POWERFUL. I'm not hesitant to mention that I've learnt and still learning new concepts from your videos and wanted to express my gratitude for sharing your videos. You are a wonderful Teacher and your teaching inputs will go a long way in educating Excel Users and mastering their skills. Thank you so much Sir !!

[@Innozant]

Thanks dear.Really means a lot to me.

[@soumyanair9704]

I have been referring so many videos to learn excel but accidentally came across your video,now am thankful to that one random video clip which changed my life,your way of teaching is so simple and easy to understand each and every concepts...keep going in this way sir...many people will be very helpful with your videos...Thank you so much sir and God belss you..

[@Innozant]

Thanks Saumya for your valuable appreciation,Really means a lot to me.Have a wonderful career ahead.Keep Learning and Keep exploring.

[@ankitbhardwaj2231]

सर जी सच में आपका यूट्यूब चैनल बढ़िया है। मुझे तो बहुत फायदा हुआ। भगवान आपको स्वस्थ और दीर्घायु रखे।🙏

[@Innozant]

Thanks dear

[@ankitbhardwaj2231]

@@Innozant sir SQL ki class bhi daal do.

[@dsraghav2882]

I never seen teacher like you I have faced so many interviews and selected many time. Thank you sir

[@Innozant]

Really means a lot to me

[@iccstudio1106]

Jese aap excel or kaam krte ho mane abhi tak kisi ko nhi dekhaa 🙏🙏🙏👍👍👍👍 thanks a lot for teaching us 🙏🙏

[@pranshushakya8067]

1. Created Master Data Sheet Using Your Guided Method In My Current Organization Working As Data Analyst Thank You 2. Work Flow Is Optimised And Automated. You Are Amazing Sir. #Respect

[@sawaimalhi8439]

wao so nice main video dekhne say phele he like kr daita hon phir dekhne k baad real m like lagane lagta hai muje bahot utam conept hai aaap k jai ho sir aaap ki

[@Innozant]

Thanks 😊 dear

[@deepaksharma-gj5ru]

sir I want to say thank you before i wasn't able to clear any interview after watching your videos continously i give all the answers to the interviewer he was impressed with me but i am not getting call from hr though haha but m jb bh prayer krta hu hamesha dua krta hu bghwan apko sab kuch de jo bh aap chte ho na jane kitne logo ka bhla kra h apne or apne friends ko recommend bh krta hu bcz i know aajkl coaching m koi itni deeply nh smjhata god bless you sir

[@Innozant]

Great Deepal..Try krte rahiye interview .sure lag jayegi ache profile par job

[@imvny]

सर, आपके सिखाने का अंदाज़ Mind Blowing है ।

[@Innozant]

Thanks dear for your valuable feedback.❤🙏

[@artiverma5122]

You are great 👍 sir, apko apkey skill jitney achey se aatey h, ussey pta lgta ap bhut mehnati ho

[@Innozant]

Thanks Arti for sucha lovely appreciation, God bless you dear

[@vivekkalshan3589]

Sir bilkul smjh me aaya achhi tarah se dil se salute hai sir aapko m aapke siva kisi or video kabhi nahi dekhta hu kyuki m janata hu achhi tarah se aap se achha koi nahi padta hai

[@Innozant]

Thanks Vivek ji

[@jagdishsinghChahar]

Namaskar Sir, I have been nervous when gone to various channels regarding Pivot table dynamic ,Fortunately i found right place for learning this ,i am glad today to do my various tasks in short time with this,GOD Bless for such valuable knowledge, Thanks.

[@Innozant]

God bless you..keep learning and Keep Growing

[@narottammanihal8463]

So Nice sir....Thank You So Much ...Your teaching style is also DYNAMIC Sir...

[@NiwantGadgil]

Bahut shandar. Itni easily samjh me aayega Aisa kabhi socha nahi tha

[@Innozant]

Thanks dear..happy learning ❤️

[@amitavghosh1354]

i used this procedure several times but without understanding the logic !!! thank you, thanks a lot for your valuable content and effort. thank you once again

[@Innozant]

Thanks Amitav..Keep exploring ❤️

[@gavidiharish13]

bow down to you sir. till today i have problem with using offset , now i had

[@jaathdmovies876]

Sir aapka ye video mere liye bohat helpful raha hai... Thank You Sir....... 🔥🔥🔥🔥🔥🔥

[@Innozant]

Thanks Rakesh ji . God bless you dear

[@YashSharma-hf1vx]

Sir your teaching skills are too good thank-you!!!

[@Ann_2208]

Appreciate your teaching style sir. It was very difficult for me before but. As I join you my concept very easy and clear very well because of you sir 🙏🏻

[@accountsmsagsi9419]

One of the Best excel Tutor for excel . Thanks for the Video

[@Innozant]

Thanks dear

[@mohammadwasiuddin6579]

SUPERB AND MARVELLOUS SIR, REALLY APPRECIATE THE WAY OF LECTURE AND TEACHING IS UNBELIEVABLE - ANYBODY CAN UNDERSTAND IF SERIOUS. - GOD BLESS YOU SIR

[@Innozant]

Thanks..Really means a lot to me

[@madhavam718]

Your vedios are very interesting.. Cannot skip after starting to watch

[@Innozant]

Thanks dear❤️👍

[@girishsharma2055]

Very nice all video sir

[@SahilSharma-mr3lg]

Humble teacher and nice behavior, thanks sir

[@remarkablegraphic_designer3668]

You are superb in simplicity and teaching 👏 👌 ❤ Best and Dynamic Teacher

[@Innozant]

Thanks dear

[@devendergusain8974]

thnx you sir sharing all videos in my whatsapp group to 250+contacts thnx keep updating us with your knowledge.

[@Innozant]

oh really ❤❤Thanks for sharing..God bless you dear

[@syedumai8315]

Sir ap ka what's up number ml skta hay plz reply

[@vishalmandiya8225]

Gajab yeh pata hi nahi tha.Great sir ji

[@tusharmangalwedhekar6154]

Thank you for educating. सर आपका सिखाने का तरीक़ा बहुत ही अच्छा है । धन्यवाद 🙏

[@Innozant]

Thanks Tushar❤️❤️🙏

[@sagarneel5867]

Thank You Sir 🙌 learning so much from you about Excel

[@umerkayani79]

You are a gifted person, Sir.. May Allah bless upon you and your family..Ameen

[@Innozant]

Thanks dear..Happy Learning

[@manojkumarsingh3385]

Sir aap ke diye hue gyan se hum me bahut improve hua hai

[@Innozant]

❤❤❤🙏🙏🙏thanks

[@shilpa1234able]

aapka teaching style bahut accha hai .

[@Innozant]

Thanks dear

[@vikramdalal9506]

Wah .. bohot acha explain kiya .. thank you

[@Saurabh-Yaduvanshi.]

Mind blowing Sir Mind Blowing

[@Ashutosh-dl7cg]

Very helpful Sir, dynamic pivot bahut he easy concept se bataya thanks you so much, Sir

[@Innozant]

Thanks Ashutosh ..Keep Learning..Keep exploring ❤️

[@mohitjaiswal4023]

Awesome sir , your all videos are waching. Very useful all videos. 👍

[@Innozant]

Thanks Mohit Ji,Happy Learning ❤️

[@ajitrai1566]

Very useful video, i appreciate your true efforts for this wonderful lesson with example., which helps end user to gain Faster.🎉

[@Innozant]

Thanks dear

[@aamirmasood4655]

Masha Allah, Bhai jan dil khush kar diya aapny,

[@Innozant]

Sukriya Aamir Masood Sahab..Apke ye words mere liye bahut eham Hain..main koshish krunga apke life me jaroor value add Kar Sakun..thanks for your love and support 🙏♥️

[@sagarkadam8886]

Sir You are a great teacher.......i don't have a word for you 🙏🙏🙏

[@Innozant]

Thanks Sagar👍❤️

[@superNareshg]

Kya jabardast techniques hai aapki samjaane ki

[@Innozant]

Thanks ❤️❤️

[@keshariprasad1992]

Whenever I need help your videos help me out.❤ thank you

[@pushpak5939]

Amazing, you taught in easy way, thank you

[@Innozant]

Thanks dear

[@eshaankashif9072]

Dear Sir, very informative trick you showed in very easy step, thanks from all Pakistan

[@Innozant]

Thanks Eshaan Sahab..Happy Learning Dear...❤️🙏

[@mgangat]

Excellent Very helpful topic covered Thanks so much

[@vsrjob]

Really very dynamic❤ love your style of teaching 🌹🌹🌹🙏🏼

[@Innozant]

Thanks a lot 😊

[@amitjha6163]

Sir mai aapke video se hamesha kuch new sikhta hu👍

[@Innozant]

Thanks Amit for such a valuable feedback. Happy Learning 👍🙏♥️

[@curious1245]

Great sir. Thanks. I appreciate your teaching style. 👍

[@Innozant]

Thanks Amit Ji.. Happy Learning Dear

[@md.tozamhossain1643]

May Allah bless you dear for your beneficial videos.

[@Innozant]

Thanks.keep Learning

[@pankajverma19811]

Let me say, you are awsome 🙂Appreicate your efforts to share the knowledge. Dynamic Pivot it wonderful and very useful in my reporting

[@Innozant]

Thanks Verma ji for your valuable appreciation..Happy Learning ❤️

[@PriyaRanjanNayak-hg4bx]

Truly amazing...Really appreciate your efforts and hard work...Keep uploading such videos...Stay Blessed...

[@Innozant]

Thank you so much 😀God Bless You

[@it-educator9735]

You r great Sir!. I like your manner of explanation.

[@Innozant]

Thanks Dear..Keep Learning ❤️

[@it-educator9735]

@@Innozant Yes I am in track with your channel and learned a lot..thanx

[@citynirmandevelopersltd.7249]

I'm from bangladesh really nice explanation, many many thanks..............@

[@Innozant]

Thanks Nirman

[@vinayheda5941]

This is what I was really searching for 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍

[@Innozant]

👍

[@VinayakSMahajan]

I knew table method. Thank you so much for offset formula 🙏

[@tanzeem7477]

Awesome sir ..

[@Kdkoyoucantunderstand]

You taught amazingly sir, in just 1 view I learned that

[@Innozant]

Thanks Kuldeep ji..Keep learning 👍❤️

[@khalidmajeed2886]

zaberdast-------------Allah will increase those who divide their knowledge to the people.

[@Innozant]

Thanks Khalid Majeed sahab..Happy learning

[@pramodbhavsar4488]

Very nice simple but powerful pivot table with offset function teaching by you thank you sir

[@Innozant]

Thanks Pramod Ji🙏♥️ for such a wonderful comment dear.🙂

[@NiwantGadgil]

Thank you Sir. I found it easiest way

[@hiteshmohite4763]

You are great Sir ji.😀👍

[@Innozant]

Thanks Hitesh Ji

[@rasimrajashaikh2815]

I love the way you teach sir.. thank you so much

[@Innozant]

Thanks dear ❤️Happy Learning

[@ransh7046]

Sir you make such a good video, we get great help from your video thank you sir

[@Innozant]

Thanks Priyanka,Keep Learning ❤️

[@RupanagudiRaviShankar]

Wonderful sir 👍

[@devangthakkar6847]

Dear Sir, Excellent - A1

[@Innozant]

👍👍♥️♥️♥️

[@easygoing799]

Simply awesome very well presented

[@gauravshah53]

Easy to understand for even beginners also

[@abhinav10x]

Thank you for very useful knowledge sharing

[@gauravshah53]

Superb teaching

[@Innozant]

Thanks Gaurav

[@falakshabir4258]

Sir I have question for u - 1st time jab pivot lagaya tha or data source main ja kar humne anmol ko bhi select kiya tha to kuu na hum puri excel sheet ko hi select krle? 🤔 3:13 pe table/range main puri sheet ka hi range lelo fir to add ho Jaega ?

[@Innozant]

Bilkul hi jayega..lekin chote dataset par to koi issue nhi hai but large amount of data hoga to?apka excle dam tod dega dear😀

[@falakshabir4258]

@@Innozant hahahha okay sir I will try fir ik or comment krk question puchunga- waise apki videos bht aachi or useful hoti hai sir - Abhi new subscriber hu apke channel ka ♥️🙂

[@Innozant]

Phir start se Seekhiye.. Playlist Announcement me jaiye wwahan ek vidoe hai mis learning process use dekhiye aur usi sequence me complete course kriye step by step

[@sandeepaswal8944]

Sir, you have explained the new concept today. I got to learn a lot from your video. I'm glad I joined you. I want to learn a lot from you. I salute you.

[@Innozant]

Thanks Sandeep Ji🙏♥️Ye learning Ka Safar Kabhi bhi khatam na hone wala Safar hai..Aur abhi to us Safar ki shuruwat ki hai humne ..Seekhte rhiye khudme value add karte rahiye aur life me aage badhte rahiye 🙏♥️

[@sandeepaswal8944]

@@Innozant Sir, I want the same education from you. May your blessings always remain.

[@vijaysahal4556]

Useful information sir 👍🏻👍🏻👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay ji❤️

[@MohanKumar-uk1gj]

Magnificent sir very helpful

[@Innozant]

Thanks Mohan Ji.Happy learning ❤❤

[@yogaraag5139]

Excellent. Beautiful Explanation !!!

[@Innozant]

Thanks Yoga

[@Sandeepkumar-mj5me]

Iam new here but whenever I saw your video very impressive 😀

[@Innozant]

Dear Sandeep.. We welcome you to experience the taste of Success with Innozant-Seed of Success. Recommend you to start your learning journey with play list Basic Excel step by step .

[@kasafkhanpathan4936]

Added very much value in my knowledge…keep it up👍🏼🙏🏻

[@Innozant]

Thanks dear❤️❤️

[@devangmehta7087]

Very useful video and very nice to teach every function

[@Innozant]

Thanks

[@swagatamkhanra4667]

Marvellous video sir,, thank u dil se

[@Innozant]

Thanks dear❤️❤️🙏🙏👍

[@rajushah0522]

Great Sir ! it's working nice

[@rjraviraftarup7553]

Excellent 👍

[@tejpalsain1507]

Great sir jee.🌹

[@Innozant]

Thanks Tejpal..Must watch video today at 8pm.🙏♥️

[@RajivKumar-xz9jr]

The way of teaching very nice.. You have short out many problems to the professionals and made their carrier bright same way..May God blessed your life and all problems are also become simplest ( Like paper Tiger)..wish you all the best!!

[@Innozant]

Thanks dear..Really means a lot to me

[@abhishekshirsekar2065]

Gr8 sir actually u give super trick which I want know to do pratically thanks a lot

[@Innozant]

Thanks Abhishek Ji🙏♥️gn

[@AjayYadav-xm8wx]

Dear Dalip, Your lessons on Excel have engendered interest for learning more. Best part is formulas are explained citing seemingly difficult situations. Want to graduate to Microsoft Access. Could I request you to prepare some videos on Microsoft Access as well. Regards

[@Innozant]

Thanks Ajay for your valuable appreciation..Will make access playlist soon after powe bi and VBA series

[@mohammedshamim9568]

Thank you sir.. amazing.

[@shabanashaik5724]

Well explained sir....

[@Innozant]

Thanks ashabana..Hv a great day ahead

[@Abdulwaheed-pp1nj]

sir you have awesome knowledge of excel , it helps a lot to us.

[@Innozant]

Thanks a lot Abdul Waheed Sahab for giving your precious time and Learn.Hope you are enjoying and enhancing skills on regular basis.Happy learning dear👍🙏♥️❤️

[@Abdulwaheed-pp1nj]

Do you have any course program I want to learn advance Excel

[@Innozant]

Yes Waheed Sahab ,You may join our Live classroom session,For more details Whatsapp us on-7065069985

[@suyashkumardewangan77]

Awesome video sir

[@sudipabiswas8807]

Bina subscription k insaan jayega kahan?? superb videos :)

[@Innozant]

Thanks Sudipa..We welcome you to experience the taste of Success with Innozant Seed of Success.Thanks for being part of Innozant Family ❤️❤️❤️

[@zarinabqureshi4028]

great sir.......... very helpful

[@Innozant]

Thanks dear

[@mosadiq123]

Excellent sirji

[@Innozant]

Thanks Sadiq sahab

[@لاغالبَإلاالله-ح4ذ]

Isme hi yadi koi chart 📊 banaye Or koi row ya column bhi offset formula ki maddat se add kar dete to kya chart update ho jayega refresh karne par

[@sachinkamble1926]

superb sir. fantastic

[@Innozant]

Thanks dear..

[@gauravbhatia7987]

Very good sir

[@Innozant]

Thanks Gaurav Ji👍❤️🙏

[@arunssairam]

Beautiful Sir

[@لاغالبَإلاالله-ح4ذ]

Sir aap bhut acchi vedio banate ho

[@Innozant]

Thanks Sameeer Ji

[@abhivlogs1570]

Thank very much brother ❤

[@BabygirlTara]

knowledge triumphs all!! wonderful videos!!

[@Innozant]

Thanks Ankita..GOD BLESS YOU ..TC.GN

[@لاغالبَإلاالله-ح4ذ]

Isme hi yadi koi chart 📊 banaye Or koi row ya column bhi offset formula ki maddat se add kar dete to kya chart update ho jayega refresh karne par q

[@niteshjha8762]

Thank you so much for constantly teaching us new things with your videos. I have learned so many things from you within a short span of time. About this current video, when I try to change the Pivot Data source and provide the named range, it says "Reference isn't valid.", although when I was practicing yesterday it gave the perfect result. Could anyone help me with this?

[@Innozant]

Kindly cgeck the namimg range agai and pass ad it is ..case sensit8ve issue.only

[@achalrajput4173]

​@@Innozant lgta h Aaj sir n thodi si lga Li h isliye sahi s nahi likh paa rhe h 😂😂

[@harishsingh2958]

So amz sir.very nice ..🙏

[@Innozant]

Thanks dear ❤️