商品描述
Filled with tips, tricks, and techniques, this easy-to-use book is the perfect resource for intermediate to advanced users of Excel. You'll find complete recipes for more than a dozen topics covering formulas, PivotTables, charts, Power Query, and more. Each recipe poses a particular problem and outlines a solution that you can put to use right away--without having to comb through tutorial pages.
Whether you're a data analyst, project manager, or financial analyst, author Dawn Griffiths directs you straight to the answers you need. Ideal as a quick reference, Excel Cookbook is also perfect for learning how to work in a more efficient way, leading to greater productivity on the job. With this book, you'll jump in and get answers to your questions--fast.
This cookbook shows you how to:
- Get the most out of Excel's features
- Address complex data problems in the best way possible
- Collect, manage, and analyze data from a variety of sources
- Use functions and formulas with ease--including dynamic array and lambda formulas
- Analyze data with PivotTables, Power Pivot, and more
- Import and transform data with Power Query
- Write custom functions and automate Excel with VBA
商品描述(中文翻譯)
這本易於使用的書籍充滿了技巧、竅門和技術，是中級到高級 Excel 使用者的完美資源。您將找到超過十幾個主題的完整食譜，涵蓋公式、樞紐分析表、圖表、Power Query 等等。每個食譜都提出了一個特定的問題，並概述了一個您可以立即使用的解決方案，而無需翻閱教學頁面。
無論您是數據分析師、專案經理還是財務分析師，作者 Dawn Griffiths 都會直接引導您找到所需的答案。作為快速參考的理想選擇，《Excel 食譜》也非常適合學習如何以更高效的方式工作，從而提高工作生產力。通過這本書，您將迅速找到問題的答案。
這本食譜將教您如何：
- 充分利用 Excel 的功能
- 以最佳方式解決複雜的數據問題
- 從各種來源收集、管理和分析數據
- 輕鬆使用函數和公式，包括動態陣列和 lambda 公式
- 使用樞紐分析表、Power Pivot 等分析數據
- 使用 Power Query 導入和轉換數據
- 編寫自定義函數並使用 VBA 自動化 Excel
