{"product_id":"excel-functions-and-formulas-pocketbook-paperback","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 (Editor), \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\u003eExamples: Summing Selected Data; Being Precise; Merging Text \u0026amp; Numbers; Table Lookups; Table Lookups with IF and ISERROR; Dates \u0026amp; Times; Single- and Multi-Cell Arrays.\u003cbr\u003e\u003c\/p\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)New Functions for Office 365, Mobile \u0026amp; Online (CONCAT, TEXTJOIN, IFS, MAXIFS\/MINIFS, SWITCH)Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE)Changing Results: IF, AND, OR, NOTTable Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH)Error Recovery (ISNA, ISERROR)Array Formulas (Single Cell \u0026amp; Multi-Cell Arrays)Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS, EDATE)Using a Formula for Data ValidationTroubleshooting: 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. Examples: Summing Selected Data; Being Precise; Merging Text \u0026amp; Numbers; Table Lookups; Table Lookups with IF and ISERROR; Dates \u0026amp; Times; Single- and Multi-Cell Arrays.\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 196\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.42 x 9.02 x 5.98 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e May 21, 2017\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":48297165062393,"sku":"9781521347157","price":17.53,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/QKqti7bkyl9781521347157.webp?v=1776430238","url":"https:\/\/bookscloud.io\/products\/excel-functions-and-formulas-pocketbook-paperback","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}