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
Sir Your way of explanation is great.❤ You are really inspiring for your teaching way. Hats off to you sir ji.❤
@Innozant
2 жыл бұрын
Thanks Sandeep Ji..Happy Learning dear...God bless You ❤️
Dear sir thanks for your guidance
Think you very much sir, I am your Excel fan from Saudi Arabia. Fantastic job God bless you.
@Innozant
2 жыл бұрын
Thanks Abubacker Sahab ❤️
End of each topics you always gives motivation factor to all viewer, its motivates us to learn further ❤🎉
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
2 жыл бұрын
Thanks Jayanta..Will upload complete series for Googlr sheets
Sir you have explained this function very easily.
@Innozant
Жыл бұрын
Thanks Monika..Keep Learning..And Keep exploring
Sir ji, you are fantabulous..
Sir I always watch your videos and you add a lot of value in my life. Love and huge respect to you sir ❤️❤️❤️
@Innozant
2 жыл бұрын
Thanks Vivek ji..God bless You..Happy learning dear❤️
Really nice and informative.... Thank you so much for uploading ... Please keep it up
@Innozant
2 жыл бұрын
Thanks Sameena for your valuable appreciation..❤️❤️
Thank you 🙏
Excellent video Sir 🙏🏻🙏🏻🙏🏻
@Innozant
2 жыл бұрын
Thanks Manoj Ji❤️
Awesome dear sir thank you sir
Good it's really appreciating
@Innozant
2 жыл бұрын
Thanks dear
Sikhane ki koi umar nahi hoti bahut hi damdar baat kahi aapne
@Innozant
2 жыл бұрын
Thanks Narender ji..Happy learning ❤️
Fabulous video sir thanku🙏🙏🙏🙏🙏
@Innozant
2 жыл бұрын
Thanks Satish Ji ❤️
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 😊
Thanks sir, pls upload more videos on google sheets.
@Innozant
2 жыл бұрын
Thanks Mira..Yes Complete series upload krenge Google sheets ke
Good
@Innozant
2 жыл бұрын
Thanks dear
Very great sir
@Innozant
2 жыл бұрын
Thanks dear
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.
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.
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.
How to highlight a All Upper case data by using conditional formatting in Excel.
Can we add item stock qty automatically into finished goods stock or less from dispatched qty
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 .
wow
🙏🙏🙏🙏
🙏🙏🙏🙏🙏
Jai ho first comment
@Innozant
2 жыл бұрын
Thanks
How power query function work if all excel files saved on cloud server.
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
Agar cell me color ho rha ho to wo bhi import ho skta hai kya uske sath dusri sheet pe?
first view
Sir Google sheets ka video uploaded ki jiye pls
How to import & Marge more then 1 sheets data "same format files"
Circular dependency detected. To resolve with iterative calculation, see File > Settings.-SIR HOW TO I SOLV THIS ERROR? PLEASE HELP ME
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
Superb Sir... Power BI ki class chal Rahi recent me koi
@Innozant
2 жыл бұрын
Haan .28th Nov se start hone ja rha hai join kar lena Sunday only class hai @11:30am
@hsgusain2054
2 жыл бұрын
Ok Sir
Sir import range main ek error aajata hai import range internal error isko kese slove kare
Sir please Google sheet m query formula sikha dijie
@Innozant
Жыл бұрын
Ok.noted
Sir interview Mai wfm ke bhi question puchte hai kya??
@Innozant
2 жыл бұрын
Haan kuch specific organization me puche jaate hain..
Sir ap class bhi dete ho
@Innozant
2 жыл бұрын
Yes Sonu..Our Live Classes Are Running,,You may join the same
sir namaste importrange 3 spreadsheets se jayada q nahi le raha hai plz help me
@Innozant
Жыл бұрын
Kya issue
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
Sir, mai excel VBA ka course karna chahta hu. Aap mujhe VBA sikhne ka liye kuch idea de sakte.
@Innozant
2 жыл бұрын
Aap Live class training join kar sakte hain for VBA
google sheet m conditional formatting ki vedio nhi hai
@Innozant
11 ай бұрын
Excel series se cover kariye
i am irfan mujhe bhi excel aata h
@paramjeet975singh3
2 жыл бұрын
Batana bhai.... Tat kaise nikalte hh
Sir hmko bahut prablem ho raha hai query function ka use bataye Google sheet par
@Innozant
Жыл бұрын
Aane wala hai kuch time me dear
@avinashsuccess
Жыл бұрын
@@Innozant thanks you sir I am waiting
Sir power bi download kiya but framework required krke msge aa rha h pls need help Windows 10 64bit
@Innozant
2 жыл бұрын
Office version kaunsa use kar re hain aap?
@durgeshrai8938
2 жыл бұрын
2010 sir
wow
wow