Need Help In Preparing MIS For Accts Receivable

Hello Friends...I've joined in a new organization in the accounts Receivable dept.
I have been given a task to prepare a report on the current outstanding status of Debtors and their trends of pmt.
I am a basic excel user..and do not know the advance features to prepare such reports.
I have got the reqd data but do not know how to present it in the form of report.
I'll appreciate if anyone of u could help me with it

Hi.....
My Self Yashvant Patel
i have working Exp. in Const. Industries for more than 4 years.
but recently i have joined Tranding company in UAE. so all my exp. and developed mis formats are not uselful for me.
i request you all to please provide me MIS reports for Asset Management, Management of Payable and receivebles, Management of PDCs
Thanking you