

Michael Alexander is a Microsoft Certified Application Developer (MCAD) with over 14 years experience developing business solutions with Microsoft Office, VBA, and .Net. He currently lives in Frisco, Texas, where he works as a senior program manager for a top technology firm.
Meer over Michael AlexanderExcel Dashboard & Reports for Dummies
Present data effectively and increase the value of your reports
Paperback Engels 2016 3e druk 9781119076766Samenvatting
Make the most of your data using the power of Excel
When you think of data, do you think of endless rows and columns in spreadsheets? 'Excel Dashboards and Reports For Dummies, 3rd Edition' shows you how to make the most of your data—and puts an end to mind-numbing spreadsheets by exploring new ways to conceptualize and present key information. There's often a gap between handling data and synthesizing it into meaningful reports, and this approachable text bridges this gap with quick and accessible information that answers key questions, like how to meaningfully capture data trends, how to show relationships in data, and when it's better to show variances than actual data values.
As a leading spreadsheet application, Microsoft Excel is the go-to data software. This tool allows you to use dashboard reports that leverage gauges, maps, charts, sliders, and other visual elements to present complex data in a manner that's easy to understand. Using Excel dashboards effectively can improve your professional capabilities by leaps and bounds.
- Analyze and report on large amounts of data in a meaningful way
- Look at data from different perspectives, and better visualize the information you're presenting by quickly slicing data on the fly
- Automate redundant reporting and analysis functions, making your data analysis and reporting routine more efficient
- Create visualizations, dashboards, and what-if analyses that are as visually appealing as they are substantial
'Excel Dashboards and Reports For Dummies, 3rd Edition' is a fantastic resource if you're looking to spice up your reporting!
Specificaties
Lezersrecensies
Inhoudsopgave
Part 1: Getting Started with Excel Dashboards & Reports.
1. Getting in the Dashboard State of Mind.
2. Building a Super Model.
Part 2: Building Basic Dashboard Components.
3. Dressing Up Your Data Tables.
4. Sparking Inspiration with Sparklines
5. Formatting Your Way to Visualizations
6. The Pivotal Pivot Table
Part 3: Building Advanced Dashboard Components.
7. Charts That Show Trending.
8. Grouping and Bucketing Data.
9. Displaying Performance Against a Target.
Part 4: Advanced Reporting Techniques.
10. Macro-Charged Reporting.
11. Giving Users an Interactive Interface.
12. Adding Interactivity with Pivot Slicers
Part 5: Working with the Outside World.
13. Using External Data for Your Dashboards and Reports.
14. Sharing Your Work with the Outside World.
Part 6: The Part of Tens.
15. Ten Chart Design Principles.
16. Ten Excel Chart Types and When to Use Them.
Index.
Anderen die dit boek kochten, kochten ook
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan