Excel Dashboards & Reports - Softcover

Alexander, Michael; Walkenbach, John

Softcover

ISBN 10: 0470620129 ISBN 13: 9780470620120

Publisher: John Wiley & Sons Inc, 2010

Synopsis

The go to resource for how to use Excel dashboards and reports to better conceptualize data

Many Excel books do an adequate job of discussing the individual functions and tools that can be used to create an “Excel Report.” What they don’t offer is the most effective ways to present and report data. Offering a comprehensive review of a wide array of technical and analytical concepts, Excel Reports and Dashboards helps Excel users go from reporting data with simple tables full of dull numbers, to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.

• Details how to analyze large amounts of data and report the results in a meaningful, eye-catching visualization
• Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly
• Shows how to automate redundant reporting and analyses

Part technical manual, part analytical guidebook, Excel Dashboards and Reports is the latest addition to the Mr. Spreadsheet’s Bookshelf series and is the leading resource for learning to create dashboard reports in an easy-to-use format that’s both visually attractive and effective.

About this title

From the Back Cover

Become your company's dashboarding expert

The need to turn impossible amounts of data into meaningful information has made dashboards a hot topic. Dashboards provide at-a-glance views into key measures relevant to a particular objective or business process. The power and flexibility of Microsoft Excel makes it an ideal platform for creating dashboards.

This guide gives you the technical know-how to go from reporting data with simple tables full of dull numbers to creating high-impact reports and dashboards that will wow management both visually and substantively. If you are familiar with data analysis concepts and experienced in using Excel's table structures, filters, and formulas, you can quickly become your organization's dashboard guru.

Let Mr. Spreadsheet show you how to:

• Analyze extensive data and report it in a useful way

• Quickly slice data into various views on the fly

• Automate redundant reporting and analysis processes

• Create eye-catching visualizations

• Create impressive dashboards and What-If analyses

COMPANION WEB SITE

Visit www.wiley.com/go/exceldr to download workbook files for all examples used in the book

About the Author

Michael Alexander is a Microsoft Excel MVP who has written several books on advanced business analysis with Microsoft Access and Excel. Visit Michael at DataPigTechnologies.com for free Excel and Access training.

John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 50-plus books include Excel 2010 Formulas, Excel 2010 Power Programming with VBA, and the bestselling Excel Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.

Edition details

• Publisher: John Wiley & Sons Inc
• Publication date: 2010
• ISBN 10: 0470620129
• ISBN 13: 9780470620120
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 434