Тёмный

Power Query : Formula Method | Combine Excel Worksheets in a Workbook using Power Query Formula 

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

Power Query : Formula Method | Combine Excel Worksheets in a Workbook using Power Query Formula
Excel Power Query Playlist Link- • Excel Power Query
Download the Assignment Master Practice Folder here (All Playlist Example at one place) drive.google.c...
===========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...
#powerquery #powerqueryappend#innozant #getandtransformexcel

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

 

15 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 85   
@shrikantbadge3978
@shrikantbadge3978 3 года назад
Wow. Great Sir. Ab lag raha hai k जमाने के साथ मै चल रहा हुं. क्यू की if u don't learn, ek din uthake company kab degi pata hi nahi चलेगा.
@Innozant
@Innozant 3 года назад
Thanks Srikant ji..Jamane ke saath chalana hi hoga .
@durgeshgupta9532
@durgeshgupta9532 3 года назад
Abhi previous power query ki video dekhkar practice kari thi or next video ka wait kar rha tha... Aur aapne upload bhi kar di...😂🙏 Thnx sir...🙏
@Innozant
@Innozant 3 года назад
Thanks Durgesh ji.. happy learning
@MDRussel-b5y
@MDRussel-b5y 8 месяцев назад
Thank you so much sir, Best online teacher in my life.
@Innozant
@Innozant 8 месяцев назад
Thanks
@aqeelahmadengr3
@aqeelahmadengr3 3 года назад
Teaching style very good.
@Innozant
@Innozant 3 года назад
thanks Aqeel sahab
@mjaved701
@mjaved701 3 года назад
Amazing, always waiting your lecture on power query. May GOD bless you Ameen
@Innozant
@Innozant 3 года назад
Thanks Javed sahab
@Raj-e1b3r
@Raj-e1b3r 6 месяцев назад
thank u veryyyy much sir .... dil se ❤❤
@abhinav10x
@abhinav10x Год назад
Great, A big thank you to you for sharing this valuable lesson.
@Innozant
@Innozant Год назад
My pleasure!
@kashifqasim8069
@kashifqasim8069 Год назад
great way of teaching new tihings
@Innozant
@Innozant Год назад
Thanks dear
@jawadahmadehssan6251
@jawadahmadehssan6251 3 года назад
Thanks alot, my data was multiplying itself after every refresh. I was looking for an answer the whole day and thankfully I come across your video and you explained it in 10 minutes. Thank you so much.
@Innozant
@Innozant 3 года назад
Thanks Jawad Ahmad sahab😂 Happy learning dear
@ArmaanKing17
@ArmaanKing17 4 месяца назад
Amazing formula method! Thanks Sir
@sandeepaswal8944
@sandeepaswal8944 3 года назад
Sir Your videos are very good and your explanation is easy understand.
@Innozant
@Innozant 3 года назад
Thanks Sandeep Ji . happy Learning dear
@satishojha6240
@satishojha6240 3 года назад
Very easy and mostly useful thanku sir
@Innozant
@Innozant 3 года назад
Thanks Satish ji
@siddharthsatbhadre
@siddharthsatbhadre 2 года назад
GREAT explanation... awesome awesome awesome awesome 🙏🙏🙏👏👏👏👏👏thank you SIR.
@Innozant
@Innozant 2 года назад
Thanks Siddharth Ji❤️❤️
@sanjayTECH04
@sanjayTECH04 2 года назад
You are a genious, sharpness is your right
@Innozant
@Innozant 2 года назад
Thanks Sanjay ji.Really means a lot to me
@jayantabhattacharyya628
@jayantabhattacharyya628 3 года назад
Dear Sir Awesome superb tutorial. Today's topic is entirely new to me. I have learned a new way of Append data through formula. Hope you will upload function/formula related tutorial in power query series. Thanks & Regards Jayanta Bhattacharyya
@Innozant
@Innozant 3 года назад
Thanks Jayanta,Hope you like and learn something new.
@surendrarajput731
@surendrarajput731 9 месяцев назад
Very Helpful And Nice 👍👍
@syedtahirbukhari8377
@syedtahirbukhari8377 5 месяцев назад
Nice really make Full one like this
@krnrajan
@krnrajan 2 года назад
Thank you so much for such wonderful tutorials. So nicely explained. God bless! One query. Where do I get to read more information on Excel.CurrentWorkbook() and similar formulas
@vijaykumarjain3222
@vijaykumarjain3222 9 месяцев назад
Nice sir which video for inconsistent column in two worksheets for merging in one sheet through power quarry,and also renaming of header while marge
@rakeshmlearningentertainme6099
@rakeshmlearningentertainme6099 2 года назад
nice all video and learn lots of thanks you sir jee
@Md.Ismail-v1e
@Md.Ismail-v1e 7 месяцев назад
Good Night Sir, Wonderfully.
@devendrakumarsharma8809
@devendrakumarsharma8809 3 года назад
Excellent learning. Could you plz advise how to merge data from separate sheets exists in a single folder
@Innozant
@Innozant 3 года назад
Soon you may able to watch this video.
@vijaykumarjain3222
@vijaykumarjain3222 9 месяцев назад
Nice sir , how to merge inconsistent coloum of different worksheet in one sheet and rename of colum
@vijaysahal4556
@vijaysahal4556 3 года назад
Agar hum end equal -shift nabi kre to hum prewev main jakr extra sheet jsper data load krna h usi ko unchek kr skte hai but phle humko text filter not equal us sheet ka naam aise kr skte h sir ya nhi plz btaye 👍🏻👍🏻👍🏻👍🏻
@kishorpanara4191
@kishorpanara4191 3 года назад
Maan gaye sir aapko thanks sir naya SHIKHA ne ke liye
@Innozant
@Innozant 3 года назад
Thanks Kishor
@VipulJain40
@VipulJain40 Год назад
Dhanywad Guruji
@asmrindia
@asmrindia 2 года назад
Sir Thanks and Very Nice Explanation 👍 Lekin Ek Baat Bataiye Ki Jab Refresh Karne Par 5th Sheet Query2 ka data Usme Append Ho Raha Tha, Tab Aapne Direct Simple Filter Karke Query2 Ko Unselect Kyu Nahi Kiya. Aisa Karne Par Bhi To Remaining 4 Sheets ka Data hi Load Hota??? Please Bataiye Thanks
@Innozant
@Innozant 2 года назад
Humen load nhi Krna tha sirf connection establish Krna tha that's why
@asmrindia
@asmrindia 2 года назад
@@Innozant Ok Sir, You are a Nice Mentor. Thanks, Om Sai Ram😀
@prtkverma
@prtkverma 2 года назад
agar kuch columns mei alpha numeric data hai (for e.g. AX1004, EMP1002) to usme konsa Data type select karenge ?
@asmrindia
@asmrindia 2 года назад
Text Data Type Lena Hoga...
@hafiznaseer1988
@hafiznaseer1988 Месяц назад
Great Sir
@mohammadaijaz4901
@mohammadaijaz4901 3 года назад
Good job Sir, very well...
@Innozant
@Innozant 3 года назад
Thanks Aijaz
@mohammadaijaz4901
@mohammadaijaz4901 3 года назад
@@Innozant Sir aap se yeh poochna tah k maine ek table power query main load kiya or uska link banaliya ab mein ye link dosri workbook main use karna chata hoon kaise karen ge sir
@kiituniversity115
@kiituniversity115 3 года назад
Sir app kona mic use krte h?
@mayyuchape7195
@mayyuchape7195 3 года назад
Very Empracive 👍
@Innozant
@Innozant 3 года назад
thanks dear
@saurabh17sharma68
@saurabh17sharma68 3 года назад
Awesome Awesome Awesome sir
@Innozant
@Innozant 3 года назад
Thanks dear..
@meditationmusic6482
@meditationmusic6482 3 года назад
So nice Sir ji
@Innozant
@Innozant 3 года назад
Thanks 🙏❤️
@PragneshPatel-pv7mo
@PragneshPatel-pv7mo Год назад
Sir, 1 master workbook me data hai aur usme last 2 column blanks hai to vo data different sheets me 2 column ka data hai to use merge kaise kre?
@jhamran9680
@jhamran9680 3 года назад
Thank You Sir ❤️
@TheSuvankarKundu
@TheSuvankarKundu 3 года назад
So much appreciated.. 😍😍
@Innozant
@Innozant 3 года назад
Thanks Suvankar ji
@saitinudesai
@saitinudesai 2 года назад
Superb
@kabirvachanupdater7072
@kabirvachanupdater7072 Год назад
Jha hmara sare step show hote hai "Query setting" usko agr hm cut krke hta de to vo vapas kha se aayega . Reply sir
@horrorlovestories
@horrorlovestories 2 года назад
Sir maine sheet macro enable workbook kiya save as karke , but jab maine normal excel file mein close and load kiya toh error aa raha tha. Sir aisa kyu hota hai file type mein?
@hsgusain2054
@hsgusain2054 2 года назад
thnak sir
@sonukumar-xp5sd
@sonukumar-xp5sd 3 года назад
Nice
@rasimrajashaikh2815
@rasimrajashaikh2815 2 года назад
Thank u sir
@Innozant
@Innozant 2 года назад
Thanks
@ibrahimkvlogs3220
@ibrahimkvlogs3220 3 года назад
Sir Mis ki job bataye kahi delhi ncr me I'm fresher plz
@Innozant
@Innozant 3 года назад
Ok.. assessment test lete hain uske base par ref provide karayenge
@ajay306
@ajay306 8 месяцев назад
What difference between append and merge
@Innozant
@Innozant 8 месяцев назад
Kindly proceed with more videos of power query
@kirandodke3647
@kirandodke3647 3 года назад
master strock sir
@Innozant
@Innozant 3 года назад
Thanks Kiran
@Harish.Prasad.Semwal
@Harish.Prasad.Semwal 7 месяцев назад
0:46 2:31 4:06 7:28
@ubaidillahmuhammad20
@ubaidillahmuhammad20 3 года назад
bravo
@Innozant
@Innozant 3 года назад
Thanks
@vvv1160
@vvv1160 Год назад
But why it's not coming
@sadashivkage3133
@sadashivkage3133 9 месяцев назад
🙏🙏
@nileshchavan742
@nileshchavan742 3 года назад
👍
@gauravbhatia7987
@gauravbhatia7987 3 года назад
🙏🙏🙏
@Innozant
@Innozant 3 года назад
🙏❤️
@imranali-iy5wk
@imranali-iy5wk 3 года назад
Aj pata chla k rows add q hoti te
@Innozant
@Innozant 3 года назад
Kyu?
@imranali-iy5wk
@imranali-iy5wk 3 года назад
@@Innozant kun ka sir dhonda bht youtube pr answer ni mila eska aj mila aur logic ka bhi aj he pata chala ka back pr naya table add ho jata ta jiski wja sy rows barh jati te Thanks alot
Далее
Merge Tables Using Power Query | Vlookup Alternative
13:43
Import ONLY The Latest File - Power Query
9:25
Просмотров 21 тыс.