{"product_id":"the-microsoft-excel-step-by-step-training-c-j-benton-9781518628757","title":"The Microsoft Excel Step-By-Step Training Guide Book Bundle","description":"\u003cb\u003e3 books in 1 a consolidation of three books in the Microsoft(R) Excel(R) Step-By-Step Training Guide Series \u003c\/b\u003e \u003cp\u003e This book bundle offers easy to follow examples with screenshots demonstrating how to use the most common basic and intermediate \u003cb\u003eMicrosoft(R) Excel(R)\u003c\/b\u003e formulas \u0026amp; features, including \u003cb\u003ePivot Tables\u003c\/b\u003e, \u0026amp; the \u003cb\u003eVLOOKUP\u003c\/b\u003e formula. The book bundle is organized into \u003cb\u003e6 step-by-step\u003c\/b\u003e sections, allowing you to grow your knowledge of Microsoft(R) Excel(R) at your own pace. \u003c\/p\u003e\u003cp\u003e In addition to the following, this book bundle 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 \u0026amp; NETWORKDAYS \u003c\/li\u003e\u003cli\u003eSUMIF \u003cp\u003e \u003cb\u003ePart 2 - Pivot Tables \u0026amp; Dashboards\u003c\/b\u003e \u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eOrganize and summarize data \u003c\/li\u003e\u003cli\u003eFormat results \u003c\/li\u003e\u003cli\u003eInsert Pivot Charts \u003c\/li\u003e\u003cli\u003eDisplay averages \u0026amp; percentages \u003c\/li\u003e\u003cli\u003eGroup data into predefined ranges \u003c\/li\u003e\u003cli\u003eRank results \u003c\/li\u003e\u003cli\u003eInsert calculated fields \u003c\/li\u003e\u003cli\u003eHow to create and update a basic Dashboard using Pivot Table data \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 Formulas\u003c\/b\u003e \u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eIF \u003c\/li\u003e\u003cli\u003eNested IF \u003cp\u003e \u003cb\u003ePart 6 - The VLOOKUP Formula\u003c\/b\u003e \u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eWhat the VLOOKUP formula does \u003c\/li\u003e\u003cli\u003eThe parts of a VLOOKUP formula \u003c\/li\u003e\u003cli\u003eDetailed examples on how to use the VLOOKUP formula \u003c\/li\u003e\u003cli\u003eIncorporating the IFERROR functionality into your VLOOKUP formula \u003c\/li\u003e\u003cli\u003eHow to apply the VLOOKUP formula across multiple tabs \u0026amp; workbooks \u003c\/li\u003e\u003cli\u003eHow to \u003cb\u003etroubleshoot\u003c\/b\u003e and \u003cb\u003eresolve\u003c\/b\u003e common VLOOKUP errors, including reasons why you may be getting the #N\/A or #REF error\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e C. J. Benton\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1518628753\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781518628757\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 10\/23\/2015\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 246\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.77lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.21h x 6.14w x 0.52d\u003c\/li\u003e","brand":"C. J. Benton","offers":[{"title":"Paperback","offer_id":43979879022847,"sku":"9781518628757","price":17.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_e684c645-f6e7-48d4-857f-cd8aca3f01cf.jpg?v=1683247261","url":"https:\/\/www.whiterainbookhouse.com\/products\/the-microsoft-excel-step-by-step-training-c-j-benton-9781518628757","provider":"WR Book House","version":"1.0","type":"link"}