Griffiths D. Excel Cookbook. Recipes for Mastering Microsoft Excel 2024 torrent

Textbook in PDF format

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
Workbooks, Worksheets, and Cells
References and Structured Data
Using Formulas
Math and Engineering
Text Manipulation
Dates and Times
Array, Logic, and Lookup Functions
Statistical Analysis
The Analysis ToolPak
Financial Analysis
PivotTables
Charts
Graphics, Sparklines, and 3D Maps
What-If Analysis
Power Query
Power Pivot and the Data Model
LET, LAMBDA, and LAMBDA Helper Functions
Developer Tools: Macros, VBA, Controls, and XML
Index