IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: UNIQUE Function in Excel
Have you ever needed to produce a list of unique values within a cell range in Excel? If so, the UNIQUE function can do this. The example below shows a simple list of countries that includes some duplicates: To produce a unique…
April 4, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: On-Demand Webinars, Part 2
Did you know we have a wide variety of IBM Planning Analytics webinars on-demand? We showcased two of our most popular webinars – Best Practices when Using Planning Analytics Workspace Charts and Creating PAW Charts Using the New Experience – in a…
March 28, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips and Tricks: Upgrading to Planning Analytics for Excel 2.0.65 or later
As of version IBM Planning Analytics version 2.0.65, you can choose to either launch IBM Planning Analytics for Excel (PAx) as a single session (by double-clicking the .XLL file) or load it as an add-in (and have it available for all Excel…
March 21, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel YEARFRAC
I often build models that define the fraction of a year for a given month. For example, January is approx. 8.5% of a calendar year (31/365) and September is approx. 11.5% of a working day’s calendar (30/260). But what happens in situations…
March 14, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: On-Demand Webinars, Part 1
So many webinars, so little time! If you are like me, you probably receive invitations to webinars on a regular basis. Some of them even make it onto my calendar. Unfortunately, more often than not, I have the best intentions of attending…
March 7, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Tips, Part 2
Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks we’ll be highlighting some of the most popular and interesting posts on Excel. You can read part 1 here. IBM…
February 28, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel EOMONTH
Thirty days has September … Do you sing that out loud every time you want to determine the number of days in a month? If so, do you have to pause and think about the end when defining the last day of…
February 21, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Tips, Part 1
Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks we’ll be highlighting some of the most popular and interesting posts on Excel. IBM Planning Analytics Tips & Tricks: Excel…
February 14, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TEXTSPLIT
Have you ever needed to parse a text string into different columns in Excel? This is easy to do via the text-to-columns wizard, but what if you wanted to do this via a formula? The TEXTSPLIT function allows you to split a…