menu
{ "item_title" : "Excel Cookbook", "item_author" : [" Dawn Griffiths "], "item_description" : "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 visualizationsUse PivotTables to slice, dice, and summarize datasetsPerform statistical and financial analyses using formulas, Forecast Sheets, the Analysis ToolPak, and moreMaster dynamic array functions such as SEQUENCE, TEXTSPLIT, and FILTERUse Power Query to import, shape, and combine datasetsCreate custom functions using LAMBDA formulasUse developer options to write VBA code and create custom UserForms", "item_img_path" : "https://covers2.booksamillion.com/covers/bam/1/09/814/332/1098143329_b.jpg", "price_data" : { "retail_price" : "65.99", "online_price" : "65.99", "our_price" : "65.99", "club_price" : "65.99", "savings_pct" : "0", "savings_amt" : "0.00", "club_savings_pct" : "0", "club_savings_amt" : "0.00", "discount_pct" : "10", "store_price" : "" } }
Excel Cookbook|Dawn Griffiths

Excel Cookbook : Recipes for Mastering Microsoft Excel

local_shippingShip to Me
In Stock.
FREE Shipping for Club Members help

Overview

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

Details

  • ISBN-13: 9781098143329
  • ISBN-10: 1098143329
  • Publisher: O'Reilly Media
  • Publish Date: June 2024
  • Dimensions: 9.19 x 7 x 1.2 inches
  • Shipping Weight: 2.05 pounds
  • Page Count: 589

Related Categories

You May Also Like...

    1

BAM Customer Reviews