Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
Excel Cookbook, EPUB eBook

Excel Cookbook EPUB

EPUB

Download - Immediately Available
Please note: eBooks can only be purchased with a UK issued credit card and all our eBooks (ePub and PDF) are DRM protected.

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 awaywithout 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 questionsfast.

This cookbook shows you how to:

  • 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

Information

Other Formats

Save 20%

£40.99

£32.79

Download - Immediately Available
Add to Basket
Sign in to add to wishlist
 
Delivered to your inbox

to transfer to your device

eBook Help

Is this the right eBook for
my device? How do I download
this eBook? See help and FAQs pages

Information