{"product_id":"excel-functions-and-formulas-pocketbook-paperback-1","title":"Excel Functions and Formulas Pocketbook - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eZico Pratama Putra\u003c\/b\u003e (Author), \u003cb\u003eAli Akbar\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\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\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 192\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.41 x 9.02 x 5.98 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e August 29, 2017\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":48639495471353,"sku":"9781975862596","price":17.53,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/MR2ArnK5zD9781975862596.webp?v=1783308199","url":"https:\/\/bookscloud.io\/products\/excel-functions-and-formulas-pocketbook-paperback-1","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}