IBM Planning Analytics Tips & Tricks
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…
May 17, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Workbook Stats
Have you ever wanted to know details about your existing worksheet or workbook such as the number of cells that contain data or the number of total sheets? In 2021, Microsoft Excel introduced a feature called Workbook Statistics that will provide details about…
May 3, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel DATE Function Updated
Some of you may remember an Excel feature that I posted about last year which explained how the DATE function will convert invalid dates into real ones. For example, DATE(2020,7,35) will be converted to August 4, 2020 since there are not 35 days…
August 17, 2021
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Excel Substitute
We have something different for today's Workday Adaptive Planning Tips & Tricks post - an Excel tip! Our Adaptive Planning users also use Excel, so we thought they'd find this helpful. Have you ever wanted to get rid of spaces in some…
March 3, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Manipulating Text in Excel
Have you ever wanted to manipulate text within Excel? Excel has a series of functions that allow you to parse text strings based on whether you want to reference the left, the right, or the middle of the cell contents. For example,…
February 2, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s NETWORKDAYS Function
Have you ever wanted to define the number of working days between two calendar dates? Do you define “working days” simply as non-weekend days or do you also include holidays? Did you know that you can calculate this information using Excel’s NETWORKDAYS…
January 26, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TYPE Function
Have you ever referenced a list in Excel and needed to know whether each value was a number or a string? This may be required when another function depends on the type of value in each cell. Excel has a function called…
January 12, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Keyboard Navigation
Have you ever wanted to quickly go to the last used cell within a spreadsheet but did not know how? Have you ever wanted to determine where the next available row or column resides? Have you ever wondered why a spreadsheet with…
January 5, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel LET Function
Have you ever created a formula that repeats another formula within a cell? Did you know that this repetition may be slowing down your reports? For example, you may have a report where you want to pull IBM Planning Analytics data and…