Excel 2016 Formulas and Functions (Paperback)

Paul McFedries

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

商品描述

Book + Content Update Program

Master core Excel 2016 tools for building powerful, reliable spreadsheets with Excel 2016 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel 2016’s core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from AutoFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.

Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.

• Quickly create powerful spreadsheets with range names and array formulas
• Use conditional formatting to instantly reveal anomalies, problems, or opportunities
• Analyze your data with standard tables and PivotTables
• Use complex criteria to filter data in lists
• Understand correlations between data
• Perform sophisticated what-if analyses
• Use regression to track trends and make forecasts
• Build loan, investment, and discount formulas
• Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets

In addition, this book is part of Que’s exciting Content Update Program. As Microsoft updates features of Excel 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit www.quepublishing.com/CUP.

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
 

商品描述(中文翻譯)

《Excel 2016 公式與函數》是一本教授如何使用 Excel 2016 核心功能來解決問題並獲得所需答案的書籍。作者 Paul McFedries 是一位 Excel 專家,透過實際案例,幫助讀者充分利用從 AutoFill 到 Excel 最新函數的功能和改進。在此過程中,你將發現處理日常任務的最快、最佳方法,包括生成帳戶號碼和預測通脹影響等。

成為 Excel 專家從未如此輕鬆!本書提供清晰的指導、內部見解,甚至提供完整的逐步項目,用於建立時間表、預測現金流、計算應收帳款、分析缺陷等。

本書還是 Que 出版社令人興奮的內容更新計劃的一部分。隨著 Microsoft 更新 Excel 2016 的功能,本書的相應部分將進行更新或新增以配合軟體的更新。這些更新將通過本書的免費網絡版傳遞給讀者,只需使用任何互聯網連接即可訪問。欲了解更多信息,請訪問 www.quepublishing.com/CUP。

關於 MrExcel Library:
MrExcel Library 中的每本書都針對特定的關鍵 Excel 任務,提供了快速有效地執行這些任務所需的技巧和示例。這些書籍由 Bill Jelen(Microsoft Excel MVP,也是領先的 Excel 解決方案網站 MrExcel.com 的幕後推手)精心挑選,將:
- 大幅提高您的工作效率,每年節省您 50 小時或更多時間
- 提供經過驗證的創新策略,解決現實世界的問題
- 教您如何獲得出色的結果,無論您有多少數據
- 幫助您避免即使是有經驗的用戶也會犯的重大錯誤。