reconciliation assessment

Hi all!

I have interview today evening, they asked me to prepare how to create daily, monthly, yearly reports in excel and reconciliation process. can anyone help me learn more about this. I'm not that good in excel.