Excel Cookbook
Recipes for Mastering Microsoft Excel
Published on 24. May 2024
Book
Paperback/Softback
600 pages
978-1-0981-4332-9 (ISBN)
Description
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 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
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 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
More details
Language
English
Place of publication
Sebastopol
United States
Product notice
Paperback (trade)
Unsewn / adhesive bound
Dimensions
Height: 231 mm
Width: 175 mm
Thickness: 35 mm
Weight
1018 gr
ISBN-13
978-1-0981-4332-9 (9781098143329)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Person
Dawn Griffiths is an author and trainer with over 20 years Excel experience. She delivers live, online training on Excel through the OaReilly learning platform, and she has written many books, including Head First Statistics, Head First Android Development, Head First Kotlin and React Cookbook. Dawn also developed the animated video course The Agile Sketchpad with her husband, David, as a way of teaching key concepts and techniques in a way that keeps your brain active and engaged.