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

February 14, 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.

IBM Planning Analytics Tips & Tricks: Excel MAXIFS and MINIFS

Many of you know that Excel’s MAX function will define the largest value within a range. And many of you also know that Excel’s SUMIFS function will allow you to merge IF checks into your sum formulas. But did you know that Excel has a function called MAXIFS, which merges these two concepts together?

Read this blog post to learn more about MAXIFS.

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

Have you ever wanted to filter a list of data to look at a subset of the entire table? Many of you know that you can use the filter button within Excel’s data section to do this.

But what if you wanted to create a filter that users can change without having to navigate through ribbons? Did you know that you can do this using Excel’s FILTER function?

Take a look at this blog post to learn how to use Excel’s FILTER function to do this.

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

Have you ever wanted to search a list and define the position where it appears in the list? Maybe you want to know how many sales reps exceeded their quota or want to define how many products cost more than an approved purchase price. This information can be calculated using Excel’s XMATCH function.

Read this blog post to learn how to use Excel’s XMATCH function.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Author

Revelwood

View all posts