{"product_id":"excel-functions-and-formulas-pocketbook-zico-pratama-putra-9781975862596","title":"Excel Functions and Formulas Pocketbook","description":"\u003cp\u003eGeared toward the intermediate to advanced Excel 2016 user, this pocketbook provides explanations and context for many powerful Excel 2016 spreadsheet formulas and functions. Step-by-step instructions for many formula\/function-related features such as using range names, and Excel's troubleshooting features. Focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Microsoft Excel 2016. This guide is suitable as a training handout, or simply an easy to use reference guide. \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cstrong\u003eTopics include: \u003c\/strong\u003e\u003cbr\u003e\u003col\u003e\n\u003cli\u003eControlling Order of Precedence\u003c\/li\u003e\n\u003cli\u003eConditionally Summing\/Counting Data (SUMIF, COUNTIF)\u003c\/li\u003e\n\u003cli\u003eBeing Precise (Rounding functions)\u003c\/li\u003e\n\u003cli\u003eImproving Clarity with Range Names: Creating Names, Limiting Scope, Defining a Constant or Formula for a Name, Managing Names, Indirectly Referring to a Named Range (INDIRECT)\u003c\/li\u003e\n\u003cli\u003eNew Functions for Office 365, Mobile \u0026amp; Online (CONCAT, TEXTJOIN, IFS, MAXIFS\/MINIFS, SWITCH)\u003c\/li\u003e\n\u003cli\u003eMerging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE)\u003c\/li\u003e\n\u003cli\u003eChanging Results: IF, AND, OR, NOT\u003c\/li\u003e\n\u003cli\u003eTable Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH)\u003c\/li\u003e\n\u003cli\u003eError Recovery (ISNA, ISERROR)\u003c\/li\u003e\n\u003cli\u003eArray Formulas (Single Cell \u0026amp; Multi-Cell Arrays)\u003c\/li\u003e\n\u003cli\u003eDates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS, EDATE)\u003c\/li\u003e\n\u003cli\u003eUsing a Formula for Data Validation\u003c\/li\u003e\n\u003cli\u003eTroubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing\/Hiding Formulas, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows. \u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cbr\u003e\u003cstrong\u003e\u003cem\u003eExamples: \u003c\/em\u003e\u003c\/strong\u003e \u003cbr\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSumming Selected Data; Being Precise; Merging Text \u0026amp; Numbers; Table Lookups; Table Lookups with IF and ISERROR; Dates \u0026amp; Times; Single- and Multi-Cell Arrays.\u003c\/li\u003e\n\u003cli\u003eImproving Clarity with Range Names: Creating Names, Limiting Scope, Defining a Constant or Formula for a Name, Managing Names, Indirectly Referring to a Named Range (INDIRECT) \u003c\/li\u003e\n\u003cli\u003eNew Functions for Office 365, Mobile \u0026amp; Online (CONCAT, TEXTJOIN, IFS, MAXIFS\/MINIFS, SWITCH) \u003c\/li\u003e\n\u003cli\u003eMerging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE) \u003c\/li\u003e\n\u003cli\u003eChanging Results: IF, AND, OR, NOT \u003c\/li\u003e\n\u003cli\u003eTable Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH) \u003c\/li\u003e\n\u003cli\u003eError Recovery (ISNA, ISERROR) \u003c\/li\u003e\n\u003cli\u003eArray Formulas (Single Cell \u0026amp; Multi-Cell Arrays) \u003c\/li\u003e\n\u003cli\u003eDates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS, EDATE) \u003c\/li\u003e\n\u003cli\u003eUsing a Formula for Data Validation \u003c\/li\u003e\n\u003cli\u003eTroubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing\/Hiding Formulas, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Zico Pratama Putra, Ali Akbar\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1975862597\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781975862596\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\/29\/2017\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 192\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.58lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.02h x 5.98w x 0.41d","brand":"Zico Pratama Putra","offers":[{"title":"Paperback","offer_id":46825820422399,"sku":"9781975862596","price":12.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_9262ef55-649a-4ae6-a89d-8a6acb831101.jpg?v=1746073721","url":"https:\/\/www.whiterainbookhouse.com\/products\/excel-functions-and-formulas-pocketbook-zico-pratama-putra-9781975862596","provider":"WR Book House","version":"1.0","type":"link"}