1
of
1
Data Visualization with Excel Dashboards and Reports
Book Hero Magic crafted this summary to help describe this book. While it's new and still
learning, it may not be perfect - your
feedback is welcome!
Summary
Read More
Format: Paperback / softback
$7999
Unit price
/
Unavailable
AVAILABLE WITH SUPPLIER
Ships from our Auckland warehouse within 3-4 weeks
Found a better price? Request a price match
Data Visualization with Excel Dashboards and Reports
$7999
Unit price
/
Unavailable
Book Hero Magic created this recommendation. While it's new and still learning, it may not be perfect - your feedback is welcome! IS THIS YOUR NEXT READ?
Book Hero Magic formatted this description to make it easier to read. While it's new and
still learning, it may not be perfect - your
feedback is welcome!
Description
Large corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are turning to these tools to cut costs for budgetary reasons. An effective analyst not only needs the technical skills to use Excel productively but must also be able to synthesise data into a story and present that story in the most impactful way. Microsoft acknowledges this with Excel, focusing significantly on business intelligence and visualisation. Data Visualization with Excel Dashboards and Reports bridges the gap between handling data and synthesising it into meaningful reports, guiding readers to think about their data beyond columns and rows.
Most Excel books adequately discuss the individual functions and tools that can be used to create an "Excel Report." Titles on Excel charts, Excel pivot tables, and books focused on "Tips and Tricks" are useful; however, they often miss the mark for most data analysts. The primary reason these titles fall short is their focus on the mechanical aspects of building charts, creating pivot tables, or other functionalities, without offering an overarching view of presenting and reporting data effectively.
What are the most meaningful ways to show trending? How do you show relationships in data? When is showing variances more valuable than showing actual data values? How do you deal with outliers? How do you bucket data most meaningfully? How do you present vast amounts of data without overwhelming your audience? In Data Visualization with Excel Dashboards and Reports, readers will find answers to all these questions. Part technical manual, part analytical guidebook, this title will help Excel users evolve from reporting data with simple tables of dull numbers to creating impactful reports and dashboards that visually and substantively impress management. The book offers a comprehensive review of an array of technical and analytical concepts essential for creating meaningful reports and dashboards.
After reading this book, the reader will be able to:
- Analyse large amounts of data and report their data meaningfully
- Gain better visibility into data from various perspectives
- Quickly slice data into different views instantly
- Automate redundant reporting and analyses
- Create impressive dashboards and What-If analyses
- Understand the fundamentals of effective visualisation
- Visualise performance comparisons
- Visualise changes and trends over time
Book Details
INFORMATION
ISBN: 9781119698722
Publisher: John Wiley & Sons Inc
Format: Paperback / softback
Date Published: 01 April 2021
Country: United States
Imprint: John Wiley & Sons Inc
Audience: Professional and scholarly
DIMENSIONS
Spine width: 23.0mm
Width: 185.0mm
Height: 229.0mm
Weight: 590g
Pages: 352
About the Author
DICK KUSLEIKA is a 12-year Microsoft Excel MVP and the principal contributor at the Daily Dose of Excel Blog.
Also by Dick Kusleika
View all-
Microsoft 365 Excel All-in-One For Dummies
Get into the nitty gritty of Excel, the all-important spreadsheet tool Microsoft 365 Excel All-in-One For Dummies offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organising data and work your way to pro techniques that help with any career field or reason for using the app. Gain the skills to apply...Paperback$8599Unit price /UnavailableAvailableShips in 3-4 weeks -
Excel Macros For Dummies
Save time and become an Excel wizard with the world’s leading Excel macro guide. Do you love Excel and all the things you can do with it, but wish you could just work… faster? Excel macros—automated workflows that save you time and energy—might be just what you need. In Excel Macros For Dummies, you’ll learn over 70 of the most...Paperback$7599Unit price /UnavailableAvailableShips in 3-4 weeks -
Microsoft 365 Excel VBA Programming For Dummies
Your step-by-step guide to doing more with Microsoft Excel Fully updated for the latest version of Office 365, Excel VBA Programming For Dummies will take your Excel knowledge to the next level. With a little background in Visual Basic for Applications (VBA) programming, you can go well beyond basic spreadsheets and functions. Learn the coding basics and syntax you need...Paperback$6699Unit price /UnavailableIn StockShips today -
Excel 2019 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel...Paperback$11099Unit price /UnavailableAvailableShips in 3-4 weeks -
Excel Quick and Easy
A fast, up-to-date, and convenient desk reference for Excel users of any skill level Drawn from the most important tasks in the latest bestselling Excel Bible, Excel Quick and Easy is your ticket to data mastery. Excel veterans Michael Alexander and Dick Kusleika distil the most essential and useful tasks you need to understand about the world's most popular spreadsheet...Paperback$3799Unit price /UnavailableAvailableShips in 3-4 weeks -
Microsoft Excel 365 Bible
Your complete guide to Excel 365, written for newbies all the way to seasoned professionals Neatly organised and written using accessible language, Microsoft Excel 365 Bible contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains...Paperback$10499Unit price /UnavailableAvailableShips in 3-4 weeks -
Excel VBA Programming For Dummies
Find out what Excel is capable of with this step-by-step guide to VBA Short of changing the tyres on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can...PaperbackSold Out -
Microsoft Excel 365 Bible
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365 Excel 365 is Microsoft’s latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it’s an ideal solution for businesses and people looking to make sense of—and draw intelligence from—their data. The Excel 365 Bible carries over the best content from the best-selling Excel...PaperbackSold Out
More from Science & Nature
View all-
Murder Under the Mistletoe
BOOK 4 IN THE BESTSELLING CANON CLEMENT MYSTERY SERIES 'The best of the new cosy crime writers' Daily Telegraph 'You'll want to take a front row pew in Champton while this delicious series unfolds' Janice Hallett It is Christmas Day and at Champton Rectory, Canon Daniel Clement and his mother Audrey are joined by the residents and guests of the...Paperback$2799Unit price /UnavailableIn StockShips today -
John and Paul
THE SUNDAY TIMES AND NEW YORK TIMES BESTSELLER LONGLISTED FOR THE BAILLIE GIFFORD PRIZE FOR NON-FICTION 'A triumph.' Deborah Levy, New Statesman 'Tremendous.' Alwyn Turner, The Times 'Revelatory.' Simon Schama, Financial Times 'The gold standard of Beatles books.' Anthony Quinn, Observer 'As enthralling and astonishing as their music.' Jon Dennis, Sunday Telegraph 'A masterpiece.' Dylan Jones, Evening Standard '[Ian Leslie]...Paperback$2800Elsewhere:$3299Unit price /UnavailableIn StockShips today -
Raising Hare
THE INSTANT SUNDAY TIMES AND NEW YORK TIMES BESTSELLER SHORTLISTED FOR THE WOMEN'S PRIZE FOR NON-FICTION 2025 SHORTLISTED FOR WATERSTONES BOOK OF THE YEAR 2024 SHORTLISTED FOR THE HATCHARDS AND BIOGRAPHERS' CLUB FIRST BIOGRAPHY PRIZE A BOOK OF THE YEAR FOR THE HAY FESTIVAL, SUNDAY TIMES, THE TIMES, FINANCIAL TIMES, SPECTATOR AND iNEWS 'A beautiful book' - ANGELINA JOLIE 'I...Paperback$2400Elsewhere:$2799Unit price /UnavailableIn StockShips today -
What If? 10th Anniversary Edition
CELEBRATING TEN YEARS OF THE MILLION-SELLING POP SCIENCE CLASSIC WITH A SPECIAL EDITION. THIS IS WHAT IF? . . . x10. THE SUNDAY TIMES BESTSELLER 'Nerd royalty' — BEN GOLDACRE 'Totally brilliant' — TIM HARFORD 'Required reading across the world' — NEW YORK TIMES From the creator of the wildly popular xkcd.com, experience hilarious and informative answers to important questions...Hardback$4200Elsewhere:$5000Unit price /UnavailableIn StockShips today -
Nuclear War
The Sunday Times bestselling non-fiction thriller that has to be read to be believed. Baillie Gifford shortlisted, a favourite of Steven Bartlett, with an average reader rating of 4.6, sure to be a mass-market hit. Up to now, no one outside of official circles has known exactly what would happen if a rogue state launched a nuclear missile at the...Paperback$2500Elsewhere:$2800Unit price /UnavailableIn StockShips today -
The Anxious Generation
A powerful argument for reclaiming childhood—and all human relationships—from the online world, from the influential social psychologist and international bestselling author. Jonathan Haidt has spent his career speaking truth and wisdom in some of the most difficult spaces—communities polarised by politics and religion, campuses battling culture wars, and now the mental health emergency hitting teenagers today in many countries around...Paperback$2299Elsewhere:$3000Unit price /UnavailableIn StockShips today -
Prisoners of Geography
Prisoners of Geography looks at the past, present, and future to offer crucial insights into one of the major factors that determine world history – because if you don’t know geography, you’ll never have the full picture. Originally published in 2015, this completely revised and updated edition brings it up to date with the events and trends of the past...Paperback$2899Unit price /UnavailableIn StockShips today -
Booker PrizeOrbital
Winner of the Booker Prize 2024. Chair of the judges, Edmund de Waal, describes the winner as 'a book about a wounded world' adding that the panel's 'unanimity about Orbital recognises its beauty and ambition'. Life on our planet as you've never seen it before. A team of astronauts in the International Space Station collect meteorological data, conduct scientific experiments...Paperback$2200Elsewhere:$2600Unit price /UnavailableIn StockShips today -
Diddly Squat: Home to Roost
It's been another memorable year on Diddly Squat Farm - will the chickens finally come home to roost? Welcome back to Clarkson's Farm. The spring crop failed. Farming sheep, pigs, and cows was hardly more lucrative (better off breeding ostriches...) But in the face of uncooperative weather, bureaucracy, and the world's persistent refusal to recognise his genius, our hero's not...Paperback$2600Elsewhere:$3000Unit price /UnavailableIn StockShips today -
The Place of Tides
To save the world, we have to start somewhere. One afternoon many years ago, James Rebanks met an old woman on a remote Norwegian island. She lived and worked alone on a tiny rocky outcrop, caring for wild ducks and gathering their down. Hers was a centuries-old trade that had once made men and women rich, but had long been...Paperback$3000Unit price /UnavailableIn StockShips today -
Ultra-Processed People
Launching the runaway bestseller with ambitions to be the biggest non-fiction paperback of the year IT'S NOT YOU. IT'S THE FOOD. "If you only read one diet or nutrition book in your life, make it this one" - Bee Wilson "You've got to get this book in your life . . . Completely compelling . . . Read a page...Paperback$2500Elsewhere:$2800Unit price /UnavailableIn StockShips today -
The Island of Missing Trees
The Island of Missing Trees by Elif Shafak is a captivating and poignant novel that delves into the intertwined lives of two star-crossed lovers in war-torn Cyprus and their enduring legacy decades later. This Sunday Times bestselling novel intricately weaves themes of love, loss, and identity amidst a backdrop of cultural and historical turmoil. Set in 1974 on the island...Paperback$2300Elsewhere:$2600Unit price /UnavailableIn StockShips today
Why buy from us?
Book Hero is not a chain store or big box retailer. We're an independent 100% NZ-owned business on a mission to help more Kiwis rediscover a love of books and reading!
Service & Delivery
Our warehouse in Auckland holds over 80,000 books, toys, board games and puzzles in-stock so you're not waiting for your order to arrive from overseas.
Auckland Bookstore
We're primarily an online store, but for your convenience you can pick up your order for free from our bookstore, which is right next door to our warehouse in Hobsonville.
Our Gifting Service
Books make wonderful thoughtful gifts and we're here to help with gift-wrapping and cards. We can even send your gift directly to your loved one.
