買這商品的人也買了...
-
Excel 2013 VBA and Macros (Paperback)$1,690$1,606 -
ERP 企業資源規劃導論, 6/e$790$624
相關主題
商品描述
Excel expert Paul McFedries shows how to use Excel 2013’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 FlashFill 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 FlashFill
• 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
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
CATEGORY: Spreadsheets
COVERS: Microsoft Office Excel 2013
商品描述(中文翻譯)
掌握 Excel 2013 的核心工具，打造強大且可靠的電子表格！
Excel 專家 Paul McFedries 展示如何使用 Excel 2013 的核心功能來解決問題並獲得所需的答案。透過真實世界的範例，McFedries 幫助您充分利用從 FlashFill 到 Excel 最新功能的各項特性和改進。在這個過程中，您將發現處理日常任務的最快、最佳方法，從生成帳號到預測通貨膨脹的影響。
成為 Excel 專家從未如此簡單！您將找到清晰明瞭的指示；內部見解；甚至完整的逐步專案，幫助您建立工時表、預測現金流、應收帳款老化、分析缺陷等。
• 迅速使用 FlashFill 創建強大的電子表格
• 使用條件格式化即時揭示異常、問題或機會
• 使用標準表格和樞紐分析表分析數據
• 使用複雜條件過濾列表中的數據
• 理解數據之間的相關性
• 執行複雜的假設分析
• 使用回歸分析追蹤趨勢並進行預測
• 建立貸款、投資和折扣公式
• 驗證數據、排除問題，並建立更準確、可靠的電子表格
關於 MrExcel 圖書館：每本 MrExcel 圖書館的書籍都針對一組特定的關鍵 Excel 任務，並提供專注的技能和範例，以快速有效地執行這些任務。這些書籍由 Microsoft Excel MVP 及領先 Excel 解決方案網站 MrExcel.com 的創始人 Bill Jelen 精選，將會：
• 顯著提高您的生產力—每年節省 50 小時或更多
• 提供解決現實問題的經驗豐富且創新的策略
• 教您如何獲得優異的結果，無論您擁有多少數據
• 幫助您避免即使是經驗豐富的使用者也會犯的關鍵錯誤
類別：電子表格
涵蓋：Microsoft Office Excel 2013
