Webinar Archives: Xcelsius Gurus – Top 10 Excel Tips for Success

Mico Yuk and Ryan Goodman are probably two of the leading Xcelsius Developers in the industry right now. Most of us know Ryan from his blog, company, books and earlier webinars. This is Mico’s first webinar and you will be surprised to know that she is the owner of the famous Xcelsius blog, www.everythingxcelsius.com. Ryan starts off the webinar with 5 essential Excel Tips that an Xcelsius developer should always keep in mind while designing dashboards and Mico takes it over from Tip # 6 and focuses on Component organization and other best practices within the design mode of Xcelsius. Its a must watch for all Xcelsius Developers out there.

Note: This is a direct Excerpt from the Business Objects Website.

Join two Xcelsius Gurus as they share their best practices and techniques for the proper use of Excel with Xcelsius and methods of how to successfully manage your Xcelsius components.  Adopting their top ten list of do’s and don’ts will ensure you can implement standards within your organization for efficient dashboard development, leading to a more scalable, manageable Xcelsius dashboard project.

In this session you will learn how to:

  • Optimize your Xcelsius Excel Sheet for Success
  • Manage your Xcelsius Component List
  • Streamline your Xcelsius projects, making them easy to manage and share


  • Sowrabha

    I am very much interested in learning how exactly from an HTML page we can pass values to Xcelsius…Can you just let me know if you can conduct any session through live meeting so that it will be very helpful…
    Thanks in advance

  • Ahmed,The most iamtropnt element of the design is of course the spreadsheet model. The look and feel / the eye candy / the funk comes later so time spent on the spreadsheet is critical. However there is nothing special about the data movement etc. I use a lot of Vlookups() (shouldn’t really as they are fat functions) and I use a lot of hidden combo boxes – you can use those to move data around a model. It’s a clever trick because the ‘default’ selection of a combo can be a cell. So if you use some control to set a cell, a hidden combo can pick that value up, set itself to that value and it’s FILTERED ROW capability can then move data without the user touching the combo box.Actually just look at this example:You do not need to use the combo box, just the number wheel and you’ll that you can move data round a model using any control you want / need. You can get the source here:The XLF is included and shows how this works.RegardsDaniel