Excel Cookbook

Recipes for Mastering Microsoft Excel
Dawn Griffiths · O'Reilly Media · 2024
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 featuresAddress complex data problems in the best way possibleCollect, manage, and analyze data from a variety of sourcesUse functions and formulas with ease-including 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
Uus kasutamata raamat
Detailid
- Alapealkiri
- Recipes for Mastering Microsoft Excel
- Autor
- Dawn Griffiths
- ISBN
- 9781098143329
- Aasta
- 2024
- Kirjastus
- O'Reilly Media
- Keel
- inglise
- Köide
- Pehme kaas
- Lehekülgi
- 600
- Teema
- Arvutid ja infotehnoloogia › Äritarkvara — Business applications
- Kaal
- 1.01 kg