Geared 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 ...
Read More
Geared 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. Topics include: Controlling Order of Precedence Conditionally 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 & 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) Using a Formula for Data Validation Troubleshooting: 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 & Numbers; Table Lookups; Table Lookups with IF and ISERROR; Dates & Times; Single- and Multi-Cell Arrays. 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 & 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 & 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 & Numbers; Table Lookups; Table Lookups with IF and ISERROR; Dates & Times; Single- and Multi-Cell Arrays.
Read Less
Add this copy of Excel Functions and Formulas Pocketbook to cart. $10.39, fair condition, Sold by Goodwill of Silicon Valley rated 5.0 out of 5 stars, ships from San Jose, CA, UNITED STATES, published 2017 by Independently published.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Fair. Supports Goodwill of Silicon Valley job training programs. The cover and pages are in Acceptable condition! Any other included accessories are also in Acceptable condition showing use. Use can include some highlighting and writing page and cover creases as well as other types visible wear such as cover tears discoloration staining marks scuffs etc. All pages intact.
Add this copy of Excel Functions and Formulas Pocketbook to cart. $10.46, new condition, Sold by Ingram Customer Returns Center rated 5.0 out of 5 stars, ships from NV, USA, published 2017 by Independently Published.
Add this copy of Excel Functions and Formulas Pocketbook to cart. $10.46, new condition, Sold by Ingram Customer Returns Center rated 5.0 out of 5 stars, ships from NV, USA, published 2017 by Createspace Independent Publishing Platform.
Add this copy of Excel Functions and Formulas Pocketbook to cart. $12.32, new condition, Sold by GreatBookPrices rated 4.0 out of 5 stars, ships from Columbia, MD, UNITED STATES, published 2017 by Createspace Independent Publishing Platform.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
New. Trade paperback (US). Glued binding. 192 p. In Stock. 100% Money Back Guarantee. Brand New, Perfect Condition, allow 4-14 business days for standard shipping. To Alaska, Hawaii, U.S. protectorate, P.O. box, and APO/FPO addresses allow 4-28 business days for Standard shipping. No expedited shipping. All orders placed with expedited shipping will be cancelled. Over 3, 000, 000 happy customers.
Add this copy of Excel Functions and Formulas Pocketbook to cart. $31.01, good condition, Sold by Bonita rated 4.0 out of 5 stars, ships from Santa Clarita, CA, UNITED STATES, published 2017 by Independently published.
Add this copy of Excel Functions and Formulas Pocketbook to cart. $31.01, good condition, Sold by Bonita rated 4.0 out of 5 stars, ships from Santa Clarita, CA, UNITED STATES, published 2017 by CreateSpace Independent Publis.
Add this copy of Excel Functions and Formulas Pocketbook to cart. $54.51, new condition, Sold by Bonita rated 4.0 out of 5 stars, ships from Santa Clarita, CA, UNITED STATES, published 2017 by Independently published.
