IBM Planning Analytics Tips & Tricks: Excel Tips, Part 3

April 11, 2023

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.

IBM Planning Analytics Tips & Tricks: Map Charts

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.

Our blog post explains how you can use the Map Charts feature.

IBM Planning Analytics Tips & Tricks: Excel’s CONCAT and TEXTJOIN Functions

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.

Learn more about Excel’s CONCAT and TEXTJOIN functions.

IBM Planning Analytics Tips & Tricks: Excel’s IFS Function

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 info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Author

Revelwood

View all posts