Тёмный

Power Pivot Import Folder Import | Use Power Query Feature to import Folder Data into Power Pivot 

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

Power Pivot Import Folder Import | Use Power Query Feature to import Folder Data into Power Pivot
Excel Power Pivot Playlist Link - • Excel Power Pivot
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
#exceltricks #exceltips #innozant #exceltipsandtricks

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

 

7 июл 2021

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 72   
@iveymbabest5303
@iveymbabest5303 3 месяца назад
Outstanding information. You have to explained it so well! Cheers😊
@kishorekumarborah9404
@kishorekumarborah9404 3 года назад
Best teacher for excel..hats off 🙏🙏
@Innozant
@Innozant 3 года назад
Thanks Kishore
@allinonewithaks9496
@allinonewithaks9496 3 года назад
Thank you so much sir... Please continue this series... Waiting for next video
@Innozant
@Innozant 3 года назад
Thanks dear..Yes sure wilp cont...
@shrikantbadge3978
@shrikantbadge3978 Год назад
Amazing sir. Thank you.
@Narendar.pathak
@Narendar.pathak 3 года назад
Thanks for this knowledge.
@Innozant
@Innozant 3 года назад
❤️❤️
@satishojha6240
@satishojha6240 3 года назад
Behtareen video sir 🙏🙏🙏🙏. good night sir
@Innozant
@Innozant 3 года назад
Thanks Satish ji .
@dhakafady774
@dhakafady774 Год назад
thanks a lot sir
@pa2happiness13
@pa2happiness13 3 года назад
👌🏼
@createyour6681
@createyour6681 3 года назад
Very great sir
@Innozant
@Innozant 3 года назад
Thanks ❤️
@pardawala_Bhiwandi
@pardawala_Bhiwandi 3 года назад
👍👍👍 thanks 👍
@kishorpanara4191
@kishorpanara4191 3 года назад
You are great sir thank you sir
@Innozant
@Innozant 3 года назад
Thanks Kishore Ji . happy learning
@jayantabhattacharyya628
@jayantabhattacharyya628 3 года назад
Dear Sir Thanks for uploading such a very useful video on import folder data to power pivot with the help of power query. It's an unique trick. That's why I love watching your videos very much. Thanks & Regards Jayanta Bhattacharyya
@Innozant
@Innozant 3 года назад
Thanks Jayanta for your valuable appreciation 🙏🙏❤️
@prajwalshetty2047
@prajwalshetty2047 2 года назад
Nice Video 👍
@rakeshmlearningentertainme6099
@rakeshmlearningentertainme6099 2 года назад
nice video
@abhishekberiya6835
@abhishekberiya6835 3 года назад
@Innozant thank you sir & hope that you will solve my query also in your further sections
@Innozant
@Innozant 3 года назад
Which query dear..are you already send your query @innozantofficial telegram id?
@abhishekberiya6835
@abhishekberiya6835 3 года назад
@@Innozant sir i have send that in telegram also we have chat today in telegram. request you to please check .
@rajivranjan-mf6zu
@rajivranjan-mf6zu 3 года назад
This is tricky and useful approach.... Ye to aapki kahi baat ho gayi ki "Tum tum nhi ab ye ho"😀😀 Thanks a lot sir to teach how to use one tool in different way...Hats off sir♥♥
@Innozant
@Innozant 3 года назад
Hahah..Thanks..bade gaur se dekhte h aap video dear❤️❤️
@gauravbhatia7987
@gauravbhatia7987 3 года назад
Thnq sir
@Innozant
@Innozant 3 года назад
Thanks ❤️
@hrhelpteam
@hrhelpteam 3 года назад
Great Sir
@Innozant
@Innozant 3 года назад
Thanks Gaurav❤️❤️
@aqeelahmadengr3
@aqeelahmadengr3 3 года назад
Good working
@Innozant
@Innozant 3 года назад
❤️❤️
@user-hz6bd5pf6c
@user-hz6bd5pf6c 2 дня назад
Sir, agar access ka data excel me lana ho to power pivot se hoga ya power query se? aapke channel pr mila nhi koi video access ka data excel me 😊
@sathyanarayana4914
@sathyanarayana4914 3 года назад
Thanks update new vedio sir
@Innozant
@Innozant 3 года назад
Thanks Sathya ❤️
@prajwalshetty2047
@prajwalshetty2047 2 года назад
Sir I used separate Power query to append Gross sales of various Branches to find total Gross sales and Sales return of various Branches to find total sales return in two different sheet, in one sheet total Gross sales and in other sheet total sales return. To find Total Net sales, I manually reduce sales return from gross sales. Sir is there any way to do this all calculation in power query itself.
@durgeshrai8938
@durgeshrai8938 3 года назад
🙏🙏🙏
@RahulRoy-po9ct
@RahulRoy-po9ct Год назад
🙏
@hussainmeghani4809
@hussainmeghani4809 3 года назад
Is there any solution to vlookup from multiple value cell. Like A1 =25, A2=7|25, A3=0, A5=0|7|25..desired result B1, B2, B5 should be mark as positive match...pls guide
@shrikantbadge3978
@shrikantbadge3978 3 года назад
Baki excel videos Ka approach just data entry operator Ka hota hai. But Deepak sir Ka approach Data analyst , MIS specialist or similar to that profile Ka knowledge dena hai. We need to understand this difference. Thanks Deepak Sir.
@someonefrom2002
@someonefrom2002 3 года назад
Bhai sir ka naam Dilip Jha hai Sir ka first video dekh lo
@shrikantbadge3978
@shrikantbadge3978 3 года назад
@@someonefrom2002 Omg I am terribly Sorry. 🙏.
@shrikantbadge3978
@shrikantbadge3978 3 года назад
लेकीन सर ने हमारे लाईफ मे skill का दीपक ही जलया हैं
@someonefrom2002
@someonefrom2002 3 года назад
@@shrikantbadge3978 Bilkul bhai, sir ne phle video me hi kaha tha " A teacher by passion " Aur wo passion hi hai jo sir ko humlog kya sabhi log dil se chahte hai #innozant_family
@keshariprasad1992
@keshariprasad1992 8 месяцев назад
Sir, pls help me to fix my data related problem. I have to prepare channel stock report that have various information like dealer stock, distributor stock, MTD n LMTD Sellout and sell in, last 3month historical information in a Single pivot with the help of silicer. We have dump of those information . But data sequence is not same for all dumps. First I have to manage sequence, then consolidated all data and then need to mapping. After these I have to make a pivot table. And I have 15 to 25 minutes to complete this on daily. Please help me to ur supervision. I know MS Access and power query also. Which will help me most?
@sushmapandey7718
@sushmapandey7718 3 года назад
👍🙏
@Innozant
@Innozant 3 года назад
Thanks Sushma..Must watch sequence video❤️👍
@sushmapandey7718
@sushmapandey7718 3 года назад
@@Innozant yes sir I will office MERI open ho gayi hai so time Nahi mil pa Raha mujhe..
@sandeepaswal8944
@sandeepaswal8944 3 года назад
Namstai Sir ji. Power Query ka hi wait tha muje. Thank u so much sir ji. Sir close & load to kai baad merai. Pivot Table Report & Pivot chart show nahi hota aisa ku sir???? Mai 2019 version use kara hu.
@Innozant
@Innozant 3 года назад
Thanks Sandeep Ji..haan Ye seriea chalega abhi
@dnyaneshwarudhare1074
@dnyaneshwarudhare1074 2 года назад
Hello sir..thanks for this video..sir can u pls tell me in my excel why power pivot not showig..when i go to add-in its only showing excel map option..Thank you
@Innozant
@Innozant 2 года назад
Which version of ms office you are using now..Upadate 2013,2016 or 2019 as per your convenience
@purshouttamofficial7244
@purshouttamofficial7244 9 месяцев назад
Sir I am facing this issue Expression.Error: Evaluation ran out of memory and can't continue.how to solve please help me Sir
@pardawala_Bhiwandi
@pardawala_Bhiwandi 3 года назад
Iska solutions do pls sir ☺️
@rakeshray9963
@rakeshray9963 3 года назад
Fy year wise month nikalna ho to keya kare column-a1 date of joining,b1-resign date(may be empty ),c1-fy19-20,c2-fy20-21,c3-fy21-22 en column mai month chahiye according to date of joining
@Innozant
@Innozant 3 года назад
Eccel sheet Ydi send kren @innozantofficial telegram id par aur query explanataionation to acha hoga
@mayurt4628
@mayurt4628 11 месяцев назад
Hi, how are you, I have replied on telegram on your channel
@pardawala_Bhiwandi
@pardawala_Bhiwandi 3 года назад
Forren key main be created Kiya power bi SE but fir Bhi nehi ho Raha hai
@Innozant
@Innozant 3 года назад
Kuch galti kar re b aap
@pardawala_Bhiwandi
@pardawala_Bhiwandi 3 года назад
Main data relationship nehi Kar pa Raha hun.......power privot me single or both options nehi milraha
@Innozant
@Innozant 3 года назад
Kyu .data tab me bhi hai relationship..wahan se krbskte hain ya power pivot me bhi hai relationship diagram bhi aur option bhi..use it
@pardawala_Bhiwandi
@pardawala_Bhiwandi 3 года назад
Ap muje rasta batao
@pardawala_Bhiwandi
@pardawala_Bhiwandi 3 года назад
Main apko mail Kar Sakta hun
@omprakashsharma5749
@omprakashsharma5749 3 года назад
Sir aap ko ek mail kiya hai pls check and reply Thank you
@Innozant
@Innozant 3 года назад
Ok.. Sharmaji ❤️
@omprakashsharma5749
@omprakashsharma5749 3 года назад
@@Innozant omprakash.sharma2605@gmail.com ye mail id hai sir ji
@pardawala_Bhiwandi
@pardawala_Bhiwandi 3 года назад
Main apko data bhejta hu
@Innozant
@Innozant 3 года назад
Check it again
@manojkumarsingh3385
@manojkumarsingh3385 3 года назад
🙏🙏🙏
@Innozant
@Innozant 3 года назад
Thanks Manoj Ji 🙏
Далее
Merge Tables Using Power Query | Vlookup Alternative
13:43
Top 20 Data & BI terms every data analyst *should* know
12:21
Introduction to Power Pivot: Excel's data model
13:45
Просмотров 2,2 тыс.