Excel cookbook : recipes for mastering Microsoft Excel / Dawn Griffiths.

Author/creator Griffiths, Dawn author.
Format Book
EditionFirst edition.
PublicationSebastopol, CA : O'Reilly Media, Inc., 2024.
Copyright Date©2024
Descriptionxvi, 572 pages : illustrations ; 24 cm
Subjects

Contents 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, VBAm controls, and XML.
Abstract 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.
General noteIncludes index.
ISBN9781098143329 paperback
ISBN1098143329 paperback

Availability

Library Location Call Number Status Item Actions
Joyner General Stacks HF5548.4 .M523 G75 2024 ✔ Available Place Hold