{"product_id":"step-by-step-guide-to-the-25-most-common-microsoft-excel-formulas-features-book-c-j-benton-9781516960644","title":"The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas \u0026 Features","description":"\u003cb\u003eLearn the 25 most common Microsoft(R) Excel(R) Formulas \u0026amp; Features quickly and easily with this detailed step-by-step guide\u0026gt;\u003c\/b\u003e\u003cp\u003eThis book offers easy to follow examples with\u0026gt;\u003cb\u003escreenshots\u003c\/b\u003e demonstrating how to use the 25 most common\u0026gt;\u003ci\u003ebasic\u003c\/i\u003e and\u0026gt;\u003ci\u003eintermediate\u003c\/i\u003e Microsoft(R) Excel(R) formulas \u0026amp; features. The book is organized into\u0026gt;\u003cb\u003e5 step-by-step sections\u003c\/b\u003e, allowing you to grow your knowledge of Excel(R) at your own pace: \u003c\/p\u003e\u003cp\u003e \u003cb\u003e****Excel v2016 is now available, with 5 bonus formulas included****\u003c\/b\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePart 1 - Excel(R) Formula Fundamentals\u003c\/b\u003e\u003c\/p\u003e\u003cli\u003eSUM, SUBTRACTION, MULTIPLICATION, \u0026amp; DIVISION\u0026gt;\u003c\/li\u003e\u003cli\u003eAVERAGE\u003c\/li\u003e\u003cli\u003eMIN \u0026amp; MAX\u0026gt;\u003c\/li\u003e\u003cli\u003eTODAY \u0026amp; NETWORKDAYS\u003c\/li\u003e\u003cli\u003eSUMIF\u0026gt;\u003cp\u003e\u003cb\u003ePart 2 - Introduction to Pivot Tables\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eHow to create a basic Pivot Table\u003c\/li\u003e\u003cli\u003eFormatting Pivot Table results\u003c\/li\u003e\u003cli\u003eInserting Pivot Charts\u003cp\u003e\u003cb\u003ePart 3 - Excel(R) Features\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eData Sorting\u003c\/li\u003e\u003cli\u003eFormula Trace\u003c\/li\u003e\u003cli\u003eText-To-Columns\u003c\/li\u003e\u003cli\u003eConditional Formatting \u0026amp; Filtering\u003cp\u003e\u003cb\u003ePart 4 - Text Functions\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eLEN \u0026amp; TRIM\u003c\/li\u003e\u003cli\u003eCONCATENATE \u0026amp; MID\u003c\/li\u003e\u003cli\u003ePROPER, UPER, \u0026amp; LOWER\u003cp\u003e\u003cb\u003ePart 5 - Logic \u0026amp; Lookup Formulas\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eIF\u003c\/li\u003e\u003cli\u003eNested IF\u003c\/li\u003e\u003cli\u003eVLOKUP\u003cp\u003eImagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using of Microsoft(R) Excel(R) \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBook 1 in The Microsoft Excel Step-By-Step Training Guide Series\u0026gt;\u003c\/b\u003e\u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003e\n\u003cb\u003eBook 1\u003c\/b\u003e - The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas \u0026amp; Features\u003c\/li\u003e\u003cli\u003e\n\u003cb\u003eBook 2\u003c\/b\u003e - The Step-By-Step Guide To Pivot Tables \u0026amp; Introduction To Dashboards\u003c\/li\u003e\u003cli\u003e\n\u003cb\u003eBook 3\u003c\/b\u003e - The Step-By-Step Guide To The VLOKUP formula in Microsoft Excel\u003c\/li\u003e\u003cli\u003e\n\u003cb\u003eBook 4\u003c\/b\u003e - The Microsoft Excel Step-By-Step Training Guide Book Bundle\u003c\/li\u003e","brand":"WoB","offers":[{"title":"GB \/ GOOD \/ INTERNAL","offer_id":49664812908817,"sku":"GOR007236155","price":10.0,"currency_code":"USD","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50388363706641,"sku":"CIN1516960645VG","price":10.34,"currency_code":"USD","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50558374805777,"sku":"CIN1516960645G","price":15.55,"currency_code":"USD","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51032400134417,"sku":"NIN9781516960644","price":9.99,"currency_code":"USD","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":52108680167697,"sku":"GOR007240778","price":10.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1516960645.jpg?v=1750717874","url":"https:\/\/www.worldofbooks.com\/products\/step-by-step-guide-to-the-25-most-common-microsoft-excel-formulas-features-book-c-j-benton-9781516960644","provider":"World of Books ","version":"1.0","type":"link"}