IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Substitute Function
Are you familiar with the SUBSTITUTE function in Excel? The SUBSTITUTE function in Excel replaces one value with another. This is similar to the REPLACE function, but SUBSTITUTE provides more flexibility. The syntax of the SUBSTITUTE function is: =SUBSTITUTE(text,old_text,new_text,instance_num) Text: This is…
October 31, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Adding Images to Charts
Charts are an excellent way to use visuals to convey information. Did you know that you can increase the effect of charts in Excel by adding custom images? Consider this plain pie chart. We can insert a corporate logo to give the…
September 12, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Popular Video Tips, Part 3
Here are two more popular IBM Planning Analytics Tips & Tricks videos. Did you know we have an entire library of video tips & tricks for IBM Planning Analytics? The Aggregate Function In this video, Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates…
August 29, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Counting Hidden Rows in Excel
With a clever combination of formulas, you can have Excel calculate the number of hidden rows in a data set. This trick will work on both manually hidden rows and autotfilter hidden rows. There are two ways to count hidden rows, depending…
August 22, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s Camera Tool
The Linked Picture tool (aka Camera tool) is a little-known feature in Excel that you can use to give your dashboards and reports greater flexibility. In summary, the linked image is an image that is connected to the source data and updates…