Cart
Free US shipping over $10
Proud to be B-Corp

Excel Dashboards and Reports Michael Alexander

Excel Dashboards and Reports By Michael Alexander

Excel Dashboards and Reports by Michael Alexander


$10.00
Condition - Very Good
Only 3 left

Summary

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.

Excel Dashboards and Reports Summary

Excel Dashboards and Reports by Michael Alexander

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 Michael Alexander

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

Introduction. Part I: Moving from Spreadsheets to Dashboards. Chapter 1: Introducing Dashboards. Chapter 2: Developing Your Data Model. Part II: Excel Chart Basics. Chapter 3: Introducing Excel Charts. Chapter 4: Understanding Chart Types. Chapter 5: Working with Chart Series. Chapter 6: Formatting and Customizing Charts. Part III: Going Beyond Tables and Charts. Chapter 7: Using Pivot Tables. Chapter 8: Using Pivot Charts. Chapter 9: Using Excel Sparklines. Chapter 10: Chartless Visualization Techniques. Part IV: Creating Advanced Dashboard Components. Chapter 11: Components that Show Trending. Chapter 12: Components that Group Data. Chapter 13: Components that Show Performance against a Target. Part V: Automating Your Dashboards and Reports. Chapter 14: Macro-Charged Reporting. Chapter 15: Adding Interactive Controls to Your Dashboard. Part VI: Working with the Outside World. Chapter 16: Importing Microsoft Access Data into Excel. Chapter 17: Sharing Your Work with the Outside World. Index.

Additional information

GOR003022366
9780470620120
0470620129
Excel Dashboards and Reports by Michael Alexander
Used - Very Good
Paperback
John Wiley and Sons Ltd
20100903
456
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Excel Dashboards and Reports