Power Query Hidden Tricks & Features
Вставка
- Опубліковано 5 жов 2024
- Power Query Hidden Tricks & Features
===========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...
#innozant #powerquery #powerquerytutorial#powerquerytricks
Aapse power query sikhkar bahot accha laga sir ji... Kafi kuch sikhne mila.... Thnk u very much sir....
Plz upload some more videos related to power query 😊❤
Thanks you sir
I just completed all 28 videos
Of power query in Just 7 days
Thank you very much for efforts you have been taken to make this series
I work at corporate.
After watching your videos
I created whole big database in power query.
Then based on that database i create one another Excel program which give output with help of database. because only Excel cannot handle big data but power query can handle it .
thankyou very much sir🙏
Great..Keep Exploring dear
Sir Ji, aapko bahot bahot sukriyan, aapse bahut kuchh sikhne ko mila hain, aapka teaching koi bhi below average student bhi aasani se samajh payen ga. Thank you once again.
Great sir ❤
I think all learner have need power quiry continue video to basic level. Please post daily base.
🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹
सीखते रहो, सिखाते रहो l
हमेशा हंसते मुस्कुराते रहो l कभी अपने लिए तो कभी अपनों के लिए l
Good Morning Sir,
Very helpful, Excellent.
Thanks for this video but can you make sql series dear sir. I really want to learn from you. Because the way you teaches us is so wonderful.
Sir, apka shikhane ka tarikai alag hay, bohat easy way, interesting and also very depth.
Thank you Sir
Thanks
Every video is mind-blowing sir ji.
thank you so much sir you are great your video has a lot of informative and motivated.
Nice Sir for the Motivation
Excellent sir
Sir power query ne to dil jeet liya 🎉😊✌️💯
Sir pls power query k kch or videos kra dijiye or power pivot k bhi
excellent video
Your ending msg is fabulous!
Thanks
Wonderful😊
Thank you so much for video
Size reduce limit error showing even for 1600 rows?, how to unable it..
Kindly help me
Thank you Jata Ji
thanks for this video sir.
Thanks Sir
Sir please power query series jldi bna do sari pls pls
My teacher 🎉
Sir ji FULL POWER QUERY PLAYLIST Link Share Kijiye ...😀😀
Nice video👍👍
amazing tricks sir
Sir SpellNumber wali file work nhi kr rhi error aa rha h likha hai ,This file type is not supported in protected view
1: The file name or path does not exist
2: The file is being used by another program
3: The workbook you are trying to save has the same name as currently open workbook.
Just killer
सर एक्सेल में मुझे एक समस्या आ रहा है मैं चाहता हु की क्रिकेट का स्कोर बोर्ड होता है उसमे बॉल्स को ओवर में कैसे कन्वर्ट करू समझ नही आ रहा है जैसे 11 बाल को ओवर में कन्वर्ट करने पर 1.5 ओवर लिखा हुआ होना चाहिए
=TRUNC(J17/6,0)+MOD(J17,6)/10
J17 is cell address for total balls
Ek second sheet pe table banao
Balls. Over
1 0.1
2. 0.2
3. 0.3
4. 0.4
5. 0.5
6. 6.0
7. 6.1
8. 6.2......and so on
Then 1st sheet me overs ke jagah par
VLOOKPUP mar Dena with the above table.
So when you type 7 balls then it will show
6.1 Overs 😊
Hello sir,
Actually view days before I got job on mis executive in company doing railway arendence so that's why I am thinking its not a mis executive work am I right sir please tell me 🙏🙏
Check the working nature ,is it mis profile or something else
👍 sir
🙏
I have a solution two months back but no response yet...
Unable to take personalized queries due to lack of time and also note that it's not possible to respond on every comment
If it is an old video of your for that related concept so would you reply or not.
where is the sheet sir ji ?
Check playlist folder
@@Innozant checklist folder where I face problems getting folders. could you please attach the file (not the checklist folder) in the description box? it's a humble request..🙏🙏🙏🙏🙏
You should help if someone asked for a solution
.
You may ask your concept related query @innozantofficial telegram I'd but if you expect for personalized query then sorry dear.
If it is an old video of your for that related concept so would you reply or not.
Thanks sir