 Название: Excel Cookbook: Recipes for Mastering Microsoft Excel (Final Release)
Автор: Dawn Griffiths
Издательство: O’Reilly Media, Inc.
Год: 2024
Страниц: 592
Язык: английский
Формат: pdf (true), epub (true)
Размер: 18.3 MB, 16.9 MB
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.
This book contains more than 350 recipes designed to help you get the most out of Microsoft Excel, whether you’re writing formulas, importing data, wrangling with PivotTables, or solving complex optimization problems. The recipes result from my over 20 years of experience using Excel and teaching it to thousands of students worldwide.
Each recipe solves a specific problem using one or more techniques, and nearly every recipe uses examples to illustrate the teaching points. You can test the examples for yourself and then put them into practice by applying them to your situation.
You don’t have to read the chapters or their recipes in any particular order, so you can read the book from cover to cover or start reading anywhere. Many recipes reference others, so you can quickly jump from one to another.
The book includes the latest features of Excel 365 (at the time of writing), such as LAMBDA functions. However, it’s also backward compatible with earlier versions. For example, it covers the XMATCH function available in Excel 2021 and Excel 365 and the MATCH function available in earlier versions. This book also includes differences in using Excel for Microsoft Windows and Excel for Mac, such as how to change the default settings.
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
Who’s it for?
Whether you’re a data analyst, project manager, financial analyst, or regular Excel user, 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.
Contents:
Preface
1. Workbooks, Worksheets, and Cells
2. References and Structured Data
3. Using Formulas
4. Math and Engineering
5. Text Manipulation
6. Dates and Times
7. Array, Logic, and Lookup Functions
8. Statistical Analysis
9. The Analysis ToolPak
10. Financial Analysis
11. PivotTables
12. Charts
13. Graphics, Sparklines, and 3D Maps
14. What-If Analysis
15. Power Query
16. Power Pivot and the Data Model
17. LET, LAMBDA, and LAMBDA Helper Functions
18. Developer Tools: Macros, VBA, Controls, and XML
Index
Скачать Excel Cookbook: Recipes for Mastering Microsoft Excel (Final Release)
True PDF:
True ePub:
|
Навигация
Вход на сайт
Реклама
Excel Cookbook: Recipes for Mastering Microsoft Excel (Final Release) 
