Тёмный

Dynamic Connections to other Sheets via IMPORTRANGE Function 

Innozant
Подписаться 155 тыс.
Просмотров 24 тыс.
50% 1

Dynamic Connections to other Sheets via IMPORTRANGE Function
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
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/innozanti...
#googlesheet#googlesheetsdynamic#innozant #googlesheetstutorial #googlesheetsstepbystep #googlesheestinhindi

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 82   
@sandeepaswal8944
@sandeepaswal8944 2 года назад
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 ❤️
@abubackersiddique990
@abubackersiddique990 2 года назад
Think you very much sir, I am your Excel fan from Saudi Arabia. Fantastic job God bless you.
@Innozant
@Innozant 2 года назад
Thanks Abubacker Sahab ❤️
@jayantabhattacharyya628
@jayantabhattacharyya628 2 года назад
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
@investmentknowledge9635
@investmentknowledge9635 9 месяцев назад
End of each topics you always gives motivation factor to all viewer, its motivates us to learn further ❤🎉
@RiddhiNayyar2.0
@RiddhiNayyar2.0 Год назад
Sir you have explained this function very easily.
@Innozant
@Innozant Год назад
Thanks Monika..Keep Learning..And Keep exploring
@Narendar.pathak
@Narendar.pathak 2 года назад
Sikhane ki koi umar nahi hoti bahut hi damdar baat kahi aapne
@Innozant
@Innozant 2 года назад
Thanks Narender ji..Happy learning ❤️
@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 😊
@someonefrom2002
@someonefrom2002 2 года назад
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
@sameenarafiq1339 2 года назад
Really nice and informative.... Thank you so much for uploading ... Please keep it up
@Innozant
@Innozant 2 года назад
Thanks Sameena for your valuable appreciation..❤️❤️
@bhartendrashrivastava8031
@bhartendrashrivastava8031 2 года назад
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 .
@eajazahmad5925
@eajazahmad5925 2 года назад
Sir ji, you are fantabulous..
@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.
@sakhan1978
@sakhan1978 9 месяцев назад
Can we add item stock qty automatically into finished goods stock or less from dispatched qty
@mamtasaini2615
@mamtasaini2615 5 месяцев назад
Dear sir thanks for your guidance
@createyour6681
@createyour6681 2 года назад
Very great sir
@Innozant
@Innozant 2 года назад
Thanks dear
@kishorpanara4191
@kishorpanara4191 2 года назад
Awesome dear sir thank you sir
@manojkumarsingh3385
@manojkumarsingh3385 2 года назад
Excellent video Sir 🙏🏻🙏🏻🙏🏻
@Innozant
@Innozant 2 года назад
Thanks Manoj Ji❤️
@devarshmehta6721
@devarshmehta6721 2 года назад
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.
@balamira297
@balamira297 2 года назад
Thanks sir, pls upload more videos on google sheets.
@Innozant
@Innozant 2 года назад
Thanks Mira..Yes Complete series upload krenge Google sheets ke
@subratadatta18
@subratadatta18 Год назад
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.
@garimamishra5731
@garimamishra5731 3 месяца назад
Thank you 🙏
@RahulMahaur-c6j
@RahulMahaur-c6j Год назад
Agar cell me color ho rha ho to wo bhi import ho skta hai kya uske sath dusri sheet pe?
@satishojha6240
@satishojha6240 2 года назад
Fabulous video sir thanku🙏🙏🙏🙏🙏
@Innozant
@Innozant 2 года назад
Thanks Satish Ji ❤️
@sohabaig3047
@sohabaig3047 2 года назад
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
@hsgusain2054
@hsgusain2054 2 года назад
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
@Srksmart-qm5dc
@Srksmart-qm5dc 2 года назад
Good it's really appreciating
@Innozant
@Innozant 2 года назад
Thanks dear
@MdAman-rj3nr
@MdAman-rj3nr Год назад
How to highlight a All Upper case data by using conditional formatting in Excel.
@paramjeet975singh3
@paramjeet975singh3 2 года назад
Sir interview Mai wfm ke bhi question puchte hai kya??
@Innozant
@Innozant 2 года назад
Haan kuch specific organization me puche jaate hain..
@vijaydagar8519
@vijaydagar8519 11 месяцев назад
How power query function work if all excel files saved on cloud server.
@SurenderRawat-pv4us
@SurenderRawat-pv4us 6 месяцев назад
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
@yadavofficelchanal55
@yadavofficelchanal55 2 года назад
Good
@Innozant
@Innozant 2 года назад
Thanks dear
@pratikkumar391
@pratikkumar391 2 года назад
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
@kishansaria8179
@kishansaria8179 2 месяца назад
How to use importrange from say Sheet5 and not the first sheet
@KOUSHIKDEY-ml7xo
@KOUSHIKDEY-ml7xo 5 месяцев назад
Circular dependency detected. To resolve with iterative calculation, see File > Settings.-SIR HOW TO I SOLV THIS ERROR? PLEASE HELP ME
@ranjitray968
@ranjitray968 2 года назад
Sir Google sheets ka video uploaded ki jiye pls
@rovar7104
@rovar7104 2 года назад
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
Yes for sure
@vijaydagar8519
@vijaydagar8519 11 месяцев назад
How to import & Marge more then 1 sheets data "same format files"
@durgeshrai8938
@durgeshrai8938 2 года назад
🙏🙏🙏🙏
@rajendrakumarjena7524
@rajendrakumarjena7524 Год назад
Sir please Google sheet m query formula sikha dijie
@Innozant
@Innozant Год назад
Ok.noted
@sonuadhikari4145
@sonuadhikari4145 2 года назад
Sir ap class bhi dete ho
@Innozant
@Innozant 2 года назад
Yes Sonu..Our Live Classes Are Running,,You may join the same
@tikapursahakari
@tikapursahakari Год назад
sir namaste importrange 3 spreadsheets se jayada q nahi le raha hai plz help me
@Innozant
@Innozant Год назад
Kya issue
@pssolutions1422
@pssolutions1422 Год назад
Sir import range main ek error aajata hai import range internal error isko kese slove kare
@Ziab-h7f
@Ziab-h7f Месяц назад
"Argument Must be a range" Importrange ko sumifs k sath use krne pr ye error aa raha h sir google sheet me
@sawaimalhi8439
@sawaimalhi8439 2 года назад
Jai ho first comment
@Innozant
@Innozant 2 года назад
Thanks
@dhakafady774
@dhakafady774 Год назад
wow
@computerknowledgeno1
@computerknowledgeno1 Год назад
google sheet m conditional formatting ki vedio nhi hai
@Innozant
@Innozant Год назад
Excel series se cover kariye
@avinashsuccess
@avinashsuccess 2 года назад
Sir hmko bahut prablem ho raha hai query function ka use bataye Google sheet par
@Innozant
@Innozant 2 года назад
Aane wala hai kuch time me dear
@avinashsuccess
@avinashsuccess 2 года назад
@@Innozant thanks you sir I am waiting
@durgeshrai8938
@durgeshrai8938 2 года назад
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
@jetixstar9070
@jetixstar9070 2 года назад
first view
@jetixstar9070
@jetixstar9070 2 года назад
i am irfan mujhe bhi excel aata h
@paramjeet975singh3
@paramjeet975singh3 2 года назад
Batana bhai.... Tat kaise nikalte hh
@gauravbhatia7987
@gauravbhatia7987 2 года назад
🙏🙏🙏🙏🙏
@dhakafady774
@dhakafady774 Год назад
wow
@dhakafady774
@dhakafady774 Год назад
wow
Далее
Google Sheets Powerful Query Function Explained
12:49
Google Sheets Toolbar Options & Spreadsheet Settings
12:55
IMPORTRANGE Function in Google Sheets | Multiple Sheets
10:11
Google Sheets IF Function for Beginners in Hindi
11:09
How to Move Data Automatically Between Excel Files
11:37
IMPORTRANGE tips and errors - Google SHEETS
13:19
Просмотров 35 тыс.