JELEN
15%
off

JELEN : CHART GRAPHS:MS EXCEL 2010_p1

4.06 (15 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?

Description

Using Excel 2010, it's possible to create breathtaking charts, graphs, and other data visualizations - and communicate even the most complex data more effectively than ever before. In Charts and Graphs, one of the world's leading Excel experts show exactly how to make the most of Excel 2010's unprecedented visual features. Bill Jelen ("MrExcel") explains exactly when and how to use each type of Excel chart, then walks through creating superb visuals and customizing them with themes, colors, and effects. Jelen shows how to craft charts that illuminate trends, differences, and relationships; how to create stock analysis charts; how to use Excel's flexible PivotCharts; and even how to present data on maps with Microsoft MapPoint. You will discover how to make the most of Excel 2010's new Sparklines and other in-cell visualizations; how to incorporate additional images and shapes with SmartArt; how to export charts for use outside of Excel; and how to generate dynamic, customized charts automatically with Excel VBA. There's even a full chapter on assessing the truth of charts created in Excel - and recognizing when someone's trying to lie to you! This book is part of the new MrExcel Library series.



Everything Excel users need to know to communicate visually - from trend analysis to stock charting, geographical mapping to Excel 2010's new In-Cell Data Bars and Sparklines
From basic through leading-edge techniques - including the automatic generation of custom charts with VBA
Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen
show more

Product details

  • Paperback | 480 pages
  • 175.26 x 228.6 x 25.4mm | 725.74g
  • Que Corporation,U.S.
  • Indianapolis, IN, United States
  • English
  • Illustrations, maps
  • 0789743124
  • 9780789743121
  • 406,273

Back cover copy

Using Excel 2010, it's possible to create breathtaking charts, graphs, and other data visualizations - and communicate even the most complex data more effectively than ever before. In Charts and Graphs, one of the world's leading Excel experts show exactly how to make the most of Excel 2010's unprecedented visual features. Bill Jelen ("MrExcel") explains exactly when and how to use each type of Excel chart, then walks through creating superb visuals and customizing them with themes, colors, and effects. Jelen shows how to craft charts that illuminate trends, differences, and relationships; how to create stock analysis charts; how to use Excel's flexible PivotCharts; and even how to present data on maps with Microsoft MapPoint. You will discover how to make the most of Excel 2010's new Sparklines and other in-cell visualizations; how to incorporate additional images and shapes with SmartArt; how to export charts for use outside of Excel; and how to generate dynamic, customized charts automatically with Excel VBA. There's even a full chapter on assessing the truth of charts created in Excel - and recognizing when someone's trying to lie to you! This book is part of the new MrExcel Library series. Everything Excel users need to know to communicate visually - from trend analysis to stock charting, geographical mapping to Excel 2010's new In-Cell Data Bars and Sparklines From basic through leading-edge techniques - including the automatic generation of custom charts with VBA Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen
show more

Table of contents

Introduction
1. Introducing Charts in Excel 2010
2. Customizing Charts
3. Creating Charts that Show Trends
4. Creating Charts that Show Differences
5. Creating Charts that Show Relationships
6. Creating Stock Analysis Charts
7. Advanced Charting Techniques
8. Creating and Using Pivot Charts
9. Using Sparklines, DataBars and Other In-Cell Visualizations
10. Presenting Your Data on a Map using Microsoft MapPoint
11. Using SmartArt Graphics and Shapes
12. Exporting Your Charts for Use Outside of Excel
13. Using Excel VBA to create Charts
14. Knowing When Someone is Lying to You with a Chart
Appendix
show more

About Bill Jelen

Bill Jelen, known worldwide as MrExcel, presents live Excel seminars to accountants throughout the U.S. His 20 books on Microsoft Excel include Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA and Macros for Microsoft Excel. Honored as a Microsoft MVP for Excel, he has produced 500 episodes of his "Learn Excel from MrExcel" video podcast. Michael Alexander, is a Microsoft Certified Application Developer (MCAD), Senior Program Manager for a top Texas technology firm, and principal of DataPigTechnologies, a developer of Excel tutorials. He is author of several books on data analysis with Access and Excel.
show more

Rating details

15 ratings
4.06 out of 5 stars
5 33% (5)
4 47% (7)
3 13% (2)
2 7% (1)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X