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 tothis forum post.
You do not have to apply these best practices and we will still support you if you don’t follow them, these are recommendations and there are times when it makes sense to do things in a different way.
We have highlighted inredthe very important best practices.
About This Article
We focus on best practices for using Excel and PowerPoint themselves.
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.
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:
Use VLOOKUP formula or INDEX(MATCH()) when possible
Avoid hard-coded formulae
Create some data validation checks (with the data validation functionality, conditional formatting, IFERROR…)
In PowerPoint, do not try and fit as much as you can in a slide so it remains readable when you present it
The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.