{"product_id":"excel-2016-the-30-most-c-j-benton-9781546500247","title":"Excel 2016 The 30 Most Common Formulas \u0026 Features - The Step-By-Step Guide","description":"\u003cb\u003eIn just a few short hours, learn the 30 most common Microsoft(R) Excel(R) Formulas \u0026amp; Features quickly and easily with this detailed step-by-step guide!\u003c\/b\u003e \u003cp\u003e \u003cb\u003eUpdated for Excel(R) 2016\u003c\/b\u003e this book offers easy to follow examples with \u003cb\u003escreenshots\u003c\/b\u003e demonstrating how to use the 30 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\u003eExercise Files Included!\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e In addition to the following, this book also includes sections on \u003cb\u003eExcel(R) keyboard shortcuts\u003c\/b\u003e and how to change the currency symbol, for example to the \u003cb\u003eBritish Pound  \u003c\/b\u003e or \u003cb\u003eEuro \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, NOW, \u0026amp; NETWORKDAYS \u003c\/li\u003e\u003cli\u003eSUMIF, AVERAGEIF, COUNTIF, \u0026amp; COUNTIFS \u003cp\u003e \u003cb\u003ePart 2 - Introduction to Pivot Tables\u003c\/b\u003e \u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eHow to create a Pivot Table report \u003c\/li\u003e\u003cli\u003eFormatting Pivot Table results \u003c\/li\u003e\u003cli\u003eAdding 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\u003eConditional Formatting \u0026amp; Filtering \u003c\/li\u003e\u003cli\u003eData Validation \u003c\/li\u003e\u003cli\u003eText-To-Columns \u003c\/li\u003e\u003cli\u003eFormula Trace \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\u003eCONCATE (CONCATENATE) \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\u003eAND \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 Microsoft(R) Excel(R)!\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e C. J. Benton\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1546500243\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781546500247\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 05\/09\/2017\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 118\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.39lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.21h x 6.14w x 0.25d\u003c\/p\u003e\n\u003c\/li\u003e","brand":"C. J. Benton","offers":[{"title":"Paperback","offer_id":47520547373311,"sku":"9781546500247","price":10.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_54ed0319-8041-474b-ab20-a76c67511e78.jpg?v=1762885735","url":"https:\/\/www.whiterainbookhouse.com\/products\/excel-2016-the-30-most-c-j-benton-9781546500247","provider":"WR Book House","version":"1.0","type":"link"}