I am about to run a course on debtors (accounts receivable) management and as part of that I have put together a debts’ ageing schedule Excel file. This file prepares ageing schedules using different techniques: functions and formulae, conditional formatting, pivot table, Excel table.
I have put together a video that walks you through the functions and formulae part of this work book … with previews of the rest.
You can watch the video from here BUT PLEASE NOTICE if your broadband speed is slow, you might have to download the file before watching it. Otherwise, it is excellent quality!
http://www.excelmaster.co.uk//support_files/video_files/debtor_age/debtors_ageing_schedule.mp4
If you want the excel file, download that from here: http://www.excelmaster.co.uk//support_files/video_files/debtor_age/ageing_sched.xlsx
Please note, I used Excel for the mac 2011 in this video … don’t worry as you can open it in Excel for Windows as normal.
Please let me have your feedback, to info@excelmaster.co.uk as mentioned at the end of the video.
Duncan Williamson
