Professional >> Engineering and Computer Science >> Computer Science >> Microsoft Technologies


Excel 2013 Charts and Graphs

Excel 2013 Charts and Graphs

Author(s):
  • Bill Jelen
    • Author: Bill Jelen
    • ISBN:9789332523944
    • 10 Digit ISBN:9332523940
    • Price:Rs. 1205.00
    • Pages:464
    • Imprint:Pearson Education
    • Binding:Paperback
    • Status:Available


    Be the first to rate the book !!

    Use Excel 2013's radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly&hellip 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!

     

    Table of Content

    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
     

    Salient Features

    The first practical, hands-on guide to getting the most out of Excel 2013's jaw-dropping charts, graphs, and other visual tools!
    • Everything Excel users need to know to communicate visually - from trend analysis to stock charting, geographical mapping to displaying product pictures
    • Shows how to make the most of Excel 2013's new Recommended Charts, Quick Analysis, and chart formatting features
    • From basic through leading-edge techniques - including automatic generation of custom charts with VBA
    • Part of Bill Jelen's popular MrExcel's Library series!