Note: Not guaranteed to come with supplemental materials (access cards, study guides, lab manuals, CDs, etc.)
Extend Your Rental at Any Time
Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.
Sorry, this item is currently unavailable.
The go to resource for how to use Excel dashboards and reports to better conceptualize dataMany 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 analysesPart 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.
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.
Table of Contents
Moving from Spreadsheets to Dashboards
Developing Your Data Model
Excel Chart Basics
Introducing Excel Charts
Understanding Chart Types
Working with Chart Series
Formatting and Customizing Charts
Going Beyond Tables and Charts
Using Pivot Tables
Using Pivot Charts
Using Excel Sparklines
Chartless Visualization Techniques
Creating Advanced Dashboard Components
Components that Show Trending
Components that Group Data
Components that Show Performance against a Target
Automating Your Dashboards and Reports
Adding Interactive Controls to Your Dashboard
Working with the Outside World
Importing Microsoft Access Data into Excel
Sharing Your Work with the Outside World
Table of Contents provided by Publisher. All Rights Reserved.