Dynamic Pivot Table | Dynamic Range for a Pivot Table using the Offset Function
HTML-код
- Опубликовано: 1 ноя 2020
- Dynamic Pivot Table | Dynamic Range for a Pivot Table using the Offset Function and automatically change range of pivot table when data is added.
1. Dynamic Pivot Table using Formula
2. Dynamic Pivot Table using Function
Download the Practice Workbook Direct Link
drive.google.com/file/d/12bfq...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#dynamicpivottable #excelpivottables#Innozant #excelinterviewquestions #misexecutiveworkdetails
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 !!
Thanks dear.Really means a lot to me.
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..
Thanks Saumya for your valuable appreciation,Really means a lot to me.Have a wonderful career ahead.Keep Learning and Keep exploring.
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 🙏🏻
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
Humble teacher and nice behavior, thanks sir
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
Thanks Amitav..Keep exploring ❤️
bow down to you sir. till today i have problem with using offset , now i had
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
Great Deepal..Try krte rahiye interview .sure lag jayegi ache profile par job
I knew table method. Thank you so much for offset formula 🙏
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.
God bless you..keep learning and Keep Growing
So Nice sir....Thank You So Much ...Your teaching style is also DYNAMIC Sir...
Sir your teaching skills are too good thank-you!!!
Jese aap excel or kaam krte ho mane abhi tak kisi ko nhi dekhaa 🙏🙏🙏👍👍👍👍 thanks a lot for teaching us 🙏🙏
knowledge triumphs all!! wonderful videos!!
Thanks Ankita..GOD BLESS YOU ..TC.GN
Excellent
Very helpful topic covered
Thanks so much
Great sir. Thanks. I appreciate your teaching style. 👍
Thanks Amit Ji.. Happy Learning Dear
Mind blowing Sir Mind Blowing
Let me say, you are awsome 🙂Appreicate your efforts to share the knowledge. Dynamic Pivot it wonderful and very useful in my reporting
Thanks Verma ji for your valuable appreciation..Happy Learning ❤️
Gajab yeh pata hi nahi tha.Great sir ji
Added very much value in my knowledge…keep it up👍🏼🙏🏻
Thanks dear❤️❤️
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
Thanks 😊 dear
Wah .. bohot acha explain kiya .. thank you
Whenever I need help your videos help me out.❤ thank you
Excellent. Beautiful Explanation !!!
Thanks Yoga
Very helpful Sir, dynamic pivot bahut he easy concept se bataya thanks you so much, Sir
Thanks Ashutosh ..Keep Learning..Keep exploring ❤️
Simply awesome very well presented
You are great 👍 sir, apko apkey skill jitney achey se aatey h, ussey pta lgta ap bhut mehnati ho
Thanks Arti for sucha lovely appreciation, God bless you dear
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.
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 🙏♥️
@@Innozant Sir, I want the same education from you. May your blessings always remain.
Very nice simple but powerful pivot table with offset function teaching by you thank you sir
Thanks Pramod Ji🙏♥️ for such a wonderful comment dear.🙂
Easy to understand for even beginners also
Thank you for very useful knowledge sharing
Thank you for educating. सर आपका सिखाने का तरीक़ा बहुत ही अच्छा है । धन्यवाद 🙏
Thanks Tushar❤️❤️🙏
You are superb in simplicity and teaching 👏 👌 ❤
Best and Dynamic Teacher
Thanks dear
सर, आपके सिखाने का अंदाज़ Mind Blowing है ।
Thanks dear for your valuable feedback.❤🙏
I love the way you teach sir.. thank you so much
Thanks dear ❤️Happy Learning
Thank you Sir. I found it easiest way
Thank you sir.. amazing.
Truly amazing...Really appreciate your efforts and hard work...Keep uploading such videos...Stay Blessed...
Thank you so much 😀God Bless You
Really very dynamic❤ love your style of teaching 🌹🌹🌹🙏🏼
Thanks a lot 😊
Amazing, you taught in easy way, thank you
Thanks dear
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
Thanks Vivek ji
Sir aapka ye video mere liye bohat helpful raha hai... Thank You Sir....... 🔥🔥🔥🔥🔥🔥
Thanks Rakesh ji . God bless you dear
Great Sir ! it's working nice
सर जी सच में आपका यूट्यूब चैनल बढ़िया है। मुझे तो बहुत फायदा हुआ। भगवान आपको स्वस्थ और दीर्घायु रखे।🙏
Thanks dear
@@Innozant sir SQL ki class bhi daal do.
One of the Best excel Tutor for excel . Thanks for the Video
Thanks dear
Very useful video, i appreciate your true efforts for this wonderful lesson with example., which helps end user to gain Faster.🎉
Thanks dear
thnx you sir sharing all videos in my whatsapp group to 250+contacts thnx keep updating us with your knowledge.
oh really ❤❤Thanks for sharing..God bless you dear
Sir ap ka what's up number ml skta hay plz reply
Bahut shandar. Itni easily samjh me aayega Aisa kabhi socha nahi tha
Thanks dear..happy learning ❤️
Awesome sir , your all videos are waching. Very useful all videos. 👍
Thanks Mohit Ji,Happy Learning ❤️
Dear Sir, very informative trick you showed in very easy step, thanks from all Pakistan
Thanks Eshaan Sahab..Happy Learning Dear...❤️🙏
SUPERB AND MARVELLOUS SIR, REALLY APPRECIATE THE WAY OF LECTURE AND TEACHING IS UNBELIEVABLE - ANYBODY CAN UNDERSTAND IF SERIOUS. - GOD BLESS YOU SIR
Thanks..Really means a lot to me
Awesome Sir, thank you so much
Thanks Anup,Keep Learning,Share and Support 🙏♥️
You are a gifted person, Sir..
May Allah bless upon you and your family..Ameen
Thanks dear..Happy Learning
May Allah bless you dear for your beneficial videos.
Thanks.keep Learning
Wonderful sir 👍
aapka teaching style bahut accha hai .
Thanks dear
pure class
Kya jabardast techniques hai aapki samjaane ki
Thanks ❤️❤️
Very much appreciated your hard work
Thanks dear
Marvellous video sir,, thank u dil se
Thanks dear❤️❤️🙏🙏👍
Thank very much brother ❤
Your vedios are very interesting.. Cannot skip after starting to watch
Thanks dear❤️👍
Sir You are a great teacher.......i don't have a word for you 🙏🙏🙏
Thanks Sagar👍❤️
Gr8 sir actually u give super trick which I want know to do pratically thanks a lot
Thanks Abhishek Ji🙏♥️gn
Magnificent sir very helpful
Thanks Mohan Ji.Happy learning ❤❤
Awesome video sir
Appreciate your lecture. If we add another month's data after submission of these dashboards, how do we expect automatic updatetion of the same in Dashboards?
Really like you sir
Beautiful Sir
Sir ji, good evening,mere computer me pivot dynamic ka offset formula copy karne per define name open nahi ho raha hai.pl.iska solution bata de.
Same problem
You taught amazingly sir, in just 1 view I learned that
Thanks Kuldeep ji..Keep learning 👍❤️
Masha Allah, Bhai jan dil khush kar diya aapny,
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 🙏♥️
jabaradsst sir ji
Sir aap ke diye hue gyan se hum me bahut improve hua hai
❤❤❤🙏🙏🙏thanks
Great work 👏
very useful sir
Very useful video and very nice to teach every function
Thanks
it is very helpful learning
Sir you make such a good video, we get great help from your video thank you sir
Thanks Priyanka,Keep Learning ❤️
nice and helpful
You r great Sir!. I like your manner of explanation.
Thanks Dear..Keep Learning ❤️
@@Innozant Yes I am in track with your channel and learned a lot..thanx
Thank you sir
Wow Sir, really its an amazing.
Good Morning.. Thanks dear
Excellent 👍
Thank you sir for teaching us
Thanks
Very nice, learning now, interesting.
Thanks Rohini
Excellent
I'm from bangladesh really nice explanation, many many thanks..............@
Thanks Nirman
Very tuff formula using give me simple easy concept
Excellent sirji
Thanks Sadiq sahab
Superb!
nice and thank you
Best sirr
superb sir. fantastic
Thanks dear..
wonderfull knowledge sir jee..
Thanks dear ❤️
great sir.......... very helpful
Thanks dear
Hi, when the raw data has grand total at the bottom and after 2 or 3 rows , again there is a different data set of 5 or 10 rows at the bottom after leaving few rows blank then this offset does not work as it includes everything grand total and different data set which is there at the bottom. Can we have any other alternative of it ?
Thanku so much sir
Well explained sir....
Thanks ashabana..Hv a great day ahead
Thank you 🙏
Thanks Rahul.Gm.Hv a wonderful day ahead