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. If you’ve missed our earlier posts, read part 1 and part 2.
Map charts is a nifty feature in Excel that will help visualize your data. It enables you to compare values and show categories across geographical regions.
In recent years Microsoft introduced a new version of the CONCATENATE functional called CONCAT. Their purpose is similar in that the new function still combines text from multiple ranges and/or strings. CONCAT will eventually replace CONCATENATE.
The TEXTJOIN function joins text from multiple ranges and/or strings but includes two additional parameters. These parameters allow you to specific the delimiter and determine if empty cells are ignored.
Excel’s IF function has been around for quite a while. Back in 2020, Excel introduced the IFS function. This function checks whether one or more conditions are met and then returns the value associated with the first TRUE condition. The main objective of IFS is to simplify an expression that would have previously required multiple nested IF functions.Read our blog post to learn the format of the IFS function.
IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at email@example.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!