by Kyle Goodfriend
If you have ever used custom functions in Excel, depending on the complexity of them, you have probably run into an issue where the accuracy of the results was sporadic. There is a quick solution.
Whether you play a technical role or are a financial analyst, Excel is likely a major asset in your toolbox. Whether it is the SUM function, the VLOOKUP function, or one of the many others, we have all used Excel functions for a plethora of reasons.
There is a lot of potential hidden in Excel that you may not be aware of. Excel offers the ability to create your own user defined functions, and it’s not hard to create them. With a little ingenuity and strategic thinking, custom Excel functions can be a huge asset.
Showing outlines to Essbase users can be challenging without the correct tools. Using outline levels in excel can provide a great way to display collapsable hierarchies.
For those of you who like to add groupings to your hierarchical data coming from Essbase, or manually created hierarchies with the Excel Indent function, check out this 1-click solution!
Looping through large ranges of data in excel can be time consuming. Use arrays to make significant performance improvements.
Looping through large ranges of data in excel can be time consuming. Here is a quicker approach.
Microsoft Excel does a great job of calculating only what is needed. If automatic calculation is turned on (and is by default), it only calculates formulas that have changed since the last calculations. If automatic calculation is turned off, F9 will accomplish the same thing. CTRL F9 goes one step further and calculates formulas that […]