Excel Dashboards & Reports 下载 pdf 百度网盘 epub 免费 2025 电子版 mobi 在线

　　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.

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.

　　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.

暂无出版社相关信息，正在全力查找中！

暂无相关书籍摘录，正在全力查找中！

在线阅读地址：Excel Dashboards & Reports在线阅读

在线听书地址：Excel Dashboards & Reports在线收听

在线购买地址：Excel Dashboards & Reports在线购买

暂无原文赏析，正在全力查找中！

编辑推荐

　　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

书籍介绍

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.