Great video. I don’t have office license. Also, these 3 excel files not in the google drive link in your description. So, I tested in Power BI platform with other excel file in your drive.
Hi, Thank you so much for your videos. The way you explaining things is outstanding. I have prepared my own dashboard for my internal project and it was a huge success. I have few questions, If we have multiple files having similar data with same column headings and other files having some extra column that's not common with other files. Should we make all files as same number of columns by deleting or is it possible to combine all the files and later we can delete in PQ? Also, I have selected data by Folder, for future file how it will work? Please help me with this.... All the best ❤
Super and very very useful Enik multiple excel work sheetil oro work sheetilum multiple sheets but different name each sheet, ad engane combine cheyd load cheyyam
Hi, very usefull video, however had some doubts regarding the same. So is this power query based on the files in the folders (looking up the files based on the files present in the folder).As mentioned like what happens if we add some other unrelated files to the same folder? Will it have any issue with the query and is the process same if we use xls file option instead of folder, will it have any change in the process of combining when adding a new file, if so what will be the process.
Good and appreciate. but one concern, in between at the time of initial transformation you have unfiltered. on row of special character.(XXXXXX)...has the same been incorporated in the new data. pls comment... Thanks in Advance
Accounting ഫീൽഡ് ജോബ് ഒരു ഇന്റർവ്യൂ ഉണ്ട്.... Compony excel ആണ് use ചെയ്യുന്നത്.. മറ്റു സോഫ്റ്റ്വെയർ ഒന്നും ഇല്ല Accounting ൽ excel ൽ പ്രധാനമായും അറിഞ്ഞിരിക്കേണ്ടത് എന്തെല്ലാം ആണ്...നിങ്ങൾക്ക് അറിയുന്നത് പറഞ്ഞാൽ.. prepare ചെയ്യാൻ ആണ്.... pls 🚨🚨🚨🚨🚨🚨🚨🚨🚨
Thank you. It is an excellent tool. Additionally, I greatly appreciate the presentation you gave Could you explain in which extension (save as type) we will save a file created with Power query.
Morethan 1000 items nu More than 10 Suppliers ninnulla price engane compare cheyaam? Compare cheithit Ooro item num best price thanna supplier ne engane choose cheyyaam ? Oru Video Cheyyaamo?
Could you pls create a inventory aging Report for given period of time with slots(0-90,91-120,121-181...) With inventory and Value of these buckets/slots
I was following chandoo but your vedios are great in malayalam. 🎉thanks for vedios
I am dca teacher. This is great. Really help full
Thank you so much. Helpful video aayirunnu
Good and properly done it even 21:18 minutes and keep continuing, and I hope more videos about excel.🎉🎉
Very informative Thanks❤
very well explained
It's really useful video.. thanks a lot
Much appreciated your effort Bro. Super informative ❤
❤️
Very informative video
Tk u ❤
awesome Bro, much helpful.
Great video. I don’t have office license. Also, these 3 excel files not in the google drive link in your description. So, I tested in Power BI platform with other excel file in your drive.
Thanks for all your efforts. Keep doing. Subscribed
Super and Much informative Bro... 👍😘
This is great. Really helpfull
aa 3 Excel sample files onn send cheyyavo
Thank u so much bro...
Highly helpful.....
Very Thankfull ❤
Appreciate your time and effort. Thanks for the video
Thanks for the video..
Waiting for next level 🔜
Very usefull. Thanks for good information
Waiting For next video
Thanks dear ❤
Nice as usual ❤
Thanks sir🎉🎉🎉
Appreciate your positive feedback! Thrilled to hear you liked the video. Keep enjoying and stay tuned for more!😊
Super bro 👌
Very useful video, thanks 💖
Thank you, I am happy to hear you feel that way!
Can i get the dataset using in this video please, its not in the link in the description
Good one!
Waiting for next video
Thanks for uploading
Excellent
Great bro,
Thank you
thank you so much. greate=
Thank you, I am happy to hear you feel that way!
Adipoli
Can you please upload VBA detailed course. Thank you
Hi,
Thank you so much for your videos. The way you explaining things is outstanding. I have prepared my own dashboard for my internal project and it was a huge success.
I have few questions,
If we have multiple files having similar data with same column headings and other files having some extra column that's not common with other files. Should we make all files as same number of columns by deleting or is it possible to combine all the files and later we can delete in PQ?
Also, I have selected data by Folder, for future file how it will work?
Please help me with this....
All the best ❤
Thank you
You're welcome
Great bro
Please do a video about Medical store/Pharmacy stock management excel sheet
الله അങ്ങയെ അനുഗ്രഹിക്കട്ടെ
Super and very very useful
Enik multiple excel work sheetil oro work sheetilum multiple sheets but different name each sheet, ad engane combine cheyd load cheyyam
Nice
❤❤❤
Is it possible to convert unstructured excel dataset to structured excel dataset?
Congratulations Alfan bhai....💐💐💐
ന്യൂസ് കണ്ടു..
....You are my inspiration... Keep going...❤
Waiting for upcoming video 🤔
Very soon Brother.. Was tied up with some trainings programs :)
Hi, very usefull video, however had some doubts regarding the same.
So is this power query based on the files in the folders (looking up the files based on the files present in the folder).As mentioned like what happens if we add some other unrelated files to the same folder? Will it have any issue with the query and is the process same if we use xls file option instead of folder, will it have any change in the process of combining when adding a new file, if so what will be the process.
Excel VBA video ചെയ്യാമോ?
Good and appreciate. but one concern, in between at the time of initial transformation you have unfiltered. on row of special character.(XXXXXX)...has the same been incorporated in the new data. pls comment... Thanks in Advance
waiting for power bi videos
Tableau and power bi tutorials cheyyumo
Hi Sir
I have a Query .can we add the formulas in power query. Example Using if function
Accounting ഫീൽഡ് ജോബ് ഒരു ഇന്റർവ്യൂ ഉണ്ട്.... Compony excel ആണ് use ചെയ്യുന്നത്..
മറ്റു സോഫ്റ്റ്വെയർ ഒന്നും ഇല്ല
Accounting ൽ excel ൽ പ്രധാനമായും അറിഞ്ഞിരിക്കേണ്ടത് എന്തെല്ലാം ആണ്...നിങ്ങൾക്ക് അറിയുന്നത് പറഞ്ഞാൽ.. prepare ചെയ്യാൻ ആണ്....
pls 🚨🚨🚨🚨🚨🚨🚨🚨🚨
1) Pivot Table
2) Lookup References
3) IF and Nested IF Function
4) SUB Total
5) Data Validation
All the best😊
I got a error after edit from query."process cannot access the file.it is being used by another process
Can't find those 3 excel files in your Drive as well as your website. Please do check and attach it.
yes have anyone got it
Are doing excel coaching???
nice
Thank you, I am happy to hear you feel that way!
Thank you. It is an excellent tool. Additionally, I greatly appreciate the presentation you gave
Could you explain in which extension (save as type) we will save a file created with Power query.
select the standard Excel workbook format, which is usually XLSX
Morethan 1000 items nu More than 10 Suppliers ninnulla price engane compare cheyaam?
Compare cheithit Ooro item num best price thanna supplier ne engane choose cheyyaam ?
Oru Video Cheyyaamo?
15:25 ബ്രോ cost and profit columns വാല്യൂ സെയിം ആണല്ലോ 🙄
Hai, is there any functions in excel to summarize the data in a any year calendrer in excel pls help
Pivot table auto load aavunilllallo refresh adichal table matrame load aakunullu
How to change date from 12 to 24 format in power query,pls reply sir
Exercise files not found in server. Kindly check.
Query to advance level video please
Using files are missing in drive
🎉
GREAT TOOL
How to set a status code (For eg. latest and superseded) If you have two cells with same value? . I am asking about the revisions of documents.
Nice question
Hi
Could you pls create a inventory aging Report for given period of time with slots(0-90,91-120,121-181...) With inventory and Value of these buckets/slots
Google suppler again
Sir.
Onnu contact cheyanulla number tharuvo
Sir I need your help regarding gst software ,can I get you number pls
❤
❤