Table of Contents
What You Need to KnowWhat You Need to HaveConventions in This BookKeyboard conventionsMouse conventionsWhat the icons meanHow This Book Is OrganizedPart I: Getting Started with Excel DashboardsPart II: Introducing Charts into Your DashboardsPart III: Advanced Dashboarding ConceptsPart IV: Pivot Table Driven DashboardsPart V: Working with the Outside WorldAbout the Companion WebsiteAbout the Power Utility Pak OfferReach Out
Chapter 1: Introducing DashboardsWhat Are Dashboards and Reports?Defining reportsDefining dashboardsEstablish the User RequirementsDefine the message(s)Establish the audienceDefine the performance measuresList the required data sourcesDefine the dimensions and filtersDetermine the need for drill-down detailsEstablish the update scheduleA Quick Look at Dashboard Design PrinciplesRule number 1: Keep it simpleUse layout and placement to draw focusFormat numbers effectivelyUse titles and labels effectivelyKey Questions to Ask Before Distributing Your DashboardDoes my dashboard present the right information?Does everything on my dashboard have a purpose?Does my dashboard prominently display the key message?Can I maintain this dashboard?Does my dashboard clearly display its scope and shelf life?Is my dashboard well documented?Is my dashboard user-friendly?Is my dashboard accurate?Chapter 2: Table Design Best PracticesTable Design PrinciplesUse colors sparinglyDe-emphasize bordersUse effective number formattingSubdue your labels and headersEnhancing Reporting with Custom Number FormattingNumber formatting basicsFormatting numbers in thousands and millionsHiding and suppressing zerosApplying custom format colorsFormatting dates and timesAdding conditions to customer number formattingChapter 3: Using Excel SparklinesUnderstanding SparklinesApplying SparklinesCreating SparklinesCustomizing SparklinesSizing and merging sparkline cellsHandling hidden or missing dataChanging the sparkline typeChanging sparkline colors and line widthUsing color to emphasize key data pointsAdjusting sparkline axis scalingFaking a reference lineSpecifying a date axisAuto-updating sparkline rangesChapter 4: Chartless Visualization TechniquesEnhancing Reports with Conditional FormattingApplying basic conditional formattingAdding your own formatting rules manuallyShow only one iconShow Data Bars and icons outside of cellsRepresenting trends with icon setsUsing Symbols to Enhance ReportingUsing Excel’s Camera ToolFinding the Camera toolUsing the Camera toolEnhancing a dashboard with the Camera tool
Chapter 5: Excel Charting for the UninitiatedWhat Is a Chart?How Excel Handles ChartsEmbedded chartsChart sheetsParts of a ChartBasic Steps for Creating a ChartCreating the chartSwitching the row and column orientationChanging the chart typeApplying chart stylesApplying a chart styleAdding and deleting chart elementsMoving and deleting chart elementsFormatting chart elementsWorking with ChartsMoving and resizing a chartConverting an embedded chart to a chart sheetCopying a chartDeleting a chartCopying a chart’s formattingRenaming a chartPrinting chartsChapter 6: Working with Chart SeriesSpecifying the Data for Your ChartAdding a New Series to a ChartAdding a new series by copying a rangeAdding a new series by extending the range highlightAdding a new series using the Select Data Source dialog boxAdding a new series by typing a new SERIES formulaDeleting a Chart SeriesModifying the Data Range for a Chart SeriesUsing range highlighting to change series dataUsing the Select Data Source dialog box to change series dataEditing the SERIES formula to change series dataUnderstanding Series NamesChanging a series nameDeleting a series nameAdjusting the Series Plot OrderCharting a Noncontiguous RangeUsing Series on Different SheetsHandling Missing DataControlling a Data Series by Hiding DataUnlinking a Chart Series from Its Data RangeConverting a chart to a pictureConverting a range reference to arraysWorking with Multiple AxesCreating a secondary value axisCreating a chart with four axesChapter 7: Formatting and Customizing ChartsChart Formatting OverviewSelecting chart elementsCommon chart elementsUI choices for formattingAdjusting Fills and Borders: General ProceduresAbout the Fill tabFormatting bordersFormatting Chart Background ElementsWorking with the chart areaWorking with the plot areaFormatting Chart SeriesBasic series formattingUsing pictures and graphics for series formattingAdditional series optionsWorking with Chart TitlesAdding titles to a chartChanging title textFormatting title textLinking title text to a cellWorking with a Chart’s LegendAdding or removing a legendMoving or resizing a legendFormatting a legendChanging the legend textDeleting a legend entryIdentifying series without using a legendWorking with Chart AxesValue axis versus category axisValue axis scalesUsing time-scale axesCreating a multiline category axisRemoving axesAxis number formatsWorking with GridlinesAdding or removing gridlinesWorking with Data LabelsAdding or removing data labelsEditing data labelsProblems and limitations with data labelsWorking with a Chart Data TableAdding and removing a data tableProblems and limitations with data tablesChapter 8: Components That Show TrendingTrending Dos and Don’tsUsing chart types appropriate for trendingStarting the vertical scale at zeroLeveraging Excel’s logarithmic scaleApplying creative label managementComparative TrendingCreating side-by-side time comparisonsCreating stacked time comparisonsTrending with a secondary axisEmphasizing Periods of TimeFormatting specific periodsUsing dividers to mark significant eventsRepresenting forecasts in your trending componentsOther Trending TechniquesAvoiding overload with directional trendingSmoothing dataChapter 9: Components That Group DataListing Top and Bottom ValuesOrganizing source dataUsing pivot tables to get top and bottom viewsUsing Histograms to Track Relationships and FrequencyAdding formulas to group dataAdding a cumulative percentUsing a pivot table to create a histogramEmphasizing Top Values in ChartsCHapter 10: Components That Show Performance Against a TargetShowing Performance with VariancesShowing Performance Against Organizational TrendsUsing a Thermometer-Style ChartUsing a Bullet GraphCreating a bullet graphAdding data to your bullet graphFinal thoughts on formatting bullet graphsShowing Performance Against a Target Range
Chapter 11: Developing Your Data ModelBuilding a Data ModelSeparating the data, analysis, and presentation layersData Model Best PracticesAvoid storing excess dataUse tabs to document and organize your data modelTest your data model before building presentation componentsExcel Functions for Your Data ModelUnderstanding lookup tablesThe VLOOKUP functionThe HLookup functionThe SUMPRODUCT functionThe Choose functionWorking with Excel TablesConverting a range to an Excel tableConverting an Excel table back to a rangeChapter 12: Adding Interactive Controls to Your DashboardGetting Started with Form ControlsFinding Form controlsAdding a control to a worksheetUsing the Button ControlUsing the Check Box ControlCheck box example: Toggling a chart series on and offUsing the Option Button ControlOption button example: Showing many views through one chartUsing the Combo Box ControlCombo box example: Changing chart data with a drop-down selectorUsing the List Box ControlList box example: Controlling multiple charts with one selectorChapter 13: Macro-Charged ReportingWhy Use a Macro?Recording Your First MacroRunning your macrosAssigning a macro to a buttonEnabling Macros in Excel 2013Viewing the new Excel security messageSetting up trusted locationsExcel Macro ExamplesBuilding navigation buttonsDynamically rearranging pivot table dataOffering one-touch reporting options
Chapter 14: Using Pivot TablesIntroducing the Pivot TableAnatomy of a pivot tableCreating the basic pivot tableCustomizing Your Pivot TableChanging the pivot table layoutRenaming the fieldsFormatting numbersChanging summary calculationsSuppressing subtotalsRemoving all subtotals at one timeRemoving the subtotals for only one fieldRemoving grand totalsHiding and showing data itemsHiding or showing items without dataSorting your pivot tableExamples of Filtering Your DataProducing top and bottom viewsCreating views by month, quarter, and yearCreating a percent distribution viewCreating a YTD totals viewCreating a month-over-month variance viewChapter 15: Using Pivot ChartsGetting Started with Pivot ChartsCreating a pivot chartUnderstanding the link between pivot charts and pivot tablesLimitations of pivot chartsUsing conditional formatting with pivot tablesCustomizing conditional formattingAlternatives to Pivot ChartsDisconnecting charts from pivot tablesCreate standalone charts that are connected to your pivot tableChapter 16: Adding Interactivity with SlicersUnderstanding SlicersCreating a Standard SlicerFormatting slicersControlling multiple pivot tablesCreating a Timeline SlicerUsing Slicers as Form ControlsChapter 17: Using the Internal Data Model and Power ViewUnderstanding the Internal Data ModelBuilding out your first data modelUsing your Data Model in a pivot tableUsing external data sources in your internal Data ModelCreating a Power View DashboardCreating and working with Power View chartsVisualizing data in a Power View mapChanging the look of your Power View dashboard
Chapter 18: Integrating External Data into Excel ReportingImporting Data from Microsoft AccessThe drag-and-drop methodThe Microsoft Access Export WizardThe Get External Data iconImporting Data from SQL ServerPassing Your Own SQL Statements to External DatabasesManually editing SQL statementsRunning stored procedures from ExcelUsing VBA to create dynamic connectionsChapter 19: Sharing Your Work with the Outside WorldSecuring Your Dashboards and ReportsSecuring access to the entire workbookLimiting access to specific worksheet rangesProtecting the workbook structureLinking Your Excel Dashboards to PowerPointCreating the link between Excel and PowerPointManually updating links to capture updatesAutomatically updating linksDistributing Your Dashboards via a PDFDistributing Your Dashboards to SkyDriveLimitations when publishing to the web
Excel® Dashboards and Reports, 2nd Edition
Excel® Dashboards and Reports, 2nd Edition
Published by
John Wiley & Sons, Inc.
111 River Street
Hoboken, NJ 07030-5774
www.wiley.com
Copyright © 2013 by John Wiley & Sons, Inc., Hoboken, New Jersey
Published by John Wiley & Sons, Inc., Hoboken, New Jersey
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions
.
Trademarks: Wiley and the Wiley logo, are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the United States and other countries, and may not be used without written permission. Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book.
Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Website is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Website may provide or recommendations it may make. Further, readers should be aware that Internet Websites listed in this work may have changed or disappeared between when this work was written and when it is read. FULFILLMENT OF EACH COUPON OFFER IS THE SOLE RESPONSIBILITY OF THE OFFEROR.
For general information on our other products and services, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
For technical support, please visit www.wiley.com/techsupport
.
Wiley also publishes its books in a variety of electronic formats. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com
. For more information about Wiley products, visit www.wiley.com
.
Library of Congress Control Number: 2013934910
ISBN 978-1-118-49042-6 (pbk); ISBN 978-1-118-49043-3 (ebk); ISBN 978-1-118-49150-8 (ebk); ISBN 978-1-118-49141-6 (ebk)
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
About the Authors
Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis using Microsoft Access and Excel. He has more than 15 years experience consulting and developing Microsoft Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. In his spare time he runs a free tutorial site, www.datapigtechnologies.com
, where he shares basic Access and Excel tips with the Office community.
John Walkenbach is a bestselling Excel author who has published more than 50 books on spreadsheets. He lives amid the saguaros, javelinas, rattlesnakes, bobcats, and gila monsters in southern Arizona — but the critters are mostly scared away by his clawhammer banjo playing. For more information, Google him.
Dedication
This is dedicated to the fans of DataPigTechnologies.com
. . . all twelve of you.
Michael Alexander
Author’s Acknowledgments
My deepest thanks to Katie Mohr and Pat O’Brien, for all the hours of work put into making this book as clear as it can be. Thanks also to the brilliant team of professionals who helped bring this book to fruition. Finally, a special thank you goes to my family for putting up with all the time spent away on this project.
Michael Alexander
Publisher’s Acknowledgments
We’re proud of this book; please send us your comments at http://dummies.custhelp.com
. For other comments, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
Some of the people who helped bring this book to market include the following:
Acquisitions, Editorial, and Vertical Websites
Sr. Project Editor: Pat O’Brien
Acquisitions Editor: Katie Mohr
Copy Editor: Melba Hoppper
Technical Editor: Doug Steele
Editorial Manager: Kevin Kirschner
Vertical Websites Project Manager: Laura Moss-Hollister
Editorial Assistant: Annie Sullivan
Sr. Editorial Assistant: Cherie Case
Composition Services
Project Coordinator: Katie Crocker
Layout and Graphics: Jennifer Goldsmith, Christin Swinford, Erin Zeltner
Proofreaders: ConText Editorial Services, Inc., Susan Moritz
Indexer: Ty Koontz
Publishing and Editorial for Technology Dummies
Richard Swadley, Vice President and Executive Group Publisher
Andy Cummings, Vice President and Publisher
Mary Bednarek, Executive Acquisitions Director
Mary C. Corder, Editorial Director
Publishing for Consumer Dummies
Kathleen Nebenhaus, Vice President and Executive Publisher
Composition Services
Debbie Stailey, Director of Composition Services
Introduction
Business intelligence (BI) is what you get when you analyze raw data and turn that information into actionable knowledge. BI can help an organization identify cost-cutting opportunities, uncover new business opportunities, recognize changing business environments, identify data anomalies, and create widely accessible reports.
The BI concept is overtaking corporate executives who are eager to turn impossible amounts of data into useful knowledge. As a result of this trend, software vendors who focus on BI and build dashboards are coming out of the woodwork. Dashboards are ideal mechanisms for delivering this targeted information in a graphical, user-friendly form. New consulting firms touting their BI knowledge are popping up virtually every week. And even the traditional enterprise solution providers like Business Objects and SAP are offering new BI capabilities presented in a dashboard format.
So maybe you’ve been hit with dashboard fever? Or maybe you’re holding this book because someone is asking you to create BI solutions (that is, create a dashboard) in Excel.
Although many IT managers would scoff at the thought of using Excel as a BI tool to create a dashboard, Excel is inherently part of the enterprise-BI-tool portfolio. Whether IT managers are keen to acknowledge it or not, most of the data analysis and reporting done in business today is done by using a spreadsheet program. We see several significant reasons to use Excel as the platform for your dashboards and reports. They are as follows:
→ Familiarity with Excel: If you work in corporate America, you’re conversant in the language of Excel. You can send even the most seasoned senior vice-president an Excel-based presentation and trust he’ll know what to do with it. With an Excel dashboard, your users spend less time figuring how to use the tool and more time viewing the data.
→ Built-in flexibility: With most enterprise dashboards, the ability to analyze the data outside of the predefined views is either disabled or unavailable. In Excel, features such as pivot tables, drop-down lists, and other interactive controls (such as a check box) don’t lock your audience into one view. And because an Excel workbook contains multiple worksheets, the users have space to add their own data analysis as needed.
→ Rapid development: Using Excel to build your own dashboards can liberate you from assorted resource and time limitations from within an organization. With Excel, you can develop dashboards faster and adapt more quickly to changing business requirements.
→ Powerful data connectivity and automation capabilities: Excel is not the toy application some IT managers make it out to be. With its own native programming language and its robust object model, Excel can help to automate certain processes and even connect with various data sources. With a few advanced techniques, your dashboard can practically run on its own.
→ Little to no incremental costs: Not all of us can work for multi-billion dollar companies that can afford enterprise-level reporting solutions. In most companies, funding for new computers and servers is limited, let alone funding for expensive dashboard software packages. For those companies, Excel is frankly the most cost-effective way to deliver key business reporting tools without compromising too deeply on usability and function.
Excel contains so many functions and features that it’s difficult to know where to start. Enter your humble authors, spirited into your hands via this book. Here we show you how you can turn Excel into your own personal BI tool. With a few fundamentals and some of the new BI functionality Microsoft has included in this latest version of Excel, you can go from reporting data with simple tables to creating meaningful dashboards sure to wow everyone.
What You Need to Know
The goal of this book is to show you how to leverage Excel functionality to build and manage better presentations. Each chapter in this book provides a comprehensive review of Excel functions and features, and the analytical concepts that will help you create better reporting components — components that can be used for both dashboards and reports. As you move through this book, you’ll be able to create increasingly sophisticated components.
After reading this book, you’ll be able to:
→ Analyze large amounts of data and report those results in a meaningful way.
→ Get better visibility into data from different perspectives.
→ Add interactive controls to show various views.
→ Automate repetitive tasks and processes.
→ Create eye-catching visualizations.
→ Create impressive dashboards and What-If analyses.
→ Access external data sources to expand your message.
What You Need to Have
In order to get the most out of this book, it’s best that you have certain skills before diving into the topics highlighted in this book. The ideal candidate for this book will have the following:
→ Some experience working with data and familiarity with the basic concepts of data analysis such as working with tables, aggregating data, and performing calculations
→ Experience using Excel with a strong grasp of concepts such as table structures, filtering, sorting, and using formulas
Conventions in This Book
Take a minute to skim this section and become familiar with some of the typographic conventions used throughout this book.
Keyboard conventions
You need to use the keyboard to enter formulas. In addition, you can work with menus and dialog boxes directly from the keyboard — a method you may find easier if your hands are already positioned over the keys.
Formula listings
Formulas usually appear on a separate line in monospace font. For example, we may list the following formula:
=VLOOKUP(StockNumber,PriceList,2,False)
Excel supports a special type of formula known as an array formula. When you enter an array formula, press Ctrl+Shift+Enter (not just Enter). Excel encloses an array formula in brackets in order to remind you that it’s an array formula. When we list an array formula, we include the brackets to make it clear that it is, in fact, an array formula. For example:
{=SUM(LEN(A1:A10))}
Do not type the brackets for an array formula. Excel puts them in automatically.
Key names
Names of keys on the keyboard appear in normal type, for example Alt, Home, PgDn, and Ctrl. When you need to press two keys simultaneously, the keys are connected with a plus sign: for example, “Press Ctrl+G to display the Go To dialog box.”
Functions, procedures, and named ranges
Excel’s worksheet functions appear in all uppercase, like so: “Use the SUM function to add the values in column A.”
Macro and procedure names appear in normal type: “Execute the InsertTotals procedure.” We often use mixed upper- and lowercase letters to make these names easier to read. Named ranges appear in italic: “Select the InputArea range.”
Unless you’re dealing with text inside quotation marks, Excel is not sensitive to case. In other words, both of the following formulas produce the same result:
=SUM(A1:A50)
=sum(a1:a50)
Excel, however, will convert the characters in the second formula to uppercase.
Mouse conventions
The mouse terminology in this book is all standard fare: “pointing,” “clicking,” “right-clicking,” “dragging,” and so on. You know the drill.
What the icons mean
Throughout the book, icons appear to call your attention to points that are particularly important.
This icon indicates a feature new to Excel 2013.
This icon tells you that something is important — perhaps a concept that may help you master the task at hand or something fundamental for understanding subsequent material.
This icon indicates a more efficient way of doing something or a technique that may not be obvious. These icons will often impress your officemates.
This icon indicates that an example file is on the companion website: www.wiley.com/go/exceldr
We use Caution icons when the operation that we’re describing can cause problems if you’re not careful.
We use the Cross-Reference icon to refer you to other chapters that have more to say on a particular topic.
How This Book Is Organized
The chapters in this book are organized into six parts. Each of these parts includes chapters that build on the previous chapters’ instruction. The idea is that as you go through each part, you will be able to build dashboards of increasing complexity until you’re an Excel dashboarding guru.
Part I: Getting Started with Excel Dashboards
Part I is all about helping you think about your data in terms of creating effective dashboards and reports. Chapter 1 introduces you to the topics of dashboards and reports, defining some of the basic concepts and outlining key steps to take to prepare for a successful project. Chapter 2 shows you how to design effective data tables. Chapter 3 shows you how you can leverage the sparkline functionality found in Excel 2013. Finally, Chapter 4 rounds out this section with a look at the various techniques that you can use to visualize data without the use of charts or graphs.
Part II: Introducing Charts into Your Dashboards
Part II provides a solid foundation in visualizing data using Excel charts. Chapter 5 starts with the basics, introducing you to Excel’s charting engine. Chapters 6 and 7 focus on formatting techniques that enable you to build customized charts that fit your distinct needs. After that, Part II takes you beyond basic chart-building with a look at some advanced business techniques that can help make your dashboards more meaningful. Starting with Chapter 8, we demonstrate how to represent trending across multiple series and distinct time periods. In Chapter 9, we explore how best to use charts to group data into meaningful views. And Chapter 10 demonstrates some of charting techniques that can help you display and measure performance against a target. By the end of this section, you will be able to effectively leverage Excel charts to synthesize your data into meaningful visualizations.
Part III: Advanced Dashboarding Concepts
In Part III, we offer an in-depth look at some of the key dashboarding concepts you can leverage to create a cutting–edge dashboard presentation. Chapter 11 shows you how to build an effective data model that provides the foundation upon which your dashboard or report is built. In this chapter, you discover the impact of poorly organized data and how to set up the source data for the most positive outcome. Chapter 12 illustrates how interactive controls can provide your clients with a simple interface, allowing them to easily navigate through and interact with your dashboard or report. Chapter 13 provides a clear understanding of how you can leverage macros to automate your reporting systems.
Part IV: Pivot Table Driven Dashboards
With Part IV, you find out how pivot tables can enhance your analytical and reporting capabilities, as well as your dashboards. In Chapter 14, we introduce you to pivot tables and explore how this Excel feature can play an integral role in Excel-based presentations. Chapter 15 provides a primer on building pivot charts, giving you a solid understanding of how Excel pivot charts work with pivot tables. Chapter 16 shows you how pivot slicers can add interactive filtering capabilities to your pivot reporting. Finally, Chapter 17 introduces you to the new internal Data Model and Power View features of Excel 2013.
Part V: Working with the Outside World
The theme in Part V is importing information from external data sources. Chapter 18 explores some of the ways to incorporate data that doesn’t originate in Excel. In this chapter, you learn how to import data from external sources, such as Microsoft Access and SQL Server, as well as create systems that allow for dynamic refreshing of external data sources. Chapter 19 wraps up this look at Excel dashboards and reports by showing you the various ways to distribute and present your work in a safe and effective way.
About the Companion Website
This book contains many examples, and the workbooks for those examples are available on the companion website that is arranged in directories that correspond to the chapters. You can download example files for this book at the following website:
www.wiley.com/go/exceldr
The example workbook files on the website aren’t compressed (installation isn’t required). These files are all Excel 2007–2013 files.
About the Power Utility Pak Offer
Toward the back of the book, you’ll find a coupon that you can redeem for a discounted copy of John Walkenbach’s award-winning Power Utility Pak — a collection of useful Excel utilities, plus many new worksheet functions. John developed this package using VBA exclusively.
You can also use this coupon to purchase the complete VBA source code for a nominal fee. Studying the code is an excellent way to pick up some useful programming techniques.
You can download a 30-day trial version of the most-recent version of the Power Utility Pak from John’s website:
http://spreadsheetpage.com
If you find it useful, use the coupon to purchase a licensed copy at a discount.
Reach Out
We’re always interested in getting feedback on our books. The best way to provide this feedback is via e-mail. Send your comments and suggestions to
mha105@yahoo.com
john@j-walk.com
Unfortunately, we’re not able to reply to specific questions. Posting your question to one of the Excel newsgroups is, by far, the best way to get such assistance.
Also, when you’re out surfing the web, don’t overlook John’s website (“The Spreadsheet Page”). You’ll find lots of useful Excel information, including tips and downloads. The URL is
http://spreadsheetpage.com
Now, without further ado, it’s time to turn the page and expand your horizons.
Part I: Getting Started with Excel Dashboards
Chapter 1: Introducing Dashboards
Chapter 2: Table Design Best Practices
Chapter 3: Using Excel Sparklines
Chapter 4: Chartless Visualization Techniques