Download the following template to practice by yourself.
Debtors Ageing Report.xlsxAung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel. Read Full Bio
4 Comments adil ahmed Jul 11, 2023 at 2:36 PM very simple, goodReply
Shamima Sultana Jul 12, 2023 at 9:44 AM Dear Adil Ahmed, You are most welcome. RegardsReply
Sajid Ahmed Aug 28, 2023 at 12:52 PMHlw Jon S M, Thanks for your comment.
If a customer has more than one invoice with different dates, you have to include multiple rows for that customer in the dataset. Each row will represent a separate invoice entry.
The information related to that customer, such as their name, will be repeated in each row for their respective invoices. But the dates, invoice ids and invoice amounts will be different. The rest of the process is similar with this article. If you have other queries let me know in the comment.
Regards,
Sajid Ahmed
Exceldemy
