Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    What I'm Giving | November 28, 2014

    Eleanor Catton: IMG Eleanor Catton: What I'm Giving



    At Powell's, we feel the holidays are the perfect time to share our love of books with those close to us. For this special blog series, we reached... Continue »

    spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton COMP- WIN APPS A- Z
2 Local Warehouse Personal Computers- Desktop Applications- Spreadsheets
11 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Excel 2013 Charts and Graphs (MrExcel Library)

by

Excel 2013 Charts and Graphs (MrExcel Library) Cover

 

Synopses & Reviews

Publisher Comments:

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

Synopsis:

Use Excel 2013 to create breathtaking charts, graphs, and other data visualizations - and communicate even the most complex data more effectively than ever before!

 

In Excel 2013 Charts and Graphs, two world-class Excel experts show exactly how to make the most of Excel 2013's unprecedented visual features. Bill Jelen ("MrExcel") and Michael Alexander explain when and how to use each type of Excel chart, then walk through creating superb visuals and customizing them with themes, colors, and effects. Learn how to:

 

* Design beautiful charts that communicate intuitively and accurately

* Make the most of Excel 2013's new Recommended Charts feature

* Use themes, colors, metallic effects, shadows, transparency, and more

* Build effective business flowcharts with IGX

* Craft charts that illuminate trends, differences, and relationships

* Create effective stock analysis charts

* Use Excel's flexible PivotCharts

* Present geographical data on maps

* Integrate product visuals into your charts

* Make the most of Sparklines and other in-cell visualizations

* Incorporate images and shapes with SmartArt

* Export charts for use outside of Excel

* Generate dynamic, customized charts automatically with Excel VBA

* Even assess the truth of Excel charts — and recognize when you're being lied to!

 

This guide is part of the MrExcel's Library series, edited by Bill Jelen, renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

About the Author

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.

Table of Contents

Introduction

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 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

Product Details

ISBN:
9780789748621
Author:
Jelen, Bill
Publisher:
Que
Subject:
Spreadsheets - General
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
Trade paper
Series:
MrExcel Library
Publication Date:
20130318
Binding:
TRADE PAPER
Language:
English
Pages:
464
Dimensions:
9.125 x 7 x 0.97 in 708 gr

Other books you might like

  1. Excel 2013 Formulas and Functions... New Trade Paper $39.99
  2. Middle C
    Used Hardcover $14.95
  3. Curiosity: How Science Became... Used Hardcover $17.50
  4. All That Is
    Used Hardcover $13.50
  5. Library of America #238: Aldo... Sale Hardcover $24.98
  6. Red Doc> Used Hardcover $17.50

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Excel 2013 Charts and Graphs (MrExcel Library) New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 464 pages Que Pub. - English 9780789748621 Reviews:
"Synopsis" by ,

Use Excel 2013 to create breathtaking charts, graphs, and other data visualizations - and communicate even the most complex data more effectively than ever before!

 

In Excel 2013 Charts and Graphs, two world-class Excel experts show exactly how to make the most of Excel 2013's unprecedented visual features. Bill Jelen ("MrExcel") and Michael Alexander explain when and how to use each type of Excel chart, then walk through creating superb visuals and customizing them with themes, colors, and effects. Learn how to:

 

* Design beautiful charts that communicate intuitively and accurately

* Make the most of Excel 2013's new Recommended Charts feature

* Use themes, colors, metallic effects, shadows, transparency, and more

* Build effective business flowcharts with IGX

* Craft charts that illuminate trends, differences, and relationships

* Create effective stock analysis charts

* Use Excel's flexible PivotCharts

* Present geographical data on maps

* Integrate product visuals into your charts

* Make the most of Sparklines and other in-cell visualizations

* Incorporate images and shapes with SmartArt

* Export charts for use outside of Excel

* Generate dynamic, customized charts automatically with Excel VBA

* Even assess the truth of Excel charts — and recognize when you're being lied to!

 

This guide is part of the MrExcel's Library series, edited by Bill Jelen, renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.