Excel 2016 In Depth (Paperback)

Bill Jelen

  • 出版商: QUE
  • 出版日期: 2015-10-28
  • 定價: $1,400
  • 售價: 8.0$1,120
  • 語言: 英文
  • 頁數: 656
  • 裝訂: Paperback
  • ISBN: 078975584X
  • ISBN-13: 9780789755841
  • 相關分類: Excel
  • 立即出貨(限量) (庫存=1)

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

商品描述

Excel 2016 In Depth

 

Full Color: Figures and code appear as they do in Excel 2016

Beyond the Basics…Beneath the Surface...In Depth

Do more in less time!

 

Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016. The result is a focused book where every topic is relevant and worth learning. Excel 2016 In Depth is the fastest, smartest way to master Excel 2016’s full power and updated interface. You’ll discover how to leverage Excel’s new tools for charting, business analysis, data visualization, forecasting, and more.

•  Quickly clean your data with Excel 2016’s powerful Get & Transform tools 

•  Discover Excel 2016’s newest charts: waterfall, histogram, Pareto, sunburst, TreeMap, and Box and Whisker 

•  Use Forecast Sheets to forecast the future, including seasonal adjustments 

•  Pivot data on maps with 3D Maps, and animate your maps over time 

•  Create formulas, charts, subtotals, and pivot tables faster than ever 

•  Create amazing PowerPivot data mashups that integrate information from anywhere 

•  Automate repetitive functions using Excel macros 

•  Solve real-world business intelligence analysis problems 

•  Use PowerPivot Data Model to create pivot tables from multiple data sets without VLOOKUP  

•  Share workbooks on the Web and social networks 

•  Leverage Excel to create highly interactive web pages and online surveys 

•  Quickly apply attractive, consistent formats 

 

 

This book is part of Que’s Content Update Program. As Microsoft updates features of Excel, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.

 

 

 

商品描述(中文翻譯)

Excel 2016 In Depth

全彩印刷:圖片和程式碼以Excel 2016的樣子呈現

超越基礎知識...深入探索...深入了解

在更短的時間內做更多事情!

熟悉Excel嗎?不要讓Excel 2016讓你感覺像個初學者!這本暢銷書的全彩印刷版已經完全改版。不再包含不必要和很少使用的內容,重點放在Excel 2016最常用和最新的功能上。結果是一本專注的書,每個主題都是相關且值得學習的。《Excel 2016 In Depth》是掌握Excel 2016全面功能和更新界面的最快、最聰明的方法。您將發現如何利用Excel的新工具進行圖表繪製、業務分析、數據可視化、預測等等。

• 使用Excel 2016強大的取得和轉換工具快速清理數據

• 探索Excel 2016最新的圖表:瀑布圖、直方圖、帕累托圖、日照圖、樹狀圖和盒鬚圖

• 使用預測工作表預測未來,包括季節性調整

• 使用3D地圖在地圖上進行數據樞紐分析,並隨時間動畫顯示地圖

• 比以往更快地創建公式、圖表、小計和樞紐表

• 創建令人驚嘆的PowerPivot數據混搭,整合來自任何地方的信息

• 使用Excel宏自動執行重複的功能

• 解決現實世界的商業智能分析問題

• 使用PowerPivot數據模型從多個數據集創建樞紐表,無需使用VLOOKUP

• 在網絡和社交網絡上共享工作簿

• 利用Excel創建高度互動的網頁和在線調查

• 快速應用吸引人且一致的格式

本書是Que的內容更新計劃的一部分。隨著Microsoft更新Excel的功能,本書的相應部分將進行更新或添加新的部分以配合軟體的更新。詳情請參閱內頁。