Use Excel 2013's radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly... so you drive your message home, and get the decisions and actions you're looking for!
This book reveals data visualization techniques you won't find anywhere else and shows you how to use Excel 2013 to create designer-quality charts and graphs that stand out from the crowd. It will help you make the most of new features ranging from Power View to Recommended Charts, and instantly share your insights with anyone, anywhere-even on the Web and social networks.
Learning advanced Excel techniques has never been easier. You'll find simple, step-by-step instructions, real-world
examples and case studies, and more than a dozen YouTube videos, straight from MrExcel!
* Create stunning data visualizations instantly with Excel 2013's new Recommended Charts
* Use charts to instantly reveal trends, differences, and relationships
* Map your data with Excel 2013, MapPoint, and the new GeoFlow add-in
* Quickly generate combo charts that once required complex, frustrating procedures
* Use sparklines to imbue worksheets with more context and insight
* Highlight and clarify the meaning of data with DataBars, color scales, icon sets, and other conditional formatting tools
* Post charts to Facebook, Twitter, or LinkedIn, directly from Excel
* Build stock charts that help you make smarter investments
* Solve "non-standard" problems such as noncontiguous data or custom data sequences
* Generate new charts automatically with Excel VBA
* Uncover visual tricks that people use to lie with Excel
About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks
and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these
books will:
* Dramatically increase your productivity-saving you 50 hours a year or more
* Present proven, creative strategies for solving real-world problems
* Show you how to get great results, no matter how much data you have
* Help you avoid critical mistakes that even experienced users make
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Maße
Höhe: 231 mm
Breite: 174 mm
Dicke: 26 mm
Gewicht
ISBN-13
978-0-7897-4862-1 (9780789748621)
Schweitzer Klassifikation
Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,500 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 39 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. His Excel tips appear regularly in CFO Excel Pro Newsletter and CFO Magazine . Before founding MrExcel.com, Bill Jelen spent 12 years in the trenches--working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary Ellen.
Introduction: Using Excel 2013 to Create Charts
1 Introducing Charts in Excel 2013
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 Chart Techniques
8 Creating Pivot Charts and Power View Dashboards
9 Using Sparklines, Data Visualizations, and Other Nonchart Methods
10 Presenting Excel Data on a Map
11 Using SmartArt Diagrams and Shapes
12 Exporting 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 Charting References
Index
