I've always considered myself a knowledgeable Excel user, but this book taught me a lot of new tricks and improved my knowledge of Excel charting. I'm new to the whole dashboarding concept but Dashboards and Reports for Dummies laid everything out in easy-to-understand chapters that slowly build up
Excel 2007 Dashboards & Reports For Dummies
โ Scribed by Alexander, Michael
- Publisher
- John Wiley & Sons, Inc
- Year
- 2011
- Tongue
- English
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
Excelยฎ 2007 Dashboards & Reports For Dummies; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; Foolish Assumptions; How This Book Is Organized; Sample Files for This Book; Icons Used In This Book; Where to Go from Here; Part I: Making the Move to Dashboards; Chapter 1: Getting in the Dashboard State of Mind; Chapter 2: Building a Super Model; Part Ii: Building Basic Dashboard Components; Chapter 3: The Pivotal Pivot Table; Chapter 4: Excel Charts for the Uninitiated.;What's the use of putting out reports that no one reads? Properly created dashboards are graphical representations that put data in a context for your audience, and they look really cool! How cool? You'll find out when you see the dazzling examples in Excel 2007 Dashboards & Reports For Dummies. And, before long, everyone's eyes will be riveted to your dashboards and reports too!This revolutionary guide shows you how to turn Excel into your own personal Business Intelligence tool. You'll learn the fundamentals of using Excel 2007 to go beyond simple tables to creating dashboard-studded reports.
โฆ Table of Contents
Excelยฎ 2007 Dashboards & Reports For Dummies
About the Author
Dedication
Author's Acknowledgments
Contents at a Glance
Table of Contents
Introduction
About This Book
Foolish Assumptions
How This Book Is Organized
Sample Files for This Book
Icons Used In This Book
Where to Go from Here
Part I: Making the Move to Dashboards
Chapter 1: Getting in the Dashboard State of Mind
Chapter 2: Building a Super Model
Part Ii: Building Basic Dashboard Components
Chapter 3: The Pivotal Pivot Table
Chapter 4: Excel Charts for the Uninitiated. Chapter 5: The New World of Conditional FormattingChapter 6: The Art of Dynamic Labeling
Part Iii: Building Advanced Dashboard Components
Chapter 7: Components That Show Trending
Chapter 8: Components That Group and Bucket Data
Chapter 9: Components That Display Performance against a Target
Part Iv: Advanced Reporting Techniques
Chapter 10: Macro-Charged Reporting
Chapter 11: Giving Users an Interactive Interface
Part V: Working with the Outside World
Chapter 12: Using External Data for Your Dashboards and Reports
Chapter 13: Sharing Your Work with the Outside World. Part Vi: The Part of TensChapter 14: Ten Chart Design Principles
Chapter 15: Ten Questions to Ask Before Distributing Your Dashboard
Index.
โฆ Subjects
Business;Computer science;Electronic spreadsheets;Electronic books
๐ SIMILAR VOLUMES
Excel 2007 Dashboards & Reports For Dummies ะะะะะ ; ะะ ะะะ ะะะะะะ ะะฒัะพั: Michael Alexanderะะฐะทะฒะฐะฝะธะต: Excel 2007 Dashboards & Reports For Dummies ะะทะดะฐัะตะปัััะฒะพ: Wiley Publishing ะะพะด: 2008 ะคะพัะผะฐั: pdf ะ ะฐะทะผะตั: 12,6 MbThe goal of this book is to show you how to leverage Excel functionality to build and ma
<b>It's time for some truly "Excel-lent" spreadsheet reporting</b> Beneath the seemingly endless rows and columns of cells, the latest version of Microsoft Excel boasts an astonishing variety of features and capabilities. But how do you go about tapping into some of that power without spending all