Bank Reconciliation with IfNa and Match Excel functions.#bankreconciliation #matchfunctioninexcel

In this video, you will learn how to handle bank reconciliation from the beginning to end. Apart from this, you will learn another powerful Excel functions like If, Ifna, format painter and March.
Watch the video and subscribe to my YouTube channel for more videos.
In case, you have any question, do not hesitate to drop it in comment section.
Use Excel and be Excel.

You can download the workbook used in the video here:

[taiwobabatunde]

Hello sir. Thanks for your insightful teachings. The worksheet however is not available on one drive. Kindly assist with practice worksheet especially when bank statements references are not same as cash book. Thank you.

[MonsuruBakare]

Thanks for sharing this Sir. Kindly share the Excel file sir. Thank you!

[ahmedayinde]

Thanks so much for this.... Please can I have the data used so one can use to practice, also what do you mean by fix it .. I do not understand it even in the PAYE computation, what function key did you pressed ?

[justineasika]

Lovely session! Kindly share the Excel file sir. Thank you!

[moronkeowosho]

Thank you sir for the session... Very insightful.. Kindly share the excel file. Thank you

[ahsanshaikh]

wonderful sir great explanation.if there are no references either on bank statement or cash book then what should we do? can we start this scenario by doing debit and credit amounts match differently.?

[willm]

great vid can you please link the file so that I can follow along with you . kind regards

[bilkisraji]

Thank you for the session, kindly share the file

[rachaelbriggs]

Sir please can you share this file so I can also practise with it
Thank you so much

[Heartie_adiepena]

Thank you sir. Can you kindly share this excel? Please is it possible to make a reconciliation of intercompany account? Thanks

[abdulrazaqabdulsalam]

Kindly share the excel file for us to practice, thanks in advance

[isaackwegyir]

How do you do the reconciliation if there is no reference number?

[casaagyekum]

Please I don’t understand how you got the 1 when you started from the beginning