First Example done together: A budget, expenses sheet (part 2)
Here the next steps to our expense/budget sheet.
Go to the first page if you haven't read it.
We do not need to write the formula on every line.... great!!!
By double click on the corner, the formula will be copied automatically towards the bottom.
Now that we have entered the formulas, we can hide the unwanted columns, right click on the columns and press Hide.
We have also changed the color of the header for monthly and yearly. So that we can see them better.
An important point is that you want to see your header all the time. Also when you have entered many many many expenses.... so lets do this by freezing the rows (and columns if you want). By clicking on the A4 Cell and then on the freeze pane button, we define the corner of the frozen zone (brrrrrrr....)
Pivot Table and Charts