Excel Cookbook

Recipes for Mastering Microsoft Excel

By: Dawn Griffiths

Write A Review

eText | 14 May 2024 | Edition Number 1

At a Glance

Format
ePUB

eText

$64.89

or 4 interest-free payments of $16.22 with

Instant online reading in your Booktopia eTextbook Library *

Why choose an eTextbook?

Instant Access *

Purchase and read your book immediately

Read Aloud

Listen and follow along as Bookshelf reads to you

Study Tools

Built-in study tools like highlights and more

* eTextbooks are not downloadable to your eReader or an app and can be accessed via web browsers only. You must be connected to the internet and have no technical issues with your device or browser that could prevent the eTextbook from operating.

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:

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