Mr. Spreadsheet's Bookshelf Series
4.5/5
()
About this series
Learn to use Excel dashboards and reports to better conceptualize data
Updated for all the latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create compelling Excel reports. Veteran author Michael Alexander walks you through the most effective ways to present and report data. Featuring a comprehensive review of a wide array of technical and analytical concepts, this essential guide helps you go from reporting data with simple tables full of dull numbers to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.
- Details how to analyze large amounts of data and report the results in a way that is both visually attractive and effective
- Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly
- Shows how to automate redundant reporting and analysis processes
- Walks you through creating impressive dashboards, eye-catching visualizations, and real-world What-If analyses
Excel Dashboards and Reports, Second Edition is part technical manual, part analytical guidebook, and exactly what you need to become your organization's dashboard dynamo!
Titles in the series (5)
- Excel 2007 Power Programming with VBA
2
This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features Includes a valuable CD-ROM with templates and worksheets from the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
- Excel 2007 PivotTables and PivotCharts
4
Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.
- Excel 2010 Formulas
7
Take your Excel formulas to the next level with this updated reference John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods you can use to maximize the power of Excel with formulas within the frameworks of all the new features of Excel 2010. You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks, and techniques you won't find anywhere else. Demonstrates how to use all the new features of Excel 2010 to maximize your formulas Shows how to develop custom worksheet functions with VBA, debug formulas, create financial formulas, and more Serves as an indispensable reference no matter your skill level Includes a valuable CD-ROM with sample files, templates and worksheets from the book, plus John Walkenbach's award-winning Power Utility Pak Prepare to excel with Excel when you have John Walkenbach and Excel 2010 Formulas by your side! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
- Excel 2013 Power Programming with VBA
15
Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to VBA Features invaluable advice from "Mr. Spreadsheet" himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else Excel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.
- Excel Dashboards and Reports
Learn to use Excel dashboards and reports to better conceptualize data Updated for all the latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create compelling Excel reports. Veteran author Michael Alexander walks you through the most effective ways to present and report data. Featuring a comprehensive review of a wide array of technical and analytical concepts, this essential guide helps you go from reporting data with simple tables full of dull numbers to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively. Details how to analyze large amounts of data and report the results in a way that is both visually attractive and effective Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly Shows how to automate redundant reporting and analysis processes Walks you through creating impressive dashboards, eye-catching visualizations, and real-world What-If analyses Excel Dashboards and Reports, Second Edition is part technical manual, part analytical guidebook, and exactly what you need to become your organization's dashboard dynamo!
Read more from John Walkenbach
Excel VBA Programming For Dummies Rating: 0 out of 5 stars0 ratingsExcel 2013 Formulas Rating: 5 out of 5 stars5/5Excel 2003 Formulas Rating: 4 out of 5 stars4/5101 Excel 2013 Tips, Tricks and Timesavers Rating: 0 out of 5 stars0 ratingsExcel 2007 VBA Programming For Dummies Rating: 3 out of 5 stars3/5Excel 2003 Power Programming with VBA Rating: 5 out of 5 stars5/5
Related to Mr. Spreadsheet's Bookshelf
Related ebooks
Excel 2019 Beginner: Excel Essentials 2019, #1 Rating: 0 out of 5 stars0 ratings50 More Excel Functions: Excel Essentials, #4 Rating: 0 out of 5 stars0 ratingsExcel for Beginners: Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsMastering Excel Macros: Introduction: Mastering Excel Macros, #1 Rating: 4 out of 5 stars4/5Excel VBA Programming: Automating Excel through Visual Basic for Application Rating: 0 out of 5 stars0 ratingsExcel 2019 PivotTables: Easy Excel Essentials 2019, #1 Rating: 5 out of 5 stars5/5Guerilla Data Analysis Using Microsoft Excel Rating: 0 out of 5 stars0 ratingsExcel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5MrExcel LX The Holy Grail of Excel Tips: Covers Excel Backwards and Forwards Rating: 0 out of 5 stars0 ratingsExcel VBA - Intermediate Lessons in Excel VBA Programming for Professional Advancement: 2 Rating: 0 out of 5 stars0 ratingsExcel VBA: A Step-By-Step Tutorial For Beginners To Learn Excel VBA Programming From Scratch: 1 Rating: 4 out of 5 stars4/5Mastering Excel: Excel Apps Rating: 3 out of 5 stars3/5Excel 2019 Intermediate: Excel Essentials 2019, #2 Rating: 0 out of 5 stars0 ratingsThe Ultimate Excel VBA Master: A Complete, Step-by-Step Guide to Becoming Excel VBA Master from Scratch Rating: 0 out of 5 stars0 ratingsExcel VBA: A Beginners' Guide Rating: 4 out of 5 stars4/5Learn Excel in 24 Hours Rating: 4 out of 5 stars4/5Mastering Microsoft Excel 2016: How to Master Microsoft Excel 2016 in 30 days Rating: 5 out of 5 stars5/5101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5Microsoft Excel: Advanced Microsoft Excel Data Analysis for Business Rating: 0 out of 5 stars0 ratingsTop Secrets Of Excel Dashboards: Save Your Time With MS Excel Rating: 5 out of 5 stars5/5Excel 2019 Bible Rating: 4 out of 5 stars4/5Excel 2019 Formulas and Functions Study Guide Rating: 0 out of 5 stars0 ratingsExcel VBA Programming: Automating Excel through Visual Basic for Application Rating: 0 out of 5 stars0 ratings150 Most Poweful Excel Shortcuts: Secrets of Saving Time with MS Excel Rating: 3 out of 5 stars3/5Learn Excel Functions: Count, Countif, Sum and Sumif Rating: 5 out of 5 stars5/5Intermediate Excel: Excel Essentials, #2 Rating: 5 out of 5 stars5/5
Language Arts & Discipline For You
Barron's American Sign Language: A Comprehensive Guide to ASL 1 and 2 with Online Video Practice Rating: 3 out of 5 stars3/5Learn Sign Language in a Hurry: Grasp the Basics of American Sign Language Quickly and Easily Rating: 4 out of 5 stars4/5Easy Spanish Stories For Beginners: 5 Spanish Short Stories For Beginners (With Audio) Rating: 3 out of 5 stars3/5Dirty Sign Language: Everyday Slang from "What's Up?" to "F*%# Off!" Rating: 0 out of 5 stars0 ratingsTalk Dirty Spanish: Beyond Mierda: The curses, slang, and street lingo you need to Know when you speak espanol Rating: 0 out of 5 stars0 ratingsThe Dictionary of Obscure Sorrows Rating: 4 out of 5 stars4/5Speed Reading: How to Read a Book a Day - Simple Tricks to Explode Your Reading Speed and Comprehension Rating: 4 out of 5 stars4/5Talk Like TED: The 9 Public-Speaking Secrets of the World's Top Minds Rating: 4 out of 5 stars4/5500 Beautiful Words You Should Know Rating: 5 out of 5 stars5/5The Everything Sign Language Book: American Sign Language Made Easy... All new photos! Rating: 4 out of 5 stars4/5Fluent in 3 Months: How Anyone at Any Age Can Learn to Speak Any Language from Anywhere in the World Rating: 3 out of 5 stars3/5On Writing Well, 30th Anniversary Edition: An Informal Guide to Writing Nonfiction Rating: 4 out of 5 stars4/5Show, Don't Tell: How to Write Vivid Descriptions, Handle Backstory, and Describe Your Characters’ Emotions Rating: 5 out of 5 stars5/5Verbal Judo, Second Edition: The Gentle Art of Persuasion Rating: 4 out of 5 stars4/5100 Words Almost Everyone Confuses and Misuses Rating: 3 out of 5 stars3/5The Craft of Research, Fourth Edition Rating: 4 out of 5 stars4/5Writing to Learn: How to Write - and Think - Clearly About Any Subject at All Rating: 4 out of 5 stars4/5The Lost Art of Handwriting: Rediscover the Beauty and Power of Penmanship Rating: 5 out of 5 stars5/5Get to the Point!: Sharpen Your Message and Make Your Words Matter Rating: 5 out of 5 stars5/5Metaphors We Live By Rating: 4 out of 5 stars4/5Wordslut: A Feminist Guide to Taking Back the English Language Rating: 4 out of 5 stars4/5The Chicago Guide to Grammar, Usage, and Punctuation Rating: 5 out of 5 stars5/5I Will Judge You by Your Bookshelf Rating: 4 out of 5 stars4/5The Elements of Style, Fourth Edition Rating: 5 out of 5 stars5/5The Plot Whisperer Book of Writing Prompts: Easy Exercises to Get You Writing Rating: 5 out of 5 stars5/5Making Sense: Conversations on Consciousness, Morality, and the Future of Humanity Rating: 4 out of 5 stars4/5
Related categories
Reviews for Mr. Spreadsheet's Bookshelf
28 ratings0 reviews