{"product_id":"microsoft-excel-step-by-step-training-guide-book-bundle-book-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\u0026gt;\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\u0026gt;\u003cb\u003eMicrosoft(R) Excel(R)\u003c\/b\u003e formulas \u0026amp; features, including\u0026gt;\u003cb\u003ePivot Tables\u003c\/b\u003e, \u0026amp; the\u0026gt;\u003cb\u003eVLOKUP\u003c\/b\u003e formula. The book bundle is organized into\u0026gt;\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\u0026gt;\u003cb\u003eExcel(R) keyboard shortcuts\u003c\/b\u003e and how to change the currency symbol, for example to the\u0026gt;\u003cb\u003eBritish Pound  \u003c\/b\u003e or\u0026gt;\u003cb\u003eEuro\u0026gt;\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\u0026gt;\u003c\/li\u003e\u003cli\u003eMIN \u0026amp; MAX\u0026gt;\u003c\/li\u003e\u003cli\u003eTODAY \u0026amp; NETWORKDAYS\u0026gt;\u003c\/li\u003e\u003cli\u003eSUMIF\u0026gt;\u003cp\u003e \u003cb\u003ePart 2 - Pivot Tables \u0026amp; Dashboards\u003c\/b\u003e \u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eOrganize and summarize data\u0026gt;\u003c\/li\u003e\u003cli\u003eFormat results\u0026gt;\u003c\/li\u003e\u003cli\u003eInsert Pivot Charts\u0026gt;\u003c\/li\u003e\u003cli\u003eDisplay averages \u0026amp; percentages\u0026gt;\u003c\/li\u003e\u003cli\u003eGroup data into predefined ranges\u0026gt;\u003c\/li\u003e\u003cli\u003eRank results\u0026gt;\u003c\/li\u003e\u003cli\u003eInsert calculated fields\u0026gt;\u003c\/li\u003e\u003cli\u003eHow to create and update a basic Dashboard using Pivot Table data\u0026gt;\u003cp\u003e \u003cb\u003ePart 3 - Excel(R) Features\u003c\/b\u003e \u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eData Sorting\u0026gt;\u003c\/li\u003e\u003cli\u003eFormula Trace\u0026gt;\u003c\/li\u003e\u003cli\u003eText-To-Columns\u0026gt;\u003c\/li\u003e\u003cli\u003eConditional Formatting \u0026amp; Filtering\u0026gt;\u003cp\u003e \u003cb\u003ePart 4 - Text Functions\u003c\/b\u003e \u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eLEN \u0026amp; TRIM\u0026gt;\u003c\/li\u003e\u003cli\u003eCONCATENATE \u0026amp; MID\u0026gt;\u003c\/li\u003e\u003cli\u003ePROPER, UPER, \u0026amp; LOWER\u0026gt;\u003cp\u003e \u003cb\u003ePart 5 - Logic Formulas\u003c\/b\u003e \u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eIF\u0026gt;\u003c\/li\u003e\u003cli\u003eNested IF\u0026gt;\u003cp\u003e \u003cb\u003ePart 6 - The VLOKUP Formula\u003c\/b\u003e \u003c\/p\u003e\n\u003c\/li\u003e\u003cli\u003eWhat the VLOKUP formula does\u0026gt;\u003c\/li\u003e\u003cli\u003eThe parts of a VLOKUP formula\u0026gt;\u003c\/li\u003e\u003cli\u003eDetailed examples on how to use the VLOKUP formula\u0026gt;\u003c\/li\u003e\u003cli\u003eIncorporating the IFEROR functionality into your VLOKUP formula\u0026gt;\u003c\/li\u003e\u003cli\u003eHow to apply the VLOKUP formula across multiple tabs \u0026amp; workbooks\u0026gt;\u003c\/li\u003e\u003cli\u003eHow to\u0026gt;\u003cb\u003etroubleshoot\u003c\/b\u003e and\u0026gt;\u003cb\u003eresolve\u003c\/b\u003e common VLOKUP errors, including reasons why you may be getting the #N\/A or #REF error\u003c\/li\u003e","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":50764208865553,"sku":"CIN1518628753G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51032763400465,"sku":"NIN9781518628757","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1518628753.jpg?v=1751054875","url":"https:\/\/www.worldofbooks.com\/en-gb\/products\/microsoft-excel-step-by-step-training-guide-book-bundle-book-c-j-benton-9781518628757","provider":"World of Books ","version":"1.0","type":"link"}