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
|Item type||Home library||Call number||URL||Status||Notes||Date due||Item reserves|
|Book||Australia||276 ALE 2016 (Browse shelf)||Available|
|EBook||International||EBL Ebook (Browse shelf)||Link to resource||eBook||Available as an ebook here|
|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.