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. 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. 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.