I would ask the instructor what he means by T-accounts. When I took
accounting (which I admit was many moons ago), the T-accounts that we were
taught would not easily be replicated in Excel.
My bet is the your prof just want debit, credit and balance columns.
Regards,
Fred.