Excel 2007 Dashboards & Reports For Dummies

About the Author
Michael Alexander is a Microsoft Certified Application Developer (MCAD)
with over 14 years experience consulting and developing office solutions. He
is the author/co-author of several books on business analysis using Microsoft
Excel and Access. Michael is one of 96 Microsoft Excel MVPs worldwide who
has been recognized for his contributions to the Excel community. He is also
the principal player behind DataPigTechnologies.com, a site that offers video
tutorials to beginning and intermediate Excel and Access users. He currently
lives in Frisco, Texas where he works as a Senior Program Manager for a
top technology firm. Michael can be contacted at mike@datapig
technologies.com.

Related Articles

Crystal Xcelsius For Dummies

– As the fastest growing dashboarding solution on the market, Xcelsius is an intuitive stand-alone Windows application that enables Excel users to transform the contents of an ordinary Excel spreadsheet into an engaging, interactive Flash-based dashboard
– Offers step-by-step instruction on the wide array of functionality that Xcelsius has to offer so that readers can complete mini-dashboards of increasing complexity with each chapter
– Addresses how to prepare Excel spreadsheets for use with Xcelsius dashboards and then use basic components of Xcelsius (charts, buttons, labels)
– Shows ways to add advanced functionality to dashboards (gauges, sliders, maps) and create interactive business calculators with Xcelsius
– Discusses integrating Xcelsius reports into PowerPoint slides, Web pages, and e-mail

Excel Dashboards and Reports For Dummies 2nd Edition

Create dynamic dashboards and put your data on display with For Dummies

No matter what business you’re in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboards & Reports For Dummies is here to help you make meaning of all your data and turn it into clear and actionable visualizations. Fully updated for the latest business intelligence and spreadsheet tools in Excel 2013, this book shows you how to analyze large amounts of data, quickly slice data into various views on the fly, automate redundant reporting, create eye-catching visualizations, and more.

Helps you move beyond reporting data with simple tables, rows, and columns to designing high-impact reports, dashboards, and visuals
Walks you through a wide array of technical and analytical concepts to give you the background you need to select the right tool for interpreting and displaying data
Covers how to build a chart, work with pivot tables, group and bucket your data, represent trends, create What-If analyses, and increase the value of your reports

Excel Dashboards & Reports For Dummies, 2nd Edition is the business analysis tool you need to transform your raw data into a powerful and effective presentation that is accessible to everyone.

Microsoft Office Excel 2007 Formulas & Functions for Dummies

Make Excel do the math and make sense of your data

Use the Insert Function dialog box, array formulas and functions, and more

Excel 2007 has more than 500 built-in functions. This book looks at the top 150, so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing? Here’s the fun and easy way!

Discover how to

* Create worksheets to track costs and revenue
* Tell the difference among average, median, and mode
* Work with statistical functions
* Develop forecasts and track trends
* Manipulate strings and work with database functions

Access 2013 For Dummies

The easy guide to Microsoft Access returns with updates on the latest version!

Microsoft Access allows you to store, organize, view, analyze, and share data; the new Access 2013 release enables you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources. Access 2013 For Dummies covers all the new features of the latest version of Accessand serves as an ideal reference, combining the latest Access features with the basics of building usable databases. You’ll learn how to create an app from the Welcome screen, get support for your desktop databases, and much more.

Includes coverage of all the new features of Access 2013, including the updated interface
Shows you how to create and share reports
Features special videos and materials created by the authors to help reinforce the lessons included in the book
Helps you build data analysis and interface tools for your specific needs
Offers plenty of techniques and tips for solving common problems

Access 2013 For Dummies provides you with access to the latest version of this database tool.

Excel 2007 VBA Programming For Dummies

Step-by-step instructions for creating VBA macros
Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.

Discover how to
– Grasp essential programming concepts
– Use the Visual Basic Editor
– Navigate the new Excel user interface
– Communicate with your users
– Deal with errors and bugs