Skip to content
ISBN: 1936220776
ISBN13: 9781936220779

Microsoft Excel 2013 Functions & Formulas Quick Reference Card (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide)

ISBN: 1936220776
ISBN13: 9781936220779
Formats

Conditions

Formats

Conditions

See all 1 editions

Book Overview

Geared 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.
Format:
Pamphlet
Language:
English
ISBN:
1936220776
ISBN13:
9781936220779
Release Date:
March 2013
Publisher:
Beezix Quick Reference Cards
Length:
4 Pages
Weight:
0.02 lbs.
ComputersComputers & Technology

More by Beezix Inc.

Customer Reviews

0 customer ratings | 0 reviews
Write a Review

There are currently no reviews. Be the first to review this work.