Excel Dashboards Reports Dummies Computers

From the Back Cover

Learn to:

• Analyse data and report it in a way that makes sense
• Slice and dice data from different perspectives
• Create eye-catching and understandable reports, visualisations, and dashboards
• Automate redundant reporting

Take Excel to the next level with this guide to advanced dashboards and reporting

This reference is your ticket to advanced analysis with Excel! Find out how to use this powerful tool for business intelligence and explore the details of data trending and relationships, creating data visualisations, and more. Part tech manual and part analytics guidebook, this resource will help you create high-impact reports and dashboards today!

• Make the move to dashboards — create effective dashboards, make great reports, and build super models
• Build the basics — dive into Pivot Tables, Excel charts, conditional formatting, and dynamic labelling
• Get advanced — dig into the powerful components of Excel, including those that show trending, display performance, group data, and more
• Share your work — use external data for dashboards and reports and share your work with the world
• Go further — take things up a notch with more extensive chart design principles and safeguards to follow before distributing dashboards
• Advanced reporting — make interactive interfaces and use macros to super-charge your reporting

Open the book and find:

• Tips to analyse large amounts of data
• Information on reporting data in meaningful ways
• Ways to break data down into various views
• Tricks to create great visualisations
• Methods to make impressive dashboards
• Technical and analytical concepts made easy
• Tips on creating Pivot Tables, representing trends, and more

About the Author

Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on Microsoft Access and Excel. He has more than 15 years experience consulting and developing Office solutions and has been named a Microsoft MVP for his ongoing contributions to the Excel community.