#How to add data analysis tool in excel how to

So lets get started! Watch a walkthrough OR continue reading for something additional! compute the number of days since the invoice is outstanding.aging analysis using the slabs give above i.e.Its all part of today’s discussion.īut as I always like to raise the bar a little higher than requirement so I will going one step further and will do:

#How to add data analysis tool in excel how to

So it seems simple and it is simple if you know how to go about IF function and how to make multiple IF statements using AND function. Understanding the approach – Aging Analysis Reports in Excel >90 days: the invoices that are past due for more than 90 days.61-90 days: The invoices that are past due for days between 61 to 90 days.31-60 days: The invoices that are past due for days between 31 to 60 days.0-30 days: The invoices that are past due for days between 1 to 30 days.Not due: The invoices which that has not fallen due yet.Each has several invoices against its name with different due dates. Open up the workbook you downloaded and its a fairly simple data consisting of four very fragrant debtors. Next step – Aging analysis using Excel Pivot tables.Lucky me! Common sense knocked the door!.To read more about sparklines please check out this page for full listing of articles on sparklines and their use.Bonus Tip: Adding Spark to the data! – Sparklines!.Aging Analysis Report in Excel! – Finding the lazy ones!.

Giving Data Wings Meaning! – Number crunching Time!.

Watch a walkthrough OR continue reading for something additional!.

Understanding the approach – Aging Analysis Reports in Excel.