Junior ledger job, how would one do reconciliations on Excel?

Hi,

I have anew junior ledger job and my daily tasks are:
Daily recon of bank statement &reports for the ledger
posting data to the mainframe system from the bank statement and reconciling on excel spreadsheet for the ledger
inputting data to the system for the ledger


So to prepare myself in advance, howwould one perform these reconcioliations?
I am told i will be using Excel Lookups, pivots and simple macros, but howcan i specifically practice these functions in the tasks above?

So how can i practice these functions for the above tasks?

Does anyone have sample excel workbooks i can practice these tasks/functions on?

thank you