Excel 2013 Charts and Graphs (Paperback)

Bill Jelen

  • 出版商: QUE
  • 出版日期: 2013-02-14
  • 售價: $1,670
  • 貴賓價: 9.5$1,587
  • 語言: 英文
  • 頁數: 464
  • 裝訂: Paperback
  • ISBN: 0789748622
  • ISBN-13: 9780789748621
  • 相關分類: Excel
  • 海外代購書籍(需單獨結帳)

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

商品描述

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.

商品描述(中文翻譯)

使用Excel 2013創建令人驚嘆的圖表、圖形和其他數據可視化,並比以往更有效地傳達最複雜的數據!在《Excel 2013圖表和圖形》中,兩位世界級的Excel專家Bill Jelen('MrExcel')和Michael Alexander將詳細介紹如何充分利用Excel 2013的前所未有的視覺特性。他們解釋了何時以及如何使用每種類型的Excel圖表,然後演示如何創建出色的視覺效果並使用主題、顏色和效果進行自定義。學習如何:

* 設計直觀準確的美麗圖表
* 充分利用Excel 2013的新推薦圖表功能
* 使用主題、顏色、金屬效果、陰影、透明度等功能
* 使用IGX創建有效的業務流程圖
* 製作能夠顯示趨勢、差異和關係的圖表
* 創建有效的股票分析圖表
* 使用Excel靈活的樞紐圖表
* 在地圖上呈現地理數據
* 將產品視覺效果整合到圖表中
* 充分利用Sparklines和其他單元格內可視化功能
* 使用SmartArt將圖像和形狀融入圖表
* 將圖表導出以在Excel之外使用
* 使用Excel VBA自動生成動態自定義圖表
* 甚至評估Excel圖表的真實性 - 並識別何時被欺騙!

本指南是MrExcel's Library系列的一部分,由著名的Excel專家Bill Jelen編輯,他還是極受歡迎的Excel幫助網站MrExcel.com的主持人。