https://theexcelclub.com/howtorecon...
To download the learn and earn activity visit the post.
Reconciling accounts is a common task carried out by accountants on a regular and reoccurring basis. Creditor statements and bank accounts are examples of accounts that need regular reconciliation.
But what if you could create a model, within minutes, that you could use over and over for these reconciliations? Imagine the time it would save.
With Power Query you can and in this article, you will learn how to reconcile accounts using Power Query and then how you can use that query repeatedly saving you hours and hours.
Find out more about our Learn and Earn Activities
https://theexcelclub.com/learnandea...
Watch more Power BI videos
• Power BI
Watch more Excel Videos
• Learn Excel Playlist
#excel #powerquery #exceltips #tutorial #reconcileaccounts #excelforaccountants