Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. For the past few weeks, we’ve been highlighting some of the most popular and interesting posts on Excel. If you’ve missed our earlier posts, read part 1, part 2 and part 3.
Here are some other Excel tips and tricks from our team of experts.
Some Revelwood clients often build models that define the fraction of a year for a given month. For example, January is approximately 8.5% of a calendar year (31/365) and September is approximately 11.5% of a working day’s calendar (30/260). What happens in situations where you want to calculate the percentage of a year where the days are not the first or last day of the month? This is where Excel’s YEARFRAC formula can help.
IBM Planning Analytics Tips & Tricks: Unhide Multiple Excel Sheets
As you know, an Excel workbook can consist of multiple sheets. There are many instances where you may want to hide some of the sheets. It’s very fast and easy to hide sheets, but Excel historically allowed you to unhide only one sheet at a time. Microsoft changed that approach and now allows you to unhide multiple sheets at once.
IBM Planning Analytics Tips & Tricks: Learn the Excel CELL Formula
Excel is, and always will be, a powerful tool for the finance team. With so much power, there are many great Excel formulas that are rarely used. Here’s a situation – imagine you wanted to easily replicate a sheet and have each sheet use an MDX expression that referenced a different dimension name. You want to use a formula to determine the sheet name.Excel’s CELL function returns information about a specific cell within an Excel file. Read more to learn the syntax of that 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!