OEG Best Practice: Best practices about Microsoft Office for the add-Ins
- We have listed below some of the best practices we recommend for the Anaplan product. These are based on our experience and are subject to change as we deliver new functionalities and learn more about how our customers use the product.
- If you would like to contribute or comment, please contribute to this forum post.
- You do not have to apply these best practices; we will still support you if you don’t follow them. These are recommendations and there are times when it may make sense to do things in a different way.
- We have highlighted in red the most important best practices.
About this Article
We focus on best practices for using the Excel and PowerPoint applications.
Our add-in has been optimiZed for the use of Excel with the “colorful” theme of Office.
It is best to use name ranges in your formulae, rather than relying on formula references (having A1 referenced in a formula for instance).
Avoid using the name ranges created automatically by the Anaplan add-in, instead, create your own name ranges and make those formula-driven with an offset function so they automatically adjust when rows/columns are added to your data.
|3||General best practices||
Build your report in a flexible way following the Excel and PowerPoint best practices (lots of them are available online through a regular search, for example the FAST Standard Organisation). For example:
Author Magali Pelissier.