Excel Cookbook

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 awaywithout 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 questionsfast.This cookbook shows you how to:Get the most out of Excel's featuresAddress complex data problems in the best way possibleCollect, manage, and analyze data from a variety of sourcesUse functions and formulas with easeincluding dynamic array and lambda formulasAnalyze data with PivotTables, Power Pivot, and moreImport and transform data with Power QueryWrite custom functions and automate Excel with VBA