Skip to content

Crystal Xcelsius for Dummies

Spend $50 to get a free DVD!

ISBN-10: 0471779105

ISBN-13: 9780471779100

Edition: 2006

Authors: Michael Alexander

List price: $34.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


As the fastest growing dashboarding solution on the market, Xcelsius is an intuitive stand-alone Windows application that enables Excel users to transform the contents of an ordinary Excel spreadsheet into an engaging, interactive Flash-based dashboard Offers step-by-step instruction on the wide array of functionality that Xcelsius has to offer so that readers can complete mini-dashboards of increasing complexity with each chapter Addresses how to prepare Excel spreadsheets for use with Xcelsius dashboards and then use basic components of Xcelsius (charts, buttons, labels) Shows ways to add advanced functionality to dashboards (gauges, sliders, maps) and create interactive business…    
Customers also bought

Book details

List price: $34.99
Copyright year: 2006
Publisher: John Wiley & Sons, Incorporated
Publication date: 4/24/2006
Binding: Paperback
Pages: 294
Size: 7.25" wide x 9.25" long x 0.50" tall
Weight: 1.034
Language: English

MICHAEL ALEXANDER is the pseudonym of a nurse who has previously worked in the UK and New Zealand.

About This Book
Foolish Assumptions
How This Book Is Organized
Icons Used In This Book
Say Hello to Crystal Xcelsius
Introducing Crystal Xcelsius
Overcoming Static Cling
More Than Just Fancy Graphics: The Benefits of Using Crystal Xcelsius
Creating more robust presentations with interactive summary and detail layers
Building what-if analyses into your presentations
Building tools that help make decisions
Crystal Xcelsius under the Hood
Importing data
Building the visual model
Compiling and publishing the dashboard
Taking Crystal Xcelsius for a Spin
Creating Your First Dashboard
Importing the Excel model
Building your visual model
Testing and publishing your visual model
Getting Fresh with your Dashboard
Getting Started with the Basics
Interacting with Single Value Components
Managing Interactivity: Input vs. Output
Understanding Scale Behavior
Building a Loan Payment Calculator
Calling Attention to Alerts
The Anatomy of the Alert Tab
Alert Method
Alert Definition
Alert Levels
Alert Level Display
Applying Your First Percent Alert
Applying Your First Value Alert
Getting Graphic with Charts
The Basics of Crystal Xcelsius Charts
Understanding the chart types
Creating Your First Chart
Understanding scale behavior
Leveraging the run-time scaling options
Changing Chart Appearance
Appearance tab options
Sub-tab sections by chart type
Understanding Combination Charts
Combination chart ground rules
Creating a combination chart with three data series
Adding a series to a combination chart
May I Please See the Menu?
Delivering Choices with a Selector Component
Understanding the Insert Option Property
Status List
Working with the Filter Component
Creating Your First Filtered Dashboard
Get Fancy with Advanced Components
Getting Geo-Graphic with Maps
Understanding the Concept of Regions
Creating a Basic Map-Based Dashboard
Applying Alerts to Map Components
Assigning a value to each Region
Assign a target to each Region
Dynamically Feeding Data to Map Components
Focusing in on Dynamic Visibility
Seeing the Basics of Dynamic Visibility
Dynamic visibility in a nutshell
Applying basic dynamic visibility
Implementing Menu-Based Visibility
Working with Crystal Xcelsius Professional
Creating Drill-Down Charts
Using Accordion Menu Components
Working with Picture Menus
Using Interactive Calendar Components
Wrapping Things Up
Adding Style and Personality to Your Dashboards
Employing the Five Formatting Must-Haves
Using Copy and Paste
Using the Properties window
Using the alignment and position functions
Using the Grouping function
Using the Object Browser
Adding Style and Personality
Using Art & Backgrounds components
Applying color schemes with global style
Discovering Skins and Templates
Changing skins
Using templates to save time
Taking Your Dashboards to Market
Exporting a Visual Model
Paying Attention to Distribution Matters
Macromedia Flash considerations
Naming considerations
Directory considerations
Canvas size considerations
Sending Data Back to Excel
Incorporating Input from Others
The Part of Tens
Designing Effective Excel Models: Ten Best Practices
Ten Cool Crystal Xcelsius Tricks
Creating a Waterfall Chart
Password-Protecting Your Dashboard with Dynamic Visibility
Highlighting the Below-Average Data Points in a Chart
Making a Data Series Disappear and Reappear
Creating a Scrolling Chart
Using Conditional Formatting to Create Regions on a Map
Making Your Own Map Component
Adding an Export to PowerPoint Button
Nesting a Dashboard within Another Dashboard
Using Crystal Xcelsius to Build Your Web Site
Frequently Asked Questions: Two Sets of Ten
Basic Questions about Crystal Xcelsius and Excel
Common Error Messages and What They Mean
Commonly Asked Component Questions
Ten (or So) Real World Examples
Load Optimization (Logistics)
Instructor Staffing (Education)
Basic ROI Calculator (Finance)
Service Outage Analyzer (IT)
Fuel Cost Analysis (Transportation)
Software Development
Site Statistics (Web Site Management)
Google AdWords Tracker (Marketing)
Headcount Visibility Reporting (HR)
Going Beyond Spreadsheets