Where to learn how to replicate an Excel template?
- by Rosarch
This Excel template is really cool. There are a lot of things in it I don't know how to do, such as:
Having header rows that "stick" to the top even when you scroll down
Slider on the first page changes where the chart pulls its data from
Functions seem to be referring to named ranges in tables, like =SUM([nov]). Where do those names come from?
Clicking "back to overview" on the "Budget" page returns you to the "Dashboard" page
The number under "starting balance" of the top right corner of "Budget" changes when you change cell C5
On "Budget", each cell in the first column of each table has a drop-down menu for text, which seems to come from the "Setup" page
The background isn't just plain white, but when I try to format paint it onto a new sheet, nothing happens
If you know how any of these effects are achieved, I'm definitely curious. But I guess the main point of my question is where I can go to answer these questions for myself. Are templates explained anywhere?