ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
Search

Excel:  Better Dashboarding with Cube Functions

1/12/2016

0 Comments

 
Picture
​CubeValue functions enable Excel wizards to create powerful dashboards OUTSIDE of Pivot Tables.


Advantages
  • Easier to maintain and apply filters across multiple pages or reporting areas
  • Easier to change one report without it affecting the layout of the rest of the spreadsheet.
  • Does not require the use of proprietary software (and by extension skills transfer to other projects)
  • Can build calculations outside of pivot tables (no more =GETPIVOTDATA() )
Learn something new?  Sign up for our newsletter. 

If you're interested in working with our trainers or consultants, check out our services page.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Data Science
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Python
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters