| Home > Forum Home > Presenting and Reporting Data > Dynamic financial reports > Use more complex formulas? Pivot tables? | Share |
Use more complex formulas? Pivot tables?
Excel Help for Use More Complex Formulas? Pivot Tables? in Presenting and Reporting Data
| Forum Topic | Login |
Use More Complex Formulas? Pivot Tables? | Rate this: (3/5 from 1 vote) |
 | I usually do this with formulas in Excel itself. pivot tables are a *very* good option for creating an expanding data set. Another good option is to name your data groups and build charts/tables off of the names instead of cell ranges. For example, label range a1:a100 "Cost". The next time the report is run, you can redefine "Cost" as a1:A110. It should reduce the amount of broken links. (name cell ranges by Insert -> Name -> Define | |
| Posted by minchazo on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Use more complex formulas? Pivot tables? in the Excel Business Solutions Directory |