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?