|
|
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.
| ISBN | 0470620129 | | Pages | 456 | | ISBN13 | 9780470620120
(What's this?) | | Weight (grammes) | 676 | | Publisher | John Wiley and Sons Ltd | | Published in | Chichester | | Imprint | John Wiley & Sons Ltd | | Series title | Mr. Spreadsheet's Bookshelf | | Format | Paperback | | Height (mm) | 232 | | Publication date | 03 Sep 2010 | | Width (mm) | 186 | | DEWEY | 658.40380285554 | | Spine width (mm) | 25 | | DEWEY edition | DC22 | | Academic level | General |
|
| |
| | | Introduction | | 1 | | | | What You Need to Know | | 2 | | | | What You Need to Have | | 3 | | | | Conventions in This Book | | 3 | | | | Keyboard conventions | | 3 | | | | Mouse conventions | | 4 | | | | What the icons mean | | 5 | | | | How This Book Is Organized | | 5 | | Part I | | Moving from Spreadsheets to Dashboards | | 5 | | Part II | | Excel Chart Basics | | 6 | | Part III | | Going Beyond Tables and Charts | | 6 | | Part IV | | Creating Advanced Dashboard Components | | 6 | | Part V | | Automating Your Dashboards and Reports | | 6 | | Part VI | | Working with the Outside World | | 6 | | | | About the Companion Web Site | | 7 | | | | About the Power Utility Pak Offer | | 7 | | | | Reach Out | | 7 | | Part I | | Moving from Spreadsheets to Dashboards | | | | Chapter 1 | | Introducing Dashboards | | 11 | | | | What are Dashboards and Reports? | | 11 | | | | Defining reports | | 12 | | | | Defining dashboards | | 12 | | | | Establish the User Requirements | | 13 | | | | Define the message(s) | | 14 | | | | Establish the audience | | 14 | | | | Define the performance measures | | 14 | | | | List the required data sources | | 15 | | | | Define the dimensions and filters | | 16 | | | | Determine the need for drill down details | | 17 | | | More... | | |
|
|
|
|
|
Enlarge
