Charts and Graphs: Microsoft Excel 2010 (Paperback)

Bill Jelen

  • 出版商: QUE
  • 出版日期: 2010-10-05
  • 定價: $1,320
  • 售價: 2.3$299
  • 語言: 英文
  • 頁數: 480
  • 裝訂: Paperback
  • ISBN: 0789743124
  • ISBN-13: 9780789743121
  • 相關分類: Excel
  • 立即出貨(限量) (庫存=1)

買這商品的人也買了...

商品描述

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
  • 商品描述(中文翻譯)

    使用Excel 2010,您可以創建令人驚嘆的圖表、圖形和其他數據可視化,比以往更有效地傳達最複雜的數據。在《圖表和圖形》中,世界領先的Excel專家之一Bill Jelen('MrExcel')將詳細介紹如何充分利用Excel 2010的前所未有的視覺功能。Jelen解釋了何時以及如何使用每種類型的Excel圖表,然後演示了如何創建出色的視覺效果並使用主題、顏色和效果進行自定義。Jelen展示了如何製作能夠顯示趨勢、差異和關係的圖表;如何創建股票分析圖表;如何使用Excel靈活的PivotCharts;甚至如何使用Microsoft MapPoint在地圖上呈現數據。您將了解如何充分利用Excel 2010的新功能Sparklines和其他單元格內可視化效果;如何使用SmartArt將其他圖像和形狀融入其中;如何將圖表導出以在Excel之外使用;以及如何使用Excel VBA自動生成動態的自定義圖表。書中還有一整章關於評估在Excel中創建的圖表的真實性,以及如何識別有人試圖欺騙您的情況!本書是新的MrExcel Library系列的一部分。

    Excel用戶需要了解的所有視覺傳達知識,從趨勢分析到股票圖表、地理映射到Excel 2010的新功能In-Cell Data Bars和Sparklines
    從基礎到尖端技術,包括使用VBA自動生成自定義圖表
    由Excel傳奇人物Bill Jelen編輯的全新MrExcel Library系列的一部分