CURRENTLY SOLD OUT
About this product
Product Identifiers
PublisherBeezix Quick Référence Cards
ISBN-101936220776
ISBN-139781936220779
eBay Product ID (ePID)159919082
Product Key Features
Publication Year2013
SubjectGeneral
Number of Pages2 Pages
Publication NameMicrosoft Excel 2013 Functions and Formulas Quick Reference Card (4-Page Cheat Sheet Focusing on Examples and Context for Intermed
LanguageEnglish
TypeTextbook
Subject AreaComputers
AuthorBeezix
FormatPaperback
Additional Product Features
Intended AudienceTrade
SynopsisGeared toward the intermediate to advanced Excel 2013 user, this example-rich 4-page laminated quick reference card/guide provides explanations and context for many powerful Excel 2013 spreadsheet formulas and functions. Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features. 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) 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) Using a Formula for Data Validation Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Showing/Hiding Formulas, Watching Cells, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows.
Ratings and Reviews
Most relevant reviews
- Jul 03, 2018
Just exactl
This is exactly what I was looking for to brush up on excel and. Easy to look up instead of a large book.Verified purchase: YesCondition: New
