Dynamic Connections to other Sheets via IMPORTRANGE Function

Dynamic Connections to other Sheets via IMPORTRANGE Function
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#googlesheet#googlesheetsdynamic#innozant #googlesheetstutorial #googlesheetsstepbystep #googlesheestinhindi

Пікірлер: 80

  • @sandeepaswal8944
    @sandeepaswal89442 жыл бұрын

    Sir Your way of explanation is great.❤ You are really inspiring for your teaching way. Hats off to you sir ji.❤

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks Sandeep Ji..Happy Learning dear...God bless You ❤️

  • @mamtasaini2615
    @mamtasaini26152 ай бұрын

    Dear sir thanks for your guidance

  • @abubackersiddique990
    @abubackersiddique9902 жыл бұрын

    Think you very much sir, I am your Excel fan from Saudi Arabia. Fantastic job God bless you.

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks Abubacker Sahab ❤️

  • @investmentknowledge9635
    @investmentknowledge96356 ай бұрын

    End of each topics you always gives motivation factor to all viewer, its motivates us to learn further ❤🎉

  • @jayantabhattacharyya628
    @jayantabhattacharyya6282 жыл бұрын

    Dear Sir Excellent Google Sheet functions and it's uses. Nowadays Google Sheet is more useful than excel. Your superb teaching makes it more attractive. Thanks & Regards Jayanta Bhattacharyya

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks Jayanta..Will upload complete series for Googlr sheets

  • @RiddhiNayyar2.0
    @RiddhiNayyar2.0 Жыл бұрын

    Sir you have explained this function very easily.

  • @Innozant

    @Innozant

    Жыл бұрын

    Thanks Monika..Keep Learning..And Keep exploring

  • @eajazahmad5925
    @eajazahmad59252 жыл бұрын

    Sir ji, you are fantabulous..

  • @someonefrom2002
    @someonefrom20022 жыл бұрын

    Sir I always watch your videos and you add a lot of value in my life. Love and huge respect to you sir ❤️❤️❤️

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks Vivek ji..God bless You..Happy learning dear❤️

  • @sameenarafiq1339
    @sameenarafiq13392 жыл бұрын

    Really nice and informative.... Thank you so much for uploading ... Please keep it up

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks Sameena for your valuable appreciation..❤️❤️

  • @garimamishra5731
    @garimamishra573121 күн бұрын

    Thank you 🙏

  • @manojkumarsingh3385
    @manojkumarsingh33852 жыл бұрын

    Excellent video Sir 🙏🏻🙏🏻🙏🏻

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks Manoj Ji❤️

  • @kishorpanara4191
    @kishorpanara41912 жыл бұрын

    Awesome dear sir thank you sir

  • @Srksmart-qm5dc
    @Srksmart-qm5dc2 жыл бұрын

    Good it's really appreciating

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks dear

  • @Narendar.pathak
    @Narendar.pathak2 жыл бұрын

    Sikhane ki koi umar nahi hoti bahut hi damdar baat kahi aapne

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks Narender ji..Happy learning ❤️

  • @satishojha6240
    @satishojha62402 жыл бұрын

    Fabulous video sir thanku🙏🙏🙏🙏🙏

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks Satish Ji ❤️

  • @brijeshshah574
    @brijeshshah574 Жыл бұрын

    Simple and effective explanation. Me 5 brands take care kerta hun Har ek brand me abhi each 5-5 lines hai. Current year me muje 3 brands me 2-2 lines nayi add kerni hai. Ab jab me last year ka data dekhna chahta hun with current year to uske saath mene jo 3 brands me nayi line add ki hai wo bhi brand wise muje show kare. Nahi ki muje manually add kerna pade har ek brands k niche. Please help🙏 thanks in advance 😊

  • @balamira297
    @balamira2972 жыл бұрын

    Thanks sir, pls upload more videos on google sheets.

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks Mira..Yes Complete series upload krenge Google sheets ke

  • @yadavofficealchanal5587
    @yadavofficealchanal55872 жыл бұрын

    Good

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks dear

  • @createyour6681
    @createyour66812 жыл бұрын

    Very great sir

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks dear

  • @devarshmehta6721
    @devarshmehta6721 Жыл бұрын

    which of your video can guide me how to pull cell value from other workbook to current worksheet cell using indirect reference written in some other cell of current worksheet? In excel.

  • @subratadatta18
    @subratadatta1810 ай бұрын

    Sir, GOOGLEFINANCE par share market ke data auto import karne ke liye aur auto update karne ke video banaye . It will be very helpful for market watchers.

  • @dipanshudas2343
    @dipanshudas2343 Жыл бұрын

    Hi sir, how do we get different columns by using "importrange formula". and need more videos of DAX. i am big fan of you,lots of things i have learned from your videos.thanks for everything.

  • @MdAman-rj3nr
    @MdAman-rj3nr Жыл бұрын

    How to highlight a All Upper case data by using conditional formatting in Excel.

  • @sakhan1978
    @sakhan19786 ай бұрын

    Can we add item stock qty automatically into finished goods stock or less from dispatched qty

  • @bhartendrashrivastava8031
    @bhartendrashrivastava80312 жыл бұрын

    Sir you are awesome. I want to ask something, mere paas Excell file ki 52 sheet hain , in sabhi 52 sheet ki kisi ek particular row ke data ko kisi other Excell file mai lekar jana ho ya copy karni hain to uske liye shortcut ya koi tarika hain , jisse ye easily possible ho sake. If yes plz replay me .

  • @dhakafady774
    @dhakafady774 Жыл бұрын

    wow

  • @durgeshrai8938
    @durgeshrai89382 жыл бұрын

    🙏🙏🙏🙏

  • @gauravbhatia7987
    @gauravbhatia79872 жыл бұрын

    🙏🙏🙏🙏🙏

  • @sawaimalhi8439
    @sawaimalhi84392 жыл бұрын

    Jai ho first comment

  • @Innozant

    @Innozant

    2 жыл бұрын

    Thanks

  • @vijaydagar8519
    @vijaydagar85198 ай бұрын

    How power query function work if all excel files saved on cloud server.

  • @sohabaig3047
    @sohabaig30472 жыл бұрын

    Sir I have a one doubt please make 1vedio on that if we have multiple sheets and we have to make 1sheet like if we change in multiple sheets that reflects in 1home sheet

  • @user-zm3pn1rd2x
    @user-zm3pn1rd2x Жыл бұрын

    Agar cell me color ho rha ho to wo bhi import ho skta hai kya uske sath dusri sheet pe?

  • @jetixstar9070
    @jetixstar90702 жыл бұрын

    first view

  • @ranjitray968
    @ranjitray9682 жыл бұрын

    Sir Google sheets ka video uploaded ki jiye pls

  • @vijaydagar8519
    @vijaydagar85198 ай бұрын

    How to import & Marge more then 1 sheets data "same format files"

  • @KOUSHIKDEY-ml7xo
    @KOUSHIKDEY-ml7xo2 ай бұрын

    Circular dependency detected. To resolve with iterative calculation, see File > Settings.-SIR HOW TO I SOLV THIS ERROR? PLEASE HELP ME

  • @SurenderRawat-pv4us
    @SurenderRawat-pv4us3 ай бұрын

    Sir ji, main ne Sheet "A" se import range kar ke data Sheet "B" me transfer kar diya, to kya me ab Sheet "B" me kuch change karna chata hu kya wo ho skta ha

  • @hsgusain2054
    @hsgusain20542 жыл бұрын

    Superb Sir... Power BI ki class chal Rahi recent me koi

  • @Innozant

    @Innozant

    2 жыл бұрын

    Haan .28th Nov se start hone ja rha hai join kar lena Sunday only class hai @11:30am

  • @hsgusain2054

    @hsgusain2054

    2 жыл бұрын

    Ok Sir

  • @pssolutions1422
    @pssolutions1422 Жыл бұрын

    Sir import range main ek error aajata hai import range internal error isko kese slove kare

  • @rajendrakumarjena7524
    @rajendrakumarjena7524 Жыл бұрын

    Sir please Google sheet m query formula sikha dijie

  • @Innozant

    @Innozant

    Жыл бұрын

    Ok.noted

  • @paramjeet975singh3
    @paramjeet975singh32 жыл бұрын

    Sir interview Mai wfm ke bhi question puchte hai kya??

  • @Innozant

    @Innozant

    2 жыл бұрын

    Haan kuch specific organization me puche jaate hain..

  • @sonuadhikari4145
    @sonuadhikari41452 жыл бұрын

    Sir ap class bhi dete ho

  • @Innozant

    @Innozant

    2 жыл бұрын

    Yes Sonu..Our Live Classes Are Running,,You may join the same

  • @user-ul1sp3mx9d
    @user-ul1sp3mx9d Жыл бұрын

    sir namaste importrange 3 spreadsheets se jayada q nahi le raha hai plz help me

  • @Innozant

    @Innozant

    Жыл бұрын

    Kya issue

  • @rovar7104
    @rovar71042 жыл бұрын

    Sir can I join MIS Executive role as a fresher with the help of power bi tool and advance excel in 21 age 🙏🏻🌻❤❤ I am not 21 but I will be in 21 in this December 1

  • @surjeetyadavlifeexperience4752

    @surjeetyadavlifeexperience4752

    Жыл бұрын

    Yes for sure

  • @pratikkumar391
    @pratikkumar3912 жыл бұрын

    Sir, mai excel VBA ka course karna chahta hu. Aap mujhe VBA sikhne ka liye kuch idea de sakte.

  • @Innozant

    @Innozant

    2 жыл бұрын

    Aap Live class training join kar sakte hain for VBA

  • @computerknowledgeno1
    @computerknowledgeno111 ай бұрын

    google sheet m conditional formatting ki vedio nhi hai

  • @Innozant

    @Innozant

    11 ай бұрын

    Excel series se cover kariye

  • @jetixstar9070
    @jetixstar90702 жыл бұрын

    i am irfan mujhe bhi excel aata h

  • @paramjeet975singh3

    @paramjeet975singh3

    2 жыл бұрын

    Batana bhai.... Tat kaise nikalte hh

  • @avinashsuccess
    @avinashsuccess Жыл бұрын

    Sir hmko bahut prablem ho raha hai query function ka use bataye Google sheet par

  • @Innozant

    @Innozant

    Жыл бұрын

    Aane wala hai kuch time me dear

  • @avinashsuccess

    @avinashsuccess

    Жыл бұрын

    @@Innozant thanks you sir I am waiting

  • @durgeshrai8938
    @durgeshrai89382 жыл бұрын

    Sir power bi download kiya but framework required krke msge aa rha h pls need help Windows 10 64bit

  • @Innozant

    @Innozant

    2 жыл бұрын

    Office version kaunsa use kar re hain aap?

  • @durgeshrai8938

    @durgeshrai8938

    2 жыл бұрын

    2010 sir

  • @dhakafady774
    @dhakafady774 Жыл бұрын

    wow

  • @dhakafady774
    @dhakafady774 Жыл бұрын

    wow