Crystal Xcelsius For Dummies

From the Inside Flap
Build cool interactive dashboards to explain your data
Create charts, maps, and gauges, slice data into various views, and more — easily!

Crystal Xcelsius is like a rocket-booster that lets you turn your Excel spreadsheets into professional-looking dashboards, scorecards, what if visualizations, even highly polished PowerPoint presentations. And here’s the know-how you need to use it! Build simple to sophisticated dashboards, add buttons, refresh your data, create a visual model with style, and much more.

Discover how to

Create basic dashboards with gauges and sliders
Build in interactivity
Use color to explain data
Add menus and selectors
Work with dynamic visibility
Format and distribute your dashboards
From the Back Cover
Build cool interactive dashboards to explain your data
Create charts, maps, and gauges, slice data into various views, and more ― easily!

Crystal Xcelsius is like a rocket-booster that lets you turn your Excel spreadsheets into professional-looking dashboards, scorecards, “what if” visualizations, even highly polished PowerPoint presentations. And here’s the know-how you need to use it! Build simple to sophisticated dashboards, add buttons, refresh your data, create a visual model with style, and much more.

Discover how to

Create basic dashboards with gauges and sliders
Build in interactivity
Use color to explain data
Add menus and selectors
Work with dynamic visibility
Format and distribute your dashboards

About the Author
Michael Alexander is a Microsoft Certified Application Developer (MCAD)
with over 14 years experience consulting and developing office solutions. He
is the author of several books and the principle contributor at www.datapig
technologies.com, where he shares free Access and Excel tips to intermediate
users. He currently lives in Frisco, Texas where he works as a Senior
Program Manager for a top technology firm.

Related Articles

Excel Dashboards and Reports For Dummies 2nd Edition

Create dynamic dashboards and put your data on display with For Dummies

No matter what business you’re in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboards & Reports For Dummies is here to help you make meaning of all your data and turn it into clear and actionable visualizations. Fully updated for the latest business intelligence and spreadsheet tools in Excel 2013, this book shows you how to analyze large amounts of data, quickly slice data into various views on the fly, automate redundant reporting, create eye-catching visualizations, and more.

Helps you move beyond reporting data with simple tables, rows, and columns to designing high-impact reports, dashboards, and visuals
Walks you through a wide array of technical and analytical concepts to give you the background you need to select the right tool for interpreting and displaying data
Covers how to build a chart, work with pivot tables, group and bucket your data, represent trends, create What-If analyses, and increase the value of your reports

Excel Dashboards & Reports For Dummies, 2nd Edition is the business analysis tool you need to transform your raw data into a powerful and effective presentation that is accessible to everyone.

Excel 2007 Dashboards & Reports For Dummies

What’s the use of putting out reports that no one reads? Properly created dashboards are graphical representations that put data in a context for your audience, and they look really cool! How cool? You’ll find out when you see the dazzling examples in Excel 2007 Dashboards & Reports For Dummies. And, before long, everyone’s eyes will be riveted to your dashboards and reports too! This revolutionary guide shows you how to turn Excel into your own personal Business Intelligence tool. You’ll learn the fundamentals of using Excel 2007 to go beyond simple tables to creating dashboard-studded reports that wow management. Get ready to catch dashboard fever as you find out how to use basic analysis techniques, build advanced dashboard components, implement advanced reporting techniques, and import external date into your Excel reports. Discover how to:

Unleash the power of Excel as a business intelligence tool Create dashboards that communicate and get noticed Think about your data in a new way Present data more effectively and increase the value of your reports Create dynamic labels that support visualization Represent time and seasonal trending Group and bucket data Display and measure values versus goals Implement macro-charged reporting Using Excel 2007 as a BI tool is the most cost-efficient way for organizations of any size create powerful and insightful reports and distribute throughout the enterprise. And Excel 2007 Dashboards and Reports for Dummies is the fastest you for you to catch dashboard fever!

Tableau for Dummies

Make your data work for you! Tableau For Dummies brings order to the chaotic world of data. Understanding your data and organizing it into formats and visualizations that make sense to you are crucial to making a real impact on your business with the information that’s already at your fingertips.

This easy-to-use reference explores the user interface, and guides you through the process of connecting your data sources to the software. Additionally, this approachable, yet comprehensive text shows you how to use graphs, charts, and other images to bring visual interest to your data, how to create dashboards from multiple data sources, and how to export the visualizations that you have developed into multiple formats that translate into positive change for your business. The mission of Tableau Software is to grant you access to data that, when put into action, will help you build your company.

Learning to use the data available to you helps you make informed, grounded business decisions that can spell success for your company.

* Navigate the user interface to efficiently access the features you need
* Connect to various spreadsheets, databases, and other data sources to create a multi-dimensional snapshot of your business
* Develop visualizations with easy to use drag and drop features
* Start building your data with templates and sample workbooks to spark your creativity and help you organize your information

Tableau For Dummies is a step-by-step resource that helps you make sense of the data landscape and put your data to work in support of your business.

Microsoft Business Intelligence For Dummies

Learn to create an effective business strategy using Microsoft’s BI stack
Microsoft Business Intelligence tools are among the most widely used applications for gathering, providing access to, and analyzing data to enable the enterprise to make sound business decisions. The tools include SharePoint Server, the Office Suite, PerformancePoint Server, and SQL Server, among others.

With so much jargon and so many technologies involved, Microsoft Business Intelligence For Dummies provides a much-needed step-by-step explanation of what’s involved and how to use this powerful package to improve your business.

Microsoft Business Intelligence encompasses a broad collection of tools designed to help business owners and managers direct the enterprise effectively
This guide provides an overview of SharePoint, PerformancePoint, the SQL Server suite, Microsoft Office, and the BI development technologies
Explains how the various technologies work together to solve functional problems
Translates the buzzwords and shows you how to create your business strategy
Examines related technologies including data warehousing, data marts, Online Analytical Processing (OLAP), data mining, reporting, dashboards, and Key Performance Indicators (KPIs)
Simplifies this complex package to get you up and running quickly

Microsoft Business Intelligence For Dummies demystifies these essential tools for enterprise managers, business analysts, and others who need to get up to speed.

ACT! by Sage for Dummies 9th Edition

Are you ready to reap the benefits of the bestselling contact relationship manager (CRM) software on the market today? Well, then—get into the act with ACT! 2008 and find out how the latest version of this exciting software enables you to set up a database that’s right for you so that you can focus on your business and career growth while also saving time and money.
With this fun and friendly guide in hand, you’ll discover how ACT! organizes customer information in one place, safely shares customer info between workgroups, and provides you with forecast tools, reports, and a contact database. Whether you’re new to the features of ACT! or you are familiar with the basics but have not yet put to use ACT!’s more advanced abilities, this nuts-and-bolts reference has been updated and revised to make sure that you are up to speed on the most efficient way to organize your customer relationships and activities.

Author and full-time ACT! Certified Consultant and ACT! Premier Trainer Karen Fredricks walks you through tasks such as:

Setting up the contact database
Adding multiple contacts to a group and adding contacts to a company
Changing contact-level security access
Scheduling activities
Using the basic ACT! Reports
Designing new reports
Automating the backup process
Integrating with Outlook
Creating groups

ACT! by Sage For Dummies, 9th Edition also boasts a companion Web site that includes all the updates for the 2008 version of ACT! You’ll be amazed by just how quickly you’ll be able to set up a database and get it to act for you.