super. i am very much interested watching your teaching
@Prabasmsoffice
5 ай бұрын
Happy to hear this from you. Watch more such videos. Keep learning.
@nktrendings816
Жыл бұрын
Super Learning BRO 👌
@eashwarsuriya2087
5 жыл бұрын
Thank u bro very useful video😊😊
@priyasanal2257
3 жыл бұрын
Hi great job. Although am keralite, I can understand you well. I must say amazing. Thank you so much
@Prabasmsoffice
3 жыл бұрын
Thanks for your encouraging comment. Keep learning and supporting.
@mathumathu3586
4 жыл бұрын
அருமையான விளக்கம் sir
@Prabasmsoffice
4 жыл бұрын
நன்றி Mathu. தொடர்ந்து அனைத்து வீடியோ களையும் ஒருங்கள்.
@ramzein776
3 жыл бұрын
very clear explanation sir
@infy25
2 жыл бұрын
The way you teach concepts are very clear. Beginners can easily learn. One request pls add what kind of errors it will throw and how to solve it. Thanks
@ErusappanRagupathi
2 жыл бұрын
Super sir i am waiting is this sir i will try my best.
@krishnamoorthic4453
3 жыл бұрын
Sir super ninga ms Excel book velietal payanullathaga irukum explanation vv super
@TamilBibleStar
2 жыл бұрын
Thanks bro.. ரொம்ப தெளிவா, புரிந்துகொள்ள எளிமையாக சொல்லி கொடுப்பது அருமை...
@Prabasmsoffice
2 жыл бұрын
முழுவதும் பார்த்து உங்களது கருத்தை கூறியதற்கு நன்றி.
@goinathan
5 жыл бұрын
You are doing a great service to persons like me.thank you bro .
@palanimuruhan66
5 жыл бұрын
Thanks Sir
@Prabasmsoffice
5 жыл бұрын
Happy learning brother
@kroobanraj2299
5 жыл бұрын
Thank u
@amalarajmstella2340
4 жыл бұрын
Thank you sir, Super you recap scenario explanation sir
@sabarishdevendran8995
5 жыл бұрын
Hi praba, great job of power query
@rbala8802
4 жыл бұрын
Superb Ji... thank you so much.
@sabarishdevendran8995
5 жыл бұрын
Definitely Mr. prabas you are doing a great job
@Prabasmsoffice
5 жыл бұрын
+sabarish devendran Thanks. Keep learning new things.
@logeshwaran9026
Жыл бұрын
Vera level brother...your teaching is super..
@Prabasmsoffice
Жыл бұрын
Thanks for watching this Excel tutorial. Watch the tutorial by playlist.
@vanjibanu8200
5 жыл бұрын
Thank you very much bro Yesterday I asked This subject - Thank- you Bro
@Prabasmsoffice
5 жыл бұрын
+Vanji Banu Yes, a lot of requests has been raised for this topic. So decided to record fast.
@krishnajagadeesh6307
4 жыл бұрын
I am your subscriber
@rajasanthosh9617
5 жыл бұрын
Thank U sir
@sivakumarramalingam9440
3 жыл бұрын
Awesome as a beginner for me very useful
@hajasahib8943
5 жыл бұрын
Thanks bro
@ebin1311
5 жыл бұрын
it's useful video sir, hence i work with large data this tool make my work easier and faster.
@Prabasmsoffice
5 жыл бұрын
Watch the videos and practice it. Recommended the videos to your friends.
@ebin1311
5 жыл бұрын
@@Prabasmsoffice sure sir
@laxmanapandi
4 жыл бұрын
Sir, neenga Vera level
@Prabasmsoffice
4 жыл бұрын
கற்க கசடற. Happy learning
@ganeshmanchi8499
5 жыл бұрын
Hi, that was a clear explanation... I was able to understand at the first instance... thank you so much... God Bless!
@Prabasmsoffice
5 жыл бұрын
Keep learning brother.
@satheeshmanohar5947
3 жыл бұрын
super sir
@Thuglyist
4 жыл бұрын
This is a great help bro. God Bless you
@Prabasmsoffice
4 жыл бұрын
Happy learning.
@Thuglyist
4 жыл бұрын
@@Prabasmsoffice Hi Mr. Prabhas. I've got a prob. I tried with th four files of same columns but I got an error: Datafornat error. Input couldn't be recognized as a valid excel doc. Details binary
@letsexcel8077
5 жыл бұрын
Thank you, sir... Very useful info.
@saranrajranganathan
3 жыл бұрын
Your explanation is superb, I have 2 clarification.. 1 . I am getting blanks after loading as table 2 . How combine the protected excel
@Prabasmsoffice
3 жыл бұрын
I will help you with a new video for using data from protected Excel.
@mariappank8361
3 жыл бұрын
Very effective and they way you explain also clear. Thank you very much. Good job.👍keep rocking 👍
@Prabasmsoffice
3 жыл бұрын
Glad that you liked the video. Keep exploring all the videos in our playlists.
Dear Mr.Prabhakar Good morning என்னிடம்ஒரு main folder க்குள்ளே 7எக்சல் சீட்கள் 📊 8sub folder📂களில் இருக்கிறது. இந்த 56எக்சல் ஷீட்களை📈 ஒரு குறிப்பிட்ட செல்களில் இருக்கும் டேட்டாவை 56 ஷீட்களில் ஒரே தடவையில் அழித்துவிட்டு பிறகு கன்சாலிடேட் செய்து பிறகு ரிப்போர்ட் ஆக வேண்டும் 📈📊 எப்படி இதனை செய்வது?🧭 மிகவும் பொறுமையாக செய்முறை விளக்கம் மிக அருமை Today i will mail you the sheets for your reference
@Prabasmsoffice
4 жыл бұрын
Need to develop VBA automation. I will look in to the Excel and email you.
@Prabasmsoffice
4 жыл бұрын
Please RING the BELL icon to receive more such Excel tips.
@mahasailesh4021
4 жыл бұрын
Thx
@kodairoadkannan
5 жыл бұрын
nice explanation
@Prabasmsoffice
5 жыл бұрын
Thanks for your positive feedback.
@goinathan
5 жыл бұрын
Very useful .consolidate exercise bro.i have one doubt. While subtotaling sl.nos are are staring with 1,2,3,.....but additional one row with other value also accompanied while filtering PL give me solution> For example {=subtotal(e5:e55)}
@Prabasmsoffice
5 жыл бұрын
Try to update a video on this concept.
@Gaajinikanth
4 жыл бұрын
Super nanba.. Really nice and full informative. Nanba, let say i do exactly like your video, does the contains copied exactly as per original raw data? Or query will sort according to its rules? I had face some problem, whenever i insert new raw data, the report generated in query is not accurate. Ungal karathu thevai..
@Prabasmsoffice
4 жыл бұрын
Record your problem as a video and share it to prabas.msoffice@gmail.com
@Gaajinikanth
4 жыл бұрын
@@Prabasmsoffice i will send you email. Currently I had listed down all my doubts and also some screenshot video for your refence. Hope you can solved my problem. Because i am always work with big data in various file. I want to simplify all the manual work into automated work.
@letsexcel8077
5 жыл бұрын
Hi sir, Thanks for this video and it works fine. Looks like there's a setback. If someone uses (opens) the original file (which has the data), then, the query shows an error. Is there anyway to ignore that particular file and continue with the consolidation ?
@letsexcel8077
5 жыл бұрын
I managed to find the solution, sir. By removing "~$" from the path, this error message can be eliminated. Good thing is, data from the file which is being used, still can be extracted.
@Prabasmsoffice
5 жыл бұрын
+Gunabalan Kanthan Excellent Gunabalan. Keep discovering new things.
@manickaa3702
4 жыл бұрын
Thank you so much 💕😊
@krishnajagadeesh6307
4 жыл бұрын
Hi bro super
@Prabasmsoffice
4 жыл бұрын
Yes Krishna, how can i help you.
@anbunfcl3571
5 жыл бұрын
Use full video bro
@sabarishdevendran8995
5 жыл бұрын
Hi praba, Today I have worked with this concept and generate the report and get the two error 1) totally 7 excel workbok sheets all the name of the excel book and sheet name is used as same as advised and report generated in that fifth work book after I had run the report found as mentioned as null. If I had removed that excel working perfectly
@Prabasmsoffice
5 жыл бұрын
+sabarish devendran Send the screenshot to my email id. ID can be found in the channel's description
@raguram9974
3 жыл бұрын
1) Is there any limitations in the storage ? 2) How will be the speed when we add huge size files
@Prabasmsoffice
3 жыл бұрын
1. There is no defined limitations. It is purely based on your system memory and architecture. 2. Also you will have to consider the row and column limitations of the Excel file for your outputs.
@subbu3377
4 жыл бұрын
HI Prabakaran, I just watched your video and its very interesting. I have a querry. Suppose I have 3 files in excel. These three files have different colums but one or two will be a common. example customer ID or product ID. How to combine this three files and obtain or extract all the relevant data without lossing any data, for further analysis? Thank you.
@Prabasmsoffice
4 жыл бұрын
Little complex.
@thivakarganesh1617
5 жыл бұрын
Reminder paththi oru video podunga sir desktop vedio
@dhanaraj2686
5 жыл бұрын
Pls update about the Google online sheet and theirs using
@Prabasmsoffice
5 жыл бұрын
Sure brother. Keep following us for further notification.
@accounttirupati6764
3 жыл бұрын
Hi Sir I want to know how to enter one excel sheet1 the same data shown in sheet 2. Can you please guide for the same
@Prabasmsoffice
3 жыл бұрын
Link with Formulas.
@sabarishdevendran8995
5 жыл бұрын
2)second time again I have created fresh one but in the middle itself showing that expression error
@MsBaranee
3 жыл бұрын
Hi Bro - Thanks for the video, useful one 👍. I'm getting error when loading a macro enabled file like when opening a file it will ask us to click on enable content file. Do you have solution for this one?
@sabarishdevendran8995
5 жыл бұрын
Help in this case
@deepakprabhu8235
5 жыл бұрын
Sir, can you add more tutorial related to Power Query
@Prabasmsoffice
5 жыл бұрын
Sure. Thanks.
@gowrianand5828
3 жыл бұрын
Sir, How to paste multiple worksheet to single sheet in excel
@Prabasmsoffice
3 жыл бұрын
You can also use Power Query.
@vijaybhaskar5851
4 жыл бұрын
Hi sir, thanks for the video. I have a doubt, as you said the tab name should be the same for all the workbooks then only the process will work. If the tab name is different in any other workbook is there any options to do the same process with the help of Power Query. Kindly advise. Thank you
@vijaybhaskar5851
4 жыл бұрын
While working in this concept commonly the column or row name can be the same in different workbooks. But the Tab name should differ right. So I got the confusion.
@Prabasmsoffice
4 жыл бұрын
It would be great for you if you watch this video two times. Your question are already answered in this video. Please watch it again.
@NGKMUSICALS
Жыл бұрын
How to combine different headers into a single book to create a report
@sumansundar5295
2 жыл бұрын
Hi sir, continously getting following error. Data ertor. Couldn't find data
@Prabasmsoffice
2 жыл бұрын
Check the following options, you may get errors: 1. If you moved the source files 2. If you renamed the connected files
@kishorem563
3 жыл бұрын
Can you please help me out bro and also I am not able to combine multiple file in to one
@maheshvenkatesan617
5 жыл бұрын
Hi Sir.. Good evening.. This superb will work in excel 2013?....
@Prabasmsoffice
5 жыл бұрын
This will definitely work in Excel 2013, but you have to download this as an add-in for 2013.
@Aasmv2013
Жыл бұрын
If the file is having more than one work sheet then how to consolidate it
@sabarishdevendran8995
5 жыл бұрын
How to consolidate multiple sheets in same work book
@Prabasmsoffice
5 жыл бұрын
+sabarish devendran I will make sure to post a video for this, keep following Prabasmsoffice
@tharunkumar1958
5 жыл бұрын
Sir I am using Trial version of MS Office 365, when I tried to use this Consolidate, the message comes that internet explorer version 9 or above should be installed..
@prabas2006
4 жыл бұрын
Try to ungrade your internet explorer
@ranjithrash5329
4 жыл бұрын
I tried this but when i combine the binary i got a error msg that data format error the input could not recognized as a valid excel document. Please help
@Prabasmsoffice
4 жыл бұрын
Have you tried with binary files?
@ranjithrash5329
4 жыл бұрын
No. I tried with XLSX file
@Prabasmsoffice
4 жыл бұрын
Let's discuss this
@JOHNCENAA005
4 жыл бұрын
Same doubt...same error for me to
@annamalair2969
3 жыл бұрын
Your videos are super But practice files not download sir
@Prabasmsoffice
3 жыл бұрын
Sorry for the inconvenience. prabastech.com/free-downloads/ All the downloadable files have been moved to this path now. Check and confirm.
@TOM_M18
6 ай бұрын
I have one doubt anna.. suppose nama tablela center heading and side headings la table ku Mela irukuna ithu use aaguma ?
@Prabasmsoffice
6 ай бұрын
Try pnnalaam, share me the sample to 9940261814
@karthikeyank4786
3 жыл бұрын
Hi sir., proper heading not coming in the power query.......
@Prabasmsoffice
3 жыл бұрын
We can option to control heading in Power Query. Please check out our other Power Query related videos.
@johnbrightson8001
2 жыл бұрын
i have data table with hyperlinks after appending by power query how to get the hyperlinks with clickable to open?
@Prabasmsoffice
2 жыл бұрын
There is an option to retain hyperlink in Power Query, will cover it in the upcoming video.
@johnbrightson8001
2 жыл бұрын
@@Prabasmsoffice thank you.
@rajasanthosh9617
3 жыл бұрын
Sir, one doubt : single work book la multiple sheets iruku, intha multiple sheets ,single ,single work book ah vara veka ethuna trick iruka sir, For eg. 1 work book had 5 multiple sheets iruku , intha 5 sheets vanthu 5 work book varanum sir, tricks iruntha sollunga sir
@selvamsekar661
4 жыл бұрын
Hello sir, how to combine multiple password protected files as one file.?
@nagalaxmirenu9217
Жыл бұрын
How can we consolidate different sheets data in one excel
@Prabasmsoffice
Жыл бұрын
from different sheets is possible ma, if they are in same format
@Common123-o5n
4 жыл бұрын
நண்பரே வேறு வேறு மாதம் பத்து பொருள்களைப் வாங்குகிறோம். ஒரு பொருளின் பெயரை enter செய்தால் அது எந்த மாதம் வாங்கியது என கண்டுபிடிக்க formula என்ன என்று சொல்லுங்கள்.
@Prabasmsoffice
4 жыл бұрын
இருக்கின்றது, இந்த வீடியோவைப் பார்க்கும்போது தெரிந்துகொள்ளலாம் kzitem.info/news/bejne/xaedsJamnIlhg3Y
@Common123-o5n
4 жыл бұрын
asset remarks phone not working car not working cutting machine notworking printer Sir, இந்த list வேறு sheetல் enter செய்தால் notworking என்றும், இதை தவிர வேறு பெயரை enter செய்தால் nillஎன்று வர formula சொல்லுங்கள். நன்றி!!
@ifhamaziz
3 жыл бұрын
Hi Sir, I'm Ifham from Sri Lanka. I usually watch your videos and practice and apply it in my real life. but i have some issues. Usually i maintain a cheque registry in office. i have lot of cheque recieves and issues. when if i want to search a cheque by it's number i should get the results of from whom i recieve and to whom i issue that particular cheque. so i did it through append and merge in power query. but the problem is sometimes i get the same cheque number for different banks. so how can i apply it separately here in power query sir? and i have a date problem too. some customers give the cheque number dated 31/04/2021. so it is a wrong date. but i have to enter it. can you help me for this problems sir?
Пікірлер: 136