Ultimate Automation using Power Query - Reconciliation of 2 Datasets in Ms-Excel
Вставка
- Опубліковано 3 сер 2024
- Join into "The Excelism" Telegram Public Group for Learning FREE Excel:
t.me/TheExcelism
Visit our website www.excelism.in
View All #1MinuteSnippets here:
• 1 Minute Snippets - Le...
Reconciliation of 2 Datasets in Ms-Excel using Consolidate Feature, Filters and SUMIF() watch here: • How to Reconcile 2 Dat...
In this video, you will be learning the following:
1. Using Power Query
2. Using Reference Queries
3. Importing Data from Table to the Queries
4. Using Group by in Power Query
5. Using Sort in Power Query
6. Using Add Conditional Column in Power Query
7. Using Add Custom Column in Power Query
8. Using Merge Feature in Power Query
9. Using Append Feature in Power Query
10. Using Load to Table into Excel from Power Query
11. Using Remove Duplicates in Power Query
12. Using Filters in Power Query
13. Changing the Table format in Excel
14. Changing the Properties of the Table in Ms-Excel
and many more..
Excellent Video explaining in a very simple yet effective way. Easy to follow and learn. This can be implemented for all repetitive reconciliations and save lot of time.
Eye-opener!
Thank you @Excelism CA Saran sir for this wonderful and practical insight.
You are a genious hahah. Never thougth to do that way!
Thank you. Consider Subscribing.
Excellent Work Sir. Thank You.
Beautifully explained 👌 - thanks very much
Wonderful Concept. Ur awesome videos sir.
very useful tips
Highly appreciate you explaination there is a dout if the ERP balance is of previous month and cerdited in the bank in current month how to reconcile the statement
Excellent brother
Very useful! Thanks :-)
please try to provide excel file if possible , great video btw :)
Best Video
Mind blowing
Great sir
Nice one sir how we have to do for reconciliation of date reference no and amount total 3 columns
Thank you 🌹
Worderful ❤️
Fantastic
Thankss
Nice Sir
we appreciate your efforts. Sir, requesting you to make a video on reconciling books of accounts with GSTR2A/2B. There are multiple elements and many possibilities so reconciling is bit difficult. It would be of great help to professionals. Hint is to export from tally > apply power query > then > export from gst portal > apply power query > and without much change in format of the data > reco is done.
Thanks in advance.
I am going to make it on my channel
One more Qu? please If the Bank or Creditor sent me his Statement and I have My Own PQ sheet how to manage the reconciliation process please ? Shall I put it in the same fail PQ in work sheet then import data or what ?Please advice ?
good work , I want to understand why is bank and ERP data have no negative values?
How to reconcile with multiple columns?
awesome video
How to setup bank reconciliation with powerquery if the reference isn't approximatively the same, please?
e.g: reference of the firm W is F.004 yet the reference of bank is F//004, so what to reconcile in this case, please?
Is this example file available for download? Thanks.
Sir the above video is about BRS.this can be done easily LeftANti and Rightanti Not only BRS ,any Reconciliatio can be done easily by LEFTANTI and RightANtii..yu pl try and upload a new video since the above seems difficult..Sir where will i find Projects
realting to MSexcel.pl guide me.thank yu
Can u please share this excel file for practice ?
Nice concept but very complex, it has many process. Can u give us an simpler alternative pls?.
This is a complete automation.
I have already uploaded a video on the same using Consolidate Feature and Filter.. pls watch the same.
@@TheExcelism sure thank you for prompt response. And also thank you for educating us.
Most welcome Mr.Rohan
How to check decimal value.? I try to run the query but decimal value not showing why?
After merge new option ok button is disabled , is there any problem is there
But if there is reconciliation between our books and let say Creditor boos we have to fill all of his information from creditor book in excel sheet or its possible to import it as excel to power query to reconcile am i right ? Correct me if I'm wrong
You are correct
Greetings from Yemen
How many rows data it was allowed
Unlimited
if i am taking 60000 records merge new option is not working ,there is any limit in power query
No limit. It should work.