Sale!

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)

Amazon.com Price:  $4.80 (as of 17/03/2019 20:30 PST- Details)

Categories: , , , , , , , ,

Description

Geared toward the intermediate to advanced Excel 2016 user, this example-rich 4-page laminated card/guide provides explanations and context for plenty of powerful Excel 2016 spreadsheet formulas and functions. Step by step instructions for plenty of formula/function-related features such as The usage of range names, and Excel’s troubleshooting features. Written with Beezix’s trademark focal point on clarity, accuracy, and the user’s perspective, this guide will be a valuable resource to toughen your proficiency in The usage of Microsoft Excel 2016. This guide is suitable as a training handout, or simply a very simple to use reference guide.

Topics include:

 Controlling Order of Precedence
Conditionally Summing/Counting Data (SUMIF, COUNTIF)
Being Precise (Rounding functions)
Bettering Clarity with Range Names: Creating Names, Limiting Scope, Defining a Constant or Formula for a Name, Managing Names, Not directly Referring to a Named Range (INDIRECT)
New Functions for Office 365, Mobile & 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, NOT
Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH)
Error Recovery (ISNA, ISERROR)
Array Formulas (Single Cell & Multi-Cell Arrays)
Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAYS, EDATE)
The usage of a Formula for Data Validation
Troubleshooting: Types of Errors, Automatic Error Checking, The usage of 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 & Numers; Table Lookups; Table Lookups with IF and ISERROR; Dates & Times; Single- and Multi-Cell Arrays.

This guide is one of more than one titles to be had for Excel 2016, other Excel titles are: Excel 2016 Introduction (ISBN 1939791928); Excel 2016 Charts & Sparklines (ISBN 9781939791955); Excel 2016 Tables, PivotTables, Sorting, Filtering & Inquire (ISBN 9781939791962); Excel 2016 Business Analytics & Power BI (ISBN 9781944684143); Excel 2016 Advanced Features & Macros (ISBN 9781944684082).

Related products

Home » Shop » Automotive » Tools and Equipment » Diagnostic and Test Tools » Software » Microsoft » Microsoft Excel » 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)

Recent Products