Item Details

Print View

Excel Dashboards & Reports for Dummies [electronic resource]

by Michael Alexander
Format
EBook; Book; Online
Published
Hoboken, New Jersey : John Wiley & Sons, Inc., [2016]
Edition
3rd edition
Language
English
Variant Title
Excel dashboards and reports for dummies
Microsoft Excel dashboards & reports for dummies
Microsoft Excel dashboards and reports for dummies
Series
For Dummies, a Wiley Brand
 — For Dummies
ISBN
9781119076766, 1119076765, 9781119088813, 111908881X, 9781119076773, 1119076773
Summary
Provides information on how to use Excel for business intelligence, including tips on using PivotTables, Excel charts, and representing data trends, and methods for creating effective dashboards.
Contents
  • Getting started with Excel dashboards and reports. Getting in the dashboard state of mind ; Building a super model
  • Building basic dashboard components. Dressing up your data tables ; Sparking inspiration with Sparklines ; Formatting your way to visualizations ; The pivotal pivot table
  • Building advanced dashboard components. Charts that show trending ; Grouping and bucketing data ; Displaying performance against a target
  • Advanced reporting techniques. Macro-charged dashboarding ; Giving users an interactive interface ; Adding interactivity with pivot slicers
  • Working with the outside world. Using external data for your dashboards and reports ; Sharing your workbook with the outside world
  • The part of tens. Ten chart design principles ; Ten Excel chart types and when to use them.
Description
Mode of access: World wide Web.
Notes
Includes index.
Copyright Not EvaluatedCopyright Not Evaluated
Technical Details
  • Access in Virgo Classic
  • Staff View

    LEADER 03122cam a2200565 i 4500
    001 u7235833
    003 SIRSI
    005 20180508152712.0
    006 m d
    007 cr n
    008 151127t20162016njua s 001 0 eng d
    010
      
      
    a| 2015958876
    020
      
      
    a| 9781119076766 q| (paperback)
    020
      
      
    a| 1119076765 q| (paperback)
    020
      
      
    z| 9781119088813 q| (ebk)
    020
      
      
    z| 111908881X q| (ebk)
    020
      
      
    z| 9781119076773 q| (ebk)
    020
      
      
    z| 1119076773 q| (ebk)
    035
      
      
    a| (WaSeSS)ssj0001637606
    037
      
      
    b| John Wiley & Sons Inc, Eastern Dist Center One Wiley Dr, Somerset, NJ, USA, 08873 n| SAN 200-2272
    040
      
      
    a| CCE b| eng c| CCE d| OCLCO d| YDXCP d| CLE d| ABG d| BKL d| OCLCF d| CHVBK d| BTCTA d| GK8 d| OCLCQ d| TUL d| NZWAC d| OCLCO d| OCLCQ d| DLC d| WaSeSS
    042
      
      
    a| lccopycat
    050
    0
    0
    a| HF5548.4.M523 b| A467 2016
    082
    0
    4
    a| 005.54 2| 23
    082
    0
    4
    a| 658.4038011 2| 23
    100
    1
      
    a| Alexander, Michael, d| 1972-
    245
    1
    0
    a| Excel dashboards & reports for dummies h| [electronic resource] / c| by Michael Alexander.
    246
    3
      
    a| Excel dashboards and reports for dummies
    246
    1
    4
    a| Microsoft Excel dashboards & reports for dummies
    246
    3
      
    a| Microsoft Excel dashboards and reports for dummies
    250
      
      
    a| 3rd edition.
    260
      
      
    a| Hoboken, New Jersey : b| John Wiley & Sons, Inc., c| [2016]
    490
    1
      
    a| For dummies, a Wiley brand
    500
      
      
    a| Includes index.
    505
    0
      
    a| Getting started with Excel dashboards and reports. Getting in the dashboard state of mind ; Building a super model -- Building basic dashboard components. Dressing up your data tables ; Sparking inspiration with Sparklines ; Formatting your way to visualizations ; The pivotal pivot table -- Building advanced dashboard components. Charts that show trending ; Grouping and bucketing data ; Displaying performance against a target -- Advanced reporting techniques. Macro-charged dashboarding ; Giving users an interactive interface ; Adding interactivity with pivot slicers -- Working with the outside world. Using external data for your dashboards and reports ; Sharing your workbook with the outside world -- The part of tens. Ten chart design principles ; Ten Excel chart types and when to use them.
    520
      
      
    a| Provides information on how to use Excel for business intelligence, including tips on using PivotTables, Excel charts, and representing data trends, and methods for creating effective dashboards.
    538
      
      
    a| Mode of access: World wide Web.
    630
    0
    0
    a| Microsoft Excel (Computer file)
    630
    0
    7
    a| Microsoft Excel (Computer file) 2| fast 0| (OCoLC)fst01366659
    650
      
    0
    a| Dashboards (Management information systems)
    650
      
    0
    a| Statistics v| Charts, diagrams, etc.
    650
      
    0
    a| Business report writing.
    650
      
    0
    a| Electronic spreadsheets.
    650
      
    0
    a| Business x| Computer programs.
    655
      
    0
    a| Electronic books.
    710
    2
      
    a| Safari Books Online
    830
      
    0
    a| --For dummies.
    856
    4
    0
    u| http://RE5QY4SB7X.search.serialssolutions.com/?V=1.0&L=RE5QY4SB7X&S=JCs&C=TC0001637606&T=marc
    596
      
      
    a| 1
    999
      
      
    a| XX(7235833.1) w| WEB i| 7235833-1001 l| INTERNET m| UVA-LIB t| INTERNET
▾See more
▴See less

Availability

Google Preview

Google Books Preview

Read Online