Excel Cookbook Recipes for Mastering Microsoft Excel

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 array formulas
Analyze data with PivotTables, Power Pivot, and more
Import and transform data with Power Query
Write custom functions and automate Excel with VBA