Excel Cookbook

Recipes for Mastering Microsoft Excel

von Dawn Griffiths

600 Seiten, Taschenbuch

Kurzbeschreibung des Verlags

Filled with tips, tricks, and techniques, this easy-to-use book is the perfect resource. You'll find more than 350 recipes for over 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, 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. With this book, you'll jump in and get answers to your questions--fast.

- Build compelling charts and use Sparklines, 3D Maps, and other visualizations - Use PivotTables to slice, dice, and summarize datasets - Perform statistical and financial analyses using formulas, Forecast Sheets, the Analysis ToolPak, and more - Master dynamic array functions such as SEQUENCE, TEXTSPLIT, and FILTER - Use Power Query to import, shape, and combine datasets - Create custom functions using LAMBDA formulas - Use developer options to write VBA code and create custom UserForms

• Themen: Informatik und Informationstechnologie Unternehmensanwendungen Tabellenkalkulation
• ISBN: 9781098143329
• Sprache: Englisch
• Erscheinungsdatum: 24.05.2024
• Größe: 231 x 175 mm
• Verlag: O'Reilly Media