This article is related to previous article money management for kids where one part of the article mention a description of recording cash flow especially daily expenses. One of the purpose to make this record is to know the trends and in order to analyze whether we are wasteful or not.
As I mentioned in the former article, there are many applications whether paid or free for this purpose. You can also use the Microsoft Excel Pivot and Chart facilities.
Steps to create pivot table in Microsoft Excel
1.Start to make notes of expenses. Below is the simplest example.
As I mentioned in the former article, there are many applications whether paid or free for this purpose. You can also use the Microsoft Excel Pivot and Chart facilities.
Steps to create pivot table in Microsoft Excel
1.Start to make notes of expenses. Below is the simplest example.
2.Block the data like picture below.
3.Click insert tab then pivot table afterwards one window namely create pivot Table is coming. Finally click OK.
4.Now, the pivot Table is done.
5.This is the final pivot table after little modification.
You can see the data easily with pivot table through drag and drop. If you want to find out the trend you can use one facility namely pivot chart.
Steps to create pivot chart in Microsoft excel
1.Select pivot table, see the picture below.
2.Click insert, select the chart type, because you want see the trend, choose line.
3.Chart is done, but in order to see comfortably you have to move chart to other sheet.
4.The final chart is coming.
After you finish the chart creation, you should see the report. If you want to see per month, you have to add one field namely month. I will show you how to add this.
First, you should insert one column. Name it month. And with text function namely left you can automatically fill the content. See the picture below.
Afterward, you copy the cell to all below that cell.
Subsequently, you just recreate new pivot and new chart with the same way.
Finally, you can see sample of the report below.
1.Total Expenses per month report
Subsequently, you just recreate new pivot and new chart with the same way.
Finally, you can see sample of the report below.
1.Total Expenses per month report
2.Trend of expenses per month
3.Trend of expenses daily per month
Above are the simplest way to record the kids expenses. You can encourage them to make like this, so you and your kids can analyze and manage the money easier. This is only simple example of create and see expenses report in Microsoft Excel.
