Excel Cookbook: Recipes for Mastering Microsoft Excel
by Griffiths, Dawn | New BookDescription
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
| Author(s): | Griffiths, Dawn |
|---|---|
| Book Type: | New Book |
| Format: | Paperback |
| ISBN-10: | 1098143329 |
| EAN: | 9781098143329 |
| Language: | English |
| Number of Pages: | 589 |
| Publication Date: | 2024-06-18 |
| Publisher: | O'Reilly Media |
| Weight: | 2.05 Pounds |
You Might Also Like
Frequently Asked Questions About Excel Cookbook: Recipes for Mastering Microsoft Excel Magazine
There are no reviews for this product.
