Normal view MARC view ISBD view

Excel dashboards and reports for dummies / by Michael Alexander

by Alexander, Michael.
Publisher: Hoboken, N.J. : Wiley, 2016Edition: 3rd ed.Description: xiii, 360 p. : ill. ; 24 cm.ISBN: 9781119076766.Subject(s): Excel | Spreadsheets | Data communications | Information technology | Communication of informationOnline resources: Download as an eBook
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 word. THE PART OF TENS: Ten chart design principles -- Ten Excel chart types and when to use them.
Summary: Reveals how to get the most of your data by exploring new ways to conceptualise and present information. Describes how to build effective dashboard models using key Excel functions. Looks at pivot tables and offers ten chart design principles.
Item type Home library Call number url Status Notes Date due
Book Book Australia
Ordered
EBook EBook International
EBL Ebook (Browse shelf) Link to resource eBook Available as an ebook here
Book Book New Zealand
276 EXC (Browse shelf) Available

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 word. THE PART OF TENS: Ten chart design principles -- Ten Excel chart types and when to use them.


Reveals how to get the most of your data by exploring new ways to conceptualise and present information. Describes how to build effective dashboard models using key Excel functions. Looks at pivot tables and offers ten chart design principles.

There are no comments for this item.

Log in to your account to post a comment.

© 2017 Chartered Accountants Australia and New Zealand ABN 50 084 642 571 (CA ANZ).
Formed in Australia. Members of CA ANZ are not liable for the debts and liabilities of CA ANZ

Powered by Koha

Powered by Koha