• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Revelwood

Revelwood

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • SOLUTIONS
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • SERVICES
      • Implementation Services
      • Advisory Services
      • Customer Care
        • Help Desk
        • System Admin
        • Performance Tune-Up
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • PRODUCTS
      • DataMaestro
      • Lightspeed Planning & Reporting
      • IBM Planning Analytics Utilities
  • How We Help
    • Workday Adaptive Planning Use Cases
    • IBM Planning Analytics Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
    • User Groups
  • Contact Us

Lee Lazarow

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel CubeDimensionCountGet Function

 

Have you ever written a TurboIntegrator process and needed to know how many dimensions are in a specific cube? Maybe you want to loop through each dimension to create a zero out view. You can do this by using the TABDIM function…

Read More

June 21, 2022

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…

Read More

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…

Read More

May 3, 2022

IBM Planning Analytics Tips & Tricks

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…

Read More

April 5, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Stacked Rows in PAx

 

Have you ever converted a stacked Perspectives view into a Dynamic report? If so, you may have noticed the way Excel formats the outside of your stack. For example, if I use the Active Form button to send the following view to…

Read More

March 8, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PASS Version Numbering

 

IBM released version 73 of IBM Planning Analytics Spreadsheet Services (PASS), formerly known as TM1 Web, on February 10, 2022. This version includes a few design improvements associated with stylesheets and sorting. The main change, however, is associated with the version number. The February…

Read More

March 1, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel OFFSET Function

 

Have you ever wanted to reference a cell based on its placement compared to another cell? Maybe you want to create a formula where each cell looks at the value 2 columns to the right or maybe you want to compare a…

Read More

February 22, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PAx – Rebuild Book vs Recreate Book

 

Are you familiar with the difference between the “Rebuild Book” button and the “Recreate Book” button in IBM Planning Analytics for Excel (PAx)? Both buttons are used to update the rows which appear on your Dynamic Reports and both buttons refresh the…

Read More

February 15, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: The SCAN Function

 

Have you ever needed to parse data by looking for a specific character within your source records? Maybe you want to filter an employee’s last name from a “Lazarow, Lee” or maybe you want to define the year from “12/25/2021”. All of…

Read More

January 25, 2022


VIEW MORE ARTICLES >

1 2Next Page » 14

Primary Sidebar

  • Categories

    • Awards & Recognition
    • FP&A Done Right
    • IBM Planning Analytics Tips & Tricks
    • Modern Accounting
    • News & Events
    • Success Stories
    • Tech Bulletins
    • Workday Adaptive Planning Insights
    • Workday Adaptive Planning Tips & Tricks

Popular Posts

  • Workday Adaptive Planning Tips & Tricks: The Formula Assistant – How To, Where & Why
  • Workday Adaptive Planning Tips & Tricks: Templates
  • IBM Planning Analytics Tips & Tricks: Troubleshooting Planning Analytics for Excel
  • Workday Adaptive Planning Named a Leader in Gartner Magic Quadrant for Cloud Financial Planning and Analysis Solutions 2020
  • Workday Adaptive Planning Tips & Tricks: Excel Reporting Using a Report Template

Sign up for our newsletter

Connect

Authors

  • John Pra Sisto
  • Revelwood
  • Adam Riskin
  • Ailenette Cruz
  • Brian Combs
  • Dave Miersch
  • Dillon Rossman
  • Gary Leiffer
  • Ken Wolf
  • Koury Reid
  • Lee Lazarow
  • Lisa Minneci
  • Marc Assenza
  • Mary Luchs
  • Michelle Song
  • Nina Inverso
  • Summer Jeter
  • Tara Byrnes
  • Thanh Chau
  • Wesley DeMarco

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

Contact:
25B Vreeland Road, Suite 111
Florham Park, NJ 07932

201.984.3030
info@revelwood.com

© Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.