Where to learn how to replicate an Excel template?

Posted by Rosarch on Super User See other posts from Super User or by Rosarch
Published on 2012-09-02T00:42:45Z Indexed on 2012/09/02 3:40 UTC
Read the original article Hit count: 465

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?

© Super User or respective owner

Related posts about microsoft-excel

Related posts about templates