相關主題
商品描述
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 Cookbook也非常適合學習如何以更高效的方式工作，從而提高工作效率。通過這本書，您可以快速獲得問題的答案。
這本食譜書向您展示如何：
- 充分利用Excel的功能
- 以最佳方式解決複雜的數據問題
- 從各種來源收集、管理和分析數據
- 輕鬆使用函數和公式，包括動態數組和lambda公式
- 使用樞紐分析表、Power Pivot等分析數據
- 使用Power Query導入和轉換數據
- 編寫自定義函數並使用VBA自動化Excel
