{"product_id":"microsoft-excel-2016-functions-formulas-quick-reference-card-windows-version-4-page-cheat-sheet-focusing-on-examples-and-context-for-functions-and-formulas-laminated-guide-1939791979","title":"Microsoft Excel 2016 Functions \u0026 Formulas Quick Reference Card - Windows Version (4-page Cheat Sheet focusing on examples and context for ... functions and formulas - Laminated Guide)","description":"\u003cp\u003e\u003cstrong\u003eISBN:\u003c\/strong\u003e 1939791979\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eAuthor:\u003c\/strong\u003e Beezix Inc\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eCondition:\u003c\/strong\u003e New\u003c\/p\u003e\u003cp\u003eGeared toward the intermediate to advanced Excel 2016 user, this example-rich 4-page laminated card\/guide 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. Written with Beezix's trademark 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.Topics include:Controlling Order of PrecedenceConditionally Summing\/Counting Data (SUMIF, COUNTIF)Being Precise (Rounding functions)Improving 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; Numers; Table Lookups; Table Lookups with IF and ISERROR; Dates \u0026amp; Times; Single- and Multi-Cell Arrays.This guide is one of multiple titles available for Excel 2016, other Excel titles are: Excel 2016 Introduction (ISBN 1939791928); Excel 2016 Charts \u0026amp; Sparklines (ISBN 9781939791955); Excel 2016 Tables, PivotTables, Sorting, Filtering \u0026amp; Inquire (ISBN 9781939791962); Excel 2016 Business Analytics \u0026amp; Power BI (ISBN 9781944684143); Excel 2016 Advanced Features \u0026amp; Macros (ISBN 9781944684082).\u003c\/p\u003e","brand":"Mia Karts","offers":[{"title":"Default Title","offer_id":51885339476256,"sku":"NEW1939791979","price":6.9,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0980\/7426\/3840\/files\/81gVUWXBP3L.jpg?v=1781892432","url":"https:\/\/miakarts.com\/products\/microsoft-excel-2016-functions-formulas-quick-reference-card-windows-version-4-page-cheat-sheet-focusing-on-examples-and-context-for-functions-and-formulas-laminated-guide-1939791979","provider":"Miakarts Books","version":"1.0","type":"link"}