I downloaded this personal budget template and there are three things I would like to know how to do.
https://templates.office.com/en-us/P...get-TM10000134
1. On the Summary tab, they have these formulas: =SUM(MonthlyIncome[[#All],[AMOUNT]]). Are these known as DAX formulas? I know you can name individual cells in the box in the top left but how do you apply it to the entire column?
2. Again on the Summary tab, if you click on the cells with the $ amounts in them, they have what looks to be a comment box but it is not actually a comment. How is this done?
3. In the monthly income / expenses / savings tabs, I can click and drag the number of required rows just like I do when I click and drag formulas. But that little bottom left corner is visible. How is that done? Also, is this linked to the chart on the Summary tab so when this populates, the chart automatically updates?
Basically, I want to create my own budget spreadsheet where I have my inputs on one worksheet and have chart(s) on another tab showing monthly, yearly, YTD. And I want to do it in a fancy way just to learn new excel tricks.
Bookmarks