{"product_id":"the-step-by-step-guide-to-the-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!\u003c\/b\u003e\u003cp\u003eThis book offers easy to follow examples with \u003cb\u003escreenshots\u003c\/b\u003e demonstrating how to use the 25 most common \u003ci\u003ebasic\u003c\/i\u003e and \u003ci\u003eintermediate\u003c\/i\u003e Microsoft(R) Excel(R) formulas \u0026amp; features. The book is organized into \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 \u003c\/li\u003e\u003cli\u003eAVERAGE\u003c\/li\u003e\u003cli\u003eMIN \u0026amp; MAX \u003c\/li\u003e\u003cli\u003eTODAY \u0026amp; NETWORKDAYS\u003c\/li\u003e\u003cli\u003eSUMIF \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, UPPER, \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\u003eVLOOKUP\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 \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 VLOOKUP 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\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e C. J. Benton\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1516960645\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781516960644\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Createspace Independent Publishing Platform\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 08\/24\/2015\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 130\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.42lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.21h x 6.14w x 0.28d\u003c\/li\u003e","brand":"C. J. Benton","offers":[{"title":"Paperback","offer_id":43985416356095,"sku":"9781516960644","price":9.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_95ff6ce3-c3f4-4f41-b33a-f87846f3651a.jpg?v=1683277443","url":"https:\/\/www.whiterainbookhouse.com\/products\/the-step-by-step-guide-to-the-c-j-benton-9781516960644","provider":"WR Book House","version":"1.0","type":"link"}