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 re
內容簡介：
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.
關於作者：
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.
目錄：
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.
購物車/收銀台(0) | 在線留言板
| 付款方式
| 聯絡我們
| 運費計算
| 幫助中心 |
加入書簽
HOME
新書上架
