Home > Store > Home & Office Computing > Microsoft Applications
Charts and Graphs: Microsoft Excel 2010
- By Bill Jelen
- Published Sep 29, 2010 by Que. Part of the MrExcel Library series.
- Copyright 2011
- Dimensions: 7 X 9-1/8
- Pages: 496
- Edition: 1st
- Book
- ISBN-10: 0-7897-4312-4
- ISBN-13: 978-0-7897-4312-1
- eBook (Watermarked)
- ISBN-10: 0-7897-4416-3
- ISBN-13: 978-0-7897-4416-6
Register your product to gain access to bonus material or receive a coupon.
Product Author Bios
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.
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.
|
8 of 8 people found the following review helpful
Fabulous Book!, By
Amazon Verified Purchase(What's this?)
This review is from: Charts and Graphs: Microsoft Excel 2010 (MrExcel Library) (Paperback)
This is an amazing book. I teach Excel, and I don't have time to Google things for hours to learn my trade. Besides the fact that this was the ONLY dedicated Excel 2010 book I could find (I didn't look too hard though), I have to say it is truly a stellar book. Well-organized, great examples, clear and clean writing style - a MUST HAVE!!!So why only 4 stars? Because even though the examples are terrific - they do not include a CD with the book, nor could I find the examples online. Worse, I wanted to recreate the charts in the book but most of the pictures only show the resulting charts and not the data that went into making them. Even a photo of the data sets would allow me to recreate them when I read it - and this is not a book you just are going to pick up and read out of boredom; you want to read for understanding and mastery. I have Mr. Excel's Pivot Table and Number Crunching book; it too is absolutely fabulous but suffers the same problem. In... Read more
9 of 10 people found the following review helpful
easy to understand, By
Amazon Verified Purchase(What's this?)
This review is from: Charts and Graphs: Microsoft Excel 2010 (MrExcel Library) (Kindle Edition)
I got my money's worth from this book in the first few minutes of reading it. I sometimes find Excel's charting feature hard to use. I am a scientist and therefore think in terms of x and y, in terms of dependent and independent variables, and not in terms of "categories" and "series", like Excel. This means I used to have to spend more time than I like getting a graph or chart to look just right for a professional presentation.Not so anymore! This book really helps you quickly understand how Excel gets your data into a graph. It does not waste your time with a lot of verbose text. If you get the Kindle version, you can easily search for just the information you need at the moment. I have the Kindle version, but I have been reading it on an iPad in the computer lab at my university. It is so easy to use and much better than carrying around a heavy book.
6 of 8 people found the following review helpful
Great Book !, By
Amazon Verified Purchase(What's this?)
This review is from: Charts and Graphs: Microsoft Excel 2010 (MrExcel Library) (Paperback)
This is a great book explaining how to design, layout and format Graphs, PivotTables, and Pivot Graphs in Excel 2010. It is easy to read, not too much fluff, and a ton of useable information.Highly recommended |
Online Sample Chapter
Creating Microsoft Excel Charts That Show Trends
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
Sample Pages
Download the sample pages (includes Chapter 3 and Index)
This book includes free shipping!
This book includes free shipping!
eBook (Watermarked)
$31.99
$25.59
This PDF will be accessible from your Account page after purchase and requires the free Adobe® Reader® software to read it.
The eBook requires no passwords or activation to read. We customize your eBook by discretely watermarking it with your name, making it uniquely yours.
- Request an Instructor or Media review copy.
- Corporate, Academic, and Employee Purchases
- International Buying Options
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
